pg_snipets.sql

SELECT relname, pg_size_pretty(round(relpages*8*1024, 0)) as size FROM pg_class ORDER BY relpages DESC LIMIT 10

LOAD 'online_analyze';
SET "onlyne_analyze.enable" TO 'on';
SET "onlyne_analyze.table_type" = 'temporary';
SET "online_analyze.verbose" = 'off';

CREATE EXTENSION pg_prewarm;
SELECT pg_prewarm('config');
SELECT pg_prewarm('dbschema');
SELECT pg_prewarm('files');
SELECT pg_prewarm('params');
SELECT pg_prewarm('v8users');