explain.depesz.com

PostgreSQL's explain analyze made readable

Result: whJx

Settings
# exclusive inclusive rows x rows loops node
1. 1,706.422 4,281.918 ↑ 5.3 1,266,594 1

Hash Semi Join (cost=8,549.03..374,800.22 rows=6,655,388 width=16) (actual time=88.933..4,281.918 rows=1,266,594 loops=1)

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

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

3. 0.006 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Filter: (spatial_structure_id = ANY ('{6}'::integer[]))
4. 1,785.053 1,785.053 ↑ 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.015..1,785.053 rows=13,307,421 loops=1)

  • Filter: (spatial_structure_id = ANY ('{6}'::integer[]))
5. 46.096 88.442 ↑ 1.0 306,357 1

Hash (cost=4,719.57..4,719.57 rows=306,357 width=4) (actual time=88.442..88.442 rows=306,357 loops=1)

  • Buckets: 524288 Batches: 1 Memory Usage: 14867kB
6. 42.346 42.346 ↑ 1.0 306,357 1

Seq Scan on dd (cost=0.00..4,719.57 rows=306,357 width=4) (actual time=0.012..42.346 rows=306,357 loops=1)

Planning time : 1.241 ms
Execution time : 4,318.624 ms