pascal@neo> ./pg_du.pl -d powerbase -a
Disk usage for table "public.metadata":
Configured page size: 8192
Estimated row count: 23
Name of the on-disk file: 16499
Data usage: 8.0KB
Indexes:
16KB (metadata_pkey)
TOAST table:
0B (pg_toast_16499)
TOAST table index:
8.0KB (pg_toast_16499_index)
Total disk usage: 32KB
Disk usage for table "public.datalink":
Configured page size: 8192
Estimated row count: 1
Name of the on-disk file: 16422
Data usage: 8.0KB
Indexes:
16KB (datalink_pkey)
16KB (fki_datalink_unit)
16KB (fki_datalink_sensor)
TOAST table:
0B (pg_toast_16422)
TOAST table index:
8.0KB (pg_toast_16422_index)
Total disk usage: 64KB
Disk usage for table "public.sensor":
Configured page size: 8192
Estimated row count: 1
Name of the on-disk file: 16405
Data usage: 8.0KB
Indexes:
16KB (sensor_pkey)
TOAST table:
0B (pg_toast_16405)
TOAST table index:
8.0KB (pg_toast_16405_index)
Total disk usage: 32KB
Disk usage for table "public.unit":
Configured page size: 8192
Estimated row count: 1
Name of the on-disk file: 16398
Data usage: 8.0KB
Indexes:
16KB (unit_pkey)
TOAST table:
0B (pg_toast_16398)
TOAST table index:
8.0KB (pg_toast_16398_index)
Total disk usage: 32KB
Disk usage for table "public.data":
Configured page size: 8192
Estimated row count: 2.64824e+07
Name of the on-disk file: 16467
Data usage: 3.7GB
Indexes:
823MB (data_pkey)
TOAST table:
0B (pg_toast_16467)
TOAST table index:
8.0KB (pg_toast_16467_index)
Total disk usage: 4.5GB