explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1fno : phoneowner

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 638.480 2,680.669 ↑ 576.5 2 1

Hash Left Join (cost=53.88..314,033.32 rows=1,153 width=1,275) (actual time=5.659..2,680.669 rows=2 loops=1)

  • Hash Cond: (ap.id = po.policy_id)
  • Filter: ((ap.user_id = 3) OR (po.user_id = 3))
  • Rows Removed by Filter: 2085546
  • Planning time: 0.467 ms
  • Execution time: 2680.717 ms
2. 2,041.057 2,041.057 ↓ 1.0 2,085,493 1

Seq Scan on amazon_mobile_policy ap (cost=0.00..289,061.29 rows=1,991,879 width=1,275) (actual time=0.022..2,041.057 rows=2,085,493 loops=1)

  • Filter: (is_policy_complete AND (((status)::text <> 'INACTIVE'::text) OR (status IS NULL)))
  • Rows Removed by Filter: 534046
3. 0.524 1.132 ↓ 1.0 1,768 1

Hash (cost=32.28..32.28 rows=1,728 width=8) (actual time=1.132..1.132 rows=1,768 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 86kB
4. 0.608 0.608 ↓ 1.0 1,768 1

Seq Scan on amazon_mobile_phoneowner po (cost=0.00..32.28 rows=1,728 width=8) (actual time=0.005..0.608 rows=1,768 loops=1)