explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4YnP

Settings
# exclusive inclusive rows x rows loops node
1. 0.107 16,615.731 ↑ 6,544.7 77 1

Sort (cost=548,752.93..550,012.79 rows=503,943 width=75) (actual time=16,615.725..16,615.731 rows=77 loops=1)

  • Sort Key: okres_dwh_1.kod_okres, okres_dwh_1.nazev, okres_dwh_1.upper_name, okres_dwh_1.x_min, okres_dwh_1.x_max, okres_dwh_1.y_min, okres_dwh_1.y_max
  • Sort Method: quicksort Memory: 35kBpper_name",
2. 3,210.589 16,615.624 ↑ 6,544.7 77 1

HashAggregate (cost=495,982.79..501,022.22 rows=503,943 width=75) (actual time=16,612.512..16,615.624 rows=77 loops=1)

  • Group Key: okres_dwh_1.kod_okres, okres_dwh_1.nazev, okres_dwh_1.upper_name, okres_dwh_1.x_min, okres_dwh_1.x_max, okres_dwh_1.y_min, okres_dwh_1.y_max
3. 3,177.119 13,405.035 ↑ 1.6 3,160,748 1

HashAggregate (cost=294,405.51..344,799.83 rows=5,039,432 width=79) (actual time=12,335.552..13,405.035 rows=3,160,748 loops=1)

  • Group Key: okres_dwh_1.kod_okres, klienti_dwh_3.client_id
4. 1,518.468 10,227.916 ↑ 1.0 5,037,418 1

Hash Join (cost=49,643.99..269,208.35 rows=5,039,432 width=79) (actual time=676.747..10,227.916 rows=5,037,418 loops=1)

  • Hash Cond: ((obec_dwh_1.kod_okres)::text = (okres_dwh_1.kod_okres)::text)
5. 1,384.023 8,709.391 ↑ 1.0 5,037,418 1

Hash Join (cost=49,640.25..255,248.01 rows=5,039,432 width=18) (actual time=676.681..8,709.391 rows=5,037,418 loops=1)

  • Hash Cond: ((cast_obec_dwh_1.kod_obec)::text = (obec_dwh_1.kod_obec)::text)
6. 1,604.166 7,323.265 ↑ 1.0 5,037,418 1

Hash Join (cost=49,412.61..241,782.89 rows=5,039,432 width=19) (actual time=674.565..7,323.265 rows=5,037,418 loops=1)

  • Hash Cond: ((zsj_d_dwh_1.kod_cast_obec)::text = (cast_obec_dwh_1.kod_cast_obec)::text)
7. 1,674.941 5,714.162 ↑ 1.0 5,037,418 1

Hash Join (cost=48,859.74..227,997.78 rows=5,039,432 width=19) (actual time=669.604..5,714.162 rows=5,037,418 loops=1)

  • Hash Cond: ((klienti_distinct_dwh_3.kod_zsj_d)::text = (zsj_d_dwh_1.kod_zsj_d)::text)
8. 2,654.621 4,030.382 ↑ 1.0 5,037,422 1

Hash Join (cost=47,953.42..213,860.55 rows=5,039,432 width=20) (actual time=660.646..4,030.382 rows=5,037,422 loops=1)

  • Hash Cond: ((klienti_dwh_3.coords_key)::text = (klienti_distinct_dwh_3.coords_key)::text)
9. 720.490 720.490 ↑ 1.0 5,249,530 1

Seq Scan on klienti_dwh_3 (cost=0.00..152,126.91 rows=5,249,591 width=45) (actual time=0.006..720.490 rows=5,249,530 loops=1)

10. 430.124 655.271 ↑ 1.0 1,416,063 1

Hash (cost=30,252.63..30,252.63 rows=1,416,063 width=41) (actual time=655.270..655.271 rows=1,416,063 loops=1)

  • Buckets: 2,097,152 Batches: 1 Memory Usage: 118,410kB
11. 225.147 225.147 ↑ 1.0 1,416,063 1

Seq Scan on klienti_distinct_dwh_3 (cost=0.00..30,252.63 rows=1,416,063 width=41) (actual time=0.007..225.147 rows=1,416,063 loops=1)

12. 4.447 8.839 ↑ 1.0 23,303 1

Hash (cost=615.03..615.03 rows=23,303 width=15) (actual time=8.839..8.839 rows=23,303 loops=1)

  • Buckets: 32,768 Batches: 1 Memory Usage: 1,326kB
13. 4.392 4.392 ↑ 1.0 23,303 1

Seq Scan on zsj_d_dwh_1 (cost=0.00..615.03 rows=23,303 width=15) (actual time=0.006..4.392 rows=23,303 loops=1)

14. 2.276 4.937 ↑ 1.0 15,061 1

Hash (cost=364.61..364.61 rows=15,061 width=14) (actual time=4.937..4.937 rows=15,061 loops=1)

  • Buckets: 16,384 Batches: 1 Memory Usage: 805kB
15. 2.661 2.661 ↑ 1.0 15,061 1

Seq Scan on cast_obec_dwh_1 (cost=0.00..364.61 rows=15,061 width=14) (actual time=0.005..2.661 rows=15,061 loops=1)

16. 0.945 2.103 ↑ 1.0 6,251 1

Hash (cost=149.51..149.51 rows=6,251 width=13) (actual time=2.103..2.103 rows=6,251 loops=1)

  • Buckets: 8,192 Batches: 1 Memory Usage: 339kB
17. 1.158 1.158 ↑ 1.0 6,251 1

Seq Scan on obec_dwh_1 (cost=0.00..149.51 rows=6,251 width=13) (actual time=0.006..1.158 rows=6,251 loops=1)

18. 0.027 0.057 ↑ 1.0 77 1

Hash (cost=2.77..2.77 rows=77 width=67) (actual time=0.057..0.057 rows=77 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 16kB
19. 0.030 0.030 ↑ 1.0 77 1

Seq Scan on okres_dwh_1 (cost=0.00..2.77 rows=77 width=67) (actual time=0.015..0.030 rows=77 loops=1)

Planning time : 1.430 ms
Execution time : 16,667.245 ms