explain.depesz.com

A tool for finding a real cause for slow queries.

Result: kWt

options
# exclusive inclusive rows x rows loops node
1. 0.061 0.577 ↓ 2.0 2 1
→

Sort (cost=166.95..166.96 rows=1 width=271) (actual time=0.577..0.577 rows=2 loops=1)

  • Sort Key: folder.display_position
  • Sort Method: quicksort Memory: 26kB
2. 0.008 0.516 ↓ 2.0 2 1
→

Nested Loop (cost=0.00..166.94 rows=1 width=271) (actual time=0.435..0.516 rows=2 loops=1)

3. 0.005 0.482 ↓ 2.0 2 1
→

Nested Loop (cost=0.00..166.39 rows=1 width=257) (actual time=0.416..0.482 rows=2 loops=1)

4. 0.007 0.419 ↓ 2.0 2 1
→

Nested Loop (cost=0.00..161.10 rows=1 width=223) (actual time=0.369..0.419 rows=2 loops=1)

5. 0.006 0.340 ↓ 2.0 2 1
→

Nested Loop (cost=0.00..160.55 rows=1 width=209) (actual time=0.304..0.340 rows=2 loops=1)

6. 0.016 0.268 ↑ 1.0 2 1
→

Nested Loop (cost=0.00..159.82 rows=2 width=185) (actual time=0.250..0.268 rows=2 loops=1)

7. 0.086 0.086 ↑ 1.0 1 1
→

Index Scan using project_path on project (cost=0.00..8.27 rows=1 width=42) (actual time=0.086..0.086 rows=1 loops=1)

  • Index Cond: ((path)::text = 'projects.psr-pf-pub-27'::text)
8. 0.166 0.166 ↑ 1.0 2 1
→

Index Scan using folder_project on folder (cost=0.00..151.52 rows=2 width=152) (actual time=0.149..0.166 rows=2 loops=1)

  • Index Cond: ((folder.project_id)::text = (project.id)::text)
  • Filter: ((NOT folder.is_deleted) AND ((folder.id)::text ~~ 'tracker%'::text))
9. 0.066 0.066 ↑ 1.0 1 2
→

Index Scan using tracker_pk on tracker (cost=0.00..0.36 rows=1 width=36) (actual time=0.032..0.033 rows=1 loops=2)

  • Index Cond: ((tracker.id)::text = (folder.id)::text)
10. 0.072 0.072 ↑ 1.0 1 2
→

Index Scan using sfuser_pk on sfuser sfuser2 (cost=0.00..0.54 rows=1 width=32) (actual time=0.035..0.036 rows=1 loops=2)

  • Index Cond: ((sfuser2.id)::text = (folder.last_modified_by_id)::text)
11. 0.058 0.058 ↑ 1.0 1 2
→

Index Scan using folder_pk on folder folder2 (cost=0.00..5.28 rows=1 width=44) (actual time=0.027..0.029 rows=1 loops=2)

  • Index Cond: ((folder2.id)::text = (folder.parent_folder_id)::text)
12. 0.026 0.026 ↑ 1.0 1 2
→

Index Scan using sfuser_pk on sfuser (cost=0.00..0.54 rows=1 width=32) (actual time=0.012..0.013 rows=1 loops=2)

  • Index Cond: ((sfuser.id)::text = (folder.created_by_id)::text)