FuelLabs/fuel-indexer

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
  • 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