explain.depesz.com

PostgreSQL's explain analyze made readable

Result: TaiC

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 0.049 ↓ 2.0 2 1

Nested Loop (cost=1.140..5.430 rows=1 width=28) (actual time=0.044..0.049 rows=2 loops=1)

2. 0.006 0.039 ↓ 2.0 2 1

GroupAggregate (cost=0.570..2.620 rows=1 width=20) (actual time=0.037..0.039 rows=2 loops=1)

  • Group Key: seven2.foxtrot, seven2.zulu, seven2.bravo
3. 0.033 0.033 ↓ 2.0 2 1

Index Only Scan using india on yankee alpha_lima (cost=0.570..2.600 rows=1 width=20) (actual time=0.029..0.033 rows=2 loops=1)

  • Index Cond: ((foxtrot = 274) AND (bravo = 0))
  • Filter: ((zulu = 48) OR (zulu = 100))
  • Rows Removed by Filter: 15
  • Heap Fetches: 17
4. 0.008 0.008 ↑ 1.0 1 2

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

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