explain.depesz.com

PostgreSQL's explain analyze made readable

Result: mTiI : Optimization for: plan #BIrG

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 93.944 301.653 ↑ 1.0 100,000 1

Limit (cost=4.18..3,163.19 rows=100,000 width=1,303) (actual time=0.091..301.653 rows=100,000 loops=1)

2. 137.279 207.709 ↑ 22.9 100,000 1

Hash Left Join (cost=4.18..72,407.62 rows=2,291,966 width=1,303) (actual time=0.090..207.709 rows=100,000 loops=1)

  • Hash Cond: (contacts_contact.created_by_id = users_user.id)
3. 70.411 70.411 ↑ 22.9 100,000 1

Seq Scan on contacts_contact (cost=0.00..63,199.76 rows=2,291,966 width=1,144) (actual time=0.064..70.411 rows=100,000 loops=1)

  • Filter: ((state <> 2) AND (state <> 2))
  • Rows Removed by Filter: 35,445
4. 0.009 0.019 ↑ 1.0 8 1

Hash (cost=4.08..4.08 rows=8 width=159) (actual time=0.019..0.019 rows=8 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 10kB
5. 0.010 0.010 ↑ 1.0 8 1

Seq Scan on users_user (cost=0.00..4.08 rows=8 width=159) (actual time=0.002..0.010 rows=8 loops=1)

Planning time : 0.287 ms
Execution time : 334.722 ms