explain.depesz.com

PostgreSQL's explain analyze made readable

Result: e3aT

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

GroupAggregate (cost=148,366.18..320,102.21 rows=284,290 width=303) (actual rows= loops=)

  • Group Key: thread.id
2. 0.000 0.000 ↓ 0.0

Gather Merge (cost=148,366.18..307,309.16 rows=852,870 width=385) (actual rows= loops=)

  • Workers Planned: 2
3. 0.000 0.000 ↓ 0.0

Merge Join (cost=147,366.16..207,866.77 rows=355,362 width=385) (actual rows= loops=)

  • Merge Cond: (thread_participant_organization.thread_id = thread.id)
4. 0.000 0.000 ↓ 0.0

Merge Join (cost=147,323.02..155,002.48 rows=346,720 width=178) (actual rows= loops=)

  • Merge Cond: (thread_participant_organization.thread_id = thread_entity.thread_id)
5. 0.000 0.000 ↓ 0.0

Sort (cost=81,083.34..81,971.75 rows=355,362 width=104) (actual rows= loops=)

  • Sort Key: thread_participant_organization.thread_id
6. 0.000 0.000 ↓ 0.0

Parallel Hash Join (cost=6,755.08..28,885.37 rows=355,362 width=104) (actual rows= loops=)

  • Hash Cond: ((thread_participant_organization.organization_type = organization.type) AND (thread_participant_organization.organization_id = organization.id))
7. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on thread_participant_organization (cost=0.00..12,082.62 rows=355,362 width=50) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Parallel Hash (cost=4,155.43..4,155.43 rows=90,643 width=87) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on organization (cost=0.00..4,155.43 rows=90,643 width=87) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Materialize (cost=66,230.80..67,652.25 rows=284,290 width=74) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Sort (cost=66,230.80..66,941.52 rows=284,290 width=74) (actual rows= loops=)

  • Sort Key: thread_entity.thread_id
12. 0.000 0.000 ↓ 0.0

Hash Join (cost=13,084.95..27,843.38 rows=284,290 width=74) (actual rows= loops=)

  • Hash Cond: ((thread_entity.entity_type = ent.type) AND (thread_entity.entity_id = ent.id))
13. 0.000 0.000 ↓ 0.0

Seq Scan on thread_entity (cost=0.00..5,212.90 rows=284,290 width=38) (actual rows= loops=)

14. 0.000 0.000 ↓ 0.0

Hash (cost=5,211.78..5,211.78 rows=284,278 width=80) (actual rows= loops=)

15. 0.000 0.000 ↓ 0.0

Seq Scan on entity ent (cost=0.00..5,211.78 rows=284,278 width=80) (actual rows= loops=)

16. 0.000 0.000 ↓ 0.0

Index Scan using pk_thread_id on thread (cost=0.42..47,903.89 rows=284,290 width=239) (actual rows= loops=)