explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8LKR

Settings
# exclusive inclusive rows x rows loops node
1. 0.019 1,295.579 ↑ 17.0 2 1

Sort (cost=2,618.88..2,618.97 rows=34 width=407) (actual time=1,295.578..1,295.579 rows=2 loops=1)

  • Sort Key: folder.display_position, folder.date_created
  • Sort Method: quicksort Memory: 25kB
2. 0.007 1,295.560 ↑ 17.0 2 1

Nested Loop (cost=1.69..2,618.02 rows=34 width=407) (actual time=1,239.462..1,295.560 rows=2 loops=1)

3. 0.009 1,295.527 ↑ 17.0 2 1

Nested Loop (cost=1.41..2,607.73 rows=34 width=392) (actual time=1,239.443..1,295.527 rows=2 loops=1)

4. 15.131 1,295.478 ↑ 17.5 2 1

Nested Loop (cost=1.13..2,597.14 rows=35 width=377) (actual time=1,239.413..1,295.478 rows=2 loops=1)

5. 26.068 70.375 ↓ 228.6 100,831 1

Nested Loop (cost=0.70..2,320.85 rows=441 width=254) (actual time=0.071..70.375 rows=100,831 loops=1)

6. 0.032 0.032 ↑ 1.0 1 1

Index Scan using idx_tuning_pp on project (cost=0.28..8.29 rows=1 width=42) (actual time=0.030..0.032 rows=1 loops=1)

  • Index Cond: ((path)::text = 'projects.sennytest'::text)
7. 44.275 44.275 ↓ 156.6 100,831 1

Index Scan using folder_project on folder (cost=0.42..2,306.12 rows=644 width=221) (actual time=0.034..44.275 rows=100,831 loops=1)

  • Index Cond: ((project_id)::text = (project.id)::text)
  • Filter: (NOT is_deleted)
  • Rows Removed by Filter: 1
8. 1,209.972 1,209.972 ↓ 0.0 0 100,831

Index Scan using folder_pk on folder folder2 (cost=0.42..0.63 rows=1 width=133) (actual time=0.012..0.012 rows=0 loops=100,831)

  • Index Cond: ((id)::text = (folder.parent_folder_id)::text)
  • Filter: ((path = 'planning'::text) OR (path ~~ 'planning.%'::text))
  • Rows Removed by Filter: 1
9. 0.040 0.040 ↑ 1.0 1 2

Index Scan using sfuser_id on sfuser (cost=0.28..0.30 rows=1 width=33) (actual time=0.020..0.020 rows=1 loops=2)

  • Index Cond: ((id)::text = (folder.created_by_id)::text)
10. 0.026 0.026 ↑ 1.0 1 2

Index Scan using sfuser_id on sfuser sfuser2 (cost=0.28..0.30 rows=1 width=33) (actual time=0.013..0.013 rows=1 loops=2)

  • Index Cond: ((id)::text = (folder.last_modified_by_id)::text)
Planning time : 3.273 ms