explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2EIm

Settings
# exclusive inclusive rows x rows loops node
1. 0.041 83,686.185 ↑ 108.6 55 1

Nested Loop Left Join (cost=4.620..7,599.040 rows=5,974 width=804) (actual time=83,684.817..83,686.185 rows=55 loops=1)

2. 0.006 83,685.994 ↑ 1.0 50 1

Limit (cost=1.140..4,726.910 rows=50 width=660) (actual time=83,684.805..83,685.994 rows=50 loops=1)

3. 0.042 83,685.988 ↑ 932.1 50 1

Nested Loop Left Join (cost=1.140..4,404,804.980 rows=46,604 width=660) (actual time=83,684.805..83,685.988 rows=50 loops=1)

4. 83,684.796 83,684.796 ↑ 932.1 50 1

Index Scan using november on quebec india (cost=0.570..4,282,398.830 rows=46,604 width=71) (actual time=83,684.763..83,684.796 rows=50 loops=1)

  • Index Cond: (golf = ANY ('mike'::bigint[]))
  • Filter: ((zulu)::text = ANY ('victor'::text[]))
  • Rows Removed by Filter: 4585041
5. 1.150 1.150 ↑ 1.0 1 50

Index Scan using bravo on lima six_uniform (cost=0.570..2.620 rows=1 width=613) (actual time=0.016..0.023 rows=1 loops=50)

  • Index Cond: (((india.six_golf)::text = (six_golf)::text) AND (india.golf = golf))
  • Filter: ((india.zulu)::text = uniform((zulu)::text))
  • Rows Removed by Filter: 6
6. 0.000 0.150 ↓ 0.0 0 50

Hash Left Join (cost=3.490..60.300 rows=55 width=160) (actual time=0.003..0.003 rows=0 loops=50)

  • Hash Cond: (seven.whiskey_echo = oscar.whiskey_echo)
7. 0.100 0.100 ↓ 0.0 0 50

Index Scan using yankee on xray seven (cost=0.570..56.630 rows=55 width=130) (actual time=0.002..0.002 rows=0 loops=50)

  • Index Cond: ((six_uniform.charlie = charlie) AND (india.golf = golf))
8. 0.035 0.055 ↓ 1.2 106 1

Hash (cost=1.850..1.850 rows=85 width=38) (actual time=0.055..0.055 rows=106 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 16kB
9. 0.020 0.020 ↓ 1.2 106 1

Seq Scan on whiskey_whiskey oscar (cost=0.000..1.850 rows=85 width=38) (actual time=0.005..0.020 rows=106 loops=1)

Planning time : 0.973 ms