explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5sjX : WITH LIMIT

Settings
# exclusive inclusive rows x rows loops node
1. 0.042 0.890 ↑ 1.0 1,000 1

Limit (cost=0.43..231.80 rows=1,000 width=8) (actual time=0.034..0.890 rows=1,000 loops=1)

2. 0.136 0.848 ↑ 179.3 1,000 1

Nested Loop Anti Join (cost=0.43..41,473.49 rows=179,252 width=8) (actual time=0.034..0.848 rows=1,000 loops=1)

  • Join Filter: (wallet_snapshots.user_id = i.user_id)
  • -> Materialize (cost=0.43..4.45 rows=1 width=8) (actualtime=0.000..0.000 rows=0 loops=1000)
3. 0.693 0.712 ↑ 179.3 1,000 1

Seq Scan on identities i (cost=0.00..38,780.24 rows=179,253 width=8) (actual time=0.013..0.712 rows=1,000 loops=1)

  • Filter: ((created_at <= '2019-06-08 15:12:49.477367'::timestamp without time zone) AND (((verification)::text = 'approved'::text) OR (updated_at >= '2019-06-08 15:12:49.477367'::timestamp withouttime zone)))
4. 0.019 0.019 ↓ 0.0 0 1

Index Scan using index_wallet_snapshots_on_airdrop_campaign_id on wallet_snapshots (cost=0.43..4.45 rows=1 width=8) (actual time=0.019..0.019 rows=0 loops=1)

  • Index Cond: (airdrop_campaign_id = 25)
Planning time : 0.611 ms
Execution time : 0.935 ms