用我真實的環境跑daily_invoice這個表看看 |
WITH RECURSIVE partition_info |
(relid, |
relname, |
relsize, |
relispartition, |
relkind) AS ( |
SELECT oid AS relid, |
relname, |
pg_relation_size(oid) AS relsize, |
relispartition, |
relkind |
FROM pg_catalog.pg_class |
WHERE relname = 'daily_invoice' AND |
relkind = 'p' |
UNION ALL |
SELECT |
c.oid AS relid, |
c.relname AS relname, |
pg_relation_size(c.oid) AS relsize, |
c.relispartition AS relispartition, |
c.relkind AS relkind |
FROM partition_info AS p, |
pg_catalog.pg_inherits AS i, |
pg_catalog.pg_class AS c |
WHERE p.relid = i.inhparent AND |
c.oid = i.inhrelid AND |
c.relispartition |
) |
SELECT * FROM partition_info; |