explain.depesz.com

PostgreSQL's explain analyze made readable

Result: P86I

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

Limit (cost=111.35..111.36 rows=1 width=410) (actual time=0.013..0.013 rows=0 loops=1)

2. 0.004 0.013 ↓ 0.0 0 1

Sort (cost=111.35..111.36 rows=1 width=410) (actual time=0.013..0.013 rows=0 loops=1)

  • Sort Key: thread.date_updated DESC NULLS LAST, thread.id DESC NULLS LAST
  • Sort Method: quicksort Memory: 25kB
3. 0.001 0.009 ↓ 0.0 0 1

GroupAggregate (cost=111.31..111.34 rows=1 width=410) (actual time=0.009..0.009 rows=0 loops=1)

  • Group Key: thread.id
4. 0.003 0.008 ↓ 0.0 0 1

Sort (cost=111.31..111.32 rows=1 width=410) (actual time=0.008..0.008 rows=0 loops=1)

  • Sort Key: thread.id DESC NULLS LAST
  • Sort Method: quicksort Memory: 25kB
5. 0.001 0.005 ↓ 0.0 0 1

Nested Loop (cost=39.26..111.30 rows=1 width=410) (actual time=0.005..0.005 rows=0 loops=1)

6. 0.000 0.004 ↓ 0.0 0 1

Nested Loop (cost=39.11..107.25 rows=17 width=354) (actual time=0.004..0.004 rows=0 loops=1)

  • Join Filter: (thread.id = thread_entity.thread_id)
7. 0.001 0.004 ↓ 0.0 0 1

Nested Loop (cost=38.96..103.95 rows=10 width=306) (actual time=0.004..0.004 rows=0 loops=1)

8. 0.001 0.003 ↓ 0.0 0 1

Merge Join (cost=38.81..101.61 rows=10 width=145) (actual time=0.003..0.003 rows=0 loops=1)

  • Merge Cond: ((thread_participant_organization.organization_id = organization.id) AND (thread_participant_organization.organization_type = organization.type))
9. 0.002 0.002 ↓ 0.0 0 1

Index Scan using idx_thread_participant_participant_id_participant_type on thread_participant_organization (cost=0.15..55.25 rows=740 width=81) (actual time=0.002..0.002 rows=0 loops=1)

10. 0.000 0.000 ↓ 0.0 0

Sort (cost=38.66..39.96 rows=520 width=128) (never executed)

  • Sort Key: organization.id, organization.type
11. 0.000 0.000 ↓ 0.0 0

Seq Scan on organization (cost=0.00..15.20 rows=520 width=128) (never executed)

12. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_thread_id on thread (cost=0.15..0.22 rows=1 width=161) (never executed)

  • Index Cond: (id = thread_participant_organization.thread_id)
13. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_thread_entity_thread_id on thread_entity (cost=0.15..0.28 rows=4 width=80) (never executed)

  • Index Cond: (thread_id = thread_participant_organization.thread_id)
14. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_entity_id_type on entity ent (cost=0.15..0.23 rows=1 width=184) (never executed)

  • Index Cond: ((id = thread_entity.entity_id) AND (type = thread_entity.entity_type))
Planning time : 1.637 ms
Execution time : 0.094 ms