explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qhy8

Settings
# exclusive inclusive rows x rows loops node
1. 0.094 2,718.792 ↑ 1.0 1 1

Aggregate (cost=4.91..5.00 rows=1 width=8) (actual time=2,718.790..2,718.792 rows=1 loops=1)

  • Output: count(*)
  • Buffers: shared hit=267664 read=5 dirtied=1
2. 2,718.698 2,718.698 ↓ 47.0 47 1

Index Scan using polygons_geom_idx on search_platform.polygons pol (cost=0.55..4.90 rows=1 width=0) (actual time=4.133..2,718.698 rows=47 loops=1)

  • Output: pol_id, segment_number, geom
  • Index Cond: (pol.geom && '0101000020E610000069A9BC1DE1F846C0F6285C8FC23D36C0'::geometry)
  • Filter: _st_intersects(pol.geom, '0101000020E610000069A9BC1DE1F846C0F6285C8FC23D36C0'::geometry)
  • Rows Removed by Filter: 3
  • Buffers: shared hit=267664 read=5 dirtied=1