如何查看PostgreSQL正在執行的SQL

 1,465 total views,  1 views today

今天在CPS伺服器上要找報表怎麼寫，因為要寫機器人自動產生報表的SQL，找了好久終於找到方法了。

先用報表軟體 故意下長一點的報表，這樣才有足夠的時間來抓SQL語法

接下來按下查詢之後，趕快下底下的 SQL，就可以偷抓出他的SQL來用了

SELECT procpid,
start,
Now() - start AS lap,
current_query
FROM (SELECT backendid,
Pg_stat_get_backend_pid(S.backendid) AS procpid,
Pg_stat_get_backend_activity_start(S.backendid) AS start,
Pg_stat_get_backend_activity(S.backendid) AS current_query
FROM (SELECT Pg_stat_get_backend_idset() AS backendid) AS S) AS S
WHERE current_query <> ""
ORDER BY lap DESC;

執行結果：