explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Xcsx

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 0.042 ↑ 1.0 1 1

Aggregate (cost=10,377.95..10,377.96 rows=1 width=24) (actual time=0.042..0.042 rows=1 loops=1)

2. 0.002 0.040 ↓ 0.0 0 1

Bitmap Heap Scan on charlie_whiskey (cost=77.25..10,327.79 rows=1,824 width=36) (actual time=0.040..0.040 rows=0 loops=1)

  • Recheck Cond: (((victor)::text = 'five'::text) OR (mike = 'golf_five'::inet) OR (((mike - 'three'::inet) & 'golf_romeo'::bigint) = 'india'::bigint))
  • Filter: (four >= (zulu() - 'seven'::interval))
3. 0.001 0.038 ↓ 0.0 0 1

BitmapOr (cost=77.25..77.25 rows=3,548 width=0) (actual time=0.038..0.038 rows=0 loops=1)

4. 0.022 0.022 ↓ 0.0 0 1

Bitmap Index Scan on charlie_india (cost=0.00..4.44 rows=2 width=0) (actual time=0.022..0.022 rows=0 loops=1)

  • Index Cond: ((victor)::text = 'five'::text)
5. 0.007 0.007 ↓ 0.0 0 1

Bitmap Index Scan on golf_mike (cost=0.00..4.57 rows=19 width=0) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: (mike = 'golf_five'::inet)
6. 0.008 0.008 ↓ 0.0 0 1

Bitmap Index Scan on whiskey (cost=0.00..66.88 rows=3,527 width=0) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: (((mike - 'three'::inet) & 'golf_romeo'::bigint) = 'india'::bigint)
Planning time : 0.169 ms
Execution time : 0.095 ms