explain.depesz.com

PostgreSQL's explain analyze made readable

Result: je5n

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

Finalize Aggregate (cost=31,014.59..31,014.60 rows=1 width=48) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Gather (cost=31,014.35..31,014.56 rows=2 width=48) (actual rows= loops=)

  • Workers Planned: 2
3. 0.000 0.000 ↓ 0.0

Partial Aggregate (cost=30,014.35..30,014.36 rows=1 width=48) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=1,197.60..25,219.20 rows=191,806 width=301) (actual rows= loops=)

  • Hash Cond: ((tcontact.tuid = temail_address.tuid) AND ((tcontact.custom ->> 'Email'::text) = temail_address.email))
5. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=2.52..22,993.07 rows=191,806 width=393) (actual rows= loops=)

  • Hash Cond: (tcontact.id = tcontact_tag_map.cont_id)
6. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on tcontact (cost=0.00..22,271.24 rows=191,806 width=111) (actual rows= loops=)

  • Filter: ((NOT cont_is_adhoc) AND (NOT cont_deleted) AND (tuid = 'ee171b16-3ac3-4a74-aa5f-39decdf4aea5'::uuid) AND (said = 'ef5b5cde-0a9b-4a28-8d35-501ea09d6368'::uuid))
7. 0.000 0.000 ↓ 0.0

Hash (cost=2.43..2.43 rows=7 width=314) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=1.34..2.43 rows=7 width=314) (actual rows= loops=)

  • Hash Cond: (tcontact_tag_map.tag_id = ttag.id)
9. 0.000 0.000 ↓ 0.0

Seq Scan on tcontact_tag_map (cost=0.00..1.07 rows=7 width=32) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Hash (cost=1.33..1.33 rows=1 width=282) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Seq Scan on ttag (cost=0.00..1.33 rows=1 width=282) (actual rows= loops=)

  • Filter: ((tuid = 'ee171b16-3ac3-4a74-aa5f-39decdf4aea5'::uuid) AND ((name)::text = 'STAR_CONTACT'::text) AND (type = 'star'::text))
12. 0.000 0.000 ↓ 0.0

Hash (cost=759.76..759.76 rows=29,021 width=40) (actual rows= loops=)

13. 0.000 0.000 ↓ 0.0

Seq Scan on temail_address (cost=0.00..759.76 rows=29,021 width=40) (actual rows= loops=)

  • Filter: (tuid = 'ee171b16-3ac3-4a74-aa5f-39decdf4aea5'::uuid)