explain.depesz.com

PostgreSQL's explain analyze made readable

Result: kBGt4

Settings
# exclusive inclusive rows x rows loops node
1. 5.319 13,084.138 ↑ 1.0 50,000 1

Limit (cost=8.95..68,368.45 rows=50,000 width=213) (actual time=1.045..13,084.138 rows=50,000 loops=1)

  • Buffers: shared hit=16131064 read=596
2. 163.831 13,078.819 ↑ 37.0 50,000 1

Nested Loop (cost=8.95..2,528,018.25 rows=1,849,055 width=213) (actual time=1.044..13,078.819 rows=50,000 loops=1)

  • Buffers: shared hit=16131064 read=596
3. 13.588 13.588 ↑ 36.8 50,200 1

Seq Scan on v2_m_matched_tb i (cost=0..57,209.55 rows=1,849,055 width=45) (actual time=0.009..13.588 rows=50,200 loops=1)

  • Buffers: shared hit=1427
4. 301.600 12,901.400 ↑ 1.0 1 50,200

Hash Join (cost=8.95..10.28 rows=1 width=176) (actual time=0.254..0.257 rows=1 loops=50,200)

  • Buffers: shared hit=16129637 read=596
5. 100.000 100.000 ↓ 1.1 26 50,000

Seq Scan on providers p (cost=0..1.23 rows=23 width=23) (actual time=0.001..0.002 rows=26 loops=50,000)

  • Buffers: shared hit=50000
6. 50.200 12,499.800 ↑ 1.0 1 50,200

Hash (cost=8.94..8.94 rows=1 width=157) (actual time=0.249..0.249 rows=1 loops=50,200)

  • Buffers: shared hit=16079637 read=596
7. 652.600 12,449.600 ↑ 1.0 1 50,200

Limit (cost=0.43..8.93 rows=1 width=157) (actual time=0.239..0.248 rows=1 loops=50,200)

  • Buffers: shared hit=16079637 read=596
8. 0.000 11,797.000 ↑ 99.0 1 50,200

Append (cost=0.43..841.4 rows=99 width=157) (actual time=0.235..0.235 rows=1 loops=50,200)

  • Buffers: shared hit=16079637 read=596
9. 100.400 100.400 ↓ 0.0 0 50,200

Index Scan using contact_reports_p2019_08_06_pkey on contact_reports_p2019_08_06 cr (cost=0.43..8.46 rows=1 width=157) (actual time=0.002..0.002 rows=0 loops=50,200)

  • Index Cond: (cr.contact_id = i.last_contact_id)
  • Buffers: shared hit=150106
10. 100.398 100.398 ↓ 0.0 0 50,199

Index Scan using contact_reports_p2019_08_07_pkey on contact_reports_p2019_08_07 cr_1 (cost=0.43..8.46 rows=1 width=157) (actual time=0.002..0.002 rows=0 loops=50,199)

  • Index Cond: (cr_1.contact_id = i.last_contact_id)
  • Buffers: shared hit=150102
11. 100.398 100.398 ↓ 0.0 0 50,199

Index Scan using contact_reports_p2019_08_08_pkey on contact_reports_p2019_08_08 cr_2 (cost=0.43..8.46 rows=1 width=157) (actual time=0.002..0.002 rows=0 loops=50,199)

  • Index Cond: (cr_2.contact_id = i.last_contact_id)
  • Buffers: shared hit=150103
12. 100.396 100.396 ↓ 0.0 0 50,198

Index Scan using contact_reports_p2019_08_09_pkey on contact_reports_p2019_08_09 cr_3 (cost=0.43..8.46 rows=1 width=157) (actual time=0.002..0.002 rows=0 loops=50,198)

  • Index Cond: (cr_3.contact_id = i.last_contact_id)
  • Buffers: shared hit=150099
13. 100.396 100.396 ↓ 0.0 0 50,198

Index Scan using contact_reports_p2019_08_10_pkey on contact_reports_p2019_08_10 cr_4 (cost=0.43..8.46 rows=1 width=157) (actual time=0.002..0.002 rows=0 loops=50,198)

  • Index Cond: (cr_4.contact_id = i.last_contact_id)
  • Buffers: shared hit=150099
14. 100.396 100.396 ↓ 0.0 0 50,198

Index Scan using contact_reports_p2019_08_11_pkey on contact_reports_p2019_08_11 cr_5 (cost=0.43..8.45 rows=1 width=157) (actual time=0.002..0.002 rows=0 loops=50,198)

  • Index Cond: (cr_5.contact_id = i.last_contact_id)
  • Buffers: shared hit=150099
15. 100.396 100.396 ↓ 0.0 0 50,198

Index Scan using contact_reports_p2019_08_12_pkey on contact_reports_p2019_08_12 cr_6 (cost=0.43..8.46 rows=1 width=157) (actual time=0.002..0.002 rows=0 loops=50,198)

  • Index Cond: (cr_6.contact_id = i.last_contact_id)
  • Buffers: shared hit=150100
16. 100.394 100.394 ↓ 0.0 0 50,197

Index Scan using contact_reports_p2019_08_13_pkey on contact_reports_p2019_08_13 cr_7 (cost=0.43..8.46 rows=1 width=157) (actual time=0.001..0.002 rows=0 loops=50,197)

  • Index Cond: (cr_7.contact_id = i.last_contact_id)
  • Buffers: shared hit=150097
17. 100.392 100.392 ↓ 0.0 0 50,196

Index Scan using contact_reports_p2019_08_14_pkey on contact_reports_p2019_08_14 cr_8 (cost=0.43..8.46 rows=1 width=157) (actual time=0.002..0.002 rows=0 loops=50,196)

  • Index Cond: (cr_8.contact_id = i.last_contact_id)
  • Buffers: shared hit=150094
18. 100.390 100.390 ↓ 0.0 0 50,195

Index Scan using contact_reports_p2019_08_15_pkey on contact_reports_p2019_08_15 cr_9 (cost=0.43..8.46 rows=1 width=157) (actual time=0.002..0.002 rows=0 loops=50,195)

  • Index Cond: (cr_9.contact_id = i.last_contact_id)
  • Buffers: shared hit=150090
19. 100.390 100.390 ↓ 0.0 0 50,195

Index Scan using contact_reports_p2019_08_16_pkey on contact_reports_p2019_08_16 cr_10 (cost=0.43..8.46 rows=1 width=157) (actual time=0.002..0.002 rows=0 loops=50,195)

  • Index Cond: (cr_10.contact_id = i.last_contact_id)
  • Buffers: shared hit=150091
20. 100.388 100.388 ↓ 0.0 0 50,194

Index Scan using contact_reports_p2019_08_17_pkey on contact_reports_p2019_08_17 cr_11 (cost=0.43..8.46 rows=1 width=157) (actual time=0.002..0.002 rows=0 loops=50,194)

  • Index Cond: (cr_11.contact_id = i.last_contact_id)
  • Buffers: shared hit=150087
21. 100.388 100.388 ↓ 0.0 0 50,194

Index Scan using contact_reports_p2019_08_18_pkey on contact_reports_p2019_08_18 cr_12 (cost=0.43..8.46 rows=1 width=157) (actual time=0.002..0.002 rows=0 loops=50,194)

  • Index Cond: (cr_12.contact_id = i.last_contact_id)
  • Buffers: shared hit=150087
22. 200.776 200.776 ↓ 0.0 0 50,194

Index Scan using contact_reports_p2019_08_19_pkey on contact_reports_p2019_08_19 cr_13 (cost=0.43..8.46 rows=1 width=157) (actual time=0.003..0.004 rows=0 loops=50,194)

  • Index Cond: (cr_13.contact_id = i.last_contact_id)
  • Buffers: shared hit=150085 read=3
23. 100.386 100.386 ↓ 0.0 0 50,193

Index Scan using contact_reports_p2019_08_20_pkey on contact_reports_p2019_08_20 cr_14 (cost=0.43..8.46 rows=1 width=157) (actual time=0.002..0.002 rows=0 loops=50,193)

  • Index Cond: (cr_14.contact_id = i.last_contact_id)
  • Buffers: shared hit=150086
24. 100.382 100.382 ↓ 0.0 0 50,191

Index Scan using contact_reports_p2019_08_21_pkey on contact_reports_p2019_08_21 cr_15 (cost=0.43..8.46 rows=1 width=157) (actual time=0.002..0.002 rows=0 loops=50,191)

  • Index Cond: (cr_15.contact_id = i.last_contact_id)
  • Buffers: shared hit=150078
25. 100.382 100.382 ↓ 0.0 0 50,191

Index Scan using contact_reports_p2019_08_22_pkey on contact_reports_p2019_08_22 cr_16 (cost=0.43..8.46 rows=1 width=157) (actual time=0.001..0.002 rows=0 loops=50,191)

  • Index Cond: (cr_16.contact_id = i.last_contact_id)
  • Buffers: shared hit=150080
26. 100.378 100.378 ↓ 0.0 0 50,189

Index Scan using contact_reports_p2019_08_23_pkey on contact_reports_p2019_08_23 cr_17 (cost=0.43..8.46 rows=1 width=157) (actual time=0.002..0.002 rows=0 loops=50,189)

  • Index Cond: (cr_17.contact_id = i.last_contact_id)
  • Buffers: shared hit=150072
27. 100.378 100.378 ↓ 0.0 0 50,189

Index Scan using contact_reports_p2019_08_24_pkey on contact_reports_p2019_08_24 cr_18 (cost=0.43..8.46 rows=1 width=157) (actual time=0.002..0.002 rows=0 loops=50,189)

  • Index Cond: (cr_18.contact_id = i.last_contact_id)
  • Buffers: shared hit=150073
28. 100.376 100.376 ↓ 0.0 0 50,188

Index Scan using contact_reports_p2019_08_25_pkey on contact_reports_p2019_08_25 cr_19 (cost=0.43..8.46 rows=1 width=157) (actual time=0.002..0.002 rows=0 loops=50,188)

  • Index Cond: (cr_19.contact_id = i.last_contact_id)
  • Buffers: shared hit=150069
29. 100.376 100.376 ↓ 0.0 0 50,188

Index Scan using contact_reports_p2019_08_26_pkey on contact_reports_p2019_08_26 cr_20 (cost=0.43..8.46 rows=1 width=157) (actual time=0.002..0.002 rows=0 loops=50,188)

  • Index Cond: (cr_20.contact_id = i.last_contact_id)
  • Buffers: shared hit=150071
30. 100.372 100.372 ↓ 0.0 0 50,186

Index Scan using contact_reports_p2019_08_27_pkey on contact_reports_p2019_08_27 cr_21 (cost=0.43..8.46 rows=1 width=157) (actual time=0.002..0.002 rows=0 loops=50,186)

  • Index Cond: (cr_21.contact_id = i.last_contact_id)
  • Buffers: shared hit=150063
31. 100.372 100.372 ↓ 0.0 0 50,186

Index Scan using contact_reports_p2019_08_28_pkey on contact_reports_p2019_08_28 cr_22 (cost=0.43..8.46 rows=1 width=157) (actual time=0.002..0.002 rows=0 loops=50,186)

  • Index Cond: (cr_22.contact_id = i.last_contact_id)
  • Buffers: shared hit=150063
32. 100.372 100.372 ↓ 0.0 0 50,186

Index Scan using contact_reports_p2019_08_29_pkey on contact_reports_p2019_08_29 cr_23 (cost=0.43..8.46 rows=1 width=157) (actual time=0.002..0.002 rows=0 loops=50,186)

  • Index Cond: (cr_23.contact_id = i.last_contact_id)
  • Buffers: shared hit=150064
33. 100.370 100.370 ↓ 0.0 0 50,185

Index Scan using contact_reports_p2019_08_30_pkey on contact_reports_p2019_08_30 cr_24 (cost=0.43..8.46 rows=1 width=157) (actual time=0.002..0.002 rows=0 loops=50,185)

  • Index Cond: (cr_24.contact_id = i.last_contact_id)
  • Buffers: shared hit=150062
34. 100.366 100.366 ↓ 0.0 0 50,183

Index Scan using contact_reports_p2019_08_31_pkey on contact_reports_p2019_08_31 cr_25 (cost=0.43..8.46 rows=1 width=157) (actual time=0.002..0.002 rows=0 loops=50,183)

  • Index Cond: (cr_25.contact_id = i.last_contact_id)
  • Buffers: shared hit=150055
35. 150.546 150.546 ↓ 0.0 0 50,182

Index Scan using contact_reports_p2019_09_01_pkey on contact_reports_p2019_09_01 cr_26 (cost=0.43..8.46 rows=1 width=157) (actual time=0.003..0.003 rows=0 loops=50,182)

  • Index Cond: (cr_26.contact_id = i.last_contact_id)
  • Buffers: shared hit=150056 read=3
36. 100.348 100.348 ↓ 0.0 0 50,174

Index Scan using contact_reports_p2019_09_02_pkey on contact_reports_p2019_09_02 cr_27 (cost=0.43..8.46 rows=1 width=157) (actual time=0.002..0.002 rows=0 loops=50,174)

  • Index Cond: (cr_27.contact_id = i.last_contact_id)
  • Buffers: shared hit=150028
37. 100.346 100.346 ↓ 0.0 0 50,173

Index Scan using contact_reports_p2019_09_03_pkey on contact_reports_p2019_09_03 cr_28 (cost=0.43..8.46 rows=1 width=157) (actual time=0.002..0.002 rows=0 loops=50,173)

  • Index Cond: (cr_28.contact_id = i.last_contact_id)
  • Buffers: shared hit=150025
38. 100.344 100.344 ↓ 0.0 0 50,172

Index Scan using contact_reports_p2019_09_04_pkey on contact_reports_p2019_09_04 cr_29 (cost=0.43..8.46 rows=1 width=157) (actual time=0.002..0.002 rows=0 loops=50,172)

  • Index Cond: (cr_29.contact_id = i.last_contact_id)
  • Buffers: shared hit=150022
39. 100.342 100.342 ↓ 0.0 0 50,171

Index Scan using contact_reports_p2019_09_05_pkey on contact_reports_p2019_09_05 cr_30 (cost=0.43..8.46 rows=1 width=157) (actual time=0.002..0.002 rows=0 loops=50,171)

  • Index Cond: (cr_30.contact_id = i.last_contact_id)
  • Buffers: shared hit=150019
40. 100.340 100.340 ↓ 0.0 0 50,170

Index Scan using contact_reports_p2019_09_06_pkey on contact_reports_p2019_09_06 cr_31 (cost=0.43..8.46 rows=1 width=157) (actual time=0.002..0.002 rows=0 loops=50,170)

  • Index Cond: (cr_31.contact_id = i.last_contact_id)
  • Buffers: shared hit=150016
41. 100.338 100.338 ↓ 0.0 0 50,169

Index Scan using contact_reports_p2019_09_07_pkey on contact_reports_p2019_09_07 cr_32 (cost=0.43..8.46 rows=1 width=157) (actual time=0.002..0.002 rows=0 loops=50,169)

  • Index Cond: (cr_32.contact_id = i.last_contact_id)
  • Buffers: shared hit=150014
42. 100.334 100.334 ↓ 0.0 0 50,167

Index Scan using contact_reports_p2019_09_08_pkey on contact_reports_p2019_09_08 cr_33 (cost=0.43..8.46 rows=1 width=157) (actual time=0.002..0.002 rows=0 loops=50,167)

  • Index Cond: (cr_33.contact_id = i.last_contact_id)
  • Buffers: shared hit=150007
43. 100.332 100.332 ↓ 0.0 0 50,166

Index Scan using contact_reports_p2019_09_09_pkey on contact_reports_p2019_09_09 cr_34 (cost=0.43..8.45 rows=1 width=157) (actual time=0.002..0.002 rows=0 loops=50,166)

  • Index Cond: (cr_34.contact_id = i.last_contact_id)
  • Buffers: shared hit=150004
44. 100.330 100.330 ↓ 0.0 0 50,165

Index Scan using contact_reports_p2019_09_10_pkey on contact_reports_p2019_09_10 cr_35 (cost=0.43..8.46 rows=1 width=157) (actual time=0.001..0.002 rows=0 loops=50,165)

  • Index Cond: (cr_35.contact_id = i.last_contact_id)
  • Buffers: shared hit=150002
45. 100.326 100.326 ↓ 0.0 0 50,163

Index Scan using contact_reports_p2019_09_11_pkey on contact_reports_p2019_09_11 cr_36 (cost=0.43..8.46 rows=1 width=157) (actual time=0.002..0.002 rows=0 loops=50,163)

  • Index Cond: (cr_36.contact_id = i.last_contact_id)
  • Buffers: shared hit=149994
46. 250.815 250.815 ↓ 0.0 0 50,163

Index Scan using contact_reports_p2019_09_12_pkey on contact_reports_p2019_09_12 cr_37 (cost=0.43..8.46 rows=1 width=157) (actual time=0.005..0.005 rows=0 loops=50,163)

  • Index Cond: (cr_37.contact_id = i.last_contact_id)
  • Buffers: shared hit=149992 read=3
47. 100.324 100.324 ↓ 0.0 0 50,162

Index Scan using contact_reports_p2019_09_13_pkey on contact_reports_p2019_09_13 cr_38 (cost=0.43..8.46 rows=1 width=157) (actual time=0.002..0.002 rows=0 loops=50,162)

  • Index Cond: (cr_38.contact_id = i.last_contact_id)
  • Buffers: shared hit=149993
48. 50.160 50.160 ↓ 0.0 0 50,160

Index Scan using contact_reports_p2019_09_14_pkey on contact_reports_p2019_09_14 cr_39 (cost=0.43..8.46 rows=1 width=157) (actual time=0.001..0.001 rows=0 loops=50,160)

  • Index Cond: (cr_39.contact_id = i.last_contact_id)
  • Buffers: shared hit=149986
49. 250.795 250.795 ↓ 0.0 0 50,159

Index Scan using contact_reports_p2019_09_15_pkey on contact_reports_p2019_09_15 cr_40 (cost=0.43..8.46 rows=1 width=157) (actual time=0.005..0.005 rows=0 loops=50,159)

  • Index Cond: (cr_40.contact_id = i.last_contact_id)
  • Buffers: shared hit=149980 read=3
50. 100.316 100.316 ↓ 0.0 0 50,158

Index Scan using contact_reports_p2019_09_16_pkey on contact_reports_p2019_09_16 cr_41 (cost=0.43..8.46 rows=1 width=157) (actual time=0.002..0.002 rows=0 loops=50,158)

  • Index Cond: (cr_41.contact_id = i.last_contact_id)
  • Buffers: shared hit=149981
51. 100.312 100.312 ↓ 0.0 0 50,156

Index Scan using contact_reports_p2019_09_17_pkey on contact_reports_p2019_09_17 cr_42 (cost=0.43..8.46 rows=1 width=157) (actual time=0.002..0.002 rows=0 loops=50,156)

  • Index Cond: (cr_42.contact_id = i.last_contact_id)
  • Buffers: shared hit=149976
52. 50.153 50.153 ↓ 0.0 0 50,153

Index Scan using contact_reports_p2019_09_18_pkey on contact_reports_p2019_09_18 cr_43 (cost=0.43..8.46 rows=1 width=157) (actual time=0.001..0.001 rows=0 loops=50,153)

  • Index Cond: (cr_43.contact_id = i.last_contact_id)
  • Buffers: shared hit=149964
53. 100.306 100.306 ↓ 0.0 0 50,153

Index Scan using contact_reports_p2019_09_19_pkey on contact_reports_p2019_09_19 cr_44 (cost=0.43..8.46 rows=1 width=157) (actual time=0.002..0.002 rows=0 loops=50,153)

  • Index Cond: (cr_44.contact_id = i.last_contact_id)
  • Buffers: shared hit=149965
54. 100.304 100.304 ↓ 0.0 0 50,152

Index Scan using contact_reports_p2019_09_20_pkey on contact_reports_p2019_09_20 cr_45 (cost=0.43..8.46 rows=1 width=157) (actual time=0.002..0.002 rows=0 loops=50,152)

  • Index Cond: (cr_45.contact_id = i.last_contact_id)
  • Buffers: shared hit=149961
55. 100.304 100.304 ↓ 0.0 0 50,152

Index Scan using contact_reports_p2019_09_21_pkey on contact_reports_p2019_09_21 cr_46 (cost=0.43..8.46 rows=1 width=157) (actual time=0.002..0.002 rows=0 loops=50,152)

  • Index Cond: (cr_46.contact_id = i.last_contact_id)
  • Buffers: shared hit=149964
56. 100.298 100.298 ↓ 0.0 0 50,149

Index Scan using contact_reports_p2019_09_22_pkey on contact_reports_p2019_09_22 cr_47 (cost=0.43..8.46 rows=1 width=157) (actual time=0.001..0.002 rows=0 loops=50,149)

  • Index Cond: (cr_47.contact_id = i.last_contact_id)
  • Buffers: shared hit=149953
57. 100.296 100.296 ↓ 0.0 0 50,148

Index Scan using contact_reports_p2019_09_23_pkey on contact_reports_p2019_09_23 cr_48 (cost=0.56..8.58 rows=1 width=157) (actual time=0.002..0.002 rows=0 loops=50,148)

  • Index Cond: (cr_48.contact_id = i.last_contact_id)
  • Buffers: shared hit=199932
58. 100.296 100.296 ↓ 0.0 0 50,148

Index Scan using contact_reports_p2019_09_24_pkey on contact_reports_p2019_09_24 cr_49 (cost=0.56..8.58 rows=1 width=157) (actual time=0.002..0.002 rows=0 loops=50,148)

  • Index Cond: (cr_49.contact_id = i.last_contact_id)
  • Buffers: shared hit=199933
59. 100.294 100.294 ↓ 0.0 0 50,147

Index Scan using contact_reports_p2019_09_25_pkey on contact_reports_p2019_09_25 cr_50 (cost=0.56..8.58 rows=1 width=157) (actual time=0.002..0.002 rows=0 loops=50,147)

  • Index Cond: (cr_50.contact_id = i.last_contact_id)
  • Buffers: shared hit=199931
60. 100.288 100.288 ↓ 0.0 0 50,144

Index Scan using contact_reports_p2019_09_26_pkey on contact_reports_p2019_09_26 cr_51 (cost=0.56..8.58 rows=1 width=157) (actual time=0.002..0.002 rows=0 loops=50,144)

  • Index Cond: (cr_51.contact_id = i.last_contact_id)
  • Buffers: shared hit=199918
61. 100.284 100.284 ↓ 0.0 0 50,142

Index Scan using contact_reports_p2019_09_27_pkey on contact_reports_p2019_09_27 cr_52 (cost=0.56..8.58 rows=1 width=157) (actual time=0.002..0.002 rows=0 loops=50,142)

  • Index Cond: (cr_52.contact_id = i.last_contact_id)
  • Buffers: shared hit=199909
62. 100.282 100.282 ↓ 0.0 0 50,141

Index Scan using contact_reports_p2019_09_28_pkey on contact_reports_p2019_09_28 cr_53 (cost=0.56..8.58 rows=1 width=157) (actual time=0.002..0.002 rows=0 loops=50,141)

  • Index Cond: (cr_53.contact_id = i.last_contact_id)
  • Buffers: shared hit=199906
63. 100.278 100.278 ↓ 0.0 0 50,139

Index Scan using contact_reports_p2019_09_29_pkey on contact_reports_p2019_09_29 cr_54 (cost=0.56..8.58 rows=1 width=157) (actual time=0.002..0.002 rows=0 loops=50,139)

  • Index Cond: (cr_54.contact_id = i.last_contact_id)
  • Buffers: shared hit=199898
64. 100.274 100.274 ↓ 0.0 0 50,137

Index Scan using contact_reports_p2019_09_30_pkey on contact_reports_p2019_09_30 cr_55 (cost=0.56..8.58 rows=1 width=157) (actual time=0.002..0.002 rows=0 loops=50,137)

  • Index Cond: (cr_55.contact_id = i.last_contact_id)
  • Buffers: shared hit=199889
65. 100.272 100.272 ↓ 0.0 0 50,136

Index Scan using contact_reports_p2019_10_01_pkey on contact_reports_p2019_10_01 cr_56 (cost=0.56..8.58 rows=1 width=157) (actual time=0.002..0.002 rows=0 loops=50,136)

  • Index Cond: (cr_56.contact_id = i.last_contact_id)
  • Buffers: shared hit=199887
66. 100.266 100.266 ↓ 0.0 0 50,133

Index Scan using contact_reports_p2019_10_02_pkey on contact_reports_p2019_10_02 cr_57 (cost=0.56..8.58 rows=1 width=157) (actual time=0.002..0.002 rows=0 loops=50,133)

  • Index Cond: (cr_57.contact_id = i.last_contact_id)
  • Buffers: shared hit=199874
67. 100.262 100.262 ↓ 0.0 0 50,131

Index Scan using contact_reports_p2019_10_03_pkey on contact_reports_p2019_10_03 cr_58 (cost=0.56..8.58 rows=1 width=157) (actual time=0.002..0.002 rows=0 loops=50,131)

  • Index Cond: (cr_58.contact_id = i.last_contact_id)
  • Buffers: shared hit=199869
68. 100.252 100.252 ↓ 0.0 0 50,126

Index Scan using contact_reports_p2019_10_04_pkey on contact_reports_p2019_10_04 cr_59 (cost=0.56..8.58 rows=1 width=157) (actual time=0.002..0.002 rows=0 loops=50,126)

  • Index Cond: (cr_59.contact_id = i.last_contact_id)
  • Buffers: shared hit=199848
69. 100.244 100.244 ↓ 0.0 0 50,122

Index Scan using contact_reports_p2019_10_05_pkey on contact_reports_p2019_10_05 cr_60 (cost=0.56..8.58 rows=1 width=157) (actual time=0.002..0.002 rows=0 loops=50,122)

  • Index Cond: (cr_60.contact_id = i.last_contact_id)
  • Buffers: shared hit=199830
70. 100.240 100.240 ↓ 0.0 0 50,120

Index Scan using contact_reports_p2019_10_06_pkey on contact_reports_p2019_10_06 cr_61 (cost=0.56..8.58 rows=1 width=157) (actual time=0.002..0.002 rows=0 loops=50,120)

  • Index Cond: (cr_61.contact_id = i.last_contact_id)
  • Buffers: shared hit=199820
71. 100.240 100.240 ↓ 0.0 0 50,120

Index Scan using contact_reports_p2019_10_07_pkey on contact_reports_p2019_10_07 cr_62 (cost=0.56..8.58 rows=1 width=157) (actual time=0.002..0.002 rows=0 loops=50,120)

  • Index Cond: (cr_62.contact_id = i.last_contact_id)
  • Buffers: shared hit=199823
72. 200.468 200.468 ↓ 0.0 0 50,117

Index Scan using contact_reports_p2019_10_08_pkey on contact_reports_p2019_10_08 cr_63 (cost=0.56..8.58 rows=1 width=157) (actual time=0.004..0.004 rows=0 loops=50,117)

  • Index Cond: (cr_63.contact_id = i.last_contact_id)
  • Buffers: shared hit=199808 read=3
73. 100.228 100.228 ↓ 0.0 0 50,114

Index Scan using contact_reports_p2019_10_09_pkey on contact_reports_p2019_10_09 cr_64 (cost=0.56..8.58 rows=1 width=157) (actual time=0.002..0.002 rows=0 loops=50,114)

  • Index Cond: (cr_64.contact_id = i.last_contact_id)
  • Buffers: shared hit=199796
74. 100.228 100.228 ↓ 0.0 0 50,114

Index Scan using contact_reports_p2019_10_10_pkey on contact_reports_p2019_10_10 cr_65 (cost=0.56..8.58 rows=1 width=157) (actual time=0.002..0.002 rows=0 loops=50,114)

  • Index Cond: (cr_65.contact_id = i.last_contact_id)
  • Buffers: shared hit=199801
75. 100.218 100.218 ↓ 0.0 0 50,109

Index Scan using contact_reports_p2019_10_11_pkey on contact_reports_p2019_10_11 cr_66 (cost=0.56..8.58 rows=1 width=157) (actual time=0.002..0.002 rows=0 loops=50,109)

  • Index Cond: (cr_66.contact_id = i.last_contact_id)
  • Buffers: shared hit=199778
76. 100.214 100.214 ↓ 0.0 0 50,107

Index Scan using contact_reports_p2019_10_12_pkey on contact_reports_p2019_10_12 cr_67 (cost=0.56..8.58 rows=1 width=157) (actual time=0.002..0.002 rows=0 loops=50,107)

  • Index Cond: (cr_67.contact_id = i.last_contact_id)
  • Buffers: shared hit=199771
77. 100.208 100.208 ↓ 0.0 0 50,104

Index Scan using contact_reports_p2019_10_13_pkey on contact_reports_p2019_10_13 cr_68 (cost=0.56..8.58 rows=1 width=157) (actual time=0.002..0.002 rows=0 loops=50,104)

  • Index Cond: (cr_68.contact_id = i.last_contact_id)
  • Buffers: shared hit=199760
78. 100.200 100.200 ↓ 0.0 0 50,100

Index Scan using contact_reports_p2019_10_14_pkey on contact_reports_p2019_10_14 cr_69 (cost=0.43..8.45 rows=1 width=157) (actual time=0.002..0.002 rows=0 loops=50,100)

  • Index Cond: (cr_69.contact_id = i.last_contact_id)
  • Buffers: shared hit=149805
79. 150.300 150.300 ↓ 0.0 0 50,100

Index Scan using contact_reports_p2019_10_15_pkey on contact_reports_p2019_10_15 cr_70 (cost=0.56..8.58 rows=1 width=157) (actual time=0.003..0.003 rows=0 loops=50,100)

  • Index Cond: (cr_70.contact_id = i.last_contact_id)
  • Buffers: shared hit=199786 read=3
80. 900.918 900.918 ↓ 0.0 0 50,051

Index Scan using contact_reports_p2019_10_16_pkey on contact_reports_p2019_10_16 cr_71 (cost=0.56..8.58 rows=1 width=157) (actual time=0.018..0.018 rows=0 loops=50,051)

  • Index Cond: (cr_71.contact_id = i.last_contact_id)
  • Buffers: shared hit=199746 read=23
81. 448.461 448.461 ↓ 0.0 0 49,829

Index Scan using contact_reports_p2019_10_17_pkey on contact_reports_p2019_10_17 cr_72 (cost=0.56..8.58 rows=1 width=157) (actual time=0.009..0.009 rows=0 loops=49,829)

  • Index Cond: (cr_72.contact_id = i.last_contact_id)
  • Buffers: shared hit=198814 read=11
82. 99.322 99.322 ↓ 0.0 0 49,661

Index Scan using contact_reports_p2019_10_18_pkey on contact_reports_p2019_10_18 cr_73 (cost=0.56..8.58 rows=1 width=157) (actual time=0.002..0.002 rows=0 loops=49,661)

  • Index Cond: (cr_73.contact_id = i.last_contact_id)
  • Buffers: shared hit=197987
83. 148.974 148.974 ↓ 0.0 0 49,658

Index Scan using contact_reports_p2019_10_19_pkey on contact_reports_p2019_10_19 cr_74 (cost=0.56..8.58 rows=1 width=157) (actual time=0.003..0.003 rows=0 loops=49,658)

  • Index Cond: (cr_74.contact_id = i.last_contact_id)
  • Buffers: shared hit=197977 read=1
84. 198.608 198.608 ↓ 0.0 0 49,652

Index Scan using contact_reports_p2019_10_20_pkey on contact_reports_p2019_10_20 cr_75 (cost=0.56..8.58 rows=1 width=157) (actual time=0.004..0.004 rows=0 loops=49,652)

  • Index Cond: (cr_75.contact_id = i.last_contact_id)
  • Buffers: shared hit=197947 read=3
85. 99.300 99.300 ↓ 0.0 0 49,650

Index Scan using contact_reports_p2019_10_21_pkey on contact_reports_p2019_10_21 cr_76 (cost=0.56..8.58 rows=1 width=157) (actual time=0.002..0.002 rows=0 loops=49,650)

  • Index Cond: (cr_76.contact_id = i.last_contact_id)
  • Buffers: shared hit=197945
86. 99.290 99.290 ↓ 0.0 0 49,645

Index Scan using contact_reports_p2019_10_22_pkey on contact_reports_p2019_10_22 cr_77 (cost=0.56..8.58 rows=1 width=157) (actual time=0.002..0.002 rows=0 loops=49,645)

  • Index Cond: (cr_77.contact_id = i.last_contact_id)
  • Buffers: shared hit=197925
87. 99.280 99.280 ↓ 0.0 0 49,640

Index Scan using contact_reports_p2019_10_23_pkey on contact_reports_p2019_10_23 cr_78 (cost=0.56..8.58 rows=1 width=157) (actual time=0.002..0.002 rows=0 loops=49,640)

  • Index Cond: (cr_78.contact_id = i.last_contact_id)
  • Buffers: shared hit=197905
88. 99.270 99.270 ↓ 0.0 0 49,635

Index Scan using contact_reports_p2019_10_24_pkey on contact_reports_p2019_10_24 cr_79 (cost=0.56..8.58 rows=1 width=157) (actual time=0.002..0.002 rows=0 loops=49,635)

  • Index Cond: (cr_79.contact_id = i.last_contact_id)
  • Buffers: shared hit=197884
89. 198.524 198.524 ↓ 0.0 0 49,631

Index Scan using contact_reports_p2019_10_25_pkey on contact_reports_p2019_10_25 cr_80 (cost=0.56..8.58 rows=1 width=157) (actual time=0.004..0.004 rows=0 loops=49,631)

  • Index Cond: (cr_80.contact_id = i.last_contact_id)
  • Buffers: shared hit=197867 read=3
90. 198.500 198.500 ↓ 0.0 0 49,625

Index Scan using contact_reports_p2019_10_26_pkey on contact_reports_p2019_10_26 cr_81 (cost=0.56..8.58 rows=1 width=157) (actual time=0.004..0.004 rows=0 loops=49,625)

  • Index Cond: (cr_81.contact_id = i.last_contact_id)
  • Buffers: shared hit=197842 read=3
91. 99.240 99.240 ↓ 0.0 0 49,620

Index Scan using contact_reports_p2019_10_27_pkey on contact_reports_p2019_10_27 cr_82 (cost=0.56..8.58 rows=1 width=157) (actual time=0.002..0.002 rows=0 loops=49,620)

  • Index Cond: (cr_82.contact_id = i.last_contact_id)
  • Buffers: shared hit=197822
92. 99.236 99.236 ↓ 0.0 0 49,618

Index Scan using contact_reports_p2019_10_28_pkey on contact_reports_p2019_10_28 cr_83 (cost=0.56..8.58 rows=1 width=157) (actual time=0.002..0.002 rows=0 loops=49,618)

  • Index Cond: (cr_83.contact_id = i.last_contact_id)
  • Buffers: shared hit=197818
93. 198.448 198.448 ↓ 0.0 0 49,612

Index Scan using contact_reports_p2019_10_29_pkey on contact_reports_p2019_10_29 cr_84 (cost=0.56..8.58 rows=1 width=157) (actual time=0.004..0.004 rows=0 loops=49,612)

  • Index Cond: (cr_84.contact_id = i.last_contact_id)
  • Buffers: shared hit=197789 read=4
94. 99.214 99.214 ↓ 0.0 0 49,607

Index Scan using contact_reports_p2019_10_30_pkey on contact_reports_p2019_10_30 cr_85 (cost=0.56..8.58 rows=1 width=157) (actual time=0.002..0.002 rows=0 loops=49,607)

  • Index Cond: (cr_85.contact_id = i.last_contact_id)
  • Buffers: shared hit=197776
95. 99.198 99.198 ↓ 0.0 0 49,599

Index Scan using contact_reports_p2019_10_31_pkey on contact_reports_p2019_10_31 cr_86 (cost=0.56..8.58 rows=1 width=157) (actual time=0.002..0.002 rows=0 loops=49,599)

  • Index Cond: (cr_86.contact_id = i.last_contact_id)
  • Buffers: shared hit=197746
96. 198.356 198.356 ↓ 0.0 0 49,589

Index Scan using contact_reports_p2019_11_01_pkey on contact_reports_p2019_11_01 cr_87 (cost=0.56..8.58 rows=1 width=157) (actual time=0.004..0.004 rows=0 loops=49,589)

  • Index Cond: (cr_87.contact_id = i.last_contact_id)
  • Buffers: shared hit=197702 read=3
97. 148.740 148.740 ↓ 0.0 0 49,580

Index Scan using contact_reports_p2019_11_02_pkey on contact_reports_p2019_11_02 cr_88 (cost=0.56..8.58 rows=1 width=157) (actual time=0.003..0.003 rows=0 loops=49,580)

  • Index Cond: (cr_88.contact_id = i.last_contact_id)
  • Buffers: shared hit=197671 read=3
98. 198.264 198.264 ↓ 0.0 0 49,566

Index Scan using contact_reports_p2019_11_03_pkey on contact_reports_p2019_11_03 cr_89 (cost=0.56..8.58 rows=1 width=157) (actual time=0.004..0.004 rows=0 loops=49,566)

  • Index Cond: (cr_89.contact_id = i.last_contact_id)
  • Buffers: shared hit=197613 read=3
99. 148.662 148.662 ↓ 0.0 0 49,554

Index Scan using contact_reports_p2019_11_04_pkey on contact_reports_p2019_11_04 cr_90 (cost=0.56..8.58 rows=1 width=157) (actual time=0.003..0.003 rows=0 loops=49,554)

  • Index Cond: (cr_90.contact_id = i.last_contact_id)
  • Buffers: shared hit=200948 read=132
100. 184.172 184.172 ↓ 0.0 0 46,043

Index Scan using contact_reports_p2019_11_05_pkey on contact_reports_p2019_11_05 cr_91 (cost=0.56..8.58 rows=1 width=157) (actual time=0.004..0.004 rows=0 loops=46,043)

  • Index Cond: (cr_91.contact_id = i.last_contact_id)
  • Buffers: shared hit=194532 read=165
101. 244.272 244.272 ↑ 1.0 1 34,896

Index Scan using contact_reports_p2019_11_06_pkey on contact_reports_p2019_11_06 cr_92 (cost=0.56..8.58 rows=1 width=157) (actual time=0.007..0.007 rows=1 loops=34,896)

  • Index Cond: (cr_92.contact_id = i.last_contact_id)
  • Buffers: shared hit=173522 read=224
102. 2.200 2.200 ↓ 0.0 0 200

Index Scan using contact_reports_p2019_11_07_pkey on contact_reports_p2019_11_07 cr_93 (cost=0.14..8.16 rows=1 width=157) (actual time=0.001..0.011 rows=0 loops=200)

  • Index Cond: (cr_93.contact_id = i.last_contact_id)
  • Buffers: shared hit=35
103. 2.400 2.400 ↓ 0.0 0 200

Index Scan using contact_reports_p2019_11_08_pkey on contact_reports_p2019_11_08 cr_94 (cost=0.14..8.16 rows=1 width=157) (actual time=0.001..0.012 rows=0 loops=200)

  • Index Cond: (cr_94.contact_id = i.last_contact_id)
  • Buffers: shared hit=35
104. 1.600 1.600 ↓ 0.0 0 200

Index Scan using contact_reports_p2019_11_09_pkey on contact_reports_p2019_11_09 cr_95 (cost=0.14..8.16 rows=1 width=157) (actual time=0.001..0.008 rows=0 loops=200)

  • Index Cond: (cr_95.contact_id = i.last_contact_id)
  • Buffers: shared hit=35
105. 1.400 1.400 ↓ 0.0 0 200

Index Scan using contact_reports_p2019_11_10_pkey on contact_reports_p2019_11_10 cr_96 (cost=0.14..8.16 rows=1 width=157) (actual time=0.001..0.007 rows=0 loops=200)

  • Index Cond: (cr_96.contact_id = i.last_contact_id)
  • Buffers: shared hit=35
106. 1.400 1.400 ↓ 0.0 0 200

Index Scan using contact_reports_p2019_11_11_pkey on contact_reports_p2019_11_11 cr_97 (cost=0.14..8.16 rows=1 width=157) (actual time=0.001..0.007 rows=0 loops=200)

  • Index Cond: (cr_97.contact_id = i.last_contact_id)
  • Buffers: shared hit=35
107. 2.000 2.000 ↓ 0.0 0 200

Index Scan using contact_reports_default_pkey on contact_reports_default cr_98 (cost=0.14..8.16 rows=1 width=157) (actual time=0.001..0.01 rows=0 loops=200)

  • Index Cond: (cr_98.contact_id = i.last_contact_id)
  • Buffers: shared hit=35
Planning time : 21.437 ms
Execution time : 13,089.383 ms