-
-
Save twarberg/514f382af7adec19248eba55f94a4e6a 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 11:44:12 AM UTC | |
| pid | datname | client_addr | wait_event_type | wait_event | query_start | state | query | |
| -------+---------------------+-------------+-----------------+------------------+-------------------------------+--------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ | |
| 1073 | | 127.0.0.1 | | | | active | | |
| 27910 | frontend_production | | | | 2017-12-07 11:44:12.776086+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; | |
| 11219 | frontend_production | 10.132.0.13 | IPC | BtreePage | 2017-12-07 01:37:51.881379+00 | active | SELECT "papers".* FROM "papers" WHERE "papers"."folder_id" = 10095 AND "papers"."id" IN (SELECT "page_id" FROM "paragraphs" INNER JOIN "paragraph_papers" ON "paragraph_papers"."paragraph_id" = "paragraphs"."id" AND "paragraph_papers"."deleted_at" IS NULL WHERE "paragraphs"."deleted_at" IS NULL AND "paragraphs"."folder_id" = 10095 AND "paragraphs"."reviewed" = 'f' AND "paragraphs"."type_id" = 54 AND "paragraph_papers"."deleted_at" IS NULL AND "paragraph_papers"."reviewed" = 'f') ORDER BY title ASC, id ASC LIMIT 10 OFFSET 250 | |
| 23143 | frontend_production | 10.132.0.13 | IPC | BtreePage | 2017-12-07 01:36:51.939122+00 | active | SELECT "papers".* FROM "papers" WHERE "papers"."folder_id" = 10095 AND "papers"."id" IN (SELECT "page_id" FROM "paragraphs" INNER JOIN "paragraph_papers" ON "paragraph_papers"."paragraph_id" = "paragraphs"."id" AND "paragraph_papers"."deleted_at" IS NULL WHERE "paragraphs"."deleted_at" IS NULL AND "paragraphs"."folder_id" = 10095 AND "paragraphs"."reviewed" = 'f' AND "paragraphs"."type_id" = 54 AND "paragraph_papers"."deleted_at" IS NULL AND "paragraph_papers"."reviewed" = 'f') ORDER BY title ASC, id ASC LIMIT 10 OFFSET 250 | |
| 11130 | frontend_production | 10.132.0.13 | IPC | BtreePage | 2017-12-07 01:34:30.497655+00 | active | SELECT "papers".* FROM "papers" WHERE "papers"."folder_id" = 10095 AND "papers"."id" IN (SELECT "page_id" FROM "paragraphs" INNER JOIN "paragraph_papers" ON "paragraph_papers"."paragraph_id" = "paragraphs"."id" AND "paragraph_papers"."deleted_at" IS NULL WHERE "paragraphs"."deleted_at" IS NULL AND "paragraphs"."folder_id" = 10095 AND "paragraphs"."reviewed" = 'f' AND "paragraphs"."type_id" = 54 AND "paragraph_papers"."deleted_at" IS NULL AND "paragraph_papers"."reviewed" = 'f') ORDER BY title ASC, id ASC LIMIT 10 OFFSET 250 | |
| 16838 | frontend_production | 10.132.0.13 | IPC | BtreePage | 2017-12-07 01:33:30.502665+00 | active | SELECT "papers".* FROM "papers" WHERE "papers"."folder_id" = 10095 AND "papers"."id" IN (SELECT "page_id" FROM "paragraphs" INNER JOIN "paragraph_papers" ON "paragraph_papers"."paragraph_id" = "paragraphs"."id" AND "paragraph_papers"."deleted_at" IS NULL WHERE "paragraphs"."deleted_at" IS NULL AND "paragraphs"."folder_id" = 10095 AND "paragraphs"."reviewed" = 'f' AND "paragraphs"."type_id" = 54 AND "paragraph_papers"."deleted_at" IS NULL AND "paragraph_papers"."reviewed" = 'f') ORDER BY title ASC, id ASC LIMIT 10 OFFSET 250 | |
| 28755 | frontend_production | 10.132.0.13 | IPC | BtreePage | 2017-12-07 01:31:08.212325+00 | active | SELECT "papers".* FROM "papers" WHERE "papers"."folder_id" = 10095 AND "papers"."id" IN (SELECT "page_id" FROM "paragraphs" INNER JOIN "paragraph_papers" ON "paragraph_papers"."paragraph_id" = "paragraphs"."id" AND "paragraph_papers"."deleted_at" IS NULL WHERE "paragraphs"."deleted_at" IS NULL AND "paragraphs"."folder_id" = 10095 AND "paragraphs"."reviewed" = 'f' AND "paragraphs"."type_id" = 54 AND "paragraph_papers"."deleted_at" IS NULL AND "paragraph_papers"."reviewed" = 'f') ORDER BY title ASC, id ASC LIMIT 10 OFFSET 250 | |
| 11105 | frontend_production | 10.132.0.13 | IPC | BtreePage | 2017-12-07 01:30:23.804418+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) | |
| 23150 | frontend_production | 10.132.0.13 | IPC | BtreePage | 2017-12-07 01:30:08.216565+00 | active | SELECT "papers".* FROM "papers" WHERE "papers"."folder_id" = 10095 AND "papers"."id" IN (SELECT "page_id" FROM "paragraphs" INNER JOIN "paragraph_papers" ON "paragraph_papers"."paragraph_id" = "paragraphs"."id" AND "paragraph_papers"."deleted_at" IS NULL WHERE "paragraphs"."deleted_at" IS NULL AND "paragraphs"."folder_id" = 10095 AND "paragraphs"."reviewed" = 'f' AND "paragraphs"."type_id" = 54 AND "paragraph_papers"."deleted_at" IS NULL AND "paragraph_papers"."reviewed" = 'f') ORDER BY title ASC, id ASC LIMIT 10 OFFSET 250 | |
| 23156 | frontend_production | 10.132.0.13 | IPC | BtreePage | 2017-12-07 01:30:02.974743+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" = 301 AND "paragraph_papers"."reviewed" = 'f' AND "paragraphs"."folder_id" = 10095) | |
| 29236 | frontend_production | 10.132.0.13 | IPC | BtreePage | 2017-12-07 01:29:56.351933+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) | |
| 11075 | frontend_production | 10.132.0.13 | IPC | BtreePage | 2017-12-07 01:29:56.304661+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" = 305 AND "paragraph_papers"."reviewed" = 'f' AND "paragraphs"."folder_id" = 10095) | |
| 7202 | frontend_production | 10.132.0.13 | IPC | BtreePage | 2017-12-07 01:29:49.310329+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) | |
| 10817 | frontend_production | 10.132.0.13 | IPC | BtreePage | 2017-12-07 01:29:48.828581+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" = 272 AND "paragraph_papers"."reviewed" = 'f' AND "paragraphs"."folder_id" = 10095) | |
| 23145 | frontend_production | 10.132.0.13 | IPC | BtreePage | 2017-12-07 01:29:48.685362+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) | |
| 10983 | frontend_production | 10.132.0.13 | IPC | BtreePage | 2017-12-07 01:29:48.684169+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" = 267 AND "paragraph_papers"."reviewed" = 'f' AND "paragraphs"."folder_id" = 10095) | |
| 15979 | frontend_production | 10.132.0.13 | IPC | BtreePage | 2017-12-07 01:29:48.671027+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) | |
| 11281 | frontend_production | 10.132.0.13 | IPC | BtreePage | 2017-12-07 01:29:48.665707+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" = 246 AND "paragraph_papers"."reviewed" = 'f' AND "paragraphs"."folder_id" = 10095) | |
| 26307 | frontend_production | 10.132.0.13 | IPC | BtreePage | 2017-12-07 01:29:48.653252+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) | |
| 16010 | frontend_production | 10.132.0.13 | IPC | BtreePage | 2017-12-07 01:29:48.651554+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" = 268 AND "paragraph_papers"."reviewed" = 'f' AND "paragraphs"."folder_id" = 10095) | |
| 23117 | frontend_production | 10.132.0.13 | IPC | BtreePage | 2017-12-07 01:29:48.643054+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" = 265 AND "paragraph_papers"."reviewed" = 'f' AND "paragraphs"."folder_id" = 10095) | |
| 29212 | frontend_production | 10.132.0.13 | IPC | BtreePage | 2017-12-07 01:29:48.639404+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) | |
| 28359 | frontend_production | 10.132.0.13 | IPC | BtreePage | 2017-12-07 01:29:48.628645+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) | |
| 3832 | frontend_production | 10.132.0.13 | IPC | BtreePage | 2017-12-07 01:29:48.628099+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" = 251 AND "paragraph_papers"."reviewed" = 'f' AND "paragraphs"."folder_id" = 10095) | |
| 18842 | frontend_production | 10.132.0.13 | IPC | BtreePage | 2017-12-07 01:29:48.622262+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) | |
| 10998 | frontend_production | 10.132.0.13 | IPC | BtreePage | 2017-12-07 01:29:48.620746+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) | |
| 28332 | frontend_production | 10.132.0.13 | IPC | BtreePage | 2017-12-07 01:29:48.618636+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) | |
| 23113 | frontend_production | 10.132.0.13 | IPC | BtreePage | 2017-12-07 01:29:48.60359+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) | |
| 28737 | frontend_production | 10.132.0.13 | IPC | BtreePage | 2017-12-07 01:29:48.583983+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) | |
| 11117 | frontend_production | 10.132.0.13 | IPC | BtreePage | 2017-12-07 01:29:48.575581+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) | |
| 11092 | frontend_production | 10.132.0.13 | IPC | BtreePage | 2017-12-07 01:29:48.573694+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) | |
| 28862 | frontend_production | | IPC | MessageQueueSend | 2017-12-07 01:29:48.568769+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) | |
| 28861 | frontend_production | | IPC | BtreePage | 2017-12-07 01:29:48.568242+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) | |
| 28860 | frontend_production | | IPC | BtreePage | 2017-12-07 01:29:48.567476+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) | |
| 28350 | frontend_production | 10.132.0.13 | IPC | BtreePage | 2017-12-07 01:29:48.566321+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) | |
| 11064 | frontend_production | 10.132.0.13 | IPC | BtreePage | 2017-12-07 01:29:48.564264+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) | |
| 28855 | frontend_production | | IPC | BtreePage | 2017-12-07 01:29:48.556282+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) | |
| 28854 | frontend_production | | IPC | BtreePage | 2017-12-07 01:29:48.553114+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) | |
| 10774 | frontend_production | 10.132.0.13 | IPC | BtreePage | 2017-12-07 01:29:48.549963+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) | |
| 22684 | frontend_production | 10.132.0.13 | IPC | BtreePage | 2017-12-07 01:29:04.327322+00 | active | SELECT COUNT(*) FROM "paragraphs" INNER JOIN "paragraph_papers" ON "paragraph_papers"."paragraph_id" = "paragraphs"."id" AND "paragraph_papers"."deleted_at" IS NULL WHERE "paragraphs"."deleted_at" IS NULL AND "paragraphs"."folder_id" = 10095 AND "paragraphs"."type_id" = 270 AND "paragraphs"."reviewed" = 'f' AND "paragraph_papers"."deleted_at" IS NULL AND "paragraph_papers"."reviewed" = 'f' | |
| 26259 | frontend_production | | IPC | BtreePage | 2017-12-07 01:29:03.112258+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 "paragraphs"."folder_id" = 10095) | |
| 28021 | frontend_production | 10.132.0.13 | IPC | BtreePage | 2017-12-07 01:29:03.099874+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 "paragraphs"."folder_id" = 10095) | |
| 3115 | frontend_production | 10.132.0.13 | IPC | BtreePage | 2017-12-07 01:29:02.9964+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) | |
| 21920 | frontend_production | 10.132.0.13 | IPC | BtreePage | 2017-12-07 01:29:02.957997+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" = 269 AND "paragraph_papers"."reviewed" = 'f' AND "paragraphs"."folder_id" = 10095) | |
| 31036 | frontend_production | | LWLock | buffer_content | 2017-12-04 14:27:53.92292+00 | active | autovacuum: VACUUM public.paragraphs (to prevent wraparound) |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment