explain.depesz.com

PostgreSQL's explain analyze made readable

Result: eooc

Settings
# exclusive inclusive rows x rows loops node
1. 17.851 1,018.322 ↓ 25.0 100 1

Gather (cost=1,074.96..59,154.52 rows=4 width=2,240) (actual time=20.359..1,018.322 rows=100 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 0.126 1,000.471 ↓ 16.5 33 3

Nested Loop Left Join (cost=74.96..58,154.12 rows=2 width=2,240) (actual time=8.997..1,000.471 rows=33 loops=3)

3. 0.174 1,000.343 ↓ 16.5 33 3

Nested Loop Left Join (cost=74.82..58,153.81 rows=2 width=1,703) (actual time=8.979..1,000.343 rows=33 loops=3)

4. 191.427 1,000.168 ↓ 16.5 33 3

Hash Join (cost=74.69..58,153.51 rows=2 width=1,182) (actual time=8.937..1,000.168 rows=33 loops=3)

  • Hash Cond: (deliverych0_.delivery_id = delivery0_.id)
5. 808.226 808.226 ↑ 1.3 310,300 3

Parallel Seq Scan on delivery_changelog deliverych0_ (cost=0.00..57,060.44 rows=387,944 width=1,182) (actual time=0.072..808.226 rows=310,300 loops=3)

6. 0.029 0.515 ↓ 12.0 12 3

Hash (cost=74.68..74.68 rows=1 width=8) (actual time=0.515..0.515 rows=12 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
7. 0.486 0.486 ↓ 12.0 12 3

Index Scan using delivery_date_city_id_status_idx on delivery delivery0_ (cost=0.42..74.68 rows=1 width=8) (actual time=0.127..0.486 rows=12 loops=3)

  • Index Cond: ((delivery_date IS NOT NULL) AND (delivery_date >= '2019-10-25 00:00:00'::timestamp without time zone) AND (delivery_date <= '2019-10-31 00:00:00'::timestamp without time zone) AND (status_code = 6))
8. 0.001 0.001 ↓ 0.0 0 100

Index Scan using delivery_completed_sub_status_pkey on delivery_completed_sub_status deliveryco1_ (cost=0.13..0.15 rows=1 width=521) (actual time=0.001..0.001 rows=0 loops=100)

  • Index Cond: (deliverych0_.completed_sub_status_id = id)
9. 0.002 0.002 ↓ 0.0 0 100

Index Scan using delivery_decline_reason_pkey on delivery_decline_reason deliveryde2_ (cost=0.14..0.16 rows=1 width=521) (actual time=0.002..0.002 rows=0 loops=100)

  • Index Cond: (deliverych0_.decline_reason_id = id)
Planning time : 1.946 ms
Execution time : 1,018.587 ms