Small updates to `forc index status`
ra0x3 opened this issue · 0 comments
ra0x3 commented
-
Fixes:
-
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
- Actual blocks indexed is
-
-
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