Differences

This shows you the differences between two versions of the page.

--- database:data_archiving [2025/10/23 01:31] – timb
+++ database:data_archiving [2025/10/23 16:44] (current) – removed timb
@@ Line 1: / Line 1: @@
-====== Data Archiving ======
-See also [[database:Database]] | [[database:Postgresql]] | [[Index]]
-Raw code on report database on rdb.prd and analysis.
-Bigest tables on 3 December 2015
-<code>
-SELECT
-    table_name,
-    schema_name,
-    table_size,
-    updated::date,
-FROM
-    table_size
-WHERE
-    updated::date = '12/03/2015'
-    AND schema_name <> 'report'
---    AND schema_name = 'report'
-ORDER BY
-    table_size DESC
--- LIMIT 5
-;
-</code>
-Data in report_request_status on rdb.prd
-<code>
-/*
-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,
-FROM
-    report_request_status
-ORDER BY
-    request_date -- DESC
-;
-</code>