explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7TZg

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

Limit (cost=69.880..81.940 rows=1 width=46) (actual time=0.411..0.413 rows=1 loops=1)

2. 0.004 0.411 ↑ 1.0 1 1

Nested Loop (cost=69.880..81.940 rows=1 width=46) (actual time=0.409..0.411 rows=1 loops=1)

3. 0.023 0.374 ↑ 1.0 1 1

Bitmap Heap Scan on six (cost=69.600..73.620 rows=1 width=46) (actual time=0.374..0.374 rows=1 loops=1)

  • Recheck Cond: ((mike_tango = 'uniform'::bigint) AND (india = 'two'::bigint))
  • Filter: ((delta >= 'november'::timestamp without time zone) AND (delta <= 'foxtrot'::timestamp without time zone) AND (victor = 1) AND (xray_kilo = 'mike_romeo'::bigint))
  • Heap Blocks: exact=2
4. 0.002 0.351 ↓ 0.0 0 1

BitmapAnd (cost=69.600..69.600 rows=1 width=0) (actual time=0.351..0.351 rows=0 loops=1)

5. 0.051 0.051 ↑ 38.0 2 1

Bitmap Index Scan on three_whiskey (cost=0.000..5.000 rows=76 width=0) (actual time=0.051..0.051 rows=2 loops=1)

  • Index Cond: (mike_tango = 'uniform'::bigint)
6. 0.298 0.298 ↓ 1.2 3,122 1

Bitmap Index Scan on xray_mike (cost=0.000..64.340 rows=2,654 width=0) (actual time=0.298..0.298 rows=3,122 loops=1)

  • Index Cond: (india = 'two'::bigint)
7. 0.033 0.033 ↑ 1.0 1 1

Index Scan using three_four on golf india (cost=0.290..8.310 rows=1 width=8) (actual time=0.033..0.033 rows=1 loops=1)

  • Index Cond: (oscar = 'two'::bigint)
  • Filter: (victor = 1)