explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dw8D

Settings
# exclusive inclusive rows x rows loops node
1. 0.056 1.072 ↑ 1.0 1,000 1

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

2. 0.161 1.016 ↑ 179.3 1,000 1

Nested Loop Anti Join (cost=0.43..41,473.49 rows=179,252 width=8) (actual time=0.029..1.016 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.840 0.855 ↑ 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.855 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.015 0.015 ↓ 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.015..0.015 rows=0 loops=1)

  • Index Cond: (airdrop_campaign_id = 25)
Planning time : 0.662 ms
Execution time : 1.120 ms