explain.depesz.com

PostgreSQL's explain analyze made readable

Result: I8Ni

Settings
# exclusive inclusive rows x rows loops node
1. 0.182 0.274 ↑ 1.0 185 1

Bitmap Heap Scan on report_cache_index (cost=4.05..203.10 rows=185 width=149) (actual time=0.103..0.274 rows=185 loops=1)

  • Recheck Cond: ((report_id)::text = 'f8565ceb9bc7ebc2:51a049c3:16912c5e3ff:-38b2'::text)
  • Heap Blocks: exact=25
2. 0.092 0.092 ↑ 1.0 185 1

Bitmap Index Scan on idx_rpt_cache (cost=0.00..4.01 rows=185 width=0) (actual time=0.092..0.092 rows=185 loops=1)

  • Index Cond: ((report_id)::text = 'f8565ceb9bc7ebc2:51a049c3:16912c5e3ff:-38b2'::text)
Planning time : 0.240 ms