explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ppdw

Settings
# exclusive inclusive rows x rows loops node
1. 687.183 2,305.418 ↑ 1.0 13,307,421 1

Append (cost=0.00..273,907.68 rows=13,310,775 width=16) (actual time=0.023..2,305.418 rows=13,307,421 loops=1)

2. 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 = 6)
3. 1,618.229 1,618.229 ↑ 1.0 13,307,421 1

Seq Scan on tbl_zone_road_mot_address_count_p_6 m_1 (cost=0.00..273,907.68 rows=13,310,774 width=16) (actual time=0.016..1,618.229 rows=13,307,421 loops=1)

  • Filter: (spatial_structure_id = 6)
Planning time : 1.244 ms
Execution time : 2,678.574 ms