explain.depesz.com

PostgreSQL's explain analyze made readable

Result: zmwi

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

Limit (cost=112.80..112.82 rows=11 width=410) (actual time=0.020..0.020 rows=0 loops=1)

2. 0.008 0.019 ↓ 0.0 0 1

Sort (cost=112.80..112.84 rows=17 width=410) (actual time=0.019..0.019 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.011 ↓ 0.0 0 1

GroupAggregate (cost=111.98..112.45 rows=17 width=410) (actual time=0.011..0.011 rows=0 loops=1)

  • Group Key: thread.id
4. 0.004 0.010 ↓ 0.0 0 1

Sort (cost=111.98..112.02 rows=17 width=410) (actual time=0.010..0.010 rows=0 loops=1)

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

Nested Loop Left Join (cost=39.26..111.63 rows=17 width=410) (actual time=0.006..0.006 rows=0 loops=1)

6. 0.006 0.006 ↓ 0.0 0 1

Nested Loop Left Join (cost=39.11..107.58 rows=17 width=354) (actual time=0.006..0.006 rows=0 loops=1)

7. 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: ((thread_entity.entity_id = id) AND (thread_entity.entity_type = type))
8. 0.005 0.005 ↓ 0.0 0 1

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

9. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (thread.id = thread_id)
10. 0.004 0.004 ↓ 0.0 0 1

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

11. 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)
12. 0.000 0.000 ↓ 0.0 0

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

13. 0.003 0.003 ↓ 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.003..0.003 rows=0 loops=1)

  • Sort Key: organization.id, organization.type
14. 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.130 ms