explain.depesz.com

PostgreSQL's explain analyze made readable

Result: saqL

Settings
# exclusive inclusive rows x rows loops node
1. 477.998 2,311.644 ↑ 3.0 564,842 1

Hash Join (cost=191,284.39..244,386.87 rows=1,698,963 width=81) (actual time=1,833.645..2,311.644 rows=564,842 loops=1)

  • Hash Cond: (n.batch_key = l.batch_key)
2.          

CTE lane_mark_not_found_in_map

3. 303.671 1,179.793 ↑ 1.8 515 1

HashSetOp Except (cost=0.00..105,742.72 rows=936 width=12) (actual time=1,179.638..1,179.793 rows=515 loops=1)

4. 183.406 876.122 ↑ 1.0 2,402,717 1

Append (cost=0.00..99,735.93 rows=2,402,717 width=12) (actual time=0.056..876.122 rows=2,402,717 loops=1)

5. 176.744 461.852 ↑ 1.0 1,698,963 1

Subquery Scan on *SELECT* 1 (cost=0.00..58,065.26 rows=1,698,963 width=12) (actual time=0.056..461.852 rows=1,698,963 loops=1)

6. 285.108 285.108 ↑ 1.0 1,698,963 1

Seq Scan on local_map_lane_mark (cost=0.00..41,075.63 rows=1,698,963 width=8) (actual time=0.054..285.108 rows=1,698,963 loops=1)

7. 73.011 230.864 ↑ 1.0 703,754 1

Subquery Scan on *SELECT* 2 (cost=0.00..29,657.08 rows=703,754 width=12) (actual time=0.018..230.864 rows=703,754 loops=1)

8. 157.853 157.853 ↑ 1.0 703,754 1

Seq Scan on aligned_lane_mark (cost=0.00..22,619.54 rows=703,754 width=8) (actual time=0.017..157.853 rows=703,754 loops=1)

9. 1,179.951 1,179.951 ↑ 1.8 515 1

CTE Scan on lane_mark_not_found_in_map n (cost=0.00..18.72 rows=936 width=8) (actual time=1,179.644..1,179.951 rows=515 loops=1)

10. 408.460 653.695 ↑ 1.0 1,698,963 1

Hash (cost=41,075.63..41,075.63 rows=1,698,963 width=81) (actual time=653.694..653.695 rows=1,698,963 loops=1)

  • Buckets: 32,768 (originally 32768) Batches: 128 (originally 64) Memory Usage: 4,025kB
11. 245.235 245.235 ↑ 1.0 1,698,963 1

Seq Scan on local_map_lane_mark l (cost=0.00..41,075.63 rows=1,698,963 width=81) (actual time=0.017..245.235 rows=1,698,963 loops=1)