explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4Ijr

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.048 ↑ 4.0 1 1

Unique (cost=97.45..97.54 rows=4 width=118) (actual time=0.048..0.048 rows=1 loops=1)

2. 0.008 0.048 ↑ 4.0 1 1

Sort (cost=97.45..97.46 rows=4 width=118) (actual time=0.048..0.048 rows=1 loops=1)

  • Sort Key: golf_quebec.india_victor DESC, quebec.golf_november DESC, quebec.papa, quebec.juliet, four_six.foxtrot_bravo, four_six.alpha, four_six.oscar_quebec, quebec.four_xray
  • Sort Method: quicksort Memory: 25kB
3. 0.000 0.040 ↑ 4.0 1 1

Nested Loop Left Join (cost=14.00..97.41 rows=4 width=118) (actual time=0.038..0.040 rows=1 loops=1)

4. 0.001 0.039 ↑ 4.0 1 1

Nested Loop Left Join (cost=13.86..96.72 rows=4 width=114) (actual time=0.037..0.039 rows=1 loops=1)

5. 0.001 0.033 ↑ 4.0 1 1

Nested Loop (cost=13.44..73.42 rows=4 width=73) (actual time=0.032..0.033 rows=1 loops=1)

6. 0.001 0.026 ↑ 2.0 2 1

Nested Loop (cost=13.15..70.82 rows=4 width=4) (actual time=0.025..0.026 rows=2 loops=1)

7. 0.004 0.016 ↑ 4.0 1 1

Bitmap Heap Scan on hotel (cost=8.85..23.98 rows=4 width=4) (actual time=0.016..0.016 rows=1 loops=1)

  • Recheck Cond: ((india_four)::text = ANY ('kilo'::text[]))
  • Filter: (yankee five NULL)
  • Heap Blocks: exact=1
8. 0.012 0.012 ↑ 4.0 1 1

Bitmap Index Scan on lima (cost=0.00..8.85 rows=4 width=0) (actual time=0.012..0.012 rows=1 loops=1)

  • Index Cond: ((india_four)::text = ANY ('kilo'::text[]))
9. 0.005 0.009 ↑ 1.0 2 1

Bitmap Heap Scan on foxtrot_delta (cost=4.30..11.69 rows=2 width=8) (actual time=0.008..0.009 rows=2 loops=1)

  • Recheck Cond: (mike_alpha = hotel.mike_alpha)
  • Filter: (yankee five NULL)
  • Heap Blocks: exact=2
10. 0.004 0.004 ↓ 2.0 4 1

Bitmap Index Scan on oscar_yankee (cost=0.00..4.30 rows=2 width=0) (actual time=0.004..0.004 rows=4 loops=1)

  • Index Cond: (mike_alpha = hotel.mike_alpha)
11. 0.006 0.006 ↓ 0.0 0 2

Index Scan using delta on quebec (cost=0.29..0.64 rows=1 width=73) (actual time=0.003..0.003 rows=0 loops=2)

  • Index Cond: (papa = foxtrot_delta.papa)
  • Filter: ((yankee five NULL) AND (november five FALSE) AND (papa <> 2))
  • Rows Removed by Filter: 0
12. 0.005 0.005 ↑ 1.0 1 1

Index Scan using mike_india on four_six (cost=0.42..5.82 rows=1 width=45) (actual time=0.004..0.005 rows=1 loops=1)

  • Index Cond: (quebec.foxtrot_bravo = foxtrot_bravo)
  • Filter: (yankee five NULL)
13. 0.001 0.001 ↓ 0.0 0 1

Index Scan using echo on golf_quebec (cost=0.14..0.16 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: (quebec.papa = papa)
  • Filter: (yankee five NULL)
Planning time : 0.525 ms
Execution time : 0.092 ms