explain.depesz.com

PostgreSQL's explain analyze made readable

Result: KRPM

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Hash Full Join (cost=6,261,094.22..31,852,113.80 rows=21,765,594 width=1,491) (actual rows= loops=)

  • Hash Cond: (contr.subcontractorssum = sub_sum.id)
2. 0.000 0.000 ↓ 0.0

Hash Full Join (cost=6,212,115.48..24,173,364.34 rows=21,765,594 width=1,400) (actual rows= loops=)

  • Hash Cond: (contr.advancepaymentsum = adv_sum.id)
3. 0.000 0.000 ↓ 0.0

Hash Full Join (cost=6,198,679.45..16,491,842.57 rows=21,765,594 width=1,403) (actual rows= loops=)

  • Hash Cond: (pric_inf.currencyrate = currencyrate.id)
4. 0.000 0.000 ↓ 0.0

Hash Full Join (cost=6,198,677.07..16,430,735.97 rows=21,765,594 width=1,405) (actual rows= loops=)

  • Hash Cond: (pric_inf.currency = currency.id)
5. 0.000 0.000 ↓ 0.0

Hash Full Join (cost=6,198,656.05..16,373,086.09 rows=21,765,594 width=1,393) (actual rows= loops=)

  • Hash Cond: (contr.priceinfo = pric_inf.id)
6. 0.000 0.000 ↓ 0.0

Hash Full Join (cost=5,988,233.90..8,554,713.21 rows=21,765,594 width=1,385) (actual rows= loops=)

  • Hash Cond: (prod.okei = okei.id)
7. 0.000 0.000 ↓ 0.0

Hash Full Join (cost=5,988,214.31..8,496,925.05 rows=21,765,594 width=1,377) (actual rows= loops=)

  • Hash Cond: (prod.okpd = okpd.id)
8. 0.000 0.000 ↓ 0.0

Hash Full Join (cost=5,988,106.71..8,439,682.76 rows=21,765,594 width=1,243) (actual rows= loops=)

  • Hash Cond: (prod.ktru = ktru.id)
9. 0.000 0.000 ↓ 0.0

Hash Full Join (cost=5,986,441.67..8,380,881.95 rows=21,765,594 width=1,126) (actual rows= loops=)

  • Hash Cond: (prod.okpd2 = okpd2.id)
10. 0.000 0.000 ↓ 0.0

Hash Full Join (cost=5,985,382.77..8,322,666.19 rows=21,765,594 width=1,011) (actual rows= loops=)

  • Hash Cond: (prod.id_products = prod_s.id)
11. 0.000 0.000 ↓ 0.0

Seq Scan on product prod (cost=0.00..848,350.74 rows=21,387,974 width=44) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

Hash (cost=5,234,722.68..5,234,722.68 rows=5,538,007 width=979) (actual rows= loops=)

13. 0.000 0.000 ↓ 0.0

Hash Full Join (cost=1,966,186.45..5,234,722.68 rows=5,538,007 width=979) (actual rows= loops=)

  • Hash Cond: (contr.products = prod_s.id)
14. 0.000 0.000 ↓ 0.0

Hash Full Join (cost=1,796,476.12..3,666,347.06 rows=5,538,007 width=983) (actual rows= loops=)

  • Hash Cond: (lg_ent_rf.oktmo = oktmo.id)
15. 0.000 0.000 ↓ 0.0

Hash Join (cost=1,792,835.27..3,648,167.63 rows=5,538,007 width=977) (actual rows= loops=)

  • Hash Cond: (supl.legalentityrfs = lg_ent_rf.id)
16. 0.000 0.000 ↓ 0.0

Gather (cost=1,763,477.27..2,621,997.11 rows=5,538,007 width=690) (actual rows= loops=)

  • Workers Planned: 2
17. 0.000 0.000 ↓ 0.0

Parallel Hash Left Join (cost=1,762,477.27..2,067,196.41 rows=2,307,503 width=690) (actual rows= loops=)

  • Hash Cond: (supl.id_contract = contr.id)
18. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on suppliers supl (cost=0.00..65,371.03 rows=2,307,503 width=16) (actual rows= loops=)

19. 0.000 0.000 ↓ 0.0

Parallel Hash (cost=1,538,677.42..1,538,677.42 rows=2,251,188 width=686) (actual rows= loops=)

20. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=507,412.74..1,538,677.42 rows=2,251,188 width=686) (actual rows= loops=)

  • Hash Cond: (custom.legalform = lg_custom.id)
21. 0.000 0.000 ↓ 0.0

Parallel Hash Left Join (cost=507,405.30..1,532,596.92 rows=2,251,188 width=589) (actual rows= loops=)

  • Hash Cond: (contr.customer = custom.id)
22. 0.000 0.000 ↓ 0.0

Parallel Hash Left Join (cost=93,231.57..848,700.82 rows=2,251,188 width=280) (actual rows= loops=)

  • Hash Cond: (contr.executionperiod = ex_per.id)
23. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on contract contr (cost=0.00..571,471.88 rows=2,251,188 width=280) (actual rows= loops=)

24. 0.000 0.000 ↓ 0.0

Parallel Hash (cost=54,051.92..54,051.92 rows=2,253,892 width=12) (actual rows= loops=)

25. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on executionperiod ex_per (cost=0.00..54,051.92 rows=2,253,892 width=12) (actual rows= loops=)

26. 0.000 0.000 ↓ 0.0

Parallel Hash (cost=289,302.88..289,302.88 rows=2,251,188 width=321) (actual rows= loops=)

27. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on customer custom (cost=0.00..289,302.88 rows=2,251,188 width=321) (actual rows= loops=)

28. 0.000 0.000 ↓ 0.0

Hash (cost=5.53..5.53 rows=153 width=105) (actual rows= loops=)

29. 0.000 0.000 ↓ 0.0

Seq Scan on legalform lg_custom (cost=0.00..5.53 rows=153 width=105) (actual rows= loops=)

30. 0.000 0.000 ↓ 0.0

Hash (cost=17,814.89..17,814.89 rows=219,689 width=299) (actual rows= loops=)

31. 0.000 0.000 ↓ 0.0

Seq Scan on legalentityrfs lg_ent_rf (cost=0.00..17,814.89 rows=219,689 width=299) (actual rows= loops=)

32. 0.000 0.000 ↓ 0.0

Hash (cost=3,060.93..3,060.93 rows=46,393 width=14) (actual rows= loops=)

33. 0.000 0.000 ↓ 0.0

Seq Scan on oktmo (cost=0.00..3,060.93 rows=46,393 width=14) (actual rows= loops=)

34. 0.000 0.000 ↓ 0.0

Hash (cost=80,428.26..80,428.26 rows=5,441,926 width=4) (actual rows= loops=)

35. 0.000 0.000 ↓ 0.0

Seq Scan on products prod_s (cost=0.00..80,428.26 rows=5,441,926 width=4) (actual rows= loops=)

36. 0.000 0.000 ↓ 0.0

Hash (cost=942.29..942.29 rows=9,329 width=123) (actual rows= loops=)

37. 0.000 0.000 ↓ 0.0

Seq Scan on okpd2 (cost=0.00..942.29 rows=9,329 width=123) (actual rows= loops=)

38. 0.000 0.000 ↓ 0.0

Hash (cost=1,451.13..1,451.13 rows=17,113 width=125) (actual rows= loops=)

39. 0.000 0.000 ↓ 0.0

Seq Scan on ktru (cost=0.00..1,451.13 rows=17,113 width=125) (actual rows= loops=)

40. 0.000 0.000 ↓ 0.0

Hash (cost=92.82..92.82 rows=1,182 width=142) (actual rows= loops=)

41. 0.000 0.000 ↓ 0.0

Seq Scan on okpd (cost=0.00..92.82 rows=1,182 width=142) (actual rows= loops=)

42. 0.000 0.000 ↓ 0.0

Hash (cost=14.82..14.82 rows=382 width=16) (actual rows= loops=)

43. 0.000 0.000 ↓ 0.0

Seq Scan on okei (cost=0.00..14.82 rows=382 width=16) (actual rows= loops=)

44. 0.000 0.000 ↓ 0.0

Hash (cost=116,504.51..116,504.51 rows=5,402,851 width=16) (actual rows= loops=)

45. 0.000 0.000 ↓ 0.0

Seq Scan on priceinfo pric_inf (cost=0.00..116,504.51 rows=5,402,851 width=16) (actual rows= loops=)

46. 0.000 0.000 ↓ 0.0

Hash (cost=14.90..14.90 rows=490 width=20) (actual rows= loops=)

47. 0.000 0.000 ↓ 0.0

Seq Scan on currency (cost=0.00..14.90 rows=490 width=20) (actual rows= loops=)

48. 0.000 0.000 ↓ 0.0

Hash (cost=1.61..1.61 rows=61 width=10) (actual rows= loops=)

49. 0.000 0.000 ↓ 0.0

Seq Scan on currencyrate (cost=0.00..1.61 rows=61 width=10) (actual rows= loops=)

50. 0.000 0.000 ↓ 0.0

Hash (cost=8,114.35..8,114.35 rows=306,135 width=9) (actual rows= loops=)

51. 0.000 0.000 ↓ 0.0

Seq Scan on advancepaymentsum adv_sum (cost=0.00..8,114.35 rows=306,135 width=9) (actual rows= loops=)

52. 0.000 0.000 ↓ 0.0

Hash (cost=25,082.77..25,082.77 rows=1,456,477 width=7) (actual rows= loops=)

53. 0.000 0.000 ↓ 0.0

Seq Scan on subcontractorssum sub_sum (cost=0.00..25,082.77 rows=1,456,477 width=7) (actual rows= loops=)