explain.depesz.com

PostgreSQL's explain analyze made readable

Result: XCpv : thing

Settings
# exclusive inclusive rows x rows loops node
1. 0.081 2,900.159 ↓ 1.3 35 1

Finalize GroupAggregate (cost=21,298.95..21,305.79 rows=27 width=17) (actual time=2,899.802..2,900.159 rows=35 loops=1)

  • Group Key: loanworken0_.queue_name
2. 19.598 2,900.078 ↓ 1.9 104 1

Gather Merge (cost=21,298.95..21,305.25 rows=54 width=17) (actual time=2,899.784..2,900.078 rows=104 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 0.185 2,880.480 ↓ 1.3 35 3 / 3

Sort (cost=20,298.93..20,299.00 rows=27 width=17) (actual time=2,880.428..2,880.480 rows=35 loops=3)

  • Sort Key: loanworken0_.queue_name
  • Sort Method: quicksort Memory: 27kB
  • Worker 0: Sort Method: quicksort Memory: 27kB
  • Worker 1: Sort Method: quicksort Memory: 27kB
4. 308.206 2,880.295 ↓ 1.3 35 3 / 3

Partial HashAggregate (cost=20,298.02..20,298.29 rows=27 width=17) (actual time=2,880.238..2,880.295 rows=35 loops=3)

  • Group Key: loanworken0_.queue_name
5. 1,399.613 2,572.089 ↑ 1.2 165,167 3 / 3

Merge Join (cost=0.93..19,277.26 rows=204,152 width=9) (actual time=9.530..2,572.089 rows=165,167 loops=3)

  • Merge Cond: (loan1_.loan_id = loanworken0_.loan_id)
6. 269.049 269.049 ↑ 1.3 165,170 3 / 3

Parallel Index Only Scan using test_index_2 on loan loan1_ (cost=0.42..6,040.15 rows=206,508 width=4) (actual time=0.036..269.049 rows=165,170 loops=3)

  • Heap Fetches: 0
7. 903.427 903.427 ↓ 1.0 495,663 3 / 3

Index Only Scan using test_index_3 on loan_work loanworken0_ (cost=0.42..9,455.23 rows=490,914 width=13) (actual time=0.036..903.427 rows=495,663 loops=3)

  • Heap Fetches: 0