See also Database | Postgresql

Raw code on report database on rdb.prd and analysis.

Bigest tables on 3 December 2015

SELECT 
    table_name,
    schema_name,
    table_size,
    updated::date, 
    1
FROM 
    table_size 
WHERE 
    updated::date = '12/03/2015'
    AND schema_name <> 'report'
--    AND schema_name = 'report'
ORDER BY 
    table_size DESC
-- LIMIT 5
;

Data in reportrequeststatus on rdb.prd

/*
report_request_status - 

    Size: 16,355,139,584
    Pages: 2,007,809
    Records: 13,821,065
    Relfilenode: 10762414
*/

SELECT 
    report_request_status_id,
    report_name,
    request_date,
    request_status,
    generation_start_date,
    generation_end_date,
    created_date,
    edited_date,
    1
FROM 
    report_request_status 
ORDER BY 
    request_date -- DESC
;