explain.depesz.com

PostgreSQL's explain analyze made readable

Result: iaqg : Optimization for: plan #Mmm7

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.022 0.063 ↓ 0.0 0 1

Hash Right Join (cost=2.55..14.80 rows=1 width=975) (actual time=0.063..0.063 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.004 0.004 ↑ 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.004 rows=8 loops=1)

3. 0.016 0.037 ↑ 1.8 12 1

Hash (cost=2.27..2.27 rows=22 width=975) (actual time=0.037..0.037 rows=12 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 13kB
4. 0.021 0.021 ↑ 1.8 12 1

Seq Scan on amazon_mobile_policy ap (cost=0.00..2.27 rows=22 width=975) (actual time=0.008..0.021 rows=12 loops=1)

  • Filter: (is_policy_complete AND (((status)::text <> 'INACTIVE'::text) OR (status IS NULL)))
  • Rows Removed by Filter: 10
Planning time : 0.478 ms
Execution time : 0.121 ms