This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
postgresql [2009/05/25 00:35] external edit
postgresql [2009/06/12 01:27] (current)
a terminate a query which is taking a long time to run
Line 117: Line 117:
     order by whenx desc     order by whenx desc
 +**terminate a query which is taking a long time to run**
 +   ​SELECT procpid, current_query,​ query_start
 +   FROM pg_stat_activity;​
 +   kill -INT procpid
postgresql.txt ยท Last modified: 2009/06/12 01:27 by a
CC Attribution-Noncommercial-Share Alike 4.0 International
Valid CSS Driven by DokuWiki do yourself a favour and use a real browser - get firefox!! Recent changes RSS feed Valid XHTML 1.0 ipv6 ready