Skip to content

Instantly share code, notes, and snippets.

@wkalt

wkalt/gist:699c3cbd1571c004109b

Created August 19, 2014 23:47
Show Gist options
  • Save wkalt/699c3cbd1571c004109b to your computer and use it in GitHub Desktop.
Save wkalt/699c3cbd1571c004109b to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
wyatt=# select * from pg_stat_activity;
datid | datname | pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | state_change | waiting | state | query
---------+----------+------+----------+----------+------------------+-------------+-----------------+-------------+-------------------------------+-------------------------------+-------------------------------+-------------------------------+---------+--------+---------------------------------------------------------------------------
2095234 | puppetdb | 6475 | 65968 | puppetdb | | 127.0.0.1 | | 51033 | 2014-08-19 16:21:16.738214-07 | <<NULL>> | 2014-08-19 16:21:27.787003-07 | 2014-08-19 16:21:27.797803-07 | f | idle | COMMIT
2095234 | puppetdb | 6476 | 65968 | puppetdb | | 127.0.0.1 | | 51034 | 2014-08-19 16:21:16.762459-07 | <<NULL>> | 2014-08-19 16:21:28.328292-07 | 2014-08-19 16:21:28.328372-07 | f | idle | COMMIT
2095234 | puppetdb | 6477 | 65968 | puppetdb | | 127.0.0.1 | | 51035 | 2014-08-19 16:21:16.766205-07 | 2014-08-19 16:21:28.331682-07 | 2014-08-19 16:21:28.345015-07 | 2014-08-19 16:21:28.345017-07 | f | active | DELETE FROM fact_values WHERE ID NOT IN (SELECT fact_value_id FROM facts)
2095234 | puppetdb | 6478 | 65968 | puppetdb | | 127.0.0.1 | | 51036 | 2014-08-19 16:21:16.769811-07 | <<NULL>> | 2014-08-19 16:21:16.772393-07 | 2014-08-19 16:21:16.772438-07 | f | idle | SET extra_float_digits = 3
2095234 | puppetdb | 6479 | 65968 | puppetdb | | 127.0.0.1 | | 51037 | 2014-08-19 16:21:16.773283-07 | <<NULL>> | 2014-08-19 16:21:16.777223-07 | 2014-08-19 16:21:16.77727-07 | f | idle | SET extra_float_digits = 3
2095234 | puppetdb | 6480 | 65968 | puppetdb | | 127.0.0.1 | | 51038 | 2014-08-19 16:21:16.778243-07 | <<NULL>> | 2014-08-19 16:21:16.780974-07 | 2014-08-19 16:21:16.781015-07 | f | idle | SET extra_float_digits = 3
2095234 | puppetdb | 6481 | 65968 | puppetdb | | 127.0.0.1 | | 51039 | 2014-08-19 16:21:16.781819-07 | <<NULL>> | 2014-08-19 16:21:16.784678-07 | 2014-08-19 16:21:16.784719-07 | f | idle | SET extra_float_digits = 3
2095234 | puppetdb | 6482 | 65968 | puppetdb | | 127.0.0.1 | | 51040 | 2014-08-19 16:21:16.785732-07 | <<NULL>> | 2014-08-19 16:21:16.789001-07 | 2014-08-19 16:21:16.789062-07 | f | idle | SET extra_float_digits = 3
2095234 | puppetdb | 6483 | 65968 | puppetdb | | 127.0.0.1 | | 51042 | 2014-08-19 16:21:28.296014-07 | <<NULL>> | 2014-08-19 16:21:28.29991-07 | 2014-08-19 16:21:28.299949-07 | f | idle | SET SESSION CHARACTERISTICS AS TRANSACTION READ ONLY
2095234 | puppetdb | 6484 | 65968 | puppetdb | | 127.0.0.1 | | 51043 | 2014-08-19 16:21:28.300741-07 | <<NULL>> | 2014-08-19 16:21:28.304368-07 | 2014-08-19 16:21:28.304419-07 | f | idle | SET SESSION CHARACTERISTICS AS TRANSACTION READ ONLY
2095234 | puppetdb | 6485 | 65968 | puppetdb | | 127.0.0.1 | | 51044 | 2014-08-19 16:21:28.30519-07 | <<NULL>> | 2014-08-19 16:21:28.308505-07 | 2014-08-19 16:21:28.308542-07 | f | idle | SET SESSION CHARACTERISTICS AS TRANSACTION READ ONLY
2095234 | puppetdb | 6486 | 65968 | puppetdb | | 127.0.0.1 | | 51045 | 2014-08-19 16:21:28.31009-07 | <<NULL>> | 2014-08-19 16:21:28.314592-07 | 2014-08-19 16:21:28.314649-07 | f | idle | SET SESSION CHARACTERISTICS AS TRANSACTION READ ONLY
2095234 | puppetdb | 6487 | 65968 | puppetdb | | 127.0.0.1 | | 51046 | 2014-08-19 16:21:28.315418-07 | <<NULL>> | 2014-08-19 16:21:28.318943-07 | 2014-08-19 16:21:28.318997-07 | f | idle | SET SESSION CHARACTERISTICS AS TRANSACTION READ ONLY
2095234 | puppetdb | 6488 | 65968 | puppetdb | | 127.0.0.1 | | 51047 | 2014-08-19 16:21:28.319869-07 | <<NULL>> | 2014-08-19 16:21:28.323247-07 | 2014-08-19 16:21:28.323284-07 | f | idle | SET SESSION CHARACTERISTICS AS TRANSACTION READ ONLY
16384 | wyatt | 7095 | 10 | wyatt | psql | <<NULL>> | <<NULL>> | -1 | 2014-08-19 16:46:06.615369-07 | 2014-08-19 16:47:07.569711-07 | 2014-08-19 16:47:07.569711-07 | 2014-08-19 16:47:07.569714-07 | f | active | select * from pg_stat_activity;
2095234 | puppetdb | 6421 | 10 | wyatt | psql | <<NULL>> | <<NULL>> | -1 | 2014-08-19 16:20:27.610807-07 | 2014-08-19 16:46:02.273957-07 | 2014-08-19 16:46:02.273957-07 | 2014-08-19 16:46:02.27396-07 | t | active | drop index fact_values_string_trgm;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment