447 |
447 |
448 Table size with TOAST (without indexes):: |
448 Table size with TOAST (without indexes):: |
449 |
449 |
450 SELECT pg_table_size('schemaname.tablename'); |
450 SELECT pg_table_size('schemaname.tablename'); |
451 |
451 |
452 Sole table size (without indexes and other):: |
452 Sole table size (without indexes and TOAST):: |
453 |
453 |
454 SELECT pg_size_pretty(pg_relation_size('schemaname.tablename')); |
454 SELECT pg_size_pretty(pg_relation_size('schemaname.tablename')); |
455 |
455 |
456 SELECT pg_relation_size(t.schemaname ||'.'|| t.tablename), t.* FROM pg_tables t ORDER BY 1 DESC; |
456 SELECT pg_relation_size(t.schemaname ||'.'|| t.tablename), t.* FROM pg_tables t ORDER BY 1 DESC; |
457 |
457 |
458 Largest table in the PostgreSQL database:: |
458 Largest table in the PostgreSQL database:: |
459 |
459 |
460 SELECT relname, relpages FROM pg_class ORDER BY relpages DESC; |
460 SELECT relname, relpages FROM pg_class ORDER BY relpages DESC; |
461 SELECT relname, pg_size_pretty(pg_relation_size(p.oid)) FROM pg_class ORDER BY relpages DESC; |
461 SELECT relname, pg_size_pretty(pg_relation_size(p.oid)) FROM pg_class ORDER BY relpages DESC; |
|
462 |
|
463 SELECT pg_table_size(t.schemaname ||'.'|| t.tablename), pg_relation_size(t.schemaname ||'.'|| t.tablename), t.* |
|
464 FROM pg_tables t |
|
465 ORDER BY 1 DESC; |
462 |
466 |
463 Largest tables with TOAST:: |
467 Largest tables with TOAST:: |
464 |
468 |
465 SELECT p.relname, t.relname, pg_size_pretty(pg_relation_size(p.oid)), p.relpages |
469 SELECT p.relname, t.relname, pg_size_pretty(pg_relation_size(p.oid)), p.relpages |
466 FROM pg_class p |
470 FROM pg_class p |