Skip to content

Instantly share code, notes, and snippets.

@begriffs

begriffs/onlylocks.csv

Created February 8, 2016 23:32
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save begriffs/32cd0e8aa9449598d621 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save begriffs/32cd0e8aa9449598d621 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
onlylocks.csv
2016-02-08 15:26:19.809 PST j demo1 93674 ::1:50887 56b9241a.16dea 1 idle 2016-02-08 15:26:18 PST 2/26 0 LOG 00000 statement: SET client_encoding = 'UTF8';SET client_min_messages TO WARNING;
2016-02-08 15:26:20.311 PST j demo1 93674 ::1:50887 56b9241a.16dea 2 idle 2016-02-08 15:26:18 PST 2/27 0 LOG 00000 statement: begin ISOLATION LEVEL READ COMMITTED;
2016-02-08 15:26:20.812 PST j demo1 93674 ::1:50887 56b9241a.16dea 3 idle in transaction 2016-02-08 15:26:18 PST 2/27 0 LOG 00000 statement: set local role 'j';
2016-02-08 15:26:22.819 PST j demo1 93675 ::1:50895 56b9241d.16deb 1 idle 2016-02-08 15:26:21 PST 3/4 0 LOG 00000 statement: SET client_encoding = 'UTF8';SET client_min_messages TO WARNING;
2016-02-08 15:26:23.319 PST j demo1 93675 ::1:50895 56b9241d.16deb 2 idle 2016-02-08 15:26:21 PST 3/5 0 LOG 00000 statement: begin ISOLATION LEVEL READ COMMITTED;
2016-02-08 15:26:25.327 PST j demo1 93676 ::1:50896 56b92420.16dec 1 idle 2016-02-08 15:26:24 PST 4/4 0 LOG 00000 statement: SET client_encoding = 'UTF8';SET client_min_messages TO WARNING;
2016-02-08 15:26:27.333 PST j demo1 93678 ::1:50897 56b92422.16dee 1 idle 2016-02-08 15:26:26 PST 5/2 0 LOG 00000 statement: SET client_encoding = 'UTF8';SET client_min_messages TO WARNING;
2016-02-08 15:26:27.836 PST j demo1 93674 ::1:50887 56b9241a.16dea 4 idle in transaction 2016-02-08 15:26:18 PST 2/27 0 LOG 00000 statement: LOCK TABLE "public"."film" IN SHARE ROW EXCLUSIVE MODE;
2016-02-08 15:26:28.337 PST j demo1 93675 ::1:50895 56b9241d.16deb 3 idle in transaction 2016-02-08 15:26:21 PST 3/5 0 LOG 00000 statement: set local role 'j';
2016-02-08 15:26:28.838 PST j demo1 93676 ::1:50896 56b92420.16dec 2 idle 2016-02-08 15:26:24 PST 4/5 0 LOG 00000 statement: begin ISOLATION LEVEL READ COMMITTED;
2016-02-08 15:26:29.339 PST j demo1 93676 ::1:50896 56b92420.16dec 3 idle in transaction 2016-02-08 15:26:24 PST 4/5 0 LOG 00000 statement: set local role 'j';
2016-02-08 15:26:29.839 PST j demo1 93678 ::1:50897 56b92422.16dee 2 idle 2016-02-08 15:26:26 PST 5/3 0 LOG 00000 statement: begin ISOLATION LEVEL READ COMMITTED;
2016-02-08 15:26:30.339 PST j demo1 93678 ::1:50897 56b92422.16dee 3 idle in transaction 2016-02-08 15:26:26 PST 5/3 0 LOG 00000 statement: set local role 'j';
2016-02-08 15:26:30.839 PST j demo1 93674 ::1:50887 56b9241a.16dea 5 idle in transaction 2016-02-08 15:26:18 PST 2/27 0 LOG 00000 statement: commit;
2016-02-08 15:26:31.340 PST j demo1 93676 ::1:50896 56b92420.16dec 4 idle in transaction 2016-02-08 15:26:24 PST 4/5 0 LOG 00000 statement: LOCK TABLE "public"."film" IN SHARE ROW EXCLUSIVE MODE;
2016-02-08 15:26:31.841 PST j demo1 93676 ::1:50896 56b92420.16dec 5 idle in transaction 2016-02-08 15:26:24 PST 4/5 0 LOG 00000 statement: commit;
2016-02-08 15:26:32.341 PST j demo1 93678 ::1:50897 56b92422.16dee 4 idle in transaction 2016-02-08 15:26:26 PST 5/3 0 LOG 00000 statement: LOCK TABLE "public"."film" IN SHARE ROW EXCLUSIVE MODE;
2016-02-08 15:26:32.843 PST j demo1 93678 ::1:50897 56b92422.16dee 5 idle in transaction 2016-02-08 15:26:26 PST 5/3 0 LOG 00000 statement: commit;
2016-02-08 15:26:33.343 PST j demo1 93675 ::1:50895 56b9241d.16deb 4 idle in transaction 2016-02-08 15:26:21 PST 3/5 0 LOG 00000 statement: LOCK TABLE "public"."film" IN SHARE ROW EXCLUSIVE MODE;
2016-02-08 15:26:33.844 PST j demo1 93675 ::1:50895 56b9241d.16deb 5 idle in transaction 2016-02-08 15:26:21 PST 3/5 0 LOG 00000 statement: commit;
2016-02-08 15:26:34.385 PST j demo1 93675 ::1:50895 56b9241d.16deb 6 idle 2016-02-08 15:26:21 PST 3/6 0 LOG 00000 statement: begin ISOLATION LEVEL READ COMMITTED;
2016-02-08 15:26:34.886 PST j demo1 93678 ::1:50897 56b92422.16dee 6 idle 2016-02-08 15:26:26 PST 5/4 0 LOG 00000 statement: begin ISOLATION LEVEL READ COMMITTED;
2016-02-08 15:26:36.903 PST j demo1 93688 ::1:50907 56b9242b.16df8 1 idle 2016-02-08 15:26:35 PST 2/29 0 LOG 00000 statement: SET client_encoding = 'UTF8';SET client_min_messages TO WARNING;
2016-02-08 15:26:38.910 PST j demo1 93690 ::1:50909 56b9242d.16dfa 1 idle 2016-02-08 15:26:37 PST 4/9 0 LOG 00000 statement: SET client_encoding = 'UTF8';SET client_min_messages TO WARNING;
2016-02-08 15:26:39.411 PST j demo1 93675 ::1:50895 56b9241d.16deb 7 idle in transaction 2016-02-08 15:26:21 PST 3/6 0 LOG 00000 statement: set local role 'j';
2016-02-08 15:26:39.911 PST j demo1 93678 ::1:50897 56b92422.16dee 7 idle in transaction 2016-02-08 15:26:26 PST 5/4 0 LOG 00000 statement: set local role 'j';
2016-02-08 15:26:40.410 PST j demo1 93688 ::1:50907 56b9242b.16df8 2 idle 2016-02-08 15:26:35 PST 2/30 0 LOG 00000 statement: begin ISOLATION LEVEL READ COMMITTED;
2016-02-08 15:26:40.911 PST j demo1 93688 ::1:50907 56b9242b.16df8 3 idle in transaction 2016-02-08 15:26:35 PST 2/30 0 LOG 00000 statement: set local role 'j';
2016-02-08 15:26:41.411 PST j demo1 93690 ::1:50909 56b9242d.16dfa 2 idle 2016-02-08 15:26:37 PST 4/10 0 LOG 00000 statement: begin ISOLATION LEVEL READ COMMITTED;
2016-02-08 15:26:41.913 PST j demo1 93690 ::1:50909 56b9242d.16dfa 3 idle in transaction 2016-02-08 15:26:37 PST 4/10 0 LOG 00000 statement: set local role 'j';
2016-02-08 15:26:42.413 PST j demo1 93675 ::1:50895 56b9241d.16deb 8 idle in transaction 2016-02-08 15:26:21 PST 3/6 0 LOG 00000 statement: LOCK TABLE "public"."film" IN SHARE ROW EXCLUSIVE MODE;
2016-02-08 15:26:42.913 PST j demo1 93675 ::1:50895 56b9241d.16deb 9 idle in transaction 2016-02-08 15:26:21 PST 3/6 0 LOG 00000 statement: commit;
2016-02-08 15:26:43.413 PST j demo1 93688 ::1:50907 56b9242b.16df8 4 idle in transaction 2016-02-08 15:26:35 PST 2/30 0 LOG 00000 statement: LOCK TABLE "public"."film" IN SHARE ROW EXCLUSIVE MODE;
2016-02-08 15:26:43.914 PST j demo1 93688 ::1:50907 56b9242b.16df8 5 idle in transaction 2016-02-08 15:26:35 PST 2/30 0 LOG 00000 statement: commit;
2016-02-08 15:26:44.415 PST j demo1 93690 ::1:50909 56b9242d.16dfa 4 idle in transaction 2016-02-08 15:26:37 PST 4/10 0 LOG 00000 statement: LOCK TABLE "public"."film" IN SHARE ROW EXCLUSIVE MODE;
2016-02-08 15:26:44.916 PST j demo1 93678 ::1:50897 56b92422.16dee 8 idle in transaction 2016-02-08 15:26:26 PST 5/4 0 LOG 00000 statement: LOCK TABLE "public"."film" IN SHARE ROW EXCLUSIVE MODE;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment