explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Rfwq

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

Limit (cost=0.84..1,890.67 rows=10 width=127) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.84..2,732,514.27 rows=14,459 width=127) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Index Scan Backward using ix_subscribers_last_seen on subscribers (cost=0.56..2,727,235.54 rows=17,133 width=106) (actual rows= loops=)

  • Filter: ((NOT was_aliased) AND (app_id = ANY ('{773,774}'::bigint[])))
4. 0.000 0.000 ↓ 0.0

Index Scan using apps_pkey on apps (cost=0.28..0.30 rows=1 width=29) (actual rows= loops=)

  • Index Cond: (id = subscribers.app_id)
  • Filter: (NOT deleted)