explain.depesz.com

PostgreSQL's explain analyze made readable

Result: cEdA

Settings
# exclusive inclusive rows x rows loops node
1. 0.010 8.345 ↑ 1.0 50 1

Limit (cost=2.84..601.90 rows=50 width=436) (actual time=0.152..8.345 rows=50 loops=1)

2. 0.098 8.335 ↑ 888.4 50 1

Nested Loop (cost=2.84..532,218.40 rows=44,421 width=436) (actual time=0.151..8.335 rows=50 loops=1)

3. 0.113 8.085 ↑ 584.5 76 1

Nested Loop (cost=2.55..517,836.43 rows=44,421 width=414) (actual time=0.094..8.085 rows=76 loops=1)

4. 0.114 7.744 ↑ 584.5 76 1

Nested Loop (cost=2.13..447,186.73 rows=44,421 width=381) (actual time=0.090..7.744 rows=76 loops=1)

  • Join Filter: (topic.id = topic_versions.topic_id)
5. 0.106 1.398 ↑ 593.5 76 1

Nested Loop (cost=1.70..415,244.70 rows=45,109 width=352) (actual time=0.079..1.398 rows=76 loops=1)

6. 0.422 1.064 ↑ 593.5 76 1

Nested Loop (cost=1.28..394,531.73 rows=45,109 width=336) (actual time=0.069..1.064 rows=76 loops=1)

7. 0.053 0.262 ↑ 721.0 76 1

Nested Loop (cost=0.85..361,667.03 rows=54,793 width=299) (actual time=0.057..0.262 rows=76 loops=1)

8. 0.029 0.029 ↑ 1,364.6 5 1

Index Scan using idx_741710_organization_indx on users "user" (cost=0.42..19,573.45 rows=6,823 width=46) (actual time=0.020..0.029 rows=5 loops=1)

  • Index Cond: (organisation_id = 2,697)
9. 0.180 0.180 ↑ 2.9 15 5

Index Scan using idx_741762_user_id on user_topics (cost=0.43..49.71 rows=43 width=261) (actual time=0.013..0.036 rows=15 loops=5)

  • Index Cond: (user_id = "user".id)
  • Filter: (NOT is_archived)
  • Rows Removed by Filter: 0
10. 0.380 0.380 ↑ 1.0 1 76

Index Scan using idx_741672_primary on topic_versions "topicVersion" (cost=0.42..0.60 rows=1 width=45) (actual time=0.005..0.005 rows=1 loops=76)

  • Index Cond: (id = user_topics.topic_version_id)
11. 0.228 0.228 ↑ 1.0 1 76

Index Scan using idx_741655_primary on topics topic (cost=0.42..0.46 rows=1 width=16) (actual time=0.003..0.003 rows=1 loops=76)

  • Index Cond: (id = user_topics.topic_id)
12. 6.232 6.232 ↑ 2.0 1 76

Index Scan using idx_741672_topic_id on topic_versions (cost=0.42..0.68 rows=2 width=45) (actual time=0.044..0.082 rows=1 loops=76)

  • Index Cond: (topic_id = user_topics.topic_id)
  • Filter: ((status)::text = 'DRAFT'::text)
  • Rows Removed by Filter: 3
13. 0.228 0.228 ↑ 1.0 1 76

Index Scan using idx_741672_primary on topic_versions "topic:currentTopicVersion" (cost=0.42..1.59 rows=1 width=45) (actual time=0.003..0.003 rows=1 loops=76)

  • Index Cond: (id = topic.production_topic_version_id)
14. 0.152 0.152 ↑ 1.0 1 76

Index Scan using idx_741371_primary on courses "topic:theme" (cost=0.29..0.32 rows=1 width=34) (actual time=0.002..0.002 rows=1 loops=76)

  • Index Cond: (id = topic.theme_id)
Planning time : 14.226 ms
Execution time : 8.623 ms