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. 0.000 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.555 8,641.440 ↓ 1.3 35 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. 924.618 8,640.885 ↓ 1.3 35 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. 4,198.839 7,716.267 ↑ 1.2 165,167 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. 807.147 807.147 ↑ 1.3 165,170 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. 2,710.281 2,710.281 ↓ 1.0 495,663 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