explain.depesz.com

PostgreSQL's explain analyze made readable

Result: enHF

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Limit (cost=1,767,762.52..1,779,430.01 rows=100,000 width=1,303) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Gather Merge (cost=1,767,762.52..1,990,608.15 rows=1,909,972 width=1,303) (actual rows= loops=)

  • Workers Planned: 2
3. 0.000 0.000 ↓ 0.0

Sort (cost=1,766,762.50..1,769,149.97 rows=954,986 width=1,303) (actual rows= loops=)

  • Sort Key: contacts_contact.created
4. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=4.18..46,371.44 rows=954,986 width=1,303) (actual rows= loops=)

  • Hash Cond: (contacts_contact.created_by_id = users_user.id)
5. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on contacts_contact (cost=0.00..42,532.40 rows=954,986 width=1,144) (actual rows= loops=)

  • Filter: ((state <> 2) AND (state <> 2))
6. 0.000 0.000 ↓ 0.0

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

7. 0.000 0.000 ↓ 0.0

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