explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lIJd

Settings
# exclusive inclusive rows x rows loops node
1. 0.031 62.405 ↓ 1.2 38 1

Finalize GroupAggregate (cost=17,248.91..17,261.45 rows=33 width=17) (actual time=57.712..62.405 rows=38 loops=1)

  • Group Key: eib_contract_object_maintenance_stg.maintenance_scheme
2. 16.069 62.374 ↓ 1.3 132 1

Gather Merge (cost=17,248.91..17,260.62 rows=99 width=17) (actual time=57.706..62.374 rows=132 loops=1)

  • Workers Planned: 3
  • Workers Launched: 3
3. 0.039 46.305 ↑ 1.0 33 4 / 4

Sort (cost=16,248.87..16,248.95 rows=33 width=17) (actual time=46.301..46.305 rows=33 loops=4)

  • Sort Key: eib_contract_object_maintenance_stg.maintenance_scheme
  • Sort Method: quicksort Memory: 27kB
  • Worker 0: Sort Method: quicksort Memory: 27kB
  • Worker 1: Sort Method: quicksort Memory: 27kB
  • Worker 2: Sort Method: quicksort Memory: 27kB
4. 31.225 46.266 ↑ 1.0 33 4 / 4

Partial HashAggregate (cost=16,247.71..16,248.04 rows=33 width=17) (actual time=46.259..46.266 rows=33 loops=4)

  • Group Key: eib_contract_object_maintenance_stg.maintenance_scheme
  • Batches: 1 Memory Usage: 24kB
  • Worker 0: Batches: 1 Memory Usage: 24kB
  • Worker 1: Batches: 1 Memory Usage: 24kB
  • Worker 2: Batches: 1 Memory Usage: 24kB
5. 15.041 15.041 ↑ 1.3 117,372 4 / 4

Parallel Seq Scan on eib_contract_object_maintenance_stg (cost=0.00..15,490.47 rows=151,447 width=9) (actual time=0.010..15.041 rows=117,372 loops=4)

Planning time : 0.100 ms
Execution time : 62.452 ms