9 lines
259 B
SQL
9 lines
259 B
SQL
WITH T AS (
|
|
SELECT
|
|
sum(CASE WHEN relkind IN ('r', 't', 'm') THEN pg_stat_get_numscans(oid) END) seq,
|
|
sum(CASE WHEN relkind = 'i' THEN pg_stat_get_numscans(oid) END) idx
|
|
FROM pg_class
|
|
WHERE relkind IN ('r', 't', 'm', 'i')
|
|
)
|
|
SELECT row_to_json(T)
|
|
FROM T
|