explain.depesz.com

PostgreSQL's explain analyze made readable

Result: NZLp

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

Nested Loop (cost=0.00..10,844.93 rows=2,005 width=9) (actual rows= loops=)

  • Join Filter: (((config.id = 1) AND (summary.time_stamp >= config.start_after) AND ((config.killbot_guild_ids @> ARRAY[summary.killer_guild_id]) OR (config.killbot_guild_ids @> ARRAY[summary.victim_guild_id]))) OR (config.killbot_player_ids @> ARRAY[summary.killer_id]) OR (config.killbot_player_ids @> ARRAY[summary.victim_id]))
2. 0.000 0.000 ↓ 0.0

Seq Scan on killbot_config config (cost=0.00..1.01 rows=1 width=76) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Seq Scan on albion_event_summary summary (cost=0.00..7,066.12 rows=151,112 width=102) (actual rows= loops=)