explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 66t

Settings
# exclusive inclusive rows x rows loops node
1. 3.855 10.914 ↑ 1.0 100 1

GroupAggregate (cost=2.12..3,511.85 rows=100 width=435) (actual time=0.293..10.914 rows=100 loops=1)

  • Group Key: thread.id
2. 0.203 7.059 ↓ 3.0 300 1

Nested Loop (cost=2.12..3,509.34 rows=101 width=435) (actual time=0.072..7.059 rows=300 loops=1)

3. 0.124 3.856 ↑ 1.0 300 1

Nested Loop (cost=1.70..3,368.83 rows=300 width=376) (actual time=0.055..3.856 rows=300 loops=1)

4. 0.109 2.832 ↑ 1.0 100 1

Nested Loop Left Join (cost=1.27..1,725.83 rows=100 width=342) (actual time=0.040..2.832 rows=100 loops=1)

5. 0.167 1.423 ↑ 1.0 100 1

Nested Loop Left Join (cost=0.85..1,673.50 rows=100 width=287) (actual time=0.020..1.423 rows=100 loops=1)

6. 0.656 0.656 ↑ 1.0 100 1

Index Scan using pk_thread_id on thread (cost=0.42..836.25 rows=100 width=246) (actual time=0.007..0.656 rows=100 loops=1)

  • Index Cond: (id = ANY ('{69cbb832-3092-4274-a4dd-ee75ca18c85a,03923999-800d-4f7f-8031-8de60df2a919,ab8b7bb6-9a8d-4661-8a70-5114be250d3c,bf9a89a1-f13c-401d-bab4-c0e755ddf9ed,fa3870fb-6dad-466d-88de-1ef2155b59ba,27538c13-bbd2- (...)
7. 0.600 0.600 ↑ 1.0 1 100

Index Scan using idx_thread_entity_thread_id on thread_entity (cost=0.42..8.36 rows=1 width=57) (actual time=0.006..0.006 rows=1 loops=100)

  • Index Cond: (thread.id = thread_id)
8. 1.300 1.300 ↑ 1.0 1 100

Index Scan using pk_entity_id_type on entity ent (cost=0.42..0.51 rows=1 width=137) (actual time=0.013..0.013 rows=1 loops=100)

  • Index Cond: ((thread_entity.entity_id = id) AND (thread_entity.entity_type = type))
9. 0.900 0.900 ↑ 1.0 3 100

Index Scan using idx_thread_participant_thread_id on thread_participant_organization (cost=0.43..16.40 rows=3 width=50) (actual time=0.008..0.009 rows=3 loops=100)

  • Index Cond: (thread_id = thread.id)
10. 3.000 3.000 ↑ 1.0 1 300

Index Scan using pk_participant_id_participant_type on organization (cost=0.42..0.46 rows=1 width=92) (actual time=0.009..0.010 rows=1 loops=300)

  • Index Cond: ((id = thread_participant_organization.organization_id) AND (type = thread_participant_organization.organization_type))