explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7ytu

Settings
# exclusive inclusive rows x rows loops node
1. 0.162 0.291 ↑ 1.0 185 1

Bitmap Heap Scan on report_cache_index (cost=7.48..206.53 rows=185 width=170) (actual time=0.139..0.291 rows=185 loops=1)

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

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

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