explain.depesz.com

PostgreSQL's explain analyze made readable

Result: BAAR

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

Nested Loop (cost=9.06..79.66 rows=7 width=8) (actual time=0.229..0.357 rows=7 loops=1)

2. 0.033 0.217 ↑ 1.0 7 1

Bitmap Heap Scan on events (cost=8.64..20.51 rows=7 width=8) (actual time=0.201..0.217 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.002 0.184 ↓ 0.0 0 1

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

4. 0.025 0.025 ↓ 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.025..0.025 rows=0 loops=1)

  • Index Cond: (severity = 'Error'::text)
5. 0.157 0.157 ↑ 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.157..0.157 rows=7 loops=1)

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

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

  • Index Cond: (entry_id = events.entry_id)
  • Filter: (created_at < '2019-08-13 13:15:39.378259+00'::timestamp with time zone)
Planning time : 0.971 ms