explain.depesz.com

PostgreSQL's explain analyze made readable

Result: DLvs

Settings
# exclusive inclusive rows x rows loops node
1. 0.006 0.050 ↓ 0.0 0 1

Nested Loop (cost=9.06..79.75 rows=1 width=8) (actual time=0.050..0.050 rows=0 loops=1)

2. 0.006 0.023 ↑ 1.0 7 1

Bitmap Heap Scan on events (cost=8.64..20.51 rows=7 width=14) (actual time=0.020..0.023 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.000 0.017 ↓ 0.0 0 1

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

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

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

  • Index Cond: ((severity = 'Warning'::text) AND (resolved = false))
6. 0.021 0.021 ↓ 0.0 0 7

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

  • Index Cond: (entry_id = events.entry_id)
  • Filter: ((events.severity = 'Error'::text) OR ((events.severity = 'Warning'::text) AND (NOT events.resolved) AND (created_at < '2019-08-13 12:13:07.247433+00'::timestamp with time zone)))
  • Rows Removed by Filter: 1
Planning time : 2.502 ms