Skip to content

Instantly share code, notes, and snippets.

@brson

brson/gist:3ea94eef54370b1302f71f83adafb935

Created June 1, 2016 17:46
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save brson/3ea94eef54370b1302f71f83adafb935 to your computer and use it in GitHub Desktop.
Save brson/3ea94eef54370b1302f71f83adafb935 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
pid | age | usename | query
-------+------------------+----------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
50 | | collectd | <insufficient privilege>
10617 | -00:00:21.223292 | ua78dgad6gfddr | SELECT query, calls, total_time, blk_read_time, blk_write_time FROM (SELECT query, SUM(calls) OVER (PARTITION BY query) AS calls, SUM(total_time) OVER (PARTITION BY query) AS total_time, SUM(blk_read_time) OVER (PARTITION BY query) AS blk_read_time, SUM(blk_write_time) OVER (PARTITION BY query) AS blk_write_time, (total_time / SUM(total_time) over ()) * 100 AS time_spent FROM public.pg_stat_statements WHERE userid = (SELECT usesysid FROM pg_user WHERE usename = current_user LIMIT 1)) ts WHERE time_spent >= 1 GROUP BY query, calls, total_time, blk_read_time, blk_write_time
10419 | -00:18:56.993427 | ua78dgad6gfddr | UPDATE version_downloads +
| | | SET downloads = downloads + 1 +
| | | WHERE version_id = $1 AND date($2) = date(date)
10413 | -00:19:04.795218 | ua78dgad6gfddr | UPDATE version_downloads +
| | | SET downloads = downloads + 1 +
| | | WHERE version_id = $1 AND date($2) = date(date)
10414 | -00:19:09.977005 | ua78dgad6gfddr | UPDATE version_downloads +
| | | SET downloads = downloads + 1 +
| | | WHERE version_id = $1 AND date($2) = date(date)
10415 | -00:19:24.9295 | ua78dgad6gfddr | UPDATE version_downloads +
| | | SET downloads = downloads + 1 +
| | | WHERE version_id = $1 AND date($2) = date(date)
10406 | -00:19:29.643535 | ua78dgad6gfddr | UPDATE version_downloads +
| | | SET downloads = downloads + 1 :
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment