```
softwareheritage=# SELECT
current_database()::text AS datname,
COALESCE(schemaname::text, 'null') AS schemaname,
COALESCE(relname::text, 'null') AS relname,
COALESCE(heap_blks_read::float, 0) AS heap_blks_read,
COALESCE(heap_blks_hit::float, 0) AS heap_blks_hit,
COALESCE(idx_blks_read::float, 0) AS idx_blks_read,
COALESCE(idx_blks_hit::float, 0) AS idx_blks_hit
FROM pg_statio_user_tables FULL JOIN (VALUES(0)) filler(i) ON TRUE;
SELECT
current_database()::text AS datname,
COALESCE(schemaname::text, 'null') AS schemaname,
COALESCE(relname::text, 'null') AS relname,
COALESCE(heap_blks_read::float, 0) AS heap_blks_read,
COALESCE(heap_blks_hit::float, 0) AS heap_blks_hit,
COALESCE(idx_blks_read::float, 0) AS idx_blks_read,
COALESCE(idx_blks_hit::float, 0) AS idx_blks_hit
FROM pg_statio_user_tables FULL JOIN (VALUES(0)) filler(i) ON TRUE;
...
(954 rows)
Time: 39803.734 ms (00:39.804)
```
softwareheritage-# ;
SELECT
current_database()::text AS datname,
COALESCE(schemaname::text, 'null') AS schemaname,
COALESCE(relname::text, 'null') AS relname,
COALESCE(heap_blks_read::float, 0) AS heap_blks_read,
COALESCE(heap_blks_hit::float, 0) AS heap_blks_hit,
COALESCE(idx_blks_read::float, 0) AS idx_blks_read,
COALESCE(idx_blks_hit::float, 0) AS idx_blks_hit
FROM pg_statio_user_tables FULL JOIN (VALUES(0)) filler(i) ON TRUE
WHERE schemaname='public'
...
(25 rows)
Time: 235.463 ms
```