explain.depesz.com

PostgreSQL's explain analyze made readable

Result: BhIv

Settings
# exclusive inclusive rows x rows loops node
1. 0.018 2,137.339 ↑ 1.1 14 1

Finalize GroupAggregate (cost=64,638.26..64,638.66 rows=16 width=16) (actual time=2,137.321..2,137.339 rows=14 loops=1)

  • Group Key: atc_nivel_1.codigo
2. 0.000 2,137.321 ↓ 1.3 42 1

Sort (cost=64,638.26..64,638.34 rows=32 width=16) (actual time=2,137.317..2,137.321 rows=42 loops=1)

  • Sort Key: atc_nivel_1.codigo
  • Sort Method: quicksort Memory: 26kB
3. 13.888 2,144.233 ↓ 1.3 42 1

Gather (cost=64,634.10..64,637.46 rows=32 width=16) (actual time=2,136.933..2,144.233 rows=42 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
4. 475.917 2,130.345 ↑ 1.1 14 3 / 3

Partial HashAggregate (cost=63,634.10..63,634.26 rows=16 width=16) (actual time=2,130.340..2,130.345 rows=14 loops=3)

  • Group Key: atc_nivel_1.codigo
5. 1,274.947 1,654.428 ↓ 10.0 585,727 3 / 3

Hash Join (cost=1.36..63,341.24 rows=58,573 width=8) (actual time=0.091..1,654.428 rows=585,727 loops=3)

  • Hash Cond: (substr((dispensaciones_cache.atc)::text, 1, 1) = (atc_nivel_1.codigo)::text)
6. 379.452 379.452 ↑ 1.3 585,727 3 / 3

Parallel Seq Scan on dispensaciones_cache (cost=0.00..61,281.59 rows=732,159 width=7) (actual time=0.041..379.452 rows=585,727 loops=3)

7. 0.012 0.029 ↑ 1.0 16 3 / 3

Hash (cost=1.16..1.16 rows=16 width=8) (actual time=0.028..0.029 rows=16 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
8. 0.017 0.017 ↑ 1.0 16 3 / 3

Seq Scan on atc_nivel_1 (cost=0.00..1.16 rows=16 width=8) (actual time=0.014..0.017 rows=16 loops=3)

Planning time : 0.728 ms
Execution time : 2,144.421 ms