explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Cvbkg

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 165.719 ↑ 1.0 3 1

Finalize GroupAggregate (cost=15,920.01..15,920.77 rows=3 width=12) (actual time=165.715..165.719 rows=3 loops=1)

  • Group Key: hotel_sig
2. 0.000 171.496 ↓ 1.5 9 1

Gather Merge (cost=15,920.01..15,920.71 rows=6 width=12) (actual time=165.693..171.496 rows=9 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 0.393 449.709 ↑ 1.0 3 3

Sort (cost=14,919.99..14,919.99 rows=3 width=12) (actual time=149.902..149.903 rows=3 loops=3)

  • Sort Key: hotel_sig
  • Sort Method: quicksort Memory: 25kB
  • Worker 0: Sort Method: quicksort Memory: 25kB
  • Worker 1: Sort Method: quicksort Memory: 25kB
4. 178.452 449.316 ↑ 1.0 3 3

Partial HashAggregate (cost=14,919.93..14,919.96 rows=3 width=12) (actual time=149.770..149.772 rows=3 loops=3)

  • Group Key: hotel_sig
5. 270.864 270.864 ↑ 1.2 122,507 3

Parallel Seq Scan on sinestandar_info_sociodemplf (cost=0.00..14,160.29 rows=151,929 width=4) (actual time=0.030..90.288 rows=122,507 loops=3)