| 注册
请输入搜索内容

热门搜索

Java Linux MySQL PHP JavaScript Hibernate jQuery Nginx
jopen
10年前发布

如何查看PostgreSQL正在执行的SQL

如何查看PostgreSQL正在执行的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 <> '<IDLE>'   ORDER BY      lap DESC;

 本文由用户 jopen 自行上传分享,仅供网友学习交流。所有权归原作者,若您的权利被侵害,请联系管理员。
 转载本站原创文章,请注明出处,并保留原始链接、图片水印。
 本站是一个以用户分享为主的开源技术平台,欢迎各类分享!
 本文地址:https://www.open-open.com/lib/view/open1408024367301.html
SQL PostgreSQL