explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8jCt

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 1,705.221 ↓ 1.3 35 1

Finalize GroupAggregate (cost=17,752.34..17,759.18 rows=27 width=17) (actual time=1,704.820..1,705.221 rows=35 loops=1)

  • Group Key: loanworken0_.queue_name
2. 0.000 1,709.581 ↓ 1.9 105 1

Gather Merge (cost=17,752.34..17,758.64 rows=54 width=17) (actual time=1,704.800..1,709.581 rows=105 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 0.615 5,101.248 ↓ 1.3 35 3

Sort (cost=16,752.32..16,752.39 rows=27 width=17) (actual time=1,700.357..1,700.416 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. 873.057 5,100.633 ↓ 1.3 35 3

Partial HashAggregate (cost=16,751.41..16,751.68 rows=27 width=17) (actual time=1,700.152..1,700.211 rows=35 loops=3)

  • Group Key: loanworken0_.queue_name
5. 1,658.253 4,227.576 ↑ 1.2 165,167 3

Parallel Hash Join (cost=9,148.84..15,730.65 rows=204,152 width=9) (actual time=596.234..1,409.192 rows=165,167 loops=3)

  • Hash Cond: (loan1_.loan_id = loanworken0_.loan_id)
6. 786.354 786.354 ↑ 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.054..262.118 rows=165,170 loops=3)

  • Heap Fetches: 0
7. 914.679 1,782.969 ↑ 1.2 165,372 3

Parallel Hash (cost=6,591.57..6,591.57 rows=204,548 width=13) (actual time=594.321..594.323 rows=165,372 loops=3)

  • Buckets: 524288 Batches: 1 Memory Usage: 27360kB
8. 868.290 868.290 ↑ 1.2 165,372 3

Parallel Index Only Scan using test_index_3 on loan_work loanworken0_ (cost=0.42..6,591.57 rows=204,548 width=13) (actual time=0.038..289.430 rows=165,372 loops=3)

  • Heap Fetches: 0