explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9peR

Settings
# exclusive inclusive rows x rows loops node
1. 0.005 0.063 ↑ 1.0 7 1

Nested Loop (cost=9.06..79.64 rows=7 width=8) (actual time=0.032..0.063 rows=7 loops=1)

2. 0.010 0.030 ↑ 1.0 7 1

Bitmap Heap Scan on events (cost=8.64..20.51 rows=7 width=8) (actual time=0.025..0.030 rows=7 loops=1)

  • Recheck Cond: ((severity = 'Error'::text) OR ((severity = 'Warning'::text) AND (NOT resolved)))
  • Filter: ((severity = 'Error'::text) OR ((severity = 'Warning'::text) AND (NOT resolved)))
  • Heap Blocks: exact=2
3. 0.001 0.020 ↓ 0.0 0 1

BitmapOr (cost=8.64..8.64 rows=7 width=0) (actual time=0.020..0.020 rows=0 loops=1)

4. 0.011 0.011 ↓ 0.0 0 1

Bitmap Index Scan on events_severity_and_resolved_idx (cost=0.00..4.29 rows=1 width=0) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: (severity = 'Error'::text)
5. 0.008 0.008 ↑ 1.0 7 1

Bitmap Index Scan on events_severity_and_resolved_idx (cost=0.00..4.35 rows=7 width=0) (actual time=0.008..0.008 rows=7 loops=1)

  • Index Cond: ((severity = 'Warning'::text) AND (resolved = false))
6. 0.028 0.028 ↑ 1.0 1 7

Index Scan using entries_pkey on entries (cost=0.43..8.45 rows=1 width=16) (actual time=0.004..0.004 rows=1 loops=7)

  • Index Cond: (entry_id = events.entry_id)
Planning time : 0.278 ms