explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 57j

Settings
# exclusive inclusive rows x rows loops node
1. 21.548 1,073.478 ↓ 34.4 61,916 1

Unique (cost=92,748.74..92,878.55 rows=1,800 width=124) (actual time=1,043.556..1,073.478 rows=61,916 loops=1)

2.          

CTE relevant_applications

3. 18.034 18.034 ↓ 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.034 rows=35,183 loops=1)

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

Sort (cost=75,160.79..75,204.06 rows=86,539 width=124) (actual time=1,043.555..1,051.930 rows=64,169 loops=1)

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

Hash Left Join (cost=57,747.72..73,741.46 rows=86,539 width=124) (actual time=765.586..997.346 rows=64,169 loops=1)

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

Hash Left Join (cost=57,736.65..73,684.37 rows=86,539 width=101) (actual time=765.374..983.270 rows=64,169 loops=1)

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

Hash Left Join (cost=56,668.73..72,571.01 rows=86,539 width=97) (actual time=750.341..952.573 rows=64,169 loops=1)

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

Hash Left Join (cost=56,665.14..72,520.28 rows=86,539 width=84) (actual time=750.300..938.907 rows=64,169 loops=1)

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

Hash Left Join (cost=55,597.21..71,406.91 rows=86,539 width=80) (actual time=732.444..905.927 rows=64,169 loops=1)

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

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

11. 374.600 727.241 ↓ 1.0 1,381,167 1

Hash (cost=35,938.02..35,938.02 rows=1,380,340 width=64) (actual time=727.241..727.241 rows=1,381,167 loops=1)

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

Seq Scan on application_history (cost=0.00..35,938.02 rows=1,380,340 width=64) (actual time=0.006..352.641 rows=1,381,167 loops=1)

13. 8.317 17.519 ↑ 1.0 40,406 1

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

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

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

15. 0.006 0.031 ↑ 1.0 9 1

Hash (cost=3.56..3.56 rows=9 width=29) (actual time=0.031..0.031 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.008..0.025 rows=9 loops=1)

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

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

  • Buckets: 65,536 Batches: 1 Memory Usage: 2,564kB
18. 7.170 7.170 ↑ 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.004..7.170 rows=40,406 loops=1)

19. 0.118 0.206 ↓ 1.0 486 1

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

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

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