explain.depesz.com

PostgreSQL's explain analyze made readable

Result: AV41

Settings
# exclusive inclusive rows x rows loops node
1. 0.052 0.068 ↓ 0.0 0 1

Bitmap Heap Scan on tunnel me (cost=4.49..91.12 rows=8 width=1,180) (actual time=0.068..0.068 rows=0 loops=1)

  • Recheck Cond: (current_incident IS NOT NULL)
  • Filter: ((up_since <= '2019-05-15 10:50:26+02'::timestamp with time zone) AND (current_state = 'up'::text))
  • Rows Removed by Filter: 28
  • Heap Blocks: exact=26
2. 0.016 0.016 ↑ 1.0 28 1

Bitmap Index Scan on idx_current_incident (cost=0.00..4.49 rows=28 width=0) (actual time=0.016..0.016 rows=28 loops=1)

  • Index Cond: (current_incident IS NOT NULL)