explain.depesz.com

PostgreSQL's explain analyze made readable

Result: cMcg : plan level G

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=1.130..58,046,764.320 rows=19,111 width=72) (actual rows= loops=)

  • Group Key: papa_kilo.quebec_seven
2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.130..50,313,263.280 rows=618,660,972 width=16) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Merge Join (cost=0.710..91,769.740 rows=274,819 width=1,956) (actual rows= loops=)

  • Merge Cond: (papa_kilo.quebec_seven = tango.six)
4. 0.000 0.000 ↓ 0.0

Index Only Scan using romeo on four_victor papa_kilo (cost=0.290..5,792.600 rows=19,111 width=8) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Index Scan using four_zulu on kilo tango (cost=0.420..82,494.130 rows=274,819 width=1,956) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Index Scan using mike on papa_oscar quebec_sierra (cost=0.410..180.540 rows=220 width=1,086) (actual rows= loops=)

  • Index Cond: (tango.seven && seven)