Skip to content

Instantly share code, notes, and snippets.

@kbarber

kbarber/gist:7696033

Created November 28, 2013 18:04
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save kbarber/7696033 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save kbarber/7696033 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
---------+------------+-------+----------+----------+------------------+-------------+-----------------+-------------+-------------------------------+-------------------------------+-------------------------------+-------------------------------+---------+---------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
1190906 | puppetdb68 | 12144 | 10 | ken | | 127.0.0.1 | | 54327 | 2013-11-28 14:50:52.701019+00 | | 2013-11-28 14:50:58.035851+00 | 2013-11-28 14:50:58.036306+00 | f | idle | SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN (SELECT 2615 AS oid , 1 AS attnum UNION ALL SELECT 1259, 1 UNION ALL SELECT 1249, 2 UNION ALL SELECT 2615, 1 UNION ALL SELECT 1259, 1 UNION ALL SELECT 1249, 2 UNION ALL SELECT 2606, 1 UNION ALL SELECT 1259, 1) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum)
1193993 | puppetdb | 27451 | 16426 | puppetdb | | 127.0.0.1 | | 58248 | 2013-11-28 18:03:29.21724+00 | 2013-11-28 18:03:30.7215+00 | 2013-11-28 18:03:30.72462+00 | 2013-11-28 18:03:30.724622+00 | t | active | UPDATE certnames SET deactivated=$1 WHERE name=$2 AND (deactivated<$3 OR deactivated IS NULL)
1193993 | puppetdb | 27452 | 16426 | puppetdb | | 127.0.0.1 | | 58249 | 2013-11-28 18:03:29.243506+00 | | 2013-11-28 18:03:30.277231+00 | 2013-11-28 18:03:30.277526+00 | f | idle | COMMIT
1193993 | puppetdb | 27453 | 16426 | puppetdb | | 127.0.0.1 | | 58250 | 2013-11-28 18:03:29.248459+00 | | 2013-11-28 18:03:30.46477+00 | 2013-11-28 18:03:30.464901+00 | f | idle | COMMIT
1193993 | puppetdb | 27454 | 16426 | puppetdb | | 127.0.0.1 | | 58251 | 2013-11-28 18:03:29.253785+00 | | 2013-11-28 18:03:30.470823+00 | 2013-11-28 18:03:30.470903+00 | f | idle | COMMIT
1193993 | puppetdb | 27455 | 16426 | puppetdb | | 127.0.0.1 | | 58252 | 2013-11-28 18:03:29.258797+00 | 2013-11-28 18:03:30.484693+00 | 2013-11-28 18:03:30.694726+00 | 2013-11-28 18:03:30.694832+00 | f | idle in transaction | DELETE FROM edges WHERE certname=$1 and source=$2 and target=$3 and type=$4
1193993 | puppetdb | 27456 | 16426 | puppetdb | | 127.0.0.1 | | 58253 | 2013-11-28 18:03:29.264006+00 | 2013-11-28 18:03:30.484712+00 | 2013-11-28 18:03:30.49726+00 | 2013-11-28 18:03:30.497261+00 | t | active | UPDATE certnames SET deactivated=$1 WHERE name=$2 AND (deactivated<$3 OR deactivated IS NULL)
1193993 | puppetdb | 27457 | 16426 | puppetdb | | 127.0.0.1 | | 58254 | 2013-11-28 18:03:29.268916+00 | 2013-11-28 18:03:30.484703+00 | 2013-11-28 18:03:30.497257+00 | 2013-11-28 18:03:30.497258+00 | t | active | UPDATE certnames SET deactivated=$1 WHERE name=$2 AND (deactivated<$3 OR deactivated IS NULL)
1193993 | puppetdb | 27458 | 16426 | puppetdb | | 127.0.0.1 | | 58255 | 2013-11-28 18:03:29.274094+00 | 2013-11-28 18:03:30.484674+00 | 2013-11-28 18:03:30.497298+00 | 2013-11-28 18:03:30.4973+00 | t | active | UPDATE certnames SET deactivated=$1 WHERE name=$2 AND (deactivated<$3 OR deactivated IS NULL)
1193993 | puppetdb | 27459 | 16426 | puppetdb | | 127.0.0.1 | | 58257 | 2013-11-28 18:03:30.216494+00 | | 2013-11-28 18:03:30.221016+00 | 2013-11-28 18:03:30.221062+00 | f | idle | SET SESSION CHARACTERISTICS AS TRANSACTION READ ONLY
1193993 | puppetdb | 27460 | 16426 | puppetdb | | 127.0.0.1 | | 58258 | 2013-11-28 18:03:30.222543+00 | | 2013-11-28 18:03:30.227513+00 | 2013-11-28 18:03:30.22757+00 | f | idle | SET SESSION CHARACTERISTICS AS TRANSACTION READ ONLY
1193993 | puppetdb | 27461 | 16426 | puppetdb | | 127.0.0.1 | | 58259 | 2013-11-28 18:03:30.228952+00 | | 2013-11-28 18:03:30.234706+00 | 2013-11-28 18:03:30.234756+00 | f | idle | SET SESSION CHARACTERISTICS AS TRANSACTION READ ONLY
1193993 | puppetdb | 27462 | 16426 | puppetdb | | 127.0.0.1 | | 58260 | 2013-11-28 18:03:30.23617+00 | | 2013-11-28 18:03:30.24227+00 | 2013-11-28 18:03:30.24232+00 | f | idle | SET SESSION CHARACTERISTICS AS TRANSACTION READ ONLY
1193993 | puppetdb | 27463 | 16426 | puppetdb | | 127.0.0.1 | | 58261 | 2013-11-28 18:03:30.244713+00 | | 2013-11-28 18:03:30.251364+00 | 2013-11-28 18:03:30.251428+00 | f | idle | SET SESSION CHARACTERISTICS AS TRANSACTION READ ONLY
1193993 | puppetdb | 27464 | 16426 | puppetdb | | 127.0.0.1 | | 58262 | 2013-11-28 18:03:30.25315+00 | | 2013-11-28 18:03:30.259764+00 | 2013-11-28 18:03:30.259796+00 | f | idle | SET SESSION CHARACTERISTICS AS TRANSACTION READ ONLY
1193993 | puppetdb | 27466 | 16426 | puppetdb | | 127.0.0.1 | | 58263 | 2013-11-28 18:03:30.483327+00 | | 2013-11-28 18:03:30.488411+00 | 2013-11-28 18:03:30.488552+00 | f | idle | SET extra_float_digits = 3
1193993 | puppetdb | 27467 | 16426 | puppetdb | | 127.0.0.1 | | 58264 | 2013-11-28 18:03:30.490496+00 | | 2013-11-28 18:03:30.494114+00 | 2013-11-28 18:03:30.494207+00 | f | idle | SET extra_float_digits = 3
1193993 | puppetdb | 27237 | 10 | ken | psql | | | -1 | 2013-11-28 18:01:17.174227+00 | 2013-11-28 18:03:36.141421+00 | 2013-11-28 18:03:36.141421+00 | 2013-11-28 18:03:36.141424+00 | f | active | select * from pg_stat_activity;
(18 rows)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment