postgres=# SELECT c.oid::regclass as table_name, postgres-# greatest(age(c.relfrozenxid),age(t.relfrozenxid)) as age postgres-# FROM pg_class c postgres-# LEFT JOIN pg_class t ON c.reltoastrelid = t.oid postgres-# WHERE c.relkind IN ('r', 'm'); table_name |...
SELECT page_id, count(event_id) FROM page LEFT JOIN ( SELECT * FROM event WHERE (payload->>'time')::timestamptz >= now() - interval '1 week' ) recent USING (tenant_id, page_id) WHERE tenant_id = 6 AND path LIKE '/blog%' GROUP BY page_id; tenant_id でのフィルターと結合...
SELECT NSPNAME as schema_name, count(RELNAME) as table_count FROM PG_CLASS C LEFT JOIN PG_NAMESPACE N ON N.OID = C.RELNAMESPACE WHERE C.RELKIND in ('p','r') AND C.RELISPARTITION = 'f' AND N.NSPNAME not in ('pg_catalog','information...
JOIN 句の例 WHERE 句 WHERE 句の Oracle スタイルの外部結合 GROUP BY 句 集計拡張機能 HAVING 句 QUALIFY 句 UNION、INTERSECT、または EXCEPT UNION クエリの例 UNION ALL クエリの例 INTERSECT クエリの例 EXCEPT クエリの例 ORDER BY 句 ORDER BY の例 CONNECT BY 句 サブクエリの例 相関性の...