explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7Zb

Settings
# exclusive inclusive rows x rows loops node
1. 0.106 0.301 ↑ 1.0 1 1

Aggregate (cost=8.60..8.61 rows=1 width=8) (actual time=0.300..0.301 rows=1 loops=1)

2. 0.195 0.195 ↓ 2.1 438 1

Index Only Scan using amenity on world_osmamenitydata (cost=0.42..8.08 rows=209 width=0) (actual time=0.046..0.195 rows=438 loops=1)

  • Index Cond: (amenity = 'cinema'::text)
  • Heap Fetches: 0