Skip to content

Instantly share code, notes, and snippets.

@sibson

sibson/gist:20281944462d31b3dcfb19ad1949ced7

Created July 5, 2016 09:40
Show Gist options
  • Save sibson/20281944462d31b3dcfb19ad1949ced7 to your computer and use it in GitHub Desktop.
Save sibson/20281944462d31b3dcfb19ad1949ced7 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
herokuconnect-prod::DATABASE=> select pid,query from pg_stat_activity where query like 'SELECT COUNT(*) AS "__count" FROM "mirror_transitionhistory" WHERE "mirror_transitionhistory".%' order by query;
pid | query
-------+-------------------------------------------------------------------------------------------------------------------------------------------------------------
31248 | SELECT COUNT(*) AS "__count" FROM "mirror_transitionhistory" WHERE "mirror_transitionhistory"."timestamp" > '2016-07-05T08:56:29.963402+00:00'::timestamptz
31203 | SELECT COUNT(*) AS "__count" FROM "mirror_transitionhistory" WHERE "mirror_transitionhistory"."timestamp" > '2016-07-05T08:57:01.023705+00:00'::timestamptz
31261 | SELECT COUNT(*) AS "__count" FROM "mirror_transitionhistory" WHERE "mirror_transitionhistory"."timestamp" > '2016-07-05T08:57:30.059660+00:00'::timestamptz
31299 | SELECT COUNT(*) AS "__count" FROM "mirror_transitionhistory" WHERE "mirror_transitionhistory"."timestamp" > '2016-07-05T08:58:00.118792+00:00'::timestamptz
31278 | SELECT COUNT(*) AS "__count" FROM "mirror_transitionhistory" WHERE "mirror_transitionhistory"."timestamp" > '2016-07-05T08:58:30.172324+00:00'::timestamptz
31325 | SELECT COUNT(*) AS "__count" FROM "mirror_transitionhistory" WHERE "mirror_transitionhistory"."timestamp" > '2016-07-05T08:59:00.221293+00:00'::timestamptz
31232 | SELECT COUNT(*) AS "__count" FROM "mirror_transitionhistory" WHERE "mirror_transitionhistory"."timestamp" > '2016-07-05T08:59:30.279584+00:00'::timestamptz
31359 | SELECT COUNT(*) AS "__count" FROM "mirror_transitionhistory" WHERE "mirror_transitionhistory"."timestamp" > '2016-07-05T09:00:00.337803+00:00'::timestamptz
31344 | SELECT COUNT(*) AS "__count" FROM "mirror_transitionhistory" WHERE "mirror_transitionhistory"."timestamp" > '2016-07-05T09:00:30.379239+00:00'::timestamptz
31314 | SELECT COUNT(*) AS "__count" FROM "mirror_transitionhistory" WHERE "mirror_transitionhistory"."timestamp" > '2016-07-05T09:01:00.427845+00:00'::timestamptz
31366 | SELECT COUNT(*) AS "__count" FROM "mirror_transitionhistory" WHERE "mirror_transitionhistory"."timestamp" > '2016-07-05T09:01:30.490208+00:00'::timestamptz
31399 | SELECT COUNT(*) AS "__count" FROM "mirror_transitionhistory" WHERE "mirror_transitionhistory"."timestamp" > '2016-07-05T09:02:00.552933+00:00'::timestamptz
31378 | SELECT COUNT(*) AS "__count" FROM "mirror_transitionhistory" WHERE "mirror_transitionhistory"."timestamp" > '2016-07-05T09:02:30.596221+00:00'::timestamptz
31426 | SELECT COUNT(*) AS "__count" FROM "mirror_transitionhistory" WHERE "mirror_transitionhistory"."timestamp" > '2016-07-05T09:03:00.659743+00:00'::timestamptz
31435 | SELECT COUNT(*) AS "__count" FROM "mirror_transitionhistory" WHERE "mirror_transitionhistory"."timestamp" > '2016-07-05T09:03:30.708896+00:00'::timestamptz
31414 | SELECT COUNT(*) AS "__count" FROM "mirror_transitionhistory" WHERE "mirror_transitionhistory"."timestamp" > '2016-07-05T09:04:00.766442+00:00'::timestamptz
31383 | SELECT COUNT(*) AS "__count" FROM "mirror_transitionhistory" WHERE "mirror_transitionhistory"."timestamp" > '2016-07-05T09:04:30.815636+00:00'::timestamptz
31513 | SELECT COUNT(*) AS "__count" FROM "mirror_transitionhistory" WHERE "mirror_transitionhistory"."timestamp" > '2016-07-05T09:05:00.869308+00:00'::timestamptz
31531 | SELECT COUNT(*) AS "__count" FROM "mirror_transitionhistory" WHERE "mirror_transitionhistory"."timestamp" > '2016-07-05T09:05:30.915498+00:00'::timestamptz
31547 | SELECT COUNT(*) AS "__count" FROM "mirror_transitionhistory" WHERE "mirror_transitionhistory"."timestamp" > '2016-07-05T09:06:00.964449+00:00'::timestamptz
31568 | SELECT COUNT(*) AS "__count" FROM "mirror_transitionhistory" WHERE "mirror_transitionhistory"."timestamp" > '2016-07-05T09:06:31.527873+00:00'::timestamptz
31489 | SELECT COUNT(*) AS "__count" FROM "mirror_transitionhistory" WHERE "mirror_transitionhistory"."timestamp" > '2016-07-05T09:07:01.066807+00:00'::timestamptz
31464 | SELECT COUNT(*) AS "__count" FROM "mirror_transitionhistory" WHERE "mirror_transitionhistory"."timestamp" > '2016-07-05T09:07:31.119114+00:00'::timestamptz
31601 | SELECT COUNT(*) AS "__count" FROM "mirror_transitionhistory" WHERE "mirror_transitionhistory"."timestamp" > '2016-07-05T09:08:01.171919+00:00'::timestamptz
31634 | SELECT COUNT(*) AS "__count" FROM "mirror_transitionhistory" WHERE "mirror_transitionhistory"."timestamp" > '2016-07-05T09:08:31.231635+00:00'::timestamptz
31662 | SELECT COUNT(*) AS "__count" FROM "mirror_transitionhistory" WHERE "mirror_transitionhistory"."timestamp" > '2016-07-05T09:09:01.273913+00:00'::timestamptz
31616 | SELECT COUNT(*) AS "__count" FROM "mirror_transitionhistory" WHERE "mirror_transitionhistory"."timestamp" > '2016-07-05T09:09:31.329838+00:00'::timestamptz
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment