explain.depesz.com

PostgreSQL's explain analyze made readable

Result: PXof

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

Limit (cost=0..0 rows=0 width=0) (actual rows=50,000 loops=1)

2. 0.000 0.000 ↓ 0.0 50,000 1

Nested Loop (cost=0..0 rows=0 width=0) (actual rows=50,000 loops=1)

3. 0.000 0.000 ↓ 0.0 50,194 1

Seq Scan on v2_m_matched_tb i (cost=0..0 rows=0 width=0) (actual rows=50,194 loops=1)

4. 0.000 0.000 ↓ 0.0 1 50,194

Hash Join (cost=0..0 rows=0 width=0) (actual rows=1 loops=50,194)

5. 0.000 0.000 ↓ 0.0 26 50,000

Seq Scan on providers p (cost=0..0 rows=0 width=0) (actual rows=26 loops=50,000)

6. 0.000 0.000 ↓ 0.0 1 50,194

Hash (cost=0..0 rows=0 width=0) (actual rows=1 loops=50,194)

7. 0.000 0.000 ↓ 0.0 1 50,194

Limit (cost=0..0 rows=0 width=0) (actual rows=1 loops=50,194)

8. 0.000 0.000 ↓ 0.0 1 50,194

Append (cost=0..0 rows=0 width=0) (actual rows=1 loops=50,194)

9. 0.000 0.000 ↓ 0.0 0 50,194

Index Scan using contact_reports_p2019_08_06_pkey on contact_reports_p2019_08_06 cr (cost=0..0 rows=0 width=0) (actual rows=0 loops=50,194)

  • Index Cond: (contact_id = i.last_contact_id)
10. 0.000 0.000 ↓ 0.0 0 50,193

Index Scan using contact_reports_p2019_08_07_pkey on contact_reports_p2019_08_07 cr_1 (cost=0..0 rows=0 width=0) (actual rows=0 loops=50,193)

  • Index Cond: (contact_id = i.last_contact_id)
11. 0.000 0.000 ↓ 0.0 0 50,193

Index Scan using contact_reports_p2019_08_08_pkey on contact_reports_p2019_08_08 cr_2 (cost=0..0 rows=0 width=0) (actual rows=0 loops=50,193)

  • Index Cond: (contact_id = i.last_contact_id)
12. 0.000 0.000 ↓ 0.0 0 50,192

Index Scan using contact_reports_p2019_08_09_pkey on contact_reports_p2019_08_09 cr_3 (cost=0..0 rows=0 width=0) (actual rows=0 loops=50,192)

  • Index Cond: (contact_id = i.last_contact_id)
13. 0.000 0.000 ↓ 0.0 0 50,192

Index Scan using contact_reports_p2019_08_10_pkey on contact_reports_p2019_08_10 cr_4 (cost=0..0 rows=0 width=0) (actual rows=0 loops=50,192)

  • Index Cond: (contact_id = i.last_contact_id)
14. 0.000 0.000 ↓ 0.0 0 50,192

Index Scan using contact_reports_p2019_08_11_pkey on contact_reports_p2019_08_11 cr_5 (cost=0..0 rows=0 width=0) (actual rows=0 loops=50,192)

  • Index Cond: (contact_id = i.last_contact_id)
15. 0.000 0.000 ↓ 0.0 0 50,192

Index Scan using contact_reports_p2019_08_12_pkey on contact_reports_p2019_08_12 cr_6 (cost=0..0 rows=0 width=0) (actual rows=0 loops=50,192)

  • Index Cond: (contact_id = i.last_contact_id)
16. 0.000 0.000 ↓ 0.0 0 50,191

Index Scan using contact_reports_p2019_08_13_pkey on contact_reports_p2019_08_13 cr_7 (cost=0..0 rows=0 width=0) (actual rows=0 loops=50,191)

  • Index Cond: (contact_id = i.last_contact_id)
17. 0.000 0.000 ↓ 0.0 0 50,190

Index Scan using contact_reports_p2019_08_14_pkey on contact_reports_p2019_08_14 cr_8 (cost=0..0 rows=0 width=0) (actual rows=0 loops=50,190)

  • Index Cond: (contact_id = i.last_contact_id)
18. 0.000 0.000 ↓ 0.0 0 50,189

Index Scan using contact_reports_p2019_08_15_pkey on contact_reports_p2019_08_15 cr_9 (cost=0..0 rows=0 width=0) (actual rows=0 loops=50,189)

  • Index Cond: (contact_id = i.last_contact_id)
19. 0.000 0.000 ↓ 0.0 0 50,189

Index Scan using contact_reports_p2019_08_16_pkey on contact_reports_p2019_08_16 cr_10 (cost=0..0 rows=0 width=0) (actual rows=0 loops=50,189)

  • Index Cond: (contact_id = i.last_contact_id)
20. 0.000 0.000 ↓ 0.0 0 50,188

Index Scan using contact_reports_p2019_08_17_pkey on contact_reports_p2019_08_17 cr_11 (cost=0..0 rows=0 width=0) (actual rows=0 loops=50,188)

  • Index Cond: (contact_id = i.last_contact_id)
21. 0.000 0.000 ↓ 0.0 0 50,188

Index Scan using contact_reports_p2019_08_18_pkey on contact_reports_p2019_08_18 cr_12 (cost=0..0 rows=0 width=0) (actual rows=0 loops=50,188)

  • Index Cond: (contact_id = i.last_contact_id)
22. 0.000 0.000 ↓ 0.0 0 50,188

Index Scan using contact_reports_p2019_08_19_pkey on contact_reports_p2019_08_19 cr_13 (cost=0..0 rows=0 width=0) (actual rows=0 loops=50,188)

  • Index Cond: (contact_id = i.last_contact_id)
23. 0.000 0.000 ↓ 0.0 0 50,188

Index Scan using contact_reports_p2019_08_20_pkey on contact_reports_p2019_08_20 cr_14 (cost=0..0 rows=0 width=0) (actual rows=0 loops=50,188)

  • Index Cond: (contact_id = i.last_contact_id)
24. 0.000 0.000 ↓ 0.0 0 50,186

Index Scan using contact_reports_p2019_08_21_pkey on contact_reports_p2019_08_21 cr_15 (cost=0..0 rows=0 width=0) (actual rows=0 loops=50,186)

  • Index Cond: (contact_id = i.last_contact_id)
25. 0.000 0.000 ↓ 0.0 0 50,186

Index Scan using contact_reports_p2019_08_22_pkey on contact_reports_p2019_08_22 cr_16 (cost=0..0 rows=0 width=0) (actual rows=0 loops=50,186)

  • Index Cond: (contact_id = i.last_contact_id)
26. 0.000 0.000 ↓ 0.0 0 50,184

Index Scan using contact_reports_p2019_08_23_pkey on contact_reports_p2019_08_23 cr_17 (cost=0..0 rows=0 width=0) (actual rows=0 loops=50,184)

  • Index Cond: (contact_id = i.last_contact_id)
27. 0.000 0.000 ↓ 0.0 0 50,184

Index Scan using contact_reports_p2019_08_24_pkey on contact_reports_p2019_08_24 cr_18 (cost=0..0 rows=0 width=0) (actual rows=0 loops=50,184)

  • Index Cond: (contact_id = i.last_contact_id)
28. 0.000 0.000 ↓ 0.0 0 50,183

Index Scan using contact_reports_p2019_08_25_pkey on contact_reports_p2019_08_25 cr_19 (cost=0..0 rows=0 width=0) (actual rows=0 loops=50,183)

  • Index Cond: (contact_id = i.last_contact_id)
29. 0.000 0.000 ↓ 0.0 0 50,183

Index Scan using contact_reports_p2019_08_26_pkey on contact_reports_p2019_08_26 cr_20 (cost=0..0 rows=0 width=0) (actual rows=0 loops=50,183)

  • Index Cond: (contact_id = i.last_contact_id)
30. 0.000 0.000 ↓ 0.0 0 50,181

Index Scan using contact_reports_p2019_08_27_pkey on contact_reports_p2019_08_27 cr_21 (cost=0..0 rows=0 width=0) (actual rows=0 loops=50,181)

  • Index Cond: (contact_id = i.last_contact_id)
31. 0.000 0.000 ↓ 0.0 0 50,181

Index Scan using contact_reports_p2019_08_28_pkey on contact_reports_p2019_08_28 cr_22 (cost=0..0 rows=0 width=0) (actual rows=0 loops=50,181)

  • Index Cond: (contact_id = i.last_contact_id)
32. 0.000 0.000 ↓ 0.0 0 50,181

Index Scan using contact_reports_p2019_08_29_pkey on contact_reports_p2019_08_29 cr_23 (cost=0..0 rows=0 width=0) (actual rows=0 loops=50,181)

  • Index Cond: (contact_id = i.last_contact_id)
33. 0.000 0.000 ↓ 0.0 0 50,180

Index Scan using contact_reports_p2019_08_30_pkey on contact_reports_p2019_08_30 cr_24 (cost=0..0 rows=0 width=0) (actual rows=0 loops=50,180)

  • Index Cond: (contact_id = i.last_contact_id)
34. 0.000 0.000 ↓ 0.0 0 50,178

Index Scan using contact_reports_p2019_08_31_pkey on contact_reports_p2019_08_31 cr_25 (cost=0..0 rows=0 width=0) (actual rows=0 loops=50,178)

  • Index Cond: (contact_id = i.last_contact_id)
35. 0.000 0.000 ↓ 0.0 0 50,177

Index Scan using contact_reports_p2019_09_01_pkey on contact_reports_p2019_09_01 cr_26 (cost=0..0 rows=0 width=0) (actual rows=0 loops=50,177)

  • Index Cond: (contact_id = i.last_contact_id)
36. 0.000 0.000 ↓ 0.0 0 50,170

Index Scan using contact_reports_p2019_09_02_pkey on contact_reports_p2019_09_02 cr_27 (cost=0..0 rows=0 width=0) (actual rows=0 loops=50,170)

  • Index Cond: (contact_id = i.last_contact_id)
37. 0.000 0.000 ↓ 0.0 0 50,169

Index Scan using contact_reports_p2019_09_03_pkey on contact_reports_p2019_09_03 cr_28 (cost=0..0 rows=0 width=0) (actual rows=0 loops=50,169)

  • Index Cond: (contact_id = i.last_contact_id)
38. 0.000 0.000 ↓ 0.0 0 50,168

Index Scan using contact_reports_p2019_09_04_pkey on contact_reports_p2019_09_04 cr_29 (cost=0..0 rows=0 width=0) (actual rows=0 loops=50,168)

  • Index Cond: (contact_id = i.last_contact_id)
39. 0.000 0.000 ↓ 0.0 0 50,167

Index Scan using contact_reports_p2019_09_05_pkey on contact_reports_p2019_09_05 cr_30 (cost=0..0 rows=0 width=0) (actual rows=0 loops=50,167)

  • Index Cond: (contact_id = i.last_contact_id)
40. 0.000 0.000 ↓ 0.0 0 50,166

Index Scan using contact_reports_p2019_09_06_pkey on contact_reports_p2019_09_06 cr_31 (cost=0..0 rows=0 width=0) (actual rows=0 loops=50,166)

  • Index Cond: (contact_id = i.last_contact_id)
41. 0.000 0.000 ↓ 0.0 0 50,165

Index Scan using contact_reports_p2019_09_07_pkey on contact_reports_p2019_09_07 cr_32 (cost=0..0 rows=0 width=0) (actual rows=0 loops=50,165)

  • Index Cond: (contact_id = i.last_contact_id)
42. 0.000 0.000 ↓ 0.0 0 50,163

Index Scan using contact_reports_p2019_09_08_pkey on contact_reports_p2019_09_08 cr_33 (cost=0..0 rows=0 width=0) (actual rows=0 loops=50,163)

  • Index Cond: (contact_id = i.last_contact_id)
43. 0.000 0.000 ↓ 0.0 0 50,162

Index Scan using contact_reports_p2019_09_09_pkey on contact_reports_p2019_09_09 cr_34 (cost=0..0 rows=0 width=0) (actual rows=0 loops=50,162)

  • Index Cond: (contact_id = i.last_contact_id)
44. 0.000 0.000 ↓ 0.0 0 50,161

Index Scan using contact_reports_p2019_09_10_pkey on contact_reports_p2019_09_10 cr_35 (cost=0..0 rows=0 width=0) (actual rows=0 loops=50,161)

  • Index Cond: (contact_id = i.last_contact_id)
45. 0.000 0.000 ↓ 0.0 0 50,159

Index Scan using contact_reports_p2019_09_11_pkey on contact_reports_p2019_09_11 cr_36 (cost=0..0 rows=0 width=0) (actual rows=0 loops=50,159)

  • Index Cond: (contact_id = i.last_contact_id)
46. 0.000 0.000 ↓ 0.0 0 50,159

Index Scan using contact_reports_p2019_09_12_pkey on contact_reports_p2019_09_12 cr_37 (cost=0..0 rows=0 width=0) (actual rows=0 loops=50,159)

  • Index Cond: (contact_id = i.last_contact_id)
47. 0.000 0.000 ↓ 0.0 0 50,159

Index Scan using contact_reports_p2019_09_13_pkey on contact_reports_p2019_09_13 cr_38 (cost=0..0 rows=0 width=0) (actual rows=0 loops=50,159)

  • Index Cond: (contact_id = i.last_contact_id)
48. 0.000 0.000 ↓ 0.0 0 50,157

Index Scan using contact_reports_p2019_09_14_pkey on contact_reports_p2019_09_14 cr_39 (cost=0..0 rows=0 width=0) (actual rows=0 loops=50,157)

  • Index Cond: (contact_id = i.last_contact_id)
49. 0.000 0.000 ↓ 0.0 0 50,156

Index Scan using contact_reports_p2019_09_15_pkey on contact_reports_p2019_09_15 cr_40 (cost=0..0 rows=0 width=0) (actual rows=0 loops=50,156)

  • Index Cond: (contact_id = i.last_contact_id)
50. 0.000 0.000 ↓ 0.0 0 50,156

Index Scan using contact_reports_p2019_09_16_pkey on contact_reports_p2019_09_16 cr_41 (cost=0..0 rows=0 width=0) (actual rows=0 loops=50,156)

  • Index Cond: (contact_id = i.last_contact_id)
51. 0.000 0.000 ↓ 0.0 0 50,154

Index Scan using contact_reports_p2019_09_17_pkey on contact_reports_p2019_09_17 cr_42 (cost=0..0 rows=0 width=0) (actual rows=0 loops=50,154)

  • Index Cond: (contact_id = i.last_contact_id)
52. 0.000 0.000 ↓ 0.0 0 50,151

Index Scan using contact_reports_p2019_09_18_pkey on contact_reports_p2019_09_18 cr_43 (cost=0..0 rows=0 width=0) (actual rows=0 loops=50,151)

  • Index Cond: (contact_id = i.last_contact_id)
53. 0.000 0.000 ↓ 0.0 0 50,151

Index Scan using contact_reports_p2019_09_19_pkey on contact_reports_p2019_09_19 cr_44 (cost=0..0 rows=0 width=0) (actual rows=0 loops=50,151)

  • Index Cond: (contact_id = i.last_contact_id)
54. 0.000 0.000 ↓ 0.0 0 50,150

Index Scan using contact_reports_p2019_09_20_pkey on contact_reports_p2019_09_20 cr_45 (cost=0..0 rows=0 width=0) (actual rows=0 loops=50,150)

  • Index Cond: (contact_id = i.last_contact_id)
55. 0.000 0.000 ↓ 0.0 0 50,150

Index Scan using contact_reports_p2019_09_21_pkey on contact_reports_p2019_09_21 cr_46 (cost=0..0 rows=0 width=0) (actual rows=0 loops=50,150)

  • Index Cond: (contact_id = i.last_contact_id)
56. 0.000 0.000 ↓ 0.0 0 50,147

Index Scan using contact_reports_p2019_09_22_pkey on contact_reports_p2019_09_22 cr_47 (cost=0..0 rows=0 width=0) (actual rows=0 loops=50,147)

  • Index Cond: (contact_id = i.last_contact_id)
57. 0.000 0.000 ↓ 0.0 0 50,146

Index Scan using contact_reports_p2019_09_23_pkey on contact_reports_p2019_09_23 cr_48 (cost=0..0 rows=0 width=0) (actual rows=0 loops=50,146)

  • Index Cond: (contact_id = i.last_contact_id)
58. 0.000 0.000 ↓ 0.0 0 50,146

Index Scan using contact_reports_p2019_09_24_pkey on contact_reports_p2019_09_24 cr_49 (cost=0..0 rows=0 width=0) (actual rows=0 loops=50,146)

  • Index Cond: (contact_id = i.last_contact_id)
59. 0.000 0.000 ↓ 0.0 0 50,145

Index Scan using contact_reports_p2019_09_25_pkey on contact_reports_p2019_09_25 cr_50 (cost=0..0 rows=0 width=0) (actual rows=0 loops=50,145)

  • Index Cond: (contact_id = i.last_contact_id)
60. 0.000 0.000 ↓ 0.0 0 50,142

Index Scan using contact_reports_p2019_09_26_pkey on contact_reports_p2019_09_26 cr_51 (cost=0..0 rows=0 width=0) (actual rows=0 loops=50,142)

  • Index Cond: (contact_id = i.last_contact_id)
61. 0.000 0.000 ↓ 0.0 0 50,140

Index Scan using contact_reports_p2019_09_27_pkey on contact_reports_p2019_09_27 cr_52 (cost=0..0 rows=0 width=0) (actual rows=0 loops=50,140)

  • Index Cond: (contact_id = i.last_contact_id)
62. 0.000 0.000 ↓ 0.0 0 50,139

Index Scan using contact_reports_p2019_09_28_pkey on contact_reports_p2019_09_28 cr_53 (cost=0..0 rows=0 width=0) (actual rows=0 loops=50,139)

  • Index Cond: (contact_id = i.last_contact_id)
63. 0.000 0.000 ↓ 0.0 0 50,137

Index Scan using contact_reports_p2019_09_29_pkey on contact_reports_p2019_09_29 cr_54 (cost=0..0 rows=0 width=0) (actual rows=0 loops=50,137)

  • Index Cond: (contact_id = i.last_contact_id)
64. 0.000 0.000 ↓ 0.0 0 50,135

Index Scan using contact_reports_p2019_09_30_pkey on contact_reports_p2019_09_30 cr_55 (cost=0..0 rows=0 width=0) (actual rows=0 loops=50,135)

  • Index Cond: (contact_id = i.last_contact_id)
65. 0.000 0.000 ↓ 0.0 0 50,134

Index Scan using contact_reports_p2019_10_01_pkey on contact_reports_p2019_10_01 cr_56 (cost=0..0 rows=0 width=0) (actual rows=0 loops=50,134)

  • Index Cond: (contact_id = i.last_contact_id)
66. 0.000 0.000 ↓ 0.0 0 50,131

Index Scan using contact_reports_p2019_10_02_pkey on contact_reports_p2019_10_02 cr_57 (cost=0..0 rows=0 width=0) (actual rows=0 loops=50,131)

  • Index Cond: (contact_id = i.last_contact_id)
67. 0.000 0.000 ↓ 0.0 0 50,129

Index Scan using contact_reports_p2019_10_03_pkey on contact_reports_p2019_10_03 cr_58 (cost=0..0 rows=0 width=0) (actual rows=0 loops=50,129)

  • Index Cond: (contact_id = i.last_contact_id)
68. 0.000 0.000 ↓ 0.0 0 50,124

Index Scan using contact_reports_p2019_10_04_pkey on contact_reports_p2019_10_04 cr_59 (cost=0..0 rows=0 width=0) (actual rows=0 loops=50,124)

  • Index Cond: (contact_id = i.last_contact_id)
69. 0.000 0.000 ↓ 0.0 0 50,120

Index Scan using contact_reports_p2019_10_05_pkey on contact_reports_p2019_10_05 cr_60 (cost=0..0 rows=0 width=0) (actual rows=0 loops=50,120)

  • Index Cond: (contact_id = i.last_contact_id)
70. 0.000 0.000 ↓ 0.0 0 50,118

Index Scan using contact_reports_p2019_10_06_pkey on contact_reports_p2019_10_06 cr_61 (cost=0..0 rows=0 width=0) (actual rows=0 loops=50,118)

  • Index Cond: (contact_id = i.last_contact_id)
71. 0.000 0.000 ↓ 0.0 0 50,118

Index Scan using contact_reports_p2019_10_07_pkey on contact_reports_p2019_10_07 cr_62 (cost=0..0 rows=0 width=0) (actual rows=0 loops=50,118)

  • Index Cond: (contact_id = i.last_contact_id)
72. 0.000 0.000 ↓ 0.0 0 50,115

Index Scan using contact_reports_p2019_10_08_pkey on contact_reports_p2019_10_08 cr_63 (cost=0..0 rows=0 width=0) (actual rows=0 loops=50,115)

  • Index Cond: (contact_id = i.last_contact_id)
73. 0.000 0.000 ↓ 0.0 0 50,113

Index Scan using contact_reports_p2019_10_09_pkey on contact_reports_p2019_10_09 cr_64 (cost=0..0 rows=0 width=0) (actual rows=0 loops=50,113)

  • Index Cond: (contact_id = i.last_contact_id)
74. 0.000 0.000 ↓ 0.0 0 50,113

Index Scan using contact_reports_p2019_10_10_pkey on contact_reports_p2019_10_10 cr_65 (cost=0..0 rows=0 width=0) (actual rows=0 loops=50,113)

  • Index Cond: (contact_id = i.last_contact_id)
75. 0.000 0.000 ↓ 0.0 0 50,108

Index Scan using contact_reports_p2019_10_11_pkey on contact_reports_p2019_10_11 cr_66 (cost=0..0 rows=0 width=0) (actual rows=0 loops=50,108)

  • Index Cond: (contact_id = i.last_contact_id)
76. 0.000 0.000 ↓ 0.0 0 50,106

Index Scan using contact_reports_p2019_10_12_pkey on contact_reports_p2019_10_12 cr_67 (cost=0..0 rows=0 width=0) (actual rows=0 loops=50,106)

  • Index Cond: (contact_id = i.last_contact_id)
77. 0.000 0.000 ↓ 0.0 0 50,103

Index Scan using contact_reports_p2019_10_13_pkey on contact_reports_p2019_10_13 cr_68 (cost=0..0 rows=0 width=0) (actual rows=0 loops=50,103)

  • Index Cond: (contact_id = i.last_contact_id)
78. 0.000 0.000 ↓ 0.0 0 50,099

Index Scan using contact_reports_p2019_10_14_pkey on contact_reports_p2019_10_14 cr_69 (cost=0..0 rows=0 width=0) (actual rows=0 loops=50,099)

  • Index Cond: (contact_id = i.last_contact_id)
79. 0.000 0.000 ↓ 0.0 0 50,099

Index Scan using contact_reports_p2019_10_15_pkey on contact_reports_p2019_10_15 cr_70 (cost=0..0 rows=0 width=0) (actual rows=0 loops=50,099)

  • Index Cond: (contact_id = i.last_contact_id)
80. 0.000 0.000 ↓ 0.0 0 50,051

Index Scan using contact_reports_p2019_10_16_pkey on contact_reports_p2019_10_16 cr_71 (cost=0..0 rows=0 width=0) (actual rows=0 loops=50,051)

  • Index Cond: (contact_id = i.last_contact_id)
81. 0.000 0.000 ↓ 0.0 0 49,839

Index Scan using contact_reports_p2019_10_17_pkey on contact_reports_p2019_10_17 cr_72 (cost=0..0 rows=0 width=0) (actual rows=0 loops=49,839)

  • Index Cond: (contact_id = i.last_contact_id)
82. 0.000 0.000 ↓ 0.0 0 49,676

Index Scan using contact_reports_p2019_10_18_pkey on contact_reports_p2019_10_18 cr_73 (cost=0..0 rows=0 width=0) (actual rows=0 loops=49,676)

  • Index Cond: (contact_id = i.last_contact_id)
83. 0.000 0.000 ↓ 0.0 0 49,673

Index Scan using contact_reports_p2019_10_19_pkey on contact_reports_p2019_10_19 cr_74 (cost=0..0 rows=0 width=0) (actual rows=0 loops=49,673)

  • Index Cond: (contact_id = i.last_contact_id)
84. 0.000 0.000 ↓ 0.0 0 49,667

Index Scan using contact_reports_p2019_10_20_pkey on contact_reports_p2019_10_20 cr_75 (cost=0..0 rows=0 width=0) (actual rows=0 loops=49,667)

  • Index Cond: (contact_id = i.last_contact_id)
85. 0.000 0.000 ↓ 0.0 0 49,666

Index Scan using contact_reports_p2019_10_21_pkey on contact_reports_p2019_10_21 cr_76 (cost=0..0 rows=0 width=0) (actual rows=0 loops=49,666)

  • Index Cond: (contact_id = i.last_contact_id)
86. 0.000 0.000 ↓ 0.0 0 49,661

Index Scan using contact_reports_p2019_10_22_pkey on contact_reports_p2019_10_22 cr_77 (cost=0..0 rows=0 width=0) (actual rows=0 loops=49,661)

  • Index Cond: (contact_id = i.last_contact_id)
87. 0.000 0.000 ↓ 0.0 0 49,656

Index Scan using contact_reports_p2019_10_23_pkey on contact_reports_p2019_10_23 cr_78 (cost=0..0 rows=0 width=0) (actual rows=0 loops=49,656)

  • Index Cond: (contact_id = i.last_contact_id)
88. 0.000 0.000 ↓ 0.0 0 49,651

Index Scan using contact_reports_p2019_10_24_pkey on contact_reports_p2019_10_24 cr_79 (cost=0..0 rows=0 width=0) (actual rows=0 loops=49,651)

  • Index Cond: (contact_id = i.last_contact_id)
89. 0.000 0.000 ↓ 0.0 0 49,647

Index Scan using contact_reports_p2019_10_25_pkey on contact_reports_p2019_10_25 cr_80 (cost=0..0 rows=0 width=0) (actual rows=0 loops=49,647)

  • Index Cond: (contact_id = i.last_contact_id)
90. 0.000 0.000 ↓ 0.0 0 49,642

Index Scan using contact_reports_p2019_10_26_pkey on contact_reports_p2019_10_26 cr_81 (cost=0..0 rows=0 width=0) (actual rows=0 loops=49,642)

  • Index Cond: (contact_id = i.last_contact_id)
91. 0.000 0.000 ↓ 0.0 0 49,638

Index Scan using contact_reports_p2019_10_27_pkey on contact_reports_p2019_10_27 cr_82 (cost=0..0 rows=0 width=0) (actual rows=0 loops=49,638)

  • Index Cond: (contact_id = i.last_contact_id)
92. 0.000 0.000 ↓ 0.0 0 49,636

Index Scan using contact_reports_p2019_10_28_pkey on contact_reports_p2019_10_28 cr_83 (cost=0..0 rows=0 width=0) (actual rows=0 loops=49,636)

  • Index Cond: (contact_id = i.last_contact_id)
93. 0.000 0.000 ↓ 0.0 0 49,630

Index Scan using contact_reports_p2019_10_29_pkey on contact_reports_p2019_10_29 cr_84 (cost=0..0 rows=0 width=0) (actual rows=0 loops=49,630)

  • Index Cond: (contact_id = i.last_contact_id)
94. 0.000 0.000 ↓ 0.0 0 49,626

Index Scan using contact_reports_p2019_10_30_pkey on contact_reports_p2019_10_30 cr_85 (cost=0..0 rows=0 width=0) (actual rows=0 loops=49,626)

  • Index Cond: (contact_id = i.last_contact_id)
95. 0.000 0.000 ↓ 0.0 0 49,618

Index Scan using contact_reports_p2019_10_31_pkey on contact_reports_p2019_10_31 cr_86 (cost=0..0 rows=0 width=0) (actual rows=0 loops=49,618)

  • Index Cond: (contact_id = i.last_contact_id)
96. 0.000 0.000 ↓ 0.0 0 49,608

Index Scan using contact_reports_p2019_11_01_pkey on contact_reports_p2019_11_01 cr_87 (cost=0..0 rows=0 width=0) (actual rows=0 loops=49,608)

  • Index Cond: (contact_id = i.last_contact_id)
97. 0.000 0.000 ↓ 0.0 0 49,600

Index Scan using contact_reports_p2019_11_02_pkey on contact_reports_p2019_11_02 cr_88 (cost=0..0 rows=0 width=0) (actual rows=0 loops=49,600)

  • Index Cond: (contact_id = i.last_contact_id)
98. 0.000 0.000 ↓ 0.0 0 49,587

Index Scan using contact_reports_p2019_11_03_pkey on contact_reports_p2019_11_03 cr_89 (cost=0..0 rows=0 width=0) (actual rows=0 loops=49,587)

  • Index Cond: (contact_id = i.last_contact_id)
99. 0.000 0.000 ↓ 0.0 0 49,576

Index Scan using contact_reports_p2019_11_04_pkey on contact_reports_p2019_11_04 cr_90 (cost=0..0 rows=0 width=0) (actual rows=0 loops=49,576)

  • Index Cond: (contact_id = i.last_contact_id)
100. 0.000 0.000 ↓ 0.0 0 46,205

Index Scan using contact_reports_p2019_11_05_pkey on contact_reports_p2019_11_05 cr_91 (cost=0..0 rows=0 width=0) (actual rows=0 loops=46,205)

  • Index Cond: (contact_id = i.last_contact_id)
101. 0.000 0.000 ↓ 0.0 1 35,223

Index Scan using contact_reports_p2019_11_06_pkey on contact_reports_p2019_11_06 cr_92 (cost=0..0 rows=0 width=0) (actual rows=1 loops=35,223)

  • Index Cond: (contact_id = i.last_contact_id)
102. 0.000 0.000 ↓ 0.0 0 194

Index Scan using contact_reports_p2019_11_07_pkey on contact_reports_p2019_11_07 cr_93 (cost=0..0 rows=0 width=0) (actual rows=0 loops=194)

  • Index Cond: (contact_id = i.last_contact_id)
103. 0.000 0.000 ↓ 0.0 0 194

Index Scan using contact_reports_p2019_11_08_pkey on contact_reports_p2019_11_08 cr_94 (cost=0..0 rows=0 width=0) (actual rows=0 loops=194)

  • Index Cond: (contact_id = i.last_contact_id)
104. 0.000 0.000 ↓ 0.0 0 194

Index Scan using contact_reports_p2019_11_09_pkey on contact_reports_p2019_11_09 cr_95 (cost=0..0 rows=0 width=0) (actual rows=0 loops=194)

  • Index Cond: (contact_id = i.last_contact_id)
105. 0.000 0.000 ↓ 0.0 0 194

Index Scan using contact_reports_p2019_11_10_pkey on contact_reports_p2019_11_10 cr_96 (cost=0..0 rows=0 width=0) (actual rows=0 loops=194)

  • Index Cond: (contact_id = i.last_contact_id)
106. 0.000 0.000 ↓ 0.0 0 194

Index Scan using contact_reports_p2019_11_11_pkey on contact_reports_p2019_11_11 cr_97 (cost=0..0 rows=0 width=0) (actual rows=0 loops=194)

  • Index Cond: (contact_id = i.last_contact_id)
107. 0.000 0.000 ↓ 0.0 0 194

Index Scan using contact_reports_default_pkey on contact_reports_default cr_98 (cost=0..0 rows=0 width=0) (actual rows=0 loops=194)

  • Index Cond: (contact_id = i.last_contact_id)