explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6I8r

Settings
# exclusive inclusive rows x rows loops node
1. 0.047 0.158 ↓ 0.0 0 1

Bitmap Heap Scan on tunnel me (cost=22.19..50.80 rows=8 width=1,180) (actual time=0.158..0.158 rows=0 loops=1)

  • Recheck Cond: ((current_incident IS NOT NULL) AND (up_since <= '2019-05-15 10:50:26+02'::timestamp with time zone))
  • Filter: (current_state = 'up'::text)
  • Rows Removed by Filter: 27
  • Heap Blocks: exact=25
2. 0.029 0.111 ↓ 0.0 0 1

BitmapAnd (cost=22.19..22.19 rows=8 width=0) (actual time=0.111..0.111 rows=0 loops=1)

3. 0.010 0.010 ↑ 1.0 28 1

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

  • Index Cond: (current_incident IS NOT NULL)
4. 0.072 0.072 ↑ 1.0 687 1

Bitmap Index Scan on idx_core_tunnel_up_since (cost=0.00..17.45 rows=689 width=0) (actual time=0.072..0.072 rows=687 loops=1)

  • Index Cond: (up_since <= '2019-05-15 10:50:26+02'::timestamp with time zone)