explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ShDg

Settings
# exclusive inclusive rows x rows loops node
1. 14.806 97.098 ↓ 1.0 181,237 1

Hash Anti Join (cost=4.46..41,047.76 rows=179,252 width=8) (actual time=0.074..97.098 rows=181,237 loops=1)

  • Hash Cond: (i.user_id = wallet_snapshots.user_id)
2. 82.230 82.230 ↓ 1.0 181,237 1

Seq Scan on identities i (cost=0.00..38,780.24 rows=179,253 width=8) (actual time=0.008..82.230 rows=181,237 loops=1)

  • Filter: ((created_at <= '2019-06-08 15:19:06.117092'::timestamp without time zone) AND (((verification)::text = 'approved'::text) OR (updated_at >= '2019-06-08 15:19:06.117092'::timestamp without time zone)))
3. 0.062 0.062 ↓ 0.0 0 1

Hash (cost=4.45..4.45 rows=1 width=8) (actual time=0.062..0.062 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
  • -> 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.062..0.062rows=0 loops=1)
  • Index Cond: (airdrop_campaign_id = 25)