explain.depesz.com

PostgreSQL's explain analyze made readable

Result: soLc

Settings
# exclusive inclusive rows x rows loops node
1. 692.657 3,564.794 ↑ 267,121.7 941,465 1

Gather Motion 60:1 (slice17; segments: 60) (cost=0.00..40,113,561.22 rows=251,485,711,928 width=64) (actual time=2,791.057..3,564.794 rows=941,465 loops=1)

  • (slice0) Executor memory: 1,188K bytes.
  • (slice1) Executor memory: 66K bytes avg x 60 workers, 66K bytes max (seg0).
  • (slice2) Executor memory: 282K bytes avg x 60 workers, 298K bytes max (seg54). Work_mem: 35K bytes max.
  • (slice3) Executor memory: 458K bytes avg x 60 workers, 474K bytes max (seg14). Work_mem: 78K bytes max.
  • (slice4) Executor memory: 903K bytes avg x 60 workers, 966K bytes max (seg26). Work_mem: 185K bytes max.
  • (slice5) Executor memory: 863K bytes avg x 60 workers, 906K bytes max (seg9). Work_mem: 187K bytes max.
  • (slice6) Executor memory: 214K bytes avg x 60 workers, 218K bytes max (seg1).
  • (slice7) Executor memory: 66K bytes avg x 60 workers, 66K bytes max (seg0).
  • (slice8) Executor memory: 66K bytes avg x 60 workers, 66K bytes max (seg0).
  • (slice9) Executor memory: 66K bytes avg x 60 workers, 66K bytes max (seg0).
  • (slice10) Executor memory: 66K bytes avg x 60 workers, 66K bytes max (seg0).
  • (slice11) Executor memory: 717K bytes avg x 60 workers, 722K bytes max (seg0). Work_mem: 52K bytes max.
  • (slice12) Executor memory: 1,539K bytes avg x 60 workers, 1575K bytes max (seg0).
  • (slice13) Executor memory: 66K bytes avg x 60 workers, 66K bytes max (seg0).
  • (slice14) Executor memory: 337K bytes avg x 60 workers, 346K bytes max (seg2).
  • (slice15) Executor memory: 130K bytes avg x 60 workers, 130K bytes max (seg0). Work_mem: 65K bytes max.
  • (slice16) Executor memory: 671K bytes avg x 60 workers, 834K bytes max (seg45). Work_mem: 1K bytes max.
  • (slice17) Executor memory: 6,178K bytes avg x 60 workers, 6182K bytes max (seg1). Work_mem: 1,058K bytes max.
2. 3.035 2,872.137 ↑ 226,944.0 18,469 1

Result (cost=0.00..3,475,781.45 rows=4,191,428,533 width=64) (actual time=2,796.554..2,872.137 rows=18,469 loops=1)

3. 8.981 2,869.102 ↑ 226,944.0 18,469 1

Result (cost=0.00..3,475,781.45 rows=4,191,428,533 width=64) (actual time=2,796.551..2,869.102 rows=18,469 loops=1)

4. 14.892 2,860.121 ↑ 226,944.0 18,469 1

Hash Left Join (cost=0.00..3,207,530.02 rows=4,191,428,533 width=218) (actual time=2,796.541..2,860.121 rows=18,469 loops=1)

  • Hash Cond: ((reference4_currency._code)::integer = exchange_rate_cbr.currency_code)
  • Extra Text: (seg5) Hash chain length 1.0 avg, 1 max, using 12 of 65536 buckets.Hash chain length 1.0 avg, 2 max, using 394 of 16384 buckets.Hash chain length 1.3 avg, 31 max, using 12113 of 32768 buckets.Hash chain length 1.4 avg, 6 max, using 7992 of 16384 buckets.Hash chain length 1.0 avg, 1 max, using 12 of 32768 buckets.Hash chain length 2.0 avg, 106 max, using 210 of 16384 buckets.Hash chain length 3.0 avg, 9 max, using 121 of 128 buckets; total 2 expansions.
5. 6.241 2,521.294 ↑ 75.3 18,469 1

Hash Left Join (cost=0.00..7,310.99 rows=1,390,854 width=210) (actual time=2,468.979..2,521.294 rows=18,469 loops=1)

  • Hash Cond: (document10555_write_off_os._fld10915rref = reference9449_cost_state_1_2._idrref)
  • Extra Text: (seg5) Hash chain length 1.0 avg, 2 max, using 394 of 16384 buckets.Hash chain length 1.3 avg, 31 max, using 12113 of 32768 buckets.Hash chain length 1.4 avg, 6 max, using 7992 of 16384 buckets.Hash chain length 1.0 avg, 1 max, using 12 of 32768 buckets.Hash chain length 2.0 avg, 106 max, using 210 of 16384 buckets.Hash chain length 3.0 avg, 9 max, using 121 of 128 buckets; total 2 expansions.
6. 6.236 2,514.669 ↑ 37.7 18,469 1

Hash Left Join (cost=0.00..5,656.65 rows=695,427 width=188) (actual time=2,468.473..2,514.669 rows=18,469 loops=1)

  • Hash Cond: (document10555_write_off_os._idrref = document10555_vt11997_write_off_os._document10555_idrref)
  • Extra Text: (seg5) Hash chain length 1.3 avg, 31 max, using 12113 of 32768 buckets.Hash chain length 1.4 avg, 6 max, using 7992 of 16384 buckets.Hash chain length 1.0 avg, 1 max, using 12 of 32768 buckets.Hash chain length 2.0 avg, 106 max, using 210 of 16384 buckets.Hash chain length 3.0 avg, 9 max, using 121 of 128 buckets; total 2 expansions.
7. 12.422 50.907 ↑ 5.9 15,430 1

Hash Left Join (cost=0.00..3,610.52 rows=90,735 width=158) (actual time=15.529..50.907 rows=15,430 loops=1)

  • Hash Cond: (document10555_write_off_os._fld10916rref = reference9448_cfo._idrref)
  • Extra Text: (seg10) Hash chain length 1.4 avg, 6 max, using 7992 of 16384 buckets.Hash chain length 1.0 avg, 1 max, using 12 of 32768 buckets.Hash chain length 2.0 avg, 106 max, using 210 of 16384 buckets.Hash chain length 3.0 avg, 9 max, using 121 of 128 buckets; total 2 expansions.
8. 5.406 29.938 ↑ 2.9 15,430 1

Hash Left Join (cost=0.00..3,099.02 rows=45,368 width=124) (actual time=0.792..29.938 rows=15,430 loops=1)

  • Hash Cond: (document10555_write_off_os._fld13159rref = reference4_currency._idrref)
  • Extra Text: (seg10) Hash chain length 1.0 avg, 1 max, using 12 of 32768 buckets.Hash chain length 2.0 avg, 106 max, using 210 of 16384 buckets.Hash chain length 3.0 avg, 9 max, using 121 of 128 buckets; total 2 expansions.
9. 4.986 24.484 ↑ 1.5 15,430 1

Hash Left Join (cost=0.00..2,642.50 rows=22,684 width=136) (actual time=0.493..24.484 rows=15,430 loops=1)

  • Hash Cond: (document10555_write_off_os._idrref = document10555_vt10606_write_off_os._document10555_idrref)
  • Extra Text: (seg5) Hash chain length 2.0 avg, 106 max, using 210 of 16384 buckets.Hash chain length 3.0 avg, 9 max, using 121 of 128 buckets; total 2 expansions.
10. 19.226 19.226 ↓ 1.0 15,268 1

Seq Scan on document10555_write_off_os (cost=0.00..436.36 rows=14,962 width=80) (actual time=0.064..19.226 rows=15,268 loops=1)

  • Filter: (NOT _marked)
11. 0.112 0.272 ↑ 18.6 415 1

Hash (cost=2,178.63..2,178.63 rows=7,722 width=72) (actual time=0.272..0.272 rows=415 loops=1)

12. 0.000 0.160 ↑ 18.6 415 1

Redistribute Motion 60:60 (slice6; segments: 60) (cost=0.00..2,178.63 rows=7,722 width=72) (actual time=0.007..0.160 rows=415 loops=1)

  • Hash Key: document10555_vt10606_write_off_os._document10555_idrref
13. 0.085 2,037.223 ↑ 21.2 364 1

Result (cost=0.00..2,176.88 rows=7,722 width=72) (actual time=2,037.027..2,037.223 rows=364 loops=1)

14. 0.000 2,037.138 ↑ 21.2 364 1

HashAggregate (cost=0.00..2,176.88 rows=7,722 width=72) (actual time=2,037.026..2,037.138 rows=364 loops=1)

  • Group Key: reference9794_supplier_contract._code, document10555_vt10606_write_off_os._document10555_idrref, reference9449_cost_state_1._description
  • Extra Text: (seg44) Hash chain length 3.0 avg, 9 max, using 121 of 128 buckets; total 2 expansions.
15. 1,143.207 2,040.469 ↑ 3.1 2,519 1

Redistribute Motion 60:60 (slice5; segments: 60) (cost=0.00..2,173.61 rows=7,722 width=72) (actual time=889.060..2,040.469 rows=2,519 loops=1)

  • Hash Key: reference9794_supplier_contract._code, document10555_vt10606_write_off_os._document10555_idrref, reference9449_cost_state_1._description
16. 14.300 897.262 ↓ 1.6 12,378 1

Hash Left Join (cost=0.00..2,171.87 rows=7,722 width=72) (actual time=886.770..897.262 rows=12,378 loops=1)

  • Hash Cond: (document10552_income_os._fld10561_rrref = reference9794_supplier_contract._idrref)
  • Extra Text: (seg30) Hash chain length 1.1 avg, 3 max, using 3588 of 32768 buckets.Hash chain length 1.1 avg, 3 max, using 3499 of 32768 buckets.Hash chain length 1.0 avg, 2 max, using 394 of 16384 buckets.Hash chain length 1.0 avg, 2 max, using 394 of 16384 buckets.Hash chain length 1.0 avg, 2 max, using 1382 of 32768 buckets.Hash chain length 1.0 avg, 2 max, using 1334 of 32768 buckets.Hash chain length 4.0 avg, 12 max, using 4026 of 4096 buckets; total 7 expansions.
17. 0.000 873.131 ↓ 3.2 12,378 1

Redistribute Motion 60:60 (slice4; segments: 60) (cost=0.00..1,734.09 rows=3,861 width=78) (actual time=869.790..873.131 rows=12,378 loops=1)

  • Hash Key: document10552_income_os._fld10561_rrref
18. 11.681 891.842 ↑ 2.8 1,358 1

Hash Left Join (cost=0.00..1,733.15 rows=3,861 width=78) (actual time=887.749..891.842 rows=1,358 loops=1)

  • Hash Cond: ((document10555_vt10606_write_off_os._fld10608)::text = (document10552_vt10565_income_os._fld10568)::text)
  • Extra Text: (seg26) Hash chain length 1.1 avg, 3 max, using 3499 of 32768 buckets.Hash chain length 1.0 avg, 2 max, using 394 of 16384 buckets.Hash chain length 1.0 avg, 2 max, using 394 of 16384 buckets.Hash chain length 1.0 avg, 2 max, using 1382 of 32768 buckets.Hash chain length 1.0 avg, 2 max, using 1334 of 32768 buckets.Hash chain length 4.0 avg, 12 max, using 4026 of 4096 buckets; total 7 expansions.
19. 0.000 1.215 ↑ 1.4 1,356 1

Redistribute Motion 60:60 (slice2; segments: 60) (cost=0.00..863.81 rows=1,926 width=68) (actual time=0.029..1.215 rows=1,356 loops=1)

  • Hash Key: document10555_vt10606_write_off_os._fld10608
20. 5.911 51.043 ↓ 1.6 3,053 1

Hash Left Join (cost=0.00..863.40 rows=1,926 width=68) (actual time=49.018..51.043 rows=3,053 loops=1)

  • Hash Cond: (document10555_vt10606_write_off_os._fld14550rref = reference9449_cost_state_1._idrref)
  • Extra Text: (seg30) Hash chain length 1.0 avg, 2 max, using 394 of 16384 buckets.Hash chain length 1.0 avg, 2 max, using 1382 of 32768 buckets.Hash chain length 1.0 avg, 2 max, using 1334 of 32768 buckets.Hash chain length 4.0 avg, 12 max, using 4026 of 4096 buckets; total 7 expansions.
  • Extra Text: (seg54) Hash chain length 1.0 avg, 2 max, using 394 of 16384 buckets.Hash chain length 1.0 avg, 2 max, using 394 of 16384 buckets.Hash chain length 1.0 avg, 2 max, using 1382 of 32768 buckets.Hash chain length 1.0 avg, 2 max, using 1334 of 32768 buckets.Hash chain length 4.0 avg, 12 max, using 4026 of 4096 buckets; total 7 expansions.
21. 1.318 1.318 ↓ 3.2 3,053 1

Seq Scan on document10555_vt10606_write_off_os (cost=0.00..431.09 rows=963 width=46) (actual time=0.041..1.318 rows=3,053 loops=1)

22. 0.199 43.814 ↓ 1.0 398 1

Hash (cost=431.05..431.05 rows=396 width=54) (actual time=43.814..43.814 rows=398 loops=1)

23. 43.596 43.615 ↓ 1.0 398 1

Broadcast Motion 60:60 (slice1; segments: 60) (cost=0.00..431.05 rows=396 width=54) (actual time=0.115..43.615 rows=398 loops=1)

24. 0.019 0.019 ↓ 1.9 13 1

Seq Scan on reference9449_cost_state_1 (cost=0.00..431.00 rows=7 width=54) (actual time=0.011..0.019 rows=13 loops=1)

  • Filter: (NOT _marked)
25. 1.756 878.946 ↑ 1.0 3,935 1

Hash (cost=865.40..865.40 rows=4,127 width=22) (actual time=878.946..878.946 rows=3,935 loops=1)

26. 774.087 877.190 ↑ 1.0 3,935 1

Redistribute Motion 60:60 (slice3; segments: 60) (cost=0.00..865.40 rows=4,127 width=22) (actual time=0.965..877.190 rows=3,935 loops=1)

  • Hash Key: document10552_vt10565_income_os._fld10568
27. 9.730 103.103 ↓ 3.6 14,824 1

Hash Join (cost=0.00..865.12 rows=4,127 width=22) (actual time=50.322..103.103 rows=14,824 loops=1)

  • Hash Cond: (document10552_vt10565_income_os._document10552_idrref = document10552_income_os._idrref)
  • Extra Text: (seg14) Hash chain length 1.0 avg, 2 max, using 1334 of 32768 buckets.Hash chain length 4.0 avg, 12 max, using 4026 of 4096 buckets; total 7 expansions.
  • Extra Text: (seg55) Hash chain length 1.0 avg, 2 max, using 1382 of 32768 buckets.Hash chain length 1.0 avg, 2 max, using 1334 of 32768 buckets.Hash chain length 4.0 avg, 12 max, using 4026 of 4096 buckets; total 7 expansions.
28. 91.280 91.280 ↓ 3.6 14,824 1

Seq Scan on document10552_vt10565_income_os (cost=0.00..431.58 rows=4,127 width=22) (actual time=43.882..91.280 rows=14,824 loops=1)

  • Filter: (NOT (_document10552_idrref IS NULL))
29. 0.500 2.093 ↓ 1.1 1,416 1

Hash (cost=431.26..431.26 rows=1,336 width=32) (actual time=2.093..2.093 rows=1,416 loops=1)

30. 1.593 1.593 ↓ 1.1 1,416 1

Seq Scan on document10552_income_os (cost=0.00..431.26 rows=1,336 width=32) (actual time=0.042..1.593 rows=1,416 loops=1)

31. 4.087 9.831 ↓ 1.0 3,984 1

Hash (cost=432.05..432.05 rows=3,957 width=26) (actual time=9.831..9.831 rows=3,984 loops=1)

32. 5.744 5.744 ↓ 1.0 3,984 1

Seq Scan on reference9794_supplier_contract (cost=0.00..432.05 rows=3,957 width=26) (actual time=0.174..5.744 rows=3,984 loops=1)

33. 0.002 0.048 ↑ 1.1 12 1

Hash (cost=431.00..431.00 rows=13 width=20) (actual time=0.048..0.048 rows=12 loops=1)

34. 0.000 0.046 ↑ 1.1 12 1

Broadcast Motion 60:60 (slice7; segments: 60) (cost=0.00..431.00 rows=13 width=20) (actual time=0.009..0.046 rows=12 loops=1)

35. 0.051 0.051 ↑ 1.0 1 1

Seq Scan on reference4_currency (cost=0.00..431.00 rows=1 width=20) (actual time=0.049..0.051 rows=1 loops=1)

  • Filter: (NOT _marked)
36. 4.596 8.547 ↓ 1.0 10,952 1

Hash (cost=432.61..432.61 rows=10,884 width=66) (actual time=8.547..8.547 rows=10,952 loops=1)

37. 3.562 3.951 ↓ 1.0 10,952 1

Broadcast Motion 60:60 (slice8; segments: 60) (cost=0.00..432.61 rows=10,884 width=66) (actual time=0.036..3.951 rows=10,952 loops=1)

38. 0.389 0.389 ↓ 1.1 206 1

Seq Scan on reference9448_cfo (cost=0.00..431.05 rows=182 width=66) (actual time=0.143..0.389 rows=206 loops=1)

  • Filter: (NOT _marked)
39. 8.651 2,457.526 ↑ 6.2 15,964 1

Hash (cost=1,413.74..1,413.74 rows=99,711 width=62) (actual time=2,457.526..2,457.526 rows=15,964 loops=1)

40. 0.000 2,448.875 ↑ 6.2 15,964 1

Redistribute Motion 60:60 (slice12; segments: 60) (cost=0.00..1,413.74 rows=99,711 width=62) (actual time=2,384.178..2,448.875 rows=15,964 loops=1)

  • Hash Key: document10555_vt11997_write_off_os._document10555_idrref
41. 2.869 2,705.803 ↑ 6.2 15,963 1

Result (cost=0.00..1,394.39 rows=99,711 width=62) (actual time=2,698.663..2,705.803 rows=15,963 loops=1)

42. 37.569 2,702.934 ↑ 6.2 15,963 1

HashAggregate (cost=0.00..1,394.39 rows=99,711 width=62) (actual time=2,698.661..2,702.934 rows=15,963 loops=1)

  • Group Key: document10555_vt11997_write_off_os._document10555_idrref, reference9449_cost_state_1_1._description
  • Extra Text: (seg58) Hash chain length 4.0 avg, 12 max, using 4026 of 4096 buckets; total 7 expansions.
43. 212.362 2,665.365 ↑ 3.3 30,338 1

Redistribute Motion 60:60 (slice11; segments: 60) (cost=0.00..1,365.60 rows=99,711 width=62) (actual time=38.850..2,665.365 rows=30,338 loops=1)

  • Hash Key: document10555_vt11997_write_off_os._document10555_idrref, reference9449_cost_state_1_1._description
44. 186.410 2,453.003 ↓ 7.3 732,780 1

Hash Left Join (cost=0.00..1,346.26 rows=99,711 width=62) (actual time=50.639..2,453.003 rows=732,780 loops=1)

  • Hash Cond: (reference11887_material._fld11890rref = reference9449_cost_state_1_1._idrref)
  • Extra Text: (seg15) Hash chain length 1.0 avg, 2 max, using 394 of 16384 buckets.Hash chain length 1.0 avg, 2 max, using 940 of 32768 buckets.Hash chain length 1.0 avg, 2 max, using 844 of 32768 buckets.Hash chain length 1.0 avg, 1 max, using 11 of 65536 buckets.Hash chain length 3.1 avg, 9 max, using 238 of 256 buckets; total 3 expansions.
45. 191.395 2,226.347 ↓ 14.7 732,780 1

Hash Left Join (cost=0.00..883.17 rows=49,856 width=40) (actual time=1.043..2,226.347 rows=732,780 loops=1)

  • Hash Cond: (document10555_vt11997_write_off_os._fld11999_rrref = reference11887_material._idrref)
  • Extra Text: (seg15) Hash chain length 1.0 avg, 2 max, using 844 of 32768 buckets.Hash chain length 1.0 avg, 1 max, using 11 of 65536 buckets.Hash chain length 3.1 avg, 9 max, using 238 of 256 buckets; total 3 expansions.
  • Extra Text: (seg26) Hash chain length 1.0 avg, 2 max, using 940 of 32768 buckets.Hash chain length 1.0 avg, 2 max, using 844 of 32768 buckets.Hash chain length 1.0 avg, 1 max, using 11 of 65536 buckets.Hash chain length 3.1 avg, 9 max, using 238 of 256 buckets; total 3 expansions.
46. 2,005.776 2,034.446 ↓ 29.4 732,780 1

Redistribute Motion 60:60 (slice9; segments: 60) (cost=0.00..439.35 rows=24,928 width=40) (actual time=0.047..2,034.446 rows=732,780 loops=1)

  • Hash Key: document10555_vt11997_write_off_os._fld11999_rrref
47. 28.670 28.670 ↓ 1.1 28,307 1

Seq Scan on document10555_vt11997_write_off_os (cost=0.00..434.37 rows=24,928 width=40) (actual time=0.170..28.670 rows=28,307 loops=1)

48. 0.175 0.506 ↓ 1.1 952 1

Hash (cost=431.10..431.10 rows=898 width=32) (actual time=0.506..0.506 rows=952 loops=1)

49. 0.331 0.331 ↓ 1.1 952 1

Seq Scan on reference11887_material (cost=0.00..431.10 rows=898 width=32) (actual time=0.038..0.331 rows=952 loops=1)

50. 0.165 40.246 ↓ 1.0 398 1

Hash (cost=431.05..431.05 rows=396 width=54) (actual time=40.246..40.246 rows=398 loops=1)

51. 40.049 40.081 ↓ 1.0 398 1

Broadcast Motion 60:60 (slice10; segments: 60) (cost=0.00..431.05 rows=396 width=54) (actual time=0.012..40.081 rows=398 loops=1)

52. 0.032 0.032 ↓ 1.9 13 1

Seq Scan on reference9449_cost_state_1 reference9449_cost_state_1_1 (cost=0.00..431.00 rows=7 width=54) (actual time=0.021..0.032 rows=13 loops=1)

  • Filter: (NOT _marked)
53. 0.133 0.384 ↓ 1.0 398 1

Hash (cost=431.05..431.05 rows=396 width=54) (actual time=0.384..0.384 rows=398 loops=1)

54. 0.190 0.251 ↓ 1.0 398 1

Broadcast Motion 60:60 (slice13; segments: 60) (cost=0.00..431.05 rows=396 width=54) (actual time=0.008..0.251 rows=398 loops=1)

55. 0.061 0.061 ↓ 1.9 13 1

Seq Scan on reference9449_cost_state_1 reference9449_cost_state_1_2 (cost=0.00..431.00 rows=7 width=54) (actual time=0.057..0.061 rows=13 loops=1)

  • Filter: (NOT _marked)
56. 0.019 323.935 ↑ 3,013.2 12 1

Hash (cost=1,726.00..1,726.00 rows=36,158 width=12) (actual time=323.935..323.935 rows=12 loops=1)

57. 6.295 323.916 ↑ 3,013.2 12 1

Broadcast Motion 60:60 (slice16; segments: 60) (cost=0.00..1,726.00 rows=36,158 width=12) (actual time=322.684..323.916 rows=12 loops=1)

58. 0.004 317.621 ↑ 54.8 11 1

Result (cost=0.00..1,725.05 rows=603 width=12) (actual time=316.954..317.621 rows=11 loops=1)

59. 0.054 317.617 ↑ 54.8 11 1

Result (cost=0.00..1,725.05 rows=603 width=12) (actual time=316.953..317.617 rows=11 loops=1)

60. 1.007 317.563 ↑ 54.8 11 1

Hash Join (cost=0.00..1,725.04 rows=603 width=16) (actual time=316.902..317.563 rows=11 loops=1)

  • Hash Cond: ((exchange_rate_cbr.currency_code = exchange_rate_cbr_1.currency_code) AND (exchange_rate_cbr.dt = (max((max(exchange_rate_cbr_1.dt))))))
  • Extra Text: (seg45) Hash chain length 1.0 avg, 1 max, using 11 of 65536 buckets.Hash chain length 3.1 avg, 9 max, using 238 of 256 buckets; total 3 expansions.
61. 0.675 1.569 ↓ 1.2 726 1

HashAggregate (cost=0.00..862.36 rows=603 width=20) (actual time=1.389..1.569 rows=726 loops=1)

  • Group Key: exchange_rate_cbr.dt, exchange_rate_cbr.currency_code, exchange_rate_cbr.rate, exchange_rate_cbr.nominal
  • Extra Text: (seg45) Hash chain length 3.1 avg, 9 max, using 238 of 256 buckets; total 3 expansions.
62. 0.084 0.894 ↓ 1.2 726 1

Append (cost=0.00..862.06 rows=603 width=20) (actual time=0.050..0.894 rows=726 loops=1)

63. 0.046 0.046 ↓ 66.0 66 1

Seq Scan on exchange_rate_cbr (cost=0.00..431.00 rows=1 width=20) (actual time=0.041..0.046 rows=66 loops=1)

64. 0.563 0.764 ↓ 1.1 671 1

Result (cost=0.00..431.05 rows=603 width=20) (actual time=0.114..0.764 rows=671 loops=1)

65. 0.201 0.201 ↓ 1.1 671 1

Seq Scan on hist_exchange_rate_cbr (cost=0.00..431.02 rows=603 width=18) (actual time=0.018..0.201 rows=671 loops=1)

66. 0.020 314.987 ↓ 11.0 11 1

Hash (cost=862.43..862.43 rows=1 width=8) (actual time=314.987..314.987 rows=11 loops=1)

67. 0.000 314.967 ↓ 11.0 11 1

Redistribute Motion 60:60 (slice15; segments: 60) (cost=0.00..862.43 rows=1 width=8) (actual time=313.054..314.967 rows=11 loops=1)

  • Hash Key: (max((max(exchange_rate_cbr_1.dt))))
68. 0.002 319.257 ↓ 2.0 2 1

Result (cost=0.00..862.43 rows=1 width=8) (actual time=319.228..319.257 rows=2 loops=1)

69. 0.065 319.255 ↓ 2.0 2 1

GroupAggregate (cost=0.00..862.43 rows=1 width=8) (actual time=319.227..319.255 rows=2 loops=1)

  • Group Key: exchange_rate_cbr_1.currency_code
70. 0.513 319.190 ↓ 120.0 120 1

Sort (cost=0.00..862.43 rows=1 width=8) (actual time=319.176..319.190 rows=120 loops=1)

  • Sort Key: exchange_rate_cbr_1.currency_code
  • Sort Method: quicksort Memory: 1,980kB
71. 313.985 318.677 ↓ 120.0 120 1

Redistribute Motion 60:60 (slice14; segments: 60) (cost=0.00..862.43 rows=1 width=8) (actual time=3.464..318.677 rows=120 loops=1)

  • Hash Key: exchange_rate_cbr_1.currency_code
72. 0.006 4.692 ↓ 12.0 12 1

Result (cost=0.00..862.43 rows=1 width=8) (actual time=4.630..4.692 rows=12 loops=1)

73. 2.397 4.686 ↓ 12.0 12 1

HashAggregate (cost=0.00..862.43 rows=1 width=8) (actual time=4.628..4.686 rows=12 loops=1)

  • Group Key: exchange_rate_cbr_1.currency_code
  • Extra Text: (seg0) Hash chain length 1.1 avg, 2 max, using 11 of 32 buckets; total 0 expansions.
74. 0.994 2.289 ↓ 1.5 902 1

HashAggregate (cost=0.00..862.36 rows=603 width=8) (actual time=1.789..2.289 rows=902 loops=1)

  • Group Key: exchange_rate_cbr_1.dt, exchange_rate_cbr_1.currency_code, exchange_rate_cbr_1.rate, exchange_rate_cbr_1.nominal
  • Extra Text: (seg2) Hash chain length 3.2 avg, 9 max, using 242 of 256 buckets; total 3 expansions.
  • Extra Text: (seg44) Hash chain length 3.6 avg, 9 max, using 251 of 256 buckets; total 3 expansions.
75. 0.076 1.295 ↓ 1.5 902 1

Append (cost=0.00..862.06 rows=603 width=20) (actual time=0.062..1.295 rows=902 loops=1)

76. 0.068 0.068 ↓ 99.0 99 1

Seq Scan on exchange_rate_cbr exchange_rate_cbr_1 (cost=0.00..431.00 rows=1 width=20) (actual time=0.064..0.068 rows=99 loops=1)

77. 0.855 1.151 ↓ 1.4 869 1

Result (cost=0.00..431.05 rows=603 width=20) (actual time=0.137..1.151 rows=869 loops=1)

78. 0.296 0.296 ↓ 1.4 869 1

Seq Scan on hist_exchange_rate_cbr hist_exchange_rate_cbr_1 (cost=0.00..431.02 rows=603 width=18) (actual time=0.051..0.296 rows=869 loops=1)

Planning time : 207.682 ms
Execution time : 3,853.753 ms