-
-
Save twarberg/20443600478d8396e76ae1a699298217 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Thu 07 Dec 2017 12:29:52 PM UTC | |
| pid | datname | client_addr | wait_event_type | wait_event | query_start | state | query | |
| -------+---------------------+-------------+-----------------+------------------+-------------------------------+--------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ | |
| 27870 | | 127.0.0.1 | Activity | WalSenderMain | | active | | |
| 26668 | frontend_production | | | | 2017-12-07 12:29:52.942082+00 | active | SELECT pid,datname,client_addr,wait_event_type,wait_event,query_start,state,query FROM pg_stat_activity WHERE state NOT LIKE 'idle%' ORDER BY query_start DESC; | |
| 15429 | frontend_production | 10.132.0.13 | IPC | BtreePage | 2017-12-07 12:29:00.820938+00 | active | SELECT COUNT(*) FROM "papers" WHERE "papers"."id" IN (SELECT "paragraph_papers"."page_id" FROM "paragraph_papers" INNER JOIN "paragraphs" ON "paragraph_papers"."paragraph_id" = "paragraphs"."id" WHERE "paragraph_papers"."deleted_at" IS NULL AND "paragraphs"."deleted_at" IS NULL AND "paragraphs"."type_id" = 117 AND "paragraph_papers"."reviewed" = 'f' AND "paragraphs"."folder_id" = 10095) | |
| 13415 | frontend_production | 10.132.0.13 | IPC | BtreePage | 2017-12-07 12:28:57.769721+00 | active | SELECT COUNT(*) FROM "papers" WHERE "papers"."id" IN (SELECT "paragraph_papers"."page_id" FROM "paragraph_papers" INNER JOIN "paragraphs" ON "paragraph_papers"."paragraph_id" = "paragraphs"."id" WHERE "paragraph_papers"."deleted_at" IS NULL AND "paragraphs"."deleted_at" IS NULL AND "paragraphs"."type_id" = 110 AND "paragraph_papers"."reviewed" = 'f' AND "paragraphs"."folder_id" = 10095) | |
| 13412 | frontend_production | 10.132.0.13 | IPC | BtreePage | 2017-12-07 12:28:55.728332+00 | active | SELECT COUNT(*) FROM "papers" WHERE "papers"."id" IN (SELECT "paragraph_papers"."page_id" FROM "paragraph_papers" INNER JOIN "paragraphs" ON "paragraph_papers"."paragraph_id" = "paragraphs"."id" WHERE "paragraph_papers"."deleted_at" IS NULL AND "paragraphs"."deleted_at" IS NULL AND "paragraphs"."type_id" = 82 AND "paragraph_papers"."reviewed" = 'f' AND "paragraphs"."folder_id" = 10095) | |
| 15848 | frontend_production | 10.132.0.13 | IPC | BtreePage | 2017-12-07 12:28:55.720853+00 | active | SELECT COUNT(*) FROM "papers" WHERE "papers"."id" IN (SELECT "paragraph_papers"."page_id" FROM "paragraph_papers" INNER JOIN "paragraphs" ON "paragraph_papers"."paragraph_id" = "paragraphs"."id" WHERE "paragraph_papers"."deleted_at" IS NULL AND "paragraphs"."deleted_at" IS NULL AND "paragraphs"."type_id" = 28 AND "paragraph_papers"."reviewed" = 'f' AND "paragraphs"."folder_id" = 10095) | |
| 14959 | frontend_production | 10.132.0.13 | IPC | BtreePage | 2017-12-07 12:28:55.720172+00 | active | SELECT COUNT(*) FROM "papers" WHERE "papers"."id" IN (SELECT "paragraph_papers"."page_id" FROM "paragraph_papers" INNER JOIN "paragraphs" ON "paragraph_papers"."paragraph_id" = "paragraphs"."id" WHERE "paragraph_papers"."deleted_at" IS NULL AND "paragraphs"."deleted_at" IS NULL AND "paragraphs"."type_id" = 55 AND "paragraph_papers"."reviewed" = 'f' AND "paragraphs"."folder_id" = 10095) | |
| 13409 | frontend_production | 10.132.0.13 | IPC | BtreePage | 2017-12-07 12:28:55.710764+00 | active | SELECT COUNT(*) FROM "papers" WHERE "papers"."id" IN (SELECT "paragraph_papers"."page_id" FROM "paragraph_papers" INNER JOIN "paragraphs" ON "paragraph_papers"."paragraph_id" = "paragraphs"."id" WHERE "paragraph_papers"."deleted_at" IS NULL AND "paragraphs"."deleted_at" IS NULL AND "paragraphs"."type_id" = 14 AND "paragraph_papers"."reviewed" = 'f' AND "paragraphs"."folder_id" = 10095) | |
| 13601 | frontend_production | 10.132.0.13 | IPC | BtreePage | 2017-12-07 12:28:55.703432+00 | active | SELECT COUNT(*) FROM "papers" WHERE "papers"."id" IN (SELECT "paragraph_papers"."page_id" FROM "paragraph_papers" INNER JOIN "paragraphs" ON "paragraph_papers"."paragraph_id" = "paragraphs"."id" WHERE "paragraph_papers"."deleted_at" IS NULL AND "paragraphs"."deleted_at" IS NULL AND "paragraphs"."type_id" = 16 AND "paragraph_papers"."reviewed" = 'f' AND "paragraphs"."folder_id" = 10095) | |
| 14800 | frontend_production | 10.132.0.13 | IPC | BtreePage | 2017-12-07 12:28:55.690105+00 | active | SELECT COUNT(*) FROM "papers" WHERE "papers"."id" IN (SELECT "paragraph_papers"."page_id" FROM "paragraph_papers" INNER JOIN "paragraphs" ON "paragraph_papers"."paragraph_id" = "paragraphs"."id" WHERE "paragraph_papers"."deleted_at" IS NULL AND "paragraphs"."deleted_at" IS NULL AND "paragraphs"."type_id" = 8 AND "paragraph_papers"."reviewed" = 'f' AND "paragraphs"."folder_id" = 10095) | |
| 13349 | frontend_production | 10.132.0.13 | IPC | BtreePage | 2017-12-07 12:28:20.298035+00 | active | SELECT COUNT(*) FROM "papers" WHERE "papers"."id" IN (SELECT "paragraph_papers"."page_id" FROM "paragraph_papers" INNER JOIN "paragraphs" ON "paragraph_papers"."paragraph_id" = "paragraphs"."id" WHERE "paragraph_papers"."deleted_at" IS NULL AND "paragraphs"."deleted_at" IS NULL AND "paragraphs"."type_id" = 270 AND "paragraph_papers"."reviewed" = 'f' AND "paragraphs"."folder_id" = 10095) | |
| 26983 | frontend_production | | IPC | BtreePage | 2017-12-07 12:28:20.148211+00 | active | SELECT COUNT(*) FROM "papers" WHERE "papers"."id" IN (SELECT "paragraph_papers"."page_id" FROM "paragraph_papers" INNER JOIN "paragraphs" ON "paragraph_papers"."paragraph_id" = "paragraphs"."id" WHERE "paragraph_papers"."deleted_at" IS NULL AND "paragraphs"."deleted_at" IS NULL AND "paragraphs"."type_id" = 11 AND "paragraph_papers"."reviewed" = 'f' AND "paragraphs"."folder_id" = 10095) | |
| 15233 | frontend_production | 10.132.0.13 | IPC | BtreePage | 2017-12-07 12:28:20.145069+00 | active | SELECT COUNT(*) FROM "papers" WHERE "papers"."id" IN (SELECT "paragraph_papers"."page_id" FROM "paragraph_papers" INNER JOIN "paragraphs" ON "paragraph_papers"."paragraph_id" = "paragraphs"."id" WHERE "paragraph_papers"."deleted_at" IS NULL AND "paragraphs"."deleted_at" IS NULL AND "paragraphs"."type_id" = 11 AND "paragraph_papers"."reviewed" = 'f' AND "paragraphs"."folder_id" = 10095) | |
| 15106 | frontend_production | 10.132.0.13 | IPC | BtreePage | 2017-12-07 12:27:11.021132+00 | active | SELECT COUNT(*) FROM "papers" WHERE "papers"."id" IN (SELECT "paragraph_papers"."page_id" FROM "paragraph_papers" INNER JOIN "paragraphs" ON "paragraph_papers"."paragraph_id" = "paragraphs"."id" WHERE "paragraph_papers"."deleted_at" IS NULL AND "paragraphs"."deleted_at" IS NULL AND "paragraphs"."type_id" = 131 AND "paragraph_papers"."reviewed" = 'f' AND "paragraphs"."folder_id" = 10095) | |
| 15161 | frontend_production | 10.132.0.13 | IPC | BtreePage | 2017-12-07 12:27:10.941931+00 | active | SELECT COUNT(*) FROM "papers" WHERE "papers"."id" IN (SELECT "paragraph_papers"."page_id" FROM "paragraph_papers" INNER JOIN "paragraphs" ON "paragraph_papers"."paragraph_id" = "paragraphs"."id" WHERE "paragraph_papers"."deleted_at" IS NULL AND "paragraphs"."deleted_at" IS NULL AND "paragraphs"."type_id" = 54 AND "paragraph_papers"."reviewed" = 'f' AND "paragraphs"."folder_id" = 10095) | |
| 15211 | frontend_production | 10.132.0.13 | IPC | BtreePage | 2017-12-07 12:27:10.801825+00 | active | SELECT COUNT(*) FROM "papers" WHERE "papers"."id" IN (SELECT "paragraph_papers"."page_id" FROM "paragraph_papers" INNER JOIN "paragraphs" ON "paragraph_papers"."paragraph_id" = "paragraphs"."id" WHERE "paragraph_papers"."deleted_at" IS NULL AND "paragraphs"."deleted_at" IS NULL AND "paragraphs"."type_id" = 116 AND "paragraph_papers"."reviewed" = 'f' AND "paragraphs"."folder_id" = 10095) | |
| 14923 | frontend_production | 10.132.0.13 | IPC | BtreePage | 2017-12-07 12:27:10.742747+00 | active | SELECT COUNT(*) FROM "papers" WHERE "papers"."id" IN (SELECT "paragraph_papers"."page_id" FROM "paragraph_papers" INNER JOIN "paragraphs" ON "paragraph_papers"."paragraph_id" = "paragraphs"."id" WHERE "paragraph_papers"."deleted_at" IS NULL AND "paragraphs"."deleted_at" IS NULL AND "paragraphs"."type_id" = 55 AND "paragraph_papers"."reviewed" = 'f' AND "paragraphs"."folder_id" = 10095) | |
| 14695 | frontend_production | 10.132.0.13 | IPC | BtreePage | 2017-12-07 12:27:10.684086+00 | active | SELECT COUNT(*) FROM "papers" WHERE "papers"."id" IN (SELECT "paragraph_papers"."page_id" FROM "paragraph_papers" INNER JOIN "paragraphs" ON "paragraph_papers"."paragraph_id" = "paragraphs"."id" WHERE "paragraph_papers"."deleted_at" IS NULL AND "paragraphs"."deleted_at" IS NULL AND "paragraphs"."type_id" = 28 AND "paragraph_papers"."reviewed" = 'f' AND "paragraphs"."folder_id" = 10095) | |
| 15138 | frontend_production | 10.132.0.13 | IPC | BtreePage | 2017-12-07 12:27:10.675413+00 | active | SELECT COUNT(*) FROM "papers" WHERE "papers"."id" IN (SELECT "paragraph_papers"."page_id" FROM "paragraph_papers" INNER JOIN "paragraphs" ON "paragraph_papers"."paragraph_id" = "paragraphs"."id" WHERE "paragraph_papers"."deleted_at" IS NULL AND "paragraphs"."deleted_at" IS NULL AND "paragraphs"."type_id" = 262 AND "paragraph_papers"."reviewed" = 'f' AND "paragraphs"."folder_id" = 10095) | |
| 13422 | frontend_production | 10.132.0.13 | IPC | BtreePage | 2017-12-07 12:27:10.649404+00 | active | SELECT COUNT(*) FROM "papers" WHERE "papers"."id" IN (SELECT "paragraph_papers"."page_id" FROM "paragraph_papers" INNER JOIN "paragraphs" ON "paragraph_papers"."paragraph_id" = "paragraphs"."id" WHERE "paragraph_papers"."deleted_at" IS NULL AND "paragraphs"."deleted_at" IS NULL AND "paragraphs"."type_id" = 271 AND "paragraph_papers"."reviewed" = 'f' AND "paragraphs"."folder_id" = 10095) | |
| 15030 | frontend_production | 10.132.0.13 | IPC | BtreePage | 2017-12-07 12:27:10.591241+00 | active | SELECT COUNT(*) FROM "papers" WHERE "papers"."id" IN (SELECT "paragraph_papers"."page_id" FROM "paragraph_papers" INNER JOIN "paragraphs" ON "paragraph_papers"."paragraph_id" = "paragraphs"."id" WHERE "paragraph_papers"."deleted_at" IS NULL AND "paragraphs"."deleted_at" IS NULL AND "paragraphs"."type_id" = 189 AND "paragraph_papers"."reviewed" = 'f' AND "paragraphs"."folder_id" = 10095) | |
| 15042 | frontend_production | 10.132.0.13 | IPC | BtreePage | 2017-12-07 12:27:10.582241+00 | active | SELECT COUNT(*) FROM "papers" WHERE "papers"."id" IN (SELECT "paragraph_papers"."page_id" FROM "paragraph_papers" INNER JOIN "paragraphs" ON "paragraph_papers"."paragraph_id" = "paragraphs"."id" WHERE "paragraph_papers"."deleted_at" IS NULL AND "paragraphs"."deleted_at" IS NULL AND "paragraphs"."type_id" = 211 AND "paragraph_papers"."reviewed" = 'f' AND "paragraphs"."folder_id" = 10095) | |
| 14969 | frontend_production | 10.132.0.13 | IPC | BtreePage | 2017-12-07 12:27:10.556133+00 | active | SELECT COUNT(*) FROM "papers" WHERE "papers"."id" IN (SELECT "paragraph_papers"."page_id" FROM "paragraph_papers" INNER JOIN "paragraphs" ON "paragraph_papers"."paragraph_id" = "paragraphs"."id" WHERE "paragraph_papers"."deleted_at" IS NULL AND "paragraphs"."deleted_at" IS NULL AND "paragraphs"."type_id" = 42 AND "paragraph_papers"."reviewed" = 'f' AND "paragraphs"."folder_id" = 10095) | |
| 13653 | frontend_production | 10.132.0.13 | IPC | BtreePage | 2017-12-07 12:27:10.518218+00 | active | SELECT COUNT(*) FROM "papers" WHERE "papers"."id" IN (SELECT "paragraph_papers"."page_id" FROM "paragraph_papers" INNER JOIN "paragraphs" ON "paragraph_papers"."paragraph_id" = "paragraphs"."id" WHERE "paragraph_papers"."deleted_at" IS NULL AND "paragraphs"."deleted_at" IS NULL AND "paragraphs"."type_id" = 82 AND "paragraph_papers"."reviewed" = 'f' AND "paragraphs"."folder_id" = 10095) | |
| 14824 | frontend_production | 10.132.0.13 | IPC | BtreePage | 2017-12-07 12:27:10.49698+00 | active | SELECT COUNT(*) FROM "papers" WHERE "papers"."id" IN (SELECT "paragraph_papers"."page_id" FROM "paragraph_papers" INNER JOIN "paragraphs" ON "paragraph_papers"."paragraph_id" = "paragraphs"."id" WHERE "paragraph_papers"."deleted_at" IS NULL AND "paragraphs"."deleted_at" IS NULL AND "paragraphs"."type_id" = 241 AND "paragraph_papers"."reviewed" = 'f' AND "paragraphs"."folder_id" = 10095) | |
| 14916 | frontend_production | 10.132.0.13 | IPC | BtreePage | 2017-12-07 12:27:10.482684+00 | active | SELECT COUNT(*) FROM "papers" WHERE "papers"."id" IN (SELECT "paragraph_papers"."page_id" FROM "paragraph_papers" INNER JOIN "paragraphs" ON "paragraph_papers"."paragraph_id" = "paragraphs"."id" WHERE "paragraph_papers"."deleted_at" IS NULL AND "paragraphs"."deleted_at" IS NULL AND "paragraphs"."type_id" = 184 AND "paragraph_papers"."reviewed" = 'f' AND "paragraphs"."folder_id" = 10095) | |
| 14943 | frontend_production | | IPC | BtreePage | 2017-12-07 12:27:10.462201+00 | active | SELECT COUNT(*) FROM "papers" WHERE "papers"."id" IN (SELECT "paragraph_papers"."page_id" FROM "paragraph_papers" INNER JOIN "paragraphs" ON "paragraph_papers"."paragraph_id" = "paragraphs"."id" WHERE "paragraph_papers"."deleted_at" IS NULL AND "paragraphs"."deleted_at" IS NULL AND "paragraphs"."type_id" = 110 AND "paragraph_papers"."reviewed" = 'f' AND "paragraphs"."folder_id" = 10095) | |
| 13693 | frontend_production | 10.132.0.13 | IPC | BtreePage | 2017-12-07 12:27:10.461784+00 | active | SELECT COUNT(*) FROM "papers" WHERE "papers"."id" IN (SELECT "paragraph_papers"."page_id" FROM "paragraph_papers" INNER JOIN "paragraphs" ON "paragraph_papers"."paragraph_id" = "paragraphs"."id" WHERE "paragraph_papers"."deleted_at" IS NULL AND "paragraphs"."deleted_at" IS NULL AND "paragraphs"."type_id" = 117 AND "paragraph_papers"."reviewed" = 'f' AND "paragraphs"."folder_id" = 10095) | |
| 14958 | frontend_production | | IPC | BtreePage | 2017-12-07 12:27:10.450794+00 | active | SELECT COUNT(*) FROM "papers" WHERE "papers"."id" IN (SELECT "paragraph_papers"."page_id" FROM "paragraph_papers" INNER JOIN "paragraphs" ON "paragraph_papers"."paragraph_id" = "paragraphs"."id" WHERE "paragraph_papers"."deleted_at" IS NULL AND "paragraphs"."deleted_at" IS NULL AND "paragraphs"."type_id" = 276 AND "paragraph_papers"."reviewed" = 'f' AND "paragraphs"."folder_id" = 10095) | |
| 14949 | frontend_production | | IPC | MessageQueueSend | 2017-12-07 12:27:10.449203+00 | active | SELECT COUNT(*) FROM "papers" WHERE "papers"."id" IN (SELECT "paragraph_papers"."page_id" FROM "paragraph_papers" INNER JOIN "paragraphs" ON "paragraph_papers"."paragraph_id" = "paragraphs"."id" WHERE "paragraph_papers"."deleted_at" IS NULL AND "paragraphs"."deleted_at" IS NULL AND "paragraphs"."type_id" = 250 AND "paragraph_papers"."reviewed" = 'f' AND "paragraphs"."folder_id" = 10095) | |
| 14941 | frontend_production | | IPC | MessageQueueSend | 2017-12-07 12:27:10.448198+00 | active | SELECT COUNT(*) FROM "papers" WHERE "papers"."id" IN (SELECT "paragraph_papers"."page_id" FROM "paragraph_papers" INNER JOIN "paragraphs" ON "paragraph_papers"."paragraph_id" = "paragraphs"."id" WHERE "paragraph_papers"."deleted_at" IS NULL AND "paragraphs"."deleted_at" IS NULL AND "paragraphs"."type_id" = 14 AND "paragraph_papers"."reviewed" = 'f' AND "paragraphs"."folder_id" = 10095) | |
| 14940 | frontend_production | | IPC | MessageQueueSend | 2017-12-07 12:27:10.446116+00 | active | SELECT COUNT(*) FROM "papers" WHERE "papers"."id" IN (SELECT "paragraph_papers"."page_id" FROM "paragraph_papers" INNER JOIN "paragraphs" ON "paragraph_papers"."paragraph_id" = "paragraphs"."id" WHERE "paragraph_papers"."deleted_at" IS NULL AND "paragraphs"."deleted_at" IS NULL AND "paragraphs"."type_id" = 16 AND "paragraph_papers"."reviewed" = 'f' AND "paragraphs"."folder_id" = 10095) | |
| 13865 | frontend_production | 10.132.0.13 | IPC | BtreePage | 2017-12-07 12:27:10.445643+00 | active | SELECT COUNT(*) FROM "papers" WHERE "papers"."id" IN (SELECT "paragraph_papers"."page_id" FROM "paragraph_papers" INNER JOIN "paragraphs" ON "paragraph_papers"."paragraph_id" = "paragraphs"."id" WHERE "paragraph_papers"."deleted_at" IS NULL AND "paragraphs"."deleted_at" IS NULL AND "paragraphs"."type_id" = 8 AND "paragraph_papers"."reviewed" = 'f' AND "paragraphs"."folder_id" = 10095) | |
| 13471 | frontend_production | 10.132.0.13 | IPC | BtreePage | 2017-12-07 12:27:10.4444+00 | active | SELECT COUNT(*) FROM "papers" WHERE "papers"."id" IN (SELECT "paragraph_papers"."page_id" FROM "paragraph_papers" INNER JOIN "paragraphs" ON "paragraph_papers"."paragraph_id" = "paragraphs"."id" WHERE "paragraph_papers"."deleted_at" IS NULL AND "paragraphs"."deleted_at" IS NULL AND "paragraphs"."type_id" = 276 AND "paragraph_papers"."reviewed" = 'f' AND "paragraphs"."folder_id" = 10095) | |
| 13582 | frontend_production | 10.132.0.13 | IPC | BtreePage | 2017-12-07 12:27:10.443157+00 | active | SELECT COUNT(*) FROM "papers" WHERE "papers"."id" IN (SELECT "paragraph_papers"."page_id" FROM "paragraph_papers" INNER JOIN "paragraphs" ON "paragraph_papers"."paragraph_id" = "paragraphs"."id" WHERE "paragraph_papers"."deleted_at" IS NULL AND "paragraphs"."deleted_at" IS NULL AND "paragraphs"."type_id" = 110 AND "paragraph_papers"."reviewed" = 'f' AND "paragraphs"."folder_id" = 10095) | |
| 14188 | frontend_production | 10.132.0.13 | IPC | BtreePage | 2017-12-07 12:27:10.443087+00 | active | SELECT COUNT(*) FROM "papers" WHERE "papers"."id" IN (SELECT "paragraph_papers"."page_id" FROM "paragraph_papers" INNER JOIN "paragraphs" ON "paragraph_papers"."paragraph_id" = "paragraphs"."id" WHERE "paragraph_papers"."deleted_at" IS NULL AND "paragraphs"."deleted_at" IS NULL AND "paragraphs"."type_id" = 14 AND "paragraph_papers"."reviewed" = 'f' AND "paragraphs"."folder_id" = 10095) | |
| 13702 | frontend_production | 10.132.0.13 | IPC | BtreePage | 2017-12-07 12:27:10.442421+00 | active | SELECT COUNT(*) FROM "papers" WHERE "papers"."id" IN (SELECT "paragraph_papers"."page_id" FROM "paragraph_papers" INNER JOIN "paragraphs" ON "paragraph_papers"."paragraph_id" = "paragraphs"."id" WHERE "paragraph_papers"."deleted_at" IS NULL AND "paragraphs"."deleted_at" IS NULL AND "paragraphs"."type_id" = 250 AND "paragraph_papers"."reviewed" = 'f' AND "paragraphs"."folder_id" = 10095) | |
| 13547 | frontend_production | 10.132.0.13 | IPC | BtreePage | 2017-12-07 12:27:10.442203+00 | active | SELECT COUNT(*) FROM "papers" WHERE "papers"."id" IN (SELECT "paragraph_papers"."page_id" FROM "paragraph_papers" INNER JOIN "paragraphs" ON "paragraph_papers"."paragraph_id" = "paragraphs"."id" WHERE "paragraph_papers"."deleted_at" IS NULL AND "paragraphs"."deleted_at" IS NULL AND "paragraphs"."type_id" = 16 AND "paragraph_papers"."reviewed" = 'f' AND "paragraphs"."folder_id" = 10095) | |
| 20828 | frontend_production | | IO | DataFileRead | 2017-12-07 12:26:57.333596+00 | active | autovacuum: VACUUM public.paragraphs (to prevent wraparound) | |
| (38 rows) |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment