explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Mk1V

Settings
# exclusive inclusive rows x rows loops node
1. 1,203.881 3,670.456 ↑ 10.7 622,820 1

Hash Semi Join (cost=3,927.45..370,178.63 rows=6,655,388 width=16) (actual time=27.692..3,670.456 rows=622,820 loops=1)

  • Hash Cond: (m.source_point_id = dd.id1)
2. 688.073 2,439.238 ↑ 1.0 13,307,421 1

Append (cost=0.00..257,269.21 rows=13,310,775 width=16) (actual time=0.028..2,439.238 rows=13,307,421 loops=1)

3. 0.007 0.007 ↓ 0.0 0 1

Seq Scan on tbl_zone_road_mot_address_count_p m (cost=0.00..0.00 rows=1 width=16) (actual time=0.007..0.007 rows=0 loops=1)

  • Filter: (spatial_structure_id = ANY ('{6}'::integer[]))
4. 1,751.158 1,751.158 ↑ 1.0 13,307,421 1

Seq Scan on tbl_zone_road_mot_address_count_p_6 m_1 (cost=0.00..257,269.21 rows=13,310,774 width=16) (actual time=0.020..1,751.158 rows=13,307,421 loops=1)

  • Filter: (spatial_structure_id = ANY ('{6}'::integer[]))
5. 14.466 27.337 ↑ 1.0 140,731 1

Hash (cost=2,168.31..2,168.31 rows=140,731 width=4) (actual time=27.337..27.337 rows=140,731 loops=1)

  • Buckets: 262144 Batches: 1 Memory Usage: 6996kB
6. 12.871 12.871 ↑ 1.0 140,731 1

Seq Scan on dd (cost=0.00..2,168.31 rows=140,731 width=4) (actual time=0.016..12.871 rows=140,731 loops=1)

Planning time : 1.646 ms
Execution time : 3,688.811 ms