[ ] Indexed blocks shows the current block height, not the number of actual blocks that have been indexed
Actual blocks indexed is $current_height - $num_blocks
Additions:
[ ] Would be nice to know what the blocks per second is (as a reference)
[ ] Would be nice to now "index size per block" if that info is available
SELECT schema_name as "Schema",
pg_size_pretty(sum(table_size)) as "Size",
(sum(table_size) / database_size) * 100 as "Size %"
FROM (
SELECT pg_catalog.pg_namespace.nspname as schema_name,
pg_relation_size(pg_catalog.pg_class.oid) as table_size,
sum(pg_relation_size(pg_catalog.pg_class.oid)) over () as database_size
FROM pg_catalog.pg_class
JOIN pg_catalog.pg_namespace ON relnamespace = pg_catalog.pg_namespace.oid
) t
WHERE schema_name = '$namespace.$identifier`
GROUP BY schema_name, database_size
ORDER BY database_size DESC
Fixes:
Indexed
blocks shows the current block height, not the number of actual blocks that have been indexed$current_height - $num_blocks
Additions: