yamazのRails日記 このページをアンテナに追加 RSSフィード

2010-05-11postgresでロックしてたりするクエリを調べる方法 このエントリーを含むブックマーク

メモ

 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;

JeslynJeslyn2011/05/05 00:04Ppl like you get all the brains. I just get to say thanks for he aneswr.

bokhhyadbokhhyad2011/05/05 10:57J4rreV <a href="http://tbdmsvxuxkig.com/">tbdmsvxuxkig</a>

bcijacwotcbcijacwotc2011/05/06 10:56B71gO6 , [url=http://eorykantomgp.com/]eorykantomgp[/url], [link=http://roabxrpwyckw.com/]roabxrpwyckw[/link], http://vbsivdiccllx.com/

トラックバック - http://rubyist.g.hatena.ne.jp/yamaz/20100511