explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jD7j

Settings
# exclusive inclusive rows x rows loops node
1. 1.222 114,455.072 ↓ 4.1 5,244 1

Nested Loop (cost=1.42..2,441,664.34 rows=1,286 width=40) (actual time=0.037..114,455.072 rows=5,244 loops=1)

2. 0.434 0.434 ↓ 7.0 49 1

Index Scan using subset_id_partitions_name_idx on subset subset2_ (cost=0.28..239.21 rows=7 width=24) (actual time=0.007..0.434 rows=49 loops=1)

  • Index Cond: ((partitions_name)::text = 'REGIONS'::text)
  • Filter: (uuid = ANY ('{8f3d70d5-ffbf-4636-b8fd-d0e294575412,56e12e51-1c39-48a1-91b1-d38aaea81925,a95896a1-5330-4945-89d0-63e57a232650,8c973d0d-aa14-4f85-84e3-d1c859562422,4e0e3984-eb3c-49bf-9cdd-40c72fd4fb2c,efe4419a-51ae-4f37-a7ba-768100b4ca0d,4506e189-2547-4b77-a711-304f519da4d0,3300a67e-0568-4e1a-8238-e0662ec72180,3841c245-fac1-40a6-8b8f-8d6876447a6d,eb9a7dd0-61f7-4cac-8dd1-eebfa7643bc1,99c5555d-082d-4b19-b635-d790b92f6fd4,a61c1ba1-af27-44b2-b939-56fd861c9b16,50890cc0-9d93-44bf-b475-d21979ee0de5,987f4919-d2e2-4331-b373-191a07df46e4,a6a03020-ac1e-421b-af92-30494bc4116f,b1f2a933-9a95-4f09-ad8b-4b5a89496e08,21239515-e474-4ba3-a54c-6613991e13be,e0f3ef92-98a9-4989-ac94-f865f96268f9,de3e0e61-6749-42d0-9b64-cebcb022cb37,3636340a-3046-43d9-81ac-cfa62865408f,034132bf-6399-408f-9263-218d2aad1902,5ed2c46b-f439-45f6-a6c1-a4ff03519fdd,ff0728aa-79fd-4f51-9bcf-ea76fe03dffb,4e8154a3-db68-485e-8e8a-65ae2fcb2f72,30a4c365-0ff0-4db7-8691-82e8470b3820,b2ddeda6-069d-4cf6-97cb-635dd0f4ced5,4b4990c3-89e4-46f5-94c5-0884d1a03d38,e1f04486-c8bd-4bfb-9cdb-40e3e08ac343,c2f265af-d2c9-42de-abc1-bcee2f340a52,dd613a3a-8e9d-4188-bb1d-21991bfaae34,bc693b0d-ea65-4021-aae9-6e36ade47025,4a93175c-eafd-4008-99eb-0d80d7bb6b43,edb364a0-a466-4fb6-81c1-3a0ac0729358,44251947-4dd0-4db4-bf6e-a3b6c76ea45f,3a79a0ad-e08e-4e28-a10a-f549f8ecaa4d,0229323a-3119-47f8-8676-c2833c53ea9a,714112b9-fee6-44c8-8a90-5c722cdab782,5c770096-6ae5-4e0e-b687-3a975f0ae189,2c2f99bd-cc25-4be4-9102-2223c91734d9,33b3e5d4-6e82-437c-9b8c-e3a783cbe723,39737a36-5787-40cf-a259-a28b02b4a0af,44286460-5131-417f-ae87-9a5efaaffba7,f643fdc6-25b0-40f9-b3e9-04be53795e15,29a2d223-66e7-4c0e-8e00-065f8ed3f4db,2721a164-0a92-4106-8aca-d68b6e4de9b3,b60756c2-693b-4516-9fb9-2047cc6a6c1e,33e03517-ef2f-4cec-8502-6a1f5260bfc5,9f29e764-822f-4c8f-906e-c38d27f2a6d1,b491b976-f9db-438a-9be6-65007c944ca6}'::uuid[]))
  • Rows Removed by Filter: 140
3. 844.515 114,453.416 ↑ 750.0 107 49

Nested Loop (cost=1.15..340,749.62 rows=80,254 width=32) (actual time=68.718..2,335.784 rows=107 loops=49)

4. 106,986.306 106,986.306 ↑ 3.0 27,031 49

Index Scan using idx_order_delivery_order_state on order_delivery fleetorder0_ (cost=0.57..94,312.51 rows=80,254 width=32) (actual time=0.692..2,183.394 rows=27,031 loops=49)

  • Index Cond: ((order_state)::text = 'AVAILABLE'::text)
  • Filter: (((order_type)::text = ANY ('{OWN_DELIVERY,MARKET_PLACE_DELIVERY,HYBRID,ON_DEMAND}'::text[])) OR (((order_type)::text = 'LOOP_DELIVERY'::text) AND (order_group_id IS NOT NULL)))
  • Rows Removed by Filter: 2,114
5. 6,622.595 6,622.595 ↓ 0.0 0 1,324,519

Index Only Scan using order_subset_pkey on order_subset subsets1_ (cost=0.57..2.97 rows=1 width=16) (actual time=0.005..0.005 rows=0 loops=1,324,519)

  • Index Cond: ((order_id = fleetorder0_.id) AND (subset_id = subset2_.id))
  • Heap Fetches: 5,241
Planning time : 0.571 ms
Execution time : 114,455.743 ms