Differences

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]
127.0.0.1 external edit
postgresql [2009/06/12 01:27]
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-Share Alike 4.0 International
Driven by DokuWiki Recent changes RSS feed Valid CSS Valid XHTML 1.0 ipv6 ready