explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ZnRQ

Settings
# exclusive inclusive rows x rows loops node
1. 409.184 836.492 ↑ 160.8 12,308 1

Subquery Scan on data (cost=0.57..1,985,130.01 rows=1,979,619 width=64) (actual time=9.092..836.492 rows=12,308 loops=1)

2. 427.308 427.308 ↑ 160.8 12,308 1

Index Scan Backward using "Prova_Idx" on planet_osm_polygon (cost=0.57..1,876,250.96 rows=1,979,619 width=264) (actual time=2.197..427.308 rows=12,308 loops=1)

  • Index Cond: (way_area > '1000000000'::double precision)
  • Filter: (way && '01030000A0110F00000100000005000000D61B7C45F81B33C1D61B7C45F81B33C10000000000000000D61B7C45F81B33C1D7A37045F81B73410000000000000000D7A37045F81B7341D7A37045F81B73410000000000000000D7A37045F81B7341D61B7C45F81B33C10000000000000000D61B7C45F81B33C1D61B7C45F81B33C10000000000000000'::geometry)
  • Rows Removed by Filter: 127
Planning time : 0.422 ms