explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9sES

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Finalize Aggregate (cost=137,582.22..137,582.23 rows=1 width=8) (actual rows= loops=)

  • Functions: 38
  • Options: Inlining false, Optimization false, Expressions true, Deforming true
2. 0.000 0.000 ↓ 0.0

Gather (cost=137,582.00..137,582.21 rows=2 width=8) (actual rows= loops=)

  • Workers Planned: 2
3. 0.000 0.000 ↓ 0.0

Partial Aggregate (cost=136,582.00..136,582.01 rows=1 width=8) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Hash Join (cost=20,270.49..136,496.80 rows=34,082 width=0) (actual rows= loops=)

  • Hash Cond: (dschd.schedule_id = schd.schedule_id)
5. 0.000 0.000 ↓ 0.0

Parallel Hash Join (cost=18,292.29..134,122.92 rows=4,880 width=8) (actual rows= loops=)

  • Hash Cond: (dschds.dispatch_schedule_id = dschd.dispatch_schedule_id)
6. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on dispatch_schedule_stop dschds (cost=0.00..108,216.83 rows=2,900,483 width=8) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Parallel Hash (cost=18,283.78..18,283.78 rows=681 width=16) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on dispatch_schedule dschd (cost=0.00..18,283.78 rows=681 width=16) (actual rows= loops=)

  • Filter: (schedule_date = '2020-03-16'::date)
9. 0.000 0.000 ↓ 0.0

Hash (cost=1,577.62..1,577.62 rows=32,046 width=16) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Hash Join (cost=253.48..1,577.62 rows=32,046 width=16) (actual rows= loops=)

  • Hash Cond: (schd.carrier_id = car.carrier_id)
11. 0.000 0.000 ↓ 0.0

Hash Join (cost=215.25..1,454.91 rows=32,046 width=24) (actual rows= loops=)

  • Hash Cond: (schds.schedule_id = schd.schedule_id)
12. 0.000 0.000 ↓ 0.0

Seq Scan on schedule_stop schds (cost=0.00..1,155.46 rows=32,046 width=8) (actual rows= loops=)

13. 0.000 0.000 ↓ 0.0

Hash (cost=157.89..157.89 rows=4,589 width=16) (actual rows= loops=)

14. 0.000 0.000 ↓ 0.0

Seq Scan on schedule schd (cost=0.00..157.89 rows=4,589 width=16) (actual rows= loops=)

15. 0.000 0.000 ↓ 0.0

Hash (cost=25.88..25.88 rows=988 width=8) (actual rows= loops=)

  • -> Seq Scan on carrier car (cost=0.00..25.88 rows=988 width=8)JIT: