explain.depesz.com

PostgreSQL's explain analyze made readable

Result: fpkK

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

Nested Loop Left Join (cost=0.14..51.16 rows=1,200 width=40) (actual rows= loops=)

  • Join Filter: ((o.characterowner_id = p.character_id) OR (o.clanowner_id = p.clan_id))
2. 0.000 0.000 ↓ 0.0

Seq Scan on "WalkerMigrationPreference" p (cost=0.00..22.00 rows=1,200 width=40) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Materialize (cost=0.14..8.17 rows=1 width=16) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Index Scan using idx_offmapwalker_realmtile on "OffMapWalker" o (cost=0.14..8.16 rows=1 width=16) (actual rows= loops=)

  • Index Cond: (realmtile_id = 0)