explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Mmm7

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.040 0.084 ↓ 0.0 0 1

Hash Right Join (cost=2.50..14.73 rows=1 width=975) (actual time=0.084..0.084 rows=0 loops=1)

  • Hash Cond: (po.policy_id = ap.id)
  • Filter: ((ap.user_id = 3) OR (po.user_id = 3))
  • Rows Removed by Filter: 13
2. 0.007 0.007 ↑ 17.5 8 1

Seq Scan on amazon_mobile_phoneowner po (cost=0.00..11.40 rows=140 width=8) (actual time=0.002..0.007 rows=8 loops=1)

3. 0.018 0.037 ↑ 1.7 12 1

Hash (cost=2.25..2.25 rows=20 width=975) (actual time=0.037..0.037 rows=12 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 13kB
4. 0.019 0.019 ↑ 1.7 12 1

Seq Scan on amazon_mobile_policy ap (cost=0.00..2.25 rows=20 width=975) (actual time=0.007..0.019 rows=12 loops=1)

  • Filter: (is_policy_complete AND (((status)::text <> 'INACTIVE'::text) OR (status IS NULL)))
  • Rows Removed by Filter: 10