explain.depesz.com

PostgreSQL's explain analyze made readable

Result: EuLk

Settings
# exclusive inclusive rows x rows loops node
1. 16.764 1,045.226 ↓ 34.4 61,916 1

Unique (cost=92,772.12..92,901.92 rows=1,800 width=124) (actual time=1,022.748..1,045.226 rows=61,916 loops=1)

2.          

CTE relevant_applications

3. 18.061 18.061 ↓ 1.0 35,183 1

Index Scan using application_organization_id_idx on application (cost=0.08..17,587.95 rows=34,869 width=804) (actual time=0.017..18.061 rows=35,183 loops=1)

  • Index Cond: (organization_id = '399dff6f-ad8f-4e70-b082-b547b26c8fe4'::uuid)
4. 51.631 1,028.462 ↑ 1.3 64,169 1

Sort (cost=75,184.17..75,227.44 rows=86,539 width=124) (actual time=1,022.746..1,028.462 rows=64,169 loops=1)

  • Sort Key: relevant_applications.id, interview_stage_group_type.id
  • Sort Method: quicksort Memory: 16,327kB
5. 13.875 976.831 ↑ 1.3 64,169 1

Hash Left Join (cost=57,762.09..73,764.83 rows=86,539 width=124) (actual time=750.299..976.831 rows=64,169 loops=1)

  • Hash Cond: (relevant_applications.archive_reason_id = archive_reason.id)
6. 16.562 962.745 ↑ 1.3 64,169 1

Hash Left Join (cost=57,751.03..73,707.75 rows=86,539 width=101) (actual time=750.081..962.745 rows=64,169 loops=1)

  • Hash Cond: (application_history.new_interview_stage_id = next_interview_stage.id)
7. 13.818 930.982 ↑ 1.3 64,169 1

Hash Left Join (cost=56,683.10..72,594.38 rows=86,539 width=97) (actual time=734.532..930.982 rows=64,169 loops=1)

  • Hash Cond: (interview_stage.interview_stage_group_id = interview_stage_group_type.id)
8. 15.666 917.132 ↑ 1.3 64,169 1

Hash Left Join (cost=56,679.51..72,543.65 rows=86,539 width=84) (actual time=734.489..917.132 rows=64,169 loops=1)

  • Hash Cond: (application_history.previous_interview_stage_id = interview_stage.id)
9. 134.881 883.760 ↑ 1.3 64,169 1

Hash Left Join (cost=55,611.59..71,430.29 rows=86,539 width=80) (actual time=716.443..883.760 rows=64,169 loops=1)

  • Hash Cond: (relevant_applications.id = application_history.application_id)
10. 37.652 37.652 ↓ 1.0 35,183 1

CTE Scan on relevant_applications (cost=0.00..209.21 rows=34,869 width=32) (actual time=0.020..37.652 rows=35,183 loops=1)

11. 368.414 711.227 ↑ 1.0 1,381,167 1

Hash (cost=35,940.50..35,940.50 rows=1,381,167 width=64) (actual time=711.226..711.227 rows=1,381,167 loops=1)

  • Buckets: 1,048,576 Batches: 2 Memory Usage: 71,463kB
12. 342.813 342.813 ↑ 1.0 1,381,167 1

Seq Scan on application_history (cost=0.00..35,940.50 rows=1,381,167 width=64) (actual time=0.008..342.813 rows=1,381,167 loops=1)

13. 8.427 17.706 ↑ 1.0 40,406 1

Hash (cost=925.81..925.81 rows=40,604 width=36) (actual time=17.706..17.706 rows=40,406 loops=1)

  • Buckets: 65,536 Batches: 1 Memory Usage: 3,191kB
14. 9.279 9.279 ↑ 1.0 40,406 1

Seq Scan on interview_stage (cost=0.00..925.81 rows=40,604 width=36) (actual time=0.006..9.279 rows=40,406 loops=1)

15. 0.007 0.032 ↑ 1.0 9 1

Hash (cost=3.56..3.56 rows=9 width=29) (actual time=0.032..0.032 rows=9 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
16. 0.025 0.025 ↑ 1.0 9 1

Seq Scan on interview_stage_group_type (cost=0.00..3.56 rows=9 width=29) (actual time=0.009..0.025 rows=9 loops=1)

  • Filter: (organization_id = '399dff6f-ad8f-4e70-b082-b547b26c8fe4'::uuid)
  • Rows Removed by Filter: 159
17. 7.506 15.201 ↑ 1.0 40,406 1

Hash (cost=925.81..925.81 rows=40,604 width=20) (actual time=15.201..15.201 rows=40,406 loops=1)

  • Buckets: 65,536 Batches: 1 Memory Usage: 2,564kB
18. 7.695 7.695 ↑ 1.0 40,406 1

Seq Scan on interview_stage next_interview_stage (cost=0.00..925.81 rows=40,604 width=20) (actual time=0.005..7.695 rows=40,406 loops=1)

19. 0.118 0.211 ↓ 1.0 486 1

Hash (cost=9.41..9.41 rows=471 width=55) (actual time=0.211..0.211 rows=486 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 51kB
20. 0.093 0.093 ↓ 1.0 486 1

Seq Scan on archive_reason (cost=0.00..9.41 rows=471 width=55) (actual time=0.007..0.093 rows=486 loops=1)