Index sizes

gistfile1.sql

Separate indexes:

"aatams.detection";"16 GB"
"aatams.detection_transmitter_id_index";"4882 MB"
"aatams.detection_receiver_name_index";"4877 MB"
"aatams.detection_timestamp_index";"4706 MB"
"aatams.detection_pkey";"4055 MB"
"aatams.detection_receiver_download_id_index";"3507 MB"

SELECT nspname || '.' || relname AS "relation",
    pg_size_pretty(pg_relation_size(C.oid)) AS "size"
  FROM pg_class C
  LEFT JOIN pg_namespace N ON (N.oid = C.relnamespace)
  WHERE nspname NOT IN ('pg_catalog', 'information_schema')
  AND relname like 'detection%'
  ORDER BY pg_relation_size(C.oid) DESC
  LIMIT 20;