explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lUB

Settings
# exclusive inclusive rows x rows loops node
1. 0.034 0.258 ↓ 50.0 50 1

Nested Loop (cost=1.140..5.670 rows=1 width=28) (actual time=0.046..0.258 rows=50 loops=1)

2. 0.027 0.124 ↓ 50.0 50 1

GroupAggregate (cost=0.570..2.870 rows=1 width=20) (actual time=0.036..0.124 rows=50 loops=1)

  • Group Key: seven2.foxtrot, seven2.zulu, seven2.bravo
3. 0.097 0.097 ↓ 50.0 50 1

Index Only Scan using india on yankee alpha_lima (cost=0.570..2.850 rows=1 width=20) (actual time=0.028..0.097 rows=50 loops=1)

  • Index Cond: (foxtrot = 274)
  • Filter: (((zulu = 48) AND (bravo = 0)) OR ((zulu = 100) AND (bravo = 0)) OR ((zulu = 53) AND (bravo = 1)) OR ((zulu = 28) AND (bravo = 1)) OR ((zulu = 30) AND (bravo = 1)) OR ((zulu = 31) AND (bravo = 1)) OR ((zulu = 32) AND (bravo = 1)) OR ((zulu = 99) AND (bravo = 1)) OR ((zulu = 98) AND (bravo = 1)) OR ((zulu = 53) AND (bravo = 2)) OR ((zulu = 28) AND (bravo = 2)) OR ((zulu = 30) AND (bravo = 2)) OR ((zulu = 31) AND (bravo = 2)) OR ((zulu = 32) AND (bravo = 2)) OR ((zulu = 99) AND (bravo = 2)) OR ((zulu = 98) AND (bravo = 2)) OR ((zulu = 53) AND (bravo = 3)) OR ((zulu = 28) AND (bravo = 3)) OR ((zulu = 30) AND (bravo = 3)) OR ((zulu = 31) AND (bravo = 3)) OR ((zulu = 32) AND (bravo = 3)) OR ((zulu = 99) AND (bravo = 3)) OR ((zulu = 53) AND (bravo = 4)) OR ((zulu = 28) AND (bravo = 4)) OR ((zulu = 30) AND (bravo = 4)) OR ((zulu = 31) AND (bravo = 4)) OR ((zulu = 32) AND (bravo = 4)) OR ((zulu = 99) AND (bravo = 4)) OR ((zulu = 53) AND (bravo = 5)) OR ((zulu = 28) AND (bravo = 5)) OR ((zulu = 30) AND (bravo = 5)) OR ((zulu = 31) AND (bravo = 5)) OR ((zulu = 32) AND (bravo = 5)) OR ((zulu = 99) AND (bravo = 5)) OR ((zulu = 53) AND (bravo = 6)) OR ((zulu = 28) AND (bravo = 6)) OR ((zulu = 30) AND (bravo = 6)) OR ((zulu = 31) AND (bravo = 6)) OR ((zulu = 32) AND (bravo = 6)) OR ((zulu = 99) AND (bravo = 6)) OR ((zulu = 39) AND (bravo = 0)) OR ((zulu = 41) AND (bravo = 0)) OR ((zulu = 42) AND (bravo = 0)) OR ((zulu = 43) AND (bravo = 0)) OR ((zulu = 51) AND (bravo = 0)) OR ((zulu = 44) AND (bravo = 0)) OR ((zulu = 103) AND (bravo = 0)) OR ((zulu = 17) AND (bravo = 1)) OR ((zulu = 70) AND (bravo = 1)) OR ((zulu = 73) AND (bravo = 1)))
  • Rows Removed by Filter: 40
  • Heap Fetches: 90
4. 0.100 0.100 ↑ 1.0 1 50

Index Scan using india on yankee three (cost=0.570..2.790 rows=1 width=28) (actual time=0.002..0.002 rows=1 loops=50)

  • Index Cond: ((foxtrot = seven2.foxtrot) AND (zulu = seven2.zulu) AND (bravo = seven2.bravo) AND (two = (alpha_four(seven2.two))))