explain.depesz.com

PostgreSQL's explain analyze made readable

Result: XCuy

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 2,271.002 ↑ 1.0 50 1

Limit (cost=1,003.15..11,442.17 rows=50 width=3,714) (actual time=2,089.477..2,271.002 rows=50 loops=1)

2. 51.953 2,278.335 ↑ 104.5 50 1

Gather Merge (cost=1,003.15..1,091,671.44 rows=5,224 width=3,714) (actual time=2,089.476..2,278.335 rows=50 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 0.039 2,226.382 ↑ 103.7 21 3 / 3

Nested Loop Left Join (cost=3.13..1,090,068.44 rows=2,177 width=3,714) (actual time=2,083.224..2,226.382 rows=21 loops=3)

4. 0.032 2,226.301 ↑ 103.7 21 3 / 3

Nested Loop Left Join (cost=2.84..1,089,363.57 rows=2,177 width=3,223) (actual time=2,083.212..2,226.301 rows=21 loops=3)

5. 0.036 2,226.101 ↑ 103.7 21 3 / 3

Nested Loop Left Join (cost=2.42..1,085,664.57 rows=2,177 width=2,309) (actual time=2,083.195..2,226.101 rows=21 loops=3)

6. 0.021 2,225.981 ↑ 103.7 21 3 / 3

Nested Loop Left Join (cost=1.99..1,082,201.61 rows=2,177 width=1,395) (actual time=2,083.170..2,225.981 rows=21 loops=3)

7. 0.025 2,225.897 ↑ 103.7 21 3 / 3

Nested Loop Left Join (cost=1.57..1,081,202.84 rows=2,177 width=1,320) (actual time=2,083.155..2,225.897 rows=21 loops=3)

8. 0.000 2,225.767 ↑ 103.7 21 3 / 3

Nested Loop (cost=1.14..1,079,904.20 rows=2,177 width=406) (actual time=2,083.134..2,225.767 rows=21 loops=3)

9. 212.536 1,573.341 ↑ 2.7 335,539 3 / 3

Nested Loop (cost=0.85..794,556.98 rows=909,699 width=291) (actual time=0.032..1,573.341 rows=335,539 loops=3)

10. 689.430 689.430 ↑ 2.7 335,687 3 / 3

Parallel Index Scan using idx_741762_primary on user_topics (cost=0.43..377,204.53 rows=909,699 width=283) (actual time=0.021..689.430 rows=335,687 loops=3)

  • Filter: (NOT is_archived)
  • Rows Removed by Filter: 644,876
11. 671.375 671.375 ↑ 1.0 1 1,007,062 / 3

Index Scan using idx_741655_primary on topics workspace_join (cost=0.42..0.46 rows=1 width=16) (actual time=0.002..0.002 rows=1 loops=1,007,062)

  • Index Cond: (id = user_topics.topic_id)
12. 671.077 671.077 ↓ 0.0 0 1,006,616 / 3

Index Scan using idx_741780_primary on workspaces workspace (cost=0.29..0.31 rows=1 width=123) (actual time=0.002..0.002 rows=0 loops=1,006,616)

  • Index Cond: (id = workspace_join.workspace_id)
  • Filter: (organisation_id = 2,697)
  • Rows Removed by Filter: 1
13. 0.105 0.105 ↑ 1.0 1 63 / 3

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

  • Index Cond: (id = user_topics.topic_version_id)
14. 0.063 0.063 ↑ 1.0 1 63 / 3

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

  • Index Cond: (id = user_topics.topic_id)
15. 0.084 0.084 ↑ 1.0 1 63 / 3

Index Scan using idx_741672_primary on topic_versions "topic:currentTopicVersion" (cost=0.42..1.59 rows=1 width=914) (actual time=0.004..0.004 rows=1 loops=63)

  • Index Cond: (id = topic.production_topic_version_id)
16. 0.168 0.168 ↑ 2.0 1 63 / 3

Index Scan using idx_741672_topic_id on topic_versions (cost=0.42..1.68 rows=2 width=914) (actual time=0.005..0.008 rows=1 loops=63)

  • Index Cond: (topic_id = topic.id)
  • Filter: ((status)::text = 'DRAFT'::text)
  • Rows Removed by Filter: 5
17. 0.042 0.042 ↓ 0.0 0 63 / 3

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

  • Index Cond: (id = topic.theme_id)
Planning time : 6.074 ms
Execution time : 2,278.514 ms