PgHero

Space

Database Size: 667 GB

3 unused indices. Remove them for faster writes.

Relation Size
input 206 GB
output 120 GB
output_pkey 93.7 GB
spent_by_index 62.3 GB
transaction 40.5 GB
input_pkey 34.1 GB
transaction_hash_key 28.5 GB
output_search_index 23.7 GB
block_transaction 19.3 GB
block_transaction_pkey 12.1 GB
block_inclusions_index 8.6 GB
transaction_pkey 8.31 GB
category_id_index 7.26 GB
node_transaction_history 1.55 GB
block 194 MB
block_hash_key 77.9 MB
node_block 46.3 MB
node_block_pkey 32.1 MB
block_height_index 22.9 MB
block_internal_id_key 22.9 MB
block_pkey 22.9 MB
node_transaction_pkey 9.88 MB
node_transaction 3.88 MB
hdb_metadata hdb_catalog 168 KB
hdb_schema_notifications hdb_catalog 48 KB
hdb_version hdb_catalog 48 KB
node 48 KB
node_block_history 40 KB
hdb_metadata_pkey hdb_catalog 16 KB
hdb_metadata_resource_version_key hdb_catalog 16 KB
hdb_schema_notifications_pkey hdb_catalog 16 KB
hdb_version_one_row hdb_catalog 16 KB
hdb_version_pkey hdb_catalog 16 KB
node_block_history_pkey 16 KB
node_internal_id_key 16 KB
node_name_key 16 KB
node_pkey 16 KB
hdb_action_log hdb_catalog 8 KB
hdb_action_log_pkey hdb_catalog 8 KB
hdb_cron_event_invocation_event_id hdb_catalog UNUSED 8 KB
hdb_cron_event_invocation_logs hdb_catalog 8 KB
hdb_cron_event_invocation_logs_pkey hdb_catalog 8 KB
hdb_cron_event_status hdb_catalog UNUSED 8 KB
hdb_cron_events hdb_catalog 8 KB
hdb_cron_events_pkey hdb_catalog 8 KB
hdb_cron_events_unique_scheduled hdb_catalog 8 KB
hdb_scheduled_event_invocation_logs hdb_catalog 8 KB
hdb_scheduled_event_invocation_logs_pkey hdb_catalog 8 KB
hdb_scheduled_event_status hdb_catalog UNUSED 8 KB
hdb_scheduled_events hdb_catalog 8 KB
hdb_scheduled_events_pkey hdb_catalog 8 KB
new_table 8 KB
new_table_tx 8 KB