ddl

王江南2025年5月19日小于 1 分钟

查询视图名

SELECT table_name AS view_name
FROM information_schema.views
WHERE table_schema NOT IN ('pg_catalog', 'information_schema')
ORDER BY view_name;

连接ip统计

SELECT 
    client_addr AS ip,
    count(*) AS connections
FROM pg_stat_activity
WHERE client_addr IS NOT NULL
GROUP BY client_addr
ORDER BY connections DESC;