explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Mdm2

Settings
# exclusive inclusive rows x rows loops node
1. 0.570 44,618.833 ↑ 1.0 1 1

Aggregate (cost=463,136.97..463,136.98 rows=1 width=8) (actual time=44,618.833..44,618.833 rows=1 loops=1)

2. 44,618.263 44,618.263 ↓ 2.1 438 1

Seq Scan on world_osmamenitydata (cost=0.00..463,136.45 rows=206 width=0) (actual time=15,017.558..44,618.263 rows=438 loops=1)

  • Filter: ((amenity)::text = 'cinema'::text)
  • Rows Removed by Filter: 210658