explain.depesz.com

A tool for finding a real cause for slow queries.

Result: 0bl

options
# exclusive inclusive rows x rows loops node
1. 0.026 0.515 ↑ 1.5 2 1
→

Sort (cost=207.57..207.57 rows=3 width=271) (actual time=0.515..0.515 rows=2 loops=1)

  • Sort Key: folder.display_position
  • Sort Method: quicksort Memory: 26kB
2. 0.007 0.489 ↑ 1.5 2 1
→

Nested Loop (cost=0.00..207.54 rows=3 width=271) (actual time=0.419..0.489 rows=2 loops=1)

3. 0.008 0.452 ↑ 1.5 2 1
→

Nested Loop (cost=0.00..206.69 rows=3 width=257) (actual time=0.395..0.452 rows=2 loops=1)

4. 0.009 0.410 ↑ 1.5 2 1
→

Nested Loop (cost=0.00..205.33 rows=3 width=223) (actual time=0.369..0.410 rows=2 loops=1)

5. 0.035 0.371 ↑ 1.5 2 1
→

Nested Loop (cost=0.00..204.48 rows=3 width=209) (actual time=0.345..0.371 rows=2 loops=1)

6. 0.026 0.146 ↑ 4.0 38 1
→

Nested Loop (cost=0.00..161.38 rows=153 width=185) (actual time=0.090..0.146 rows=38 loops=1)

7. 0.047 0.047 ↑ 1.0 1 1
→

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

  • Index Cond: ((path)::text = 'projects.psr-pf-pub-27'::text)
8. 0.073 0.073 ↑ 4.2 38 1
→

Index Scan using folder_project on folder (cost=0.00..151.12 rows=159 width=152) (actual time=0.034..0.073 rows=38 loops=1)

  • Index Cond: ((folder.project_id)::text = (project.id)::text)
  • Filter: (NOT folder.is_deleted)
9. 0.190 0.190 ↓ 0.0 0 38
→

Index Scan using tracker_pk on tracker (cost=0.00..0.27 rows=1 width=36) (actual time=0.005..0.005 rows=0 loops=38)

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

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

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

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

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

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

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