explain.depesz.com

PostgreSQL's explain analyze made readable

Result: cMaA : Optimization for: plan #KTAL

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.019 7.258 ↑ 9,500.0 1 1

Bitmap Heap Scan on event_status_info (cost=2.38..292,986.47 rows=9,500 width=872) (actual time=7.257..7.258 rows=1 loops=1)

  • Recheck Cond: (event_info @> '[{"key": "hostname", "value": "hostname1"}, {"key": "status", "value": "InProgress"}]'::jsonb)
  • Heap Blocks: exact=1\n\r Buffers: shared hit=1
  • Index Cond: (event_info @> '[{"key": "hostname", "value": "hostname1"}, {"key": "status", "value": "InProgress"}]'::jsonb)
2. 7.239 7.239 ↑ 47,500.0 2 1

Bitmap Index Scan on pgroonga_content_index (cost=0.00..0.00 rows=95,000 width=0) (actual time=7.239..7.239 rows=2 loops=1)

Planning time : 2.469 ms
Execution time : 7.545 ms