explain.depesz.com

PostgreSQL's explain analyze made readable

Result: y8st

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.009 ↓ 0.0 0 1

Limit (cost=104.32..104.34 rows=10 width=290) (actual time=0.009..0.009 rows=0 loops=1)

2. 0.004 0.008 ↓ 0.0 0 1

Sort (cost=104.32..104.34 rows=10 width=290) (actual time=0.008..0.008 rows=0 loops=1)

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

HashAggregate (cost=104.03..104.15 rows=10 width=290) (actual time=0.004..0.004 rows=0 loops=1)

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

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

5. 0.003 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)

6. 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)

  • Merge Cond: ((thread_participant_organization.organization_id = organization.id) AND (thread_participant_organization.organization_type = organization.type))
  • Index Cond: (id = thread_participant_organization.thread_id)
7. 0.000 0.000 ↓ 0.0 0

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

8. 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)

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

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

Execution time : 0.068 ms