explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9MXN : ok

Settings
# exclusive inclusive rows x rows loops node
1. 0.021 126.261 ↑ 1.0 1 1

Aggregate (cost=33,887.340..33,887.350 rows=1 width=8) (actual time=126.260..126.261 rows=1 loops=1)

2. 109.126 126.240 ↑ 185.0 1 1

Bitmap Heap Scan on kilo (cost=745.880..33,886.870 rows=185 width=0) (actual time=24.727..126.240 rows=1 loops=1)

  • Recheck Cond: ((golf)::text = 'hotel'::text)
  • Filter: ((uniform <> 'oscar'::numeric) AND (seven = 'november'::numeric) AND ((yankee_golf)::text = 'yankee_five'::text))
  • Rows Removed by Filter: 40322
  • Heap Blocks: exact=18736
3. 17.114 17.114 ↓ 1.0 40,323 1

Bitmap Index Scan on romeo (cost=0.000..745.830 rows=40,188 width=0) (actual time=17.114..17.114 rows=40,323 loops=1)

  • Index Cond: ((golf)::text = 'hotel'::text)
Planning time : 0.476 ms
Execution time : 126.371 ms