explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ieLA

Settings
# exclusive inclusive rows x rows loops node
1. 0.947 1,369.003 ↓ 41.0 246 1

Nested Loop (cost=1.39..781.39 rows=6 width=1,245) (actual time=21.441..1,369.003 rows=246 loops=1)

2. 325.754 325.754 ↓ 41.0 246 1

Index Scan using ix_bc_user_cs on breadcrumb bc (cost=0.69..729.06 rows=6 width=380) (actual time=17.769..325.754 rows=246 loops=1)

  • Index Cond: (((user_business_key)::text = ANY ('{bd73ab06-fa7b-4eaf-8c13-75c9fe15fcb9,cd2d125e-c3f2-4e77-93b2-3b00d50eb7e9,b1de30f3-0d9b-4330-89e3-fad56fa3f1ab,48cf4488-49a6-4977-b495-57f83a6112c5,d1d5ee17-7cfb-4a8a-9cd0-639f01fc0fae,62f846ce-e969-47f5-bbce-b4d1e7fbe751,6fdfe79f-e1eb-4c5e-ba43-d332a3afa43f,d1f373fa-d8b7-4345-8c56-c282ed86ce83,cdf86179-42c9-420f-999f-26428d8956ce,5a4c60c4-90e7-49f6-98ff-613a188bd3f9,40ee8592-9fb3-4103-ad53-894a938147fd,bcb997ee-24c2-4422-8529-d96e9840b8ee,3f001fbb-d8b4-4a33-a9fa-634763b436c2,27355423-1aab-4c0d-8005-85e0a90f15cd,4a054599-9e1e-47c5-a912-4047a42fcb34,f1cfb8c6-f98e-4428-a4df-c2aa56d3e952,4e60f228-5fba-4c23-bdf3-787a0acf4f2e,eff5b1f4-12f9-454b-a58d-04c9f7b4f895,ba0fed2a-5622-4301-9a4a-d882e1fa614d,9aa52ac9-a087-46dc-aa8b-2c274a27ef0e,451d21a8-0e29-4ad6-aa25-8725bae5b904,72908f16-b0cc-410a-bb42-79798491cff0,28f0fe9f-9cd1-431d-add5-dac4c5279cdc,fc6886f9-d136-44c8-ac34-8b72c735f365,3bbd1acf-e43d-4450-8b69-5712a587db0e,1f2c817f-f3bc-4cfd-8d7d-7ffe4ba94674,7d7b207b-a5d2-4a9d-8846-691e87662626,0ba00409-81a2-4eca-8ce1-edbe5f1f6a26,0c59d703-d350-47cd-997c-e1546fe4b63a,3312e73d-b81f-4701-974e-b57d6602c0ed,ce8ea902-f16a-4b47-9dcb-6b0d331e96ea,2a60a853-f549-4a83-8c74-bfec79576d8a,60deb5c3-544f-4a6e-84a4-069460408817,a75c9b31-f935-4c5e-82fa-5c86a13ab213,20b08f39-67d2-40f1-aea2-708853a6067a,b6895c03-8a3e-40d3-a33e-25d367db6e5b,17fc697c-9177-458c-8bdc-4ac03eec9d25,702b0a85-1537-475d-b559-170c7f052190,0a949a77-8042-4604-8eda-288fb10164d8,53e5cc6f-ae9e-4c0a-b130-e2e683e6bd3f,b19ab745-cc25-4951-af6f-5f809f5f4906,fa317ef5-7a5e-440c-a485-8f2a360bcb2c,d5198834-a9c1-43f6-8485-fc57ed188861,62276887-8f89-46e0-b936-80d3a6724f25,d495662d-52cd-4a83-82ab-f1c9dbbd7566,aa3d3d9f-5b08-47b2-889e-8aefd09156cf,f49dd042-222a-4883-997c-cef5323ea762,34ab1c39-c41c-4670-b3e0-dcb55248f445,6c116685-dda8-4deb-b8b7-3c548d50d296,8ed643a8-1fde-4527-a1c5-1b1feeb23d6a}'::text[])) AND ((cardstack_key)::text = ANY ('{ff80808154ce31c90155124ca83059df_californiaintegrated,ff80808154ce31c90154e96aaf2e235b_californiaintegrated,ff80808154ce31c90154e95ea2f322ac_californiaintegrated}'::text[])))
3. 1,042.302 1,042.302 ↑ 1.0 1 246

Index Scan using submission_pkey on submission sb (cost=0.70..8.71 rows=1 width=902) (actual time=4.236..4.237 rows=1 loops=246)

  • Index Cond: ((id)::text = (bc.submission_id)::text)
Planning time : 38.276 ms