explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vcgj

Settings
# exclusive inclusive rows x rows loops node
1. 0.006 0.246 ↑ 1.0 1 1

Sort (cost=41.79..41.79 rows=1 width=131) (actual time=0.245..0.246 rows=1 loops=1)

  • Sort Key: tango0kilo_oscar.kilo_six_yankee DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=13
2. 0.003 0.240 ↑ 1.0 1 1

Nested Loop (cost=8.76..41.78 rows=1 width=131) (actual time=0.176..0.240 rows=1 loops=1)

  • Buffers: shared hit=13
3. 0.001 0.207 ↑ 1.0 1 1

Nested Loop (cost=8.76..37.79 rows=1 width=134) (actual time=0.169..0.207 rows=1 loops=1)

  • Buffers: shared hit=12
4. 0.004 0.189 ↑ 1.0 1 1

Nested Loop (cost=8.63..37.31 rows=1 width=116) (actual time=0.151..0.189 rows=1 loops=1)

  • Buffers: shared hit=10
5. 0.108 0.127 ↑ 1.0 1 1

Bitmap Heap Scan on six_lima romeo (cost=4.32..20.65 rows=1 width=46) (actual time=0.115..0.127 rows=1 loops=1)

  • Filter: ((("oscar"())::text <> ANY ('alpha'::text[])) AND lima_victor.quebec_juliet(hotel1kilo_oscar.juliet))
  • Heap Blocks: exact=3
  • Buffers: shared hit=5
6. 0.019 0.019 ↑ 1.3 3 1

Bitmap Index Scan on yankee (cost=0.00..4.32 rows=4 width=0) (actual time=0.018..0.019 rows=3 loops=1)

  • Index Cond: ((hotel1kilo_oscar.mike_six)::text = 'quebec_three'::text)
  • Buffers: shared hit=2
7. 0.047 0.058 ↑ 1.0 1 1

Bitmap Heap Scan on golf lima_hotel (cost=4.31..16.66 rows=1 width=78) (actual time=0.032..0.058 rows=1 loops=1)

  • Filter: ((("oscar"())::text <> ANY ('alpha'::text[])) AND lima_victor.quebec_juliet(tango0kilo_oscar.juliet))
  • Heap Blocks: exact=3
  • Buffers: shared hit=5
8. 0.011 0.011 ↑ 1.0 3 1

Bitmap Index Scan on two (cost=0.00..4.31 rows=3 width=0) (actual time=0.011..0.011 rows=3 loops=1)

  • Index Cond: ((tango0kilo_oscar.india)::text = (hotel1kilo_oscar.india)::text)
  • Buffers: shared hit=2
9. 0.017 0.017 ↑ 1.0 1 1

Index Scan using lima_four on six_whiskey whiskey (cost=0.13..0.46 rows=1 width=26) (actual time=0.016..0.017 rows=1 loops=1)

  • Index Cond: ((mike_romeo2kilo_oscar.kilo_six_india)::text = (tango0kilo_oscar.kilo_six_india)::text)
  • Filter: ((("oscar"())::text <> ANY ('alpha'::text[])) AND lima_victor.uniform(mike_romeo2kilo_oscar.juliet))
  • Buffers: shared hit=2
10. 0.030 0.030 ↓ 2.8 11 1

Seq Scan on xray papa (cost=0.00..3.94 rows=4 width=43) (actual time=0.006..0.030 rows=11 loops=1)

  • Filter: ((("oscar"())::text <> ANY ('alpha'::text[])) AND lima_victor.uniform(four3kilo_oscar.juliet))
  • Buffers: shared hit=1
Planning time : 0.888 ms
Execution time : 0.33 ms