explain.depesz.com

PostgreSQL's explain analyze made readable

Result: KxcB : With Limit

Settings
# exclusive inclusive rows x rows loops node
1. 0.044 0.947 ↑ 1.0 1,000 1

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

2. 0.154 0.903 ↑ 179.3 1,000 1

Nested Loop Anti Join (cost=0.43..41,473.49 rows=179,252 width=8) (actual time=0.048..0.903 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.716 0.749 ↑ 179.3 1,000 1

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

  • Filter: ((created_at <= '2019-06-08 15:09:24.754911'::timestamp without time zone) AND (((verification)::text = 'approved'::text) OR (updated_at >= '2019-06-08 15:09:24.754911'::timestamp withouttime zone)))
4. 0.033 0.033 ↓ 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.033..0.033 rows=0 loops=1)

  • Index Cond: (airdrop_campaign_id = 25)
Planning time : 0.720 ms
Execution time : 0.992 ms