explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lfN9

Settings
# exclusive inclusive rows x rows loops node
1. 0.041 0.790 ↑ 1.0 1,000 1

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

2. 0.131 0.749 ↑ 179.3 1,000 1

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

  • Join Filter: (wallet_snapshots.user_id = i.user_id)
3. 0.618 0.618 ↑ 179.3 1,000 1

Seq Scan on identities i (cost=0.00..38,780.24 rows=179,253 width=8) (actual time=0.007..0.618 rows=1,000 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)))
4. 0.000 0.000 ↓ 0.0 0 1,000

Materialize (cost=0.43..4.45 rows=1 width=8) (actual time=0.000..0.000 rows=0 loops=1,000)

5. 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.014..0.015 rows=0 loops=1)

  • Index Cond: (airdrop_campaign_id = 25)
Planning time : 0.345 ms
Execution time : 0.837 ms