explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ctvud

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

Update on f_campaign_transition_characteristics f (cost=42,820.93..856,822.72 rows=17 width=1,269) (actual rows= loops=)

  • Update on f_campaign_transition_characteristics_p201804 f_1
  • Update on f_campaign_transition_characteristics_p201805 f_2
  • Update on f_campaign_transition_characteristics_p201806 f_3
  • Update on f_campaign_transition_characteristics_p201807 f_4
  • Update on f_campaign_transition_characteristics_p201808 f_5
  • Update on f_campaign_transition_characteristics_p201809 f_6
  • Update on f_campaign_transition_characteristics_p201810 f_7
  • Update on f_campaign_transition_characteristics_p201811 f_8
  • Update on f_campaign_transition_characteristics_p201812 f_9
  • Update on f_campaign_transition_characteristics_p201901 f_10
  • Update on f_campaign_transition_characteristics_p201902 f_11
  • Update on f_campaign_transition_characteristics_p201903 f_12
  • Update on f_campaign_transition_characteristics_p201904 f_13
  • Update on f_campaign_transition_characteristics_p201905 f_14
  • Update on f_campaign_transition_characteristics_p201906 f_15
  • Update on f_campaign_transition_characteristics_p201907 f_16
  • Update on f_campaign_transition_characteristics_p201908 f_17
2. 0.000 0.000 ↓ 0.0

Hash Join (cost=42,820.93..46,959.93 rows=1 width=1,294) (actual rows= loops=)

  • Hash Cond: (((p.contract_id)::text = (f_1.contract_id)::text) AND ((p.customer_id)::text = (f_1.customer_id)::text) AND (p.campaign_key = f_1.campaign_key) AND (p.partition_field = f_1.partition_field))
3. 0.000 0.000 ↓ 0.0

Subquery Scan on p (cost=42,808.53..45,567.78 rows=91,975 width=784) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

HashAggregate (cost=42,808.53..44,648.03 rows=91,975 width=380) (actual rows= loops=)

  • Group Key: part_f_campaign_transition_detail.campaign_key, part_f_campaign_transition_detail.partition_field, part_f_campaign_transition_detail.customer_id, part_f_campaign_transition_detail.contract_id
5. 0.000 0.000 ↓ 0.0

Seq Scan on part_f_campaign_transition_detail (cost=0.00..11,221.85 rows=203,785 width=178) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Hash (cost=10.80..10.80 rows=80 width=890) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Seq Scan on f_campaign_transition_characteristics_p201804 f_1 (cost=0.00..10.80 rows=80 width=890) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Hash Join (cost=42,820.93..46,959.93 rows=1 width=1,294) (actual rows= loops=)

  • Hash Cond: (((p_1.contract_id)::text = (f_2.contract_id)::text) AND ((p_1.customer_id)::text = (f_2.customer_id)::text) AND (p_1.campaign_key = f_2.campaign_key) AND (p_1.partition_field = f_2.partition_field))
9. 0.000 0.000 ↓ 0.0

Subquery Scan on p_1 (cost=42,808.53..45,567.78 rows=91,975 width=784) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

HashAggregate (cost=42,808.53..44,648.03 rows=91,975 width=380) (actual rows= loops=)

  • Group Key: part_f_campaign_transition_detail_1.campaign_key, part_f_campaign_transition_detail_1.partition_field, part_f_campaign_transition_detail_1.customer_id, part_f_campaign_transition_detail_1.contract_id
11. 0.000 0.000 ↓ 0.0

Seq Scan on part_f_campaign_transition_detail part_f_campaign_transition_detail_1 (cost=0.00..11,221.85 rows=203,785 width=178) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

Hash (cost=10.80..10.80 rows=80 width=890) (actual rows= loops=)

13. 0.000 0.000 ↓ 0.0

Seq Scan on f_campaign_transition_characteristics_p201805 f_2 (cost=0.00..10.80 rows=80 width=890) (actual rows= loops=)

14. 0.000 0.000 ↓ 0.0

Hash Join (cost=42,820.93..46,959.93 rows=1 width=1,294) (actual rows= loops=)

  • Hash Cond: (((p_2.contract_id)::text = (f_3.contract_id)::text) AND ((p_2.customer_id)::text = (f_3.customer_id)::text) AND (p_2.campaign_key = f_3.campaign_key) AND (p_2.partition_field = f_3.partition_field))
15. 0.000 0.000 ↓ 0.0

Subquery Scan on p_2 (cost=42,808.53..45,567.78 rows=91,975 width=784) (actual rows= loops=)

16. 0.000 0.000 ↓ 0.0

HashAggregate (cost=42,808.53..44,648.03 rows=91,975 width=380) (actual rows= loops=)

  • Group Key: part_f_campaign_transition_detail_2.campaign_key, part_f_campaign_transition_detail_2.partition_field, part_f_campaign_transition_detail_2.customer_id, part_f_campaign_transition_detail_2.contract_id
17. 0.000 0.000 ↓ 0.0

Seq Scan on part_f_campaign_transition_detail part_f_campaign_transition_detail_2 (cost=0.00..11,221.85 rows=203,785 width=178) (actual rows= loops=)

18. 0.000 0.000 ↓ 0.0

Hash (cost=10.80..10.80 rows=80 width=890) (actual rows= loops=)

19. 0.000 0.000 ↓ 0.0

Seq Scan on f_campaign_transition_characteristics_p201806 f_3 (cost=0.00..10.80 rows=80 width=890) (actual rows= loops=)

20. 0.000 0.000 ↓ 0.0

Hash Join (cost=42,820.93..46,959.93 rows=1 width=1,294) (actual rows= loops=)

  • Hash Cond: (((p_3.contract_id)::text = (f_4.contract_id)::text) AND ((p_3.customer_id)::text = (f_4.customer_id)::text) AND (p_3.campaign_key = f_4.campaign_key) AND (p_3.partition_field = f_4.partition_field))
21. 0.000 0.000 ↓ 0.0

Subquery Scan on p_3 (cost=42,808.53..45,567.78 rows=91,975 width=784) (actual rows= loops=)

22. 0.000 0.000 ↓ 0.0

HashAggregate (cost=42,808.53..44,648.03 rows=91,975 width=380) (actual rows= loops=)

  • Group Key: part_f_campaign_transition_detail_3.campaign_key, part_f_campaign_transition_detail_3.partition_field, part_f_campaign_transition_detail_3.customer_id, part_f_campaign_transition_detail_3.contract_id
23. 0.000 0.000 ↓ 0.0

Seq Scan on part_f_campaign_transition_detail part_f_campaign_transition_detail_3 (cost=0.00..11,221.85 rows=203,785 width=178) (actual rows= loops=)

24. 0.000 0.000 ↓ 0.0

Hash (cost=10.80..10.80 rows=80 width=890) (actual rows= loops=)

25. 0.000 0.000 ↓ 0.0

Seq Scan on f_campaign_transition_characteristics_p201807 f_4 (cost=0.00..10.80 rows=80 width=890) (actual rows= loops=)

26. 0.000 0.000 ↓ 0.0

Hash Join (cost=42,820.93..46,959.93 rows=1 width=1,294) (actual rows= loops=)

  • Hash Cond: (((p_4.contract_id)::text = (f_5.contract_id)::text) AND ((p_4.customer_id)::text = (f_5.customer_id)::text) AND (p_4.campaign_key = f_5.campaign_key) AND (p_4.partition_field = f_5.partition_field))
27. 0.000 0.000 ↓ 0.0

Subquery Scan on p_4 (cost=42,808.53..45,567.78 rows=91,975 width=784) (actual rows= loops=)

28. 0.000 0.000 ↓ 0.0

HashAggregate (cost=42,808.53..44,648.03 rows=91,975 width=380) (actual rows= loops=)

  • Group Key: part_f_campaign_transition_detail_4.campaign_key, part_f_campaign_transition_detail_4.partition_field, part_f_campaign_transition_detail_4.customer_id, part_f_campaign_transition_detail_4.contract_id
29. 0.000 0.000 ↓ 0.0

Seq Scan on part_f_campaign_transition_detail part_f_campaign_transition_detail_4 (cost=0.00..11,221.85 rows=203,785 width=178) (actual rows= loops=)

30. 0.000 0.000 ↓ 0.0

Hash (cost=10.80..10.80 rows=80 width=890) (actual rows= loops=)

31. 0.000 0.000 ↓ 0.0

Seq Scan on f_campaign_transition_characteristics_p201808 f_5 (cost=0.00..10.80 rows=80 width=890) (actual rows= loops=)

32. 0.000 0.000 ↓ 0.0

Hash Join (cost=42,820.93..46,959.93 rows=1 width=1,294) (actual rows= loops=)

  • Hash Cond: (((p_5.contract_id)::text = (f_6.contract_id)::text) AND ((p_5.customer_id)::text = (f_6.customer_id)::text) AND (p_5.campaign_key = f_6.campaign_key) AND (p_5.partition_field = f_6.partition_field))
33. 0.000 0.000 ↓ 0.0

Subquery Scan on p_5 (cost=42,808.53..45,567.78 rows=91,975 width=784) (actual rows= loops=)

34. 0.000 0.000 ↓ 0.0

HashAggregate (cost=42,808.53..44,648.03 rows=91,975 width=380) (actual rows= loops=)

  • Group Key: part_f_campaign_transition_detail_5.campaign_key, part_f_campaign_transition_detail_5.partition_field, part_f_campaign_transition_detail_5.customer_id, part_f_campaign_transition_detail_5.contract_id
35. 0.000 0.000 ↓ 0.0

Seq Scan on part_f_campaign_transition_detail part_f_campaign_transition_detail_5 (cost=0.00..11,221.85 rows=203,785 width=178) (actual rows= loops=)

36. 0.000 0.000 ↓ 0.0

Hash (cost=10.80..10.80 rows=80 width=890) (actual rows= loops=)

37. 0.000 0.000 ↓ 0.0

Seq Scan on f_campaign_transition_characteristics_p201809 f_6 (cost=0.00..10.80 rows=80 width=890) (actual rows= loops=)

38. 0.000 0.000 ↓ 0.0

Hash Join (cost=42,820.93..46,959.93 rows=1 width=1,294) (actual rows= loops=)

  • Hash Cond: (((p_6.contract_id)::text = (f_7.contract_id)::text) AND ((p_6.customer_id)::text = (f_7.customer_id)::text) AND (p_6.campaign_key = f_7.campaign_key) AND (p_6.partition_field = f_7.partition_field))
39. 0.000 0.000 ↓ 0.0

Subquery Scan on p_6 (cost=42,808.53..45,567.78 rows=91,975 width=784) (actual rows= loops=)

40. 0.000 0.000 ↓ 0.0

HashAggregate (cost=42,808.53..44,648.03 rows=91,975 width=380) (actual rows= loops=)

  • Group Key: part_f_campaign_transition_detail_6.campaign_key, part_f_campaign_transition_detail_6.partition_field, part_f_campaign_transition_detail_6.customer_id, part_f_campaign_transition_detail_6.contract_id
41. 0.000 0.000 ↓ 0.0

Seq Scan on part_f_campaign_transition_detail part_f_campaign_transition_detail_6 (cost=0.00..11,221.85 rows=203,785 width=178) (actual rows= loops=)

42. 0.000 0.000 ↓ 0.0

Hash (cost=10.80..10.80 rows=80 width=890) (actual rows= loops=)

43. 0.000 0.000 ↓ 0.0

Seq Scan on f_campaign_transition_characteristics_p201810 f_7 (cost=0.00..10.80 rows=80 width=890) (actual rows= loops=)

44. 0.000 0.000 ↓ 0.0

Hash Join (cost=42,820.93..46,959.93 rows=1 width=1,294) (actual rows= loops=)

  • Hash Cond: (((p_7.contract_id)::text = (f_8.contract_id)::text) AND ((p_7.customer_id)::text = (f_8.customer_id)::text) AND (p_7.campaign_key = f_8.campaign_key) AND (p_7.partition_field = f_8.partition_field))
45. 0.000 0.000 ↓ 0.0

Subquery Scan on p_7 (cost=42,808.53..45,567.78 rows=91,975 width=784) (actual rows= loops=)

46. 0.000 0.000 ↓ 0.0

HashAggregate (cost=42,808.53..44,648.03 rows=91,975 width=380) (actual rows= loops=)

  • Group Key: part_f_campaign_transition_detail_7.campaign_key, part_f_campaign_transition_detail_7.partition_field, part_f_campaign_transition_detail_7.customer_id, part_f_campaign_transition_detail_7.contract_id
47. 0.000 0.000 ↓ 0.0

Seq Scan on part_f_campaign_transition_detail part_f_campaign_transition_detail_7 (cost=0.00..11,221.85 rows=203,785 width=178) (actual rows= loops=)

48. 0.000 0.000 ↓ 0.0

Hash (cost=10.80..10.80 rows=80 width=890) (actual rows= loops=)

49. 0.000 0.000 ↓ 0.0

Seq Scan on f_campaign_transition_characteristics_p201811 f_8 (cost=0.00..10.80 rows=80 width=890) (actual rows= loops=)

50. 0.000 0.000 ↓ 0.0

Hash Join (cost=42,820.93..46,959.93 rows=1 width=1,294) (actual rows= loops=)

  • Hash Cond: (((p_8.contract_id)::text = (f_9.contract_id)::text) AND ((p_8.customer_id)::text = (f_9.customer_id)::text) AND (p_8.campaign_key = f_9.campaign_key) AND (p_8.partition_field = f_9.partition_field))
51. 0.000 0.000 ↓ 0.0

Subquery Scan on p_8 (cost=42,808.53..45,567.78 rows=91,975 width=784) (actual rows= loops=)

52. 0.000 0.000 ↓ 0.0

HashAggregate (cost=42,808.53..44,648.03 rows=91,975 width=380) (actual rows= loops=)

  • Group Key: part_f_campaign_transition_detail_8.campaign_key, part_f_campaign_transition_detail_8.partition_field, part_f_campaign_transition_detail_8.customer_id, part_f_campaign_transition_detail_8.contract_id
53. 0.000 0.000 ↓ 0.0

Seq Scan on part_f_campaign_transition_detail part_f_campaign_transition_detail_8 (cost=0.00..11,221.85 rows=203,785 width=178) (actual rows= loops=)

54. 0.000 0.000 ↓ 0.0

Hash (cost=10.80..10.80 rows=80 width=890) (actual rows= loops=)

55. 0.000 0.000 ↓ 0.0

Seq Scan on f_campaign_transition_characteristics_p201812 f_9 (cost=0.00..10.80 rows=80 width=890) (actual rows= loops=)

56. 0.000 0.000 ↓ 0.0

Hash Join (cost=42,820.93..46,959.93 rows=1 width=1,294) (actual rows= loops=)

  • Hash Cond: (((p_9.contract_id)::text = (f_10.contract_id)::text) AND ((p_9.customer_id)::text = (f_10.customer_id)::text) AND (p_9.campaign_key = f_10.campaign_key) AND (p_9.partition_field = f_10.partition_field))
57. 0.000 0.000 ↓ 0.0

Subquery Scan on p_9 (cost=42,808.53..45,567.78 rows=91,975 width=784) (actual rows= loops=)

58. 0.000 0.000 ↓ 0.0

HashAggregate (cost=42,808.53..44,648.03 rows=91,975 width=380) (actual rows= loops=)

  • Group Key: part_f_campaign_transition_detail_9.campaign_key, part_f_campaign_transition_detail_9.partition_field, part_f_campaign_transition_detail_9.customer_id, part_f_campaign_transition_detail_9.contract_id
59. 0.000 0.000 ↓ 0.0

Seq Scan on part_f_campaign_transition_detail part_f_campaign_transition_detail_9 (cost=0.00..11,221.85 rows=203,785 width=178) (actual rows= loops=)

60. 0.000 0.000 ↓ 0.0

Hash (cost=10.80..10.80 rows=80 width=890) (actual rows= loops=)

61. 0.000 0.000 ↓ 0.0

Seq Scan on f_campaign_transition_characteristics_p201901 f_10 (cost=0.00..10.80 rows=80 width=890) (actual rows= loops=)

62. 0.000 0.000 ↓ 0.0

Hash Join (cost=42,820.93..46,959.93 rows=1 width=1,294) (actual rows= loops=)

  • Hash Cond: (((p_10.contract_id)::text = (f_11.contract_id)::text) AND ((p_10.customer_id)::text = (f_11.customer_id)::text) AND (p_10.campaign_key = f_11.campaign_key) AND (p_10.partition_field = f_11.partition_field))
63. 0.000 0.000 ↓ 0.0

Subquery Scan on p_10 (cost=42,808.53..45,567.78 rows=91,975 width=784) (actual rows= loops=)

64. 0.000 0.000 ↓ 0.0

HashAggregate (cost=42,808.53..44,648.03 rows=91,975 width=380) (actual rows= loops=)

  • Group Key: part_f_campaign_transition_detail_10.campaign_key, part_f_campaign_transition_detail_10.partition_field, part_f_campaign_transition_detail_10.customer_id, part_f_campaign_transition_detail_10.contract_id
65. 0.000 0.000 ↓ 0.0

Seq Scan on part_f_campaign_transition_detail part_f_campaign_transition_detail_10 (cost=0.00..11,221.85 rows=203,785 width=178) (actual rows= loops=)

66. 0.000 0.000 ↓ 0.0

Hash (cost=10.80..10.80 rows=80 width=890) (actual rows= loops=)

67. 0.000 0.000 ↓ 0.0

Seq Scan on f_campaign_transition_characteristics_p201902 f_11 (cost=0.00..10.80 rows=80 width=890) (actual rows= loops=)

68. 0.000 0.000 ↓ 0.0

Hash Join (cost=42,820.93..46,959.93 rows=1 width=1,294) (actual rows= loops=)

  • Hash Cond: (((p_11.contract_id)::text = (f_12.contract_id)::text) AND ((p_11.customer_id)::text = (f_12.customer_id)::text) AND (p_11.campaign_key = f_12.campaign_key) AND (p_11.partition_field = f_12.partition_field))
69. 0.000 0.000 ↓ 0.0

Subquery Scan on p_11 (cost=42,808.53..45,567.78 rows=91,975 width=784) (actual rows= loops=)

70. 0.000 0.000 ↓ 0.0

HashAggregate (cost=42,808.53..44,648.03 rows=91,975 width=380) (actual rows= loops=)

  • Group Key: part_f_campaign_transition_detail_11.campaign_key, part_f_campaign_transition_detail_11.partition_field, part_f_campaign_transition_detail_11.customer_id, part_f_campaign_transition_detail_11.contract_id
71. 0.000 0.000 ↓ 0.0

Seq Scan on part_f_campaign_transition_detail part_f_campaign_transition_detail_11 (cost=0.00..11,221.85 rows=203,785 width=178) (actual rows= loops=)

72. 0.000 0.000 ↓ 0.0

Hash (cost=10.80..10.80 rows=80 width=890) (actual rows= loops=)

73. 0.000 0.000 ↓ 0.0

Seq Scan on f_campaign_transition_characteristics_p201903 f_12 (cost=0.00..10.80 rows=80 width=890) (actual rows= loops=)

74. 0.000 0.000 ↓ 0.0

Hash Join (cost=42,820.93..46,959.93 rows=1 width=1,294) (actual rows= loops=)

  • Hash Cond: (((p_12.contract_id)::text = (f_13.contract_id)::text) AND ((p_12.customer_id)::text = (f_13.customer_id)::text) AND (p_12.campaign_key = f_13.campaign_key) AND (p_12.partition_field = f_13.partition_field))
75. 0.000 0.000 ↓ 0.0

Subquery Scan on p_12 (cost=42,808.53..45,567.78 rows=91,975 width=784) (actual rows= loops=)

76. 0.000 0.000 ↓ 0.0

HashAggregate (cost=42,808.53..44,648.03 rows=91,975 width=380) (actual rows= loops=)

  • Group Key: part_f_campaign_transition_detail_12.campaign_key, part_f_campaign_transition_detail_12.partition_field, part_f_campaign_transition_detail_12.customer_id, part_f_campaign_transition_detail_12.contract_id
77. 0.000 0.000 ↓ 0.0

Seq Scan on part_f_campaign_transition_detail part_f_campaign_transition_detail_12 (cost=0.00..11,221.85 rows=203,785 width=178) (actual rows= loops=)

78. 0.000 0.000 ↓ 0.0

Hash (cost=10.80..10.80 rows=80 width=890) (actual rows= loops=)

79. 0.000 0.000 ↓ 0.0

Seq Scan on f_campaign_transition_characteristics_p201904 f_13 (cost=0.00..10.80 rows=80 width=890) (actual rows= loops=)

80. 0.000 0.000 ↓ 0.0

Hash Join (cost=47,407.28..105,400.50 rows=1 width=1,078) (actual rows= loops=)

  • Hash Cond: (((f_14.contract_id)::text = (p_13.contract_id)::text) AND ((f_14.customer_id)::text = (p_13.customer_id)::text) AND (f_14.campaign_key = p_13.campaign_key) AND (f_14.partition_field = p_13.partition_field))
81. 0.000 0.000 ↓ 0.0

Seq Scan on f_campaign_transition_characteristics_p201905 f_14 (cost=0.00..49,263.20 rows=831,420 width=213) (actual rows= loops=)

82. 0.000 0.000 ↓ 0.0

Hash (cost=45,567.78..45,567.78 rows=91,975 width=784) (actual rows= loops=)

83. 0.000 0.000 ↓ 0.0

Subquery Scan on p_13 (cost=42,808.53..45,567.78 rows=91,975 width=784) (actual rows= loops=)

84. 0.000 0.000 ↓ 0.0

HashAggregate (cost=42,808.53..44,648.03 rows=91,975 width=380) (actual rows= loops=)

  • Group Key: part_f_campaign_transition_detail_13.campaign_key, part_f_campaign_transition_detail_13.partition_field, part_f_campaign_transition_detail_13.customer_id, part_f_campaign_transition_detail_13.contract_id
85. 0.000 0.000 ↓ 0.0

Seq Scan on part_f_campaign_transition_detail part_f_campaign_transition_detail_13 (cost=0.00..11,221.85 rows=203,785 width=178) (actual rows= loops=)

86. 0.000 0.000 ↓ 0.0

Hash Join (cost=42,884.35..47,023.35 rows=1 width=1,077) (actual rows= loops=)

  • Hash Cond: (((p_14.contract_id)::text = (f_15.contract_id)::text) AND ((p_14.customer_id)::text = (f_15.customer_id)::text) AND (p_14.campaign_key = f_15.campaign_key) AND (p_14.partition_field = f_15.partition_field))
87. 0.000 0.000 ↓ 0.0

Subquery Scan on p_14 (cost=42,808.53..45,567.78 rows=91,975 width=784) (actual rows= loops=)

88. 0.000 0.000 ↓ 0.0

HashAggregate (cost=42,808.53..44,648.03 rows=91,975 width=380) (actual rows= loops=)

  • Group Key: part_f_campaign_transition_detail_14.campaign_key, part_f_campaign_transition_detail_14.partition_field, part_f_campaign_transition_detail_14.customer_id, part_f_campaign_transition_detail_14.contract_id
89. 0.000 0.000 ↓ 0.0

Seq Scan on part_f_campaign_transition_detail part_f_campaign_transition_detail_14 (cost=0.00..11,221.85 rows=203,785 width=178) (actual rows= loops=)

90. 0.000 0.000 ↓ 0.0

Hash (cost=59.94..59.94 rows=794 width=216) (actual rows= loops=)

91. 0.000 0.000 ↓ 0.0

Seq Scan on f_campaign_transition_characteristics_p201906 f_15 (cost=0.00..59.94 rows=794 width=216) (actual rows= loops=)

92. 0.000 0.000 ↓ 0.0

Hash Join (cost=42,820.93..46,959.93 rows=1 width=1,294) (actual rows= loops=)

  • Hash Cond: (((p_15.contract_id)::text = (f_16.contract_id)::text) AND ((p_15.customer_id)::text = (f_16.customer_id)::text) AND (p_15.campaign_key = f_16.campaign_key) AND (p_15.partition_field = f_16.partition_field))
93. 0.000 0.000 ↓ 0.0

Subquery Scan on p_15 (cost=42,808.53..45,567.78 rows=91,975 width=784) (actual rows= loops=)

94. 0.000 0.000 ↓ 0.0

HashAggregate (cost=42,808.53..44,648.03 rows=91,975 width=380) (actual rows= loops=)

  • Group Key: part_f_campaign_transition_detail_15.campaign_key, part_f_campaign_transition_detail_15.partition_field, part_f_campaign_transition_detail_15.customer_id, part_f_campaign_transition_detail_15.contract_id
95. 0.000 0.000 ↓ 0.0

Seq Scan on part_f_campaign_transition_detail part_f_campaign_transition_detail_15 (cost=0.00..11,221.85 rows=203,785 width=178) (actual rows= loops=)

96. 0.000 0.000 ↓ 0.0

Hash (cost=10.80..10.80 rows=80 width=890) (actual rows= loops=)

97. 0.000 0.000 ↓ 0.0

Seq Scan on f_campaign_transition_characteristics_p201907 f_16 (cost=0.00..10.80 rows=80 width=890) (actual rows= loops=)

98. 0.000 0.000 ↓ 0.0

Hash Join (cost=42,820.93..46,959.93 rows=1 width=1,294) (actual rows= loops=)

  • Hash Cond: (((p_16.contract_id)::text = (f_17.contract_id)::text) AND ((p_16.customer_id)::text = (f_17.customer_id)::text) AND (p_16.campaign_key = f_17.campaign_key) AND (p_16.partition_field = f_17.partition_field))
99. 0.000 0.000 ↓ 0.0

Subquery Scan on p_16 (cost=42,808.53..45,567.78 rows=91,975 width=784) (actual rows= loops=)

100. 0.000 0.000 ↓ 0.0

HashAggregate (cost=42,808.53..44,648.03 rows=91,975 width=380) (actual rows= loops=)

  • Group Key: part_f_campaign_transition_detail_16.campaign_key, part_f_campaign_transition_detail_16.partition_field, part_f_campaign_transition_detail_16.customer_id, part_f_campaign_transition_detail_16.contract_id
101. 0.000 0.000 ↓ 0.0

Seq Scan on part_f_campaign_transition_detail part_f_campaign_transition_detail_16 (cost=0.00..11,221.85 rows=203,785 width=178) (actual rows= loops=)

102. 0.000 0.000 ↓ 0.0

Hash (cost=10.80..10.80 rows=80 width=890) (actual rows= loops=)

103. 0.000 0.000 ↓ 0.0

Seq Scan on f_campaign_transition_characteristics_p201908 f_17 (cost=0.00..10.80 rows=80 width=890) (actual rows= loops=)