explain.depesz.com

PostgreSQL's explain analyze made readable

Result: U2x4 : tmi

Settings
# exclusive inclusive rows x rows loops node
1. 2,021.078 112,882,535.095 ↓ 35,701.0 35,701 1

Nested Loop (cost=3,660,205.85..4,374,539.60 rows=1 width=416) (actual time=35,383.019..112,882,535.095 rows=35,701 loops=1)

2. 151,598.476 110,010,108.037 ↓ 64,865.0 64,865 1

Nested Loop (cost=3,660,205.43..4,374,430.38 rows=1 width=405) (actual time=35,279.905..110,010,108.037 rows=64,865 loops=1)

3. 40,090.331 78,205.284 ↓ 2,086,959.0 2,086,959 1

Gather (cost=3,660,205.00..4,373,851.24 rows=1 width=121) (actual time=30,874.253..78,205.284 rows=2,086,959 loops=1)

  • Workers Planned: 6
  • Workers Launched: 6
4. 4,374.184 38,114.953 ↓ 298,137.0 298,137 7

Hash Anti Join (cost=3,659,455.00..4,373,101.14 rows=1 width=121) (actual time=30,864.770..38,114.953 rows=298,137 loops=7)

  • Hash Cond: (pfe.response_id = lr.raw_lead_id)
5. 3,374.158 3,374.158 ↑ 1.2 2,145,408 7

Parallel Seq Scan on page_form_events pfe (cost=0.00..566,606.93 rows=2,502,795 width=121) (actual time=0.020..3,374.158 rows=2,145,408 loops=7)

  • Filter: ((element_type)::text = ANY ('{phone,email}'::text[]))
  • Rows Removed by Filter: 13
6. 19,477.543 30,366.611 ↓ 1.0 44,558,760 7

Hash (cost=3,103,138.89..3,103,138.89 rows=44,505,289 width=16) (actual time=30,366.611..30,366.611 rows=44,558,760 loops=7)

  • Buckets: 67108864 Batches: 1 Memory Usage: 2612980kB
7. 10,889.068 10,889.068 ↓ 1.0 44,558,760 7

Seq Scan on leads_raw lr (cost=0.00..3,103,138.89 rows=44,505,289 width=16) (actual time=0.142..10,889.068 rows=44,558,760 loops=7)

8. 738,783.486 109,780,304.277 ↓ 0.0 0 2,086,959

Append (cost=0.42..576.52 rows=261 width=284) (actual time=51.817..52.603 rows=0 loops=2,086,959)

9. 93,913.155 93,913.155 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2015_04_new_response_id_idx on web_responses_2015_04 (cost=0.42..2.19 rows=1 width=255) (actual time=0.045..0.045 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
10. 93,913.155 93,913.155 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2015_05_new_response_id_idx on web_responses_2015_05 (cost=0.42..2.19 rows=1 width=256) (actual time=0.045..0.045 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
11. 91,826.196 91,826.196 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2015_06_new_response_id_idx on web_responses_2015_06 (cost=0.42..2.19 rows=1 width=260) (actual time=0.044..0.044 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
12. 114,782.745 114,782.745 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2015_07_new_response_id_idx on web_responses_2015_07 (cost=0.42..2.19 rows=1 width=264) (actual time=0.055..0.055 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
13. 152,348.007 152,348.007 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2015_08_new_response_id_idx on web_responses_2015_08 (cost=0.43..2.19 rows=1 width=270) (actual time=0.073..0.073 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
14. 156,521.925 156,521.925 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2015_09_new_response_id_idx on web_responses_2015_09 (cost=0.43..2.19 rows=1 width=279) (actual time=0.075..0.075 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
15. 179,478.474 179,478.474 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2015_10_new_response_id_idx on web_responses_2015_10 (cost=0.43..2.19 rows=1 width=279) (actual time=0.086..0.086 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
16. 321,391.686 321,391.686 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2015_11_new_response_id_idx on web_responses_2015_11 (cost=0.43..2.20 rows=1 width=256) (actual time=0.154..0.154 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
17. 409,043.964 409,043.964 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2015_12_new_response_id_idx on web_responses_2015_12 (cost=0.43..2.20 rows=1 width=252) (actual time=0.196..0.196 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
18. 505,044.078 505,044.078 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2016_01_new_response_id_idx on web_responses_2016_01 (cost=0.43..2.20 rows=1 width=250) (actual time=0.242..0.242 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
19. 544,696.299 544,696.299 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2016_02_new_response_id_idx on web_responses_2016_02 (cost=0.43..2.20 rows=1 width=248) (actual time=0.261..0.261 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
20. 617,739.864 617,739.864 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2016_03_new_response_id_idx on web_responses_2016_03 (cost=0.56..2.33 rows=1 width=245) (actual time=0.296..0.296 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
21. 649,044.249 649,044.249 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2016_04_new_response_id_idx on web_responses_2016_04 (cost=0.56..2.33 rows=1 width=248) (actual time=0.311..0.311 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
22. 667,826.880 667,826.880 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2016_05_new_response_id_idx on web_responses_2016_05 (cost=0.56..2.33 rows=1 width=249) (actual time=0.320..0.320 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
23. 667,826.880 667,826.880 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2016_06_new_response_id_idx on web_responses_2016_06 (cost=0.56..2.33 rows=1 width=250) (actual time=0.320..0.320 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
24. 730,435.650 730,435.650 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2016_07_new_response_id_idx on web_responses_2016_07 (cost=0.56..2.33 rows=1 width=246) (actual time=0.350..0.350 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
25. 563,478.930 563,478.930 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2016_08_new_response_id_idx on web_responses_2016_08 (cost=0.56..2.33 rows=1 width=258) (actual time=0.270..0.270 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
26. 406,957.005 406,957.005 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2016_09_new_response_id_idx on web_responses_2016_09 (cost=0.43..2.20 rows=1 width=275) (actual time=0.195..0.195 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
27. 611,478.987 611,478.987 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2016_10_new_response_id_idx on web_responses_2016_10 (cost=0.56..2.33 rows=1 width=283) (actual time=0.293..0.293 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
28. 676,174.716 676,174.716 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2016_11_new_response_id_idx on web_responses_2016_11 (cost=0.56..2.33 rows=1 width=281) (actual time=0.324..0.324 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
29. 690,783.429 690,783.429 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2016_12_new_response_id_idx on web_responses_2016_12 (cost=0.56..2.33 rows=1 width=281) (actual time=0.331..0.331 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
30. 918,261.960 918,261.960 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2017_01_new_response_id_idx on web_responses_2017_01 (cost=0.56..2.33 rows=1 width=279) (actual time=0.440..0.440 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
31. 836,870.559 836,870.559 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2017_02_new_response_id_idx on web_responses_2017_02 (cost=0.56..2.33 rows=1 width=275) (actual time=0.401..0.401 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
32. 801,392.256 801,392.256 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2017_03_new_response_id_idx on web_responses_2017_03 (cost=0.56..2.33 rows=1 width=273) (actual time=0.384..0.384 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
33. 697,044.306 697,044.306 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2017_04_new_response_id_idx on web_responses_2017_04 (cost=0.56..2.33 rows=1 width=280) (actual time=0.334..0.334 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
34. 682,435.593 682,435.593 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2017_05_new_response_id_idx on web_responses_2017_05 (cost=0.56..2.33 rows=1 width=285) (actual time=0.327..0.327 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
35. 694,957.347 694,957.347 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2017_06_new_response_id_idx on web_responses_2017_06 (cost=0.56..2.33 rows=1 width=288) (actual time=0.333..0.333 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
36. 784,696.584 784,696.584 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2017_07_new_response_id_idx on web_responses_2017_07 (cost=0.56..2.33 rows=1 width=286) (actual time=0.376..0.376 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
37. 828,522.723 828,522.723 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2017_08_new_response_id_idx on web_responses_2017_08 (cost=0.56..2.33 rows=1 width=285) (actual time=0.397..0.397 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
38. 788,870.502 788,870.502 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2017_09_new_response_id_idx on web_responses_2017_09 (cost=0.56..2.33 rows=1 width=287) (actual time=0.378..0.378 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
39. 834,783.600 834,783.600 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2017_10_new_response_id_idx on web_responses_2017_10 (cost=0.56..2.33 rows=1 width=279) (actual time=0.400..0.400 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
40. 768,000.912 768,000.912 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2017_11_new_response_id_idx on web_responses_2017_11 (cost=0.56..2.33 rows=1 width=279) (actual time=0.368..0.368 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
41. 734,609.568 734,609.568 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2017_12_new_response_id_idx on web_responses_2017_12 (cost=0.56..2.33 rows=1 width=279) (actual time=0.352..0.352 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
42. 10,434.795 10,434.795 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2017_26_cars_new_response_id_idx on web_responses_2017_26_cars (cost=0.29..2.04 rows=1 width=225) (actual time=0.005..0.005 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
43. 58,434.852 58,434.852 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2017_26_edmunds_new_response_id_idx on web_responses_2017_26_edmunds (cost=0.42..2.19 rows=1 width=282) (actual time=0.028..0.028 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
44. 10,434.795 10,434.795 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2017_27_cars_new_response_id_idx on web_responses_2017_27_cars (cost=0.28..2.04 rows=1 width=226) (actual time=0.005..0.005 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
45. 56,347.893 56,347.893 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2017_27_edmunds_new_response_id_idx on web_responses_2017_27_edmunds (cost=0.42..2.19 rows=1 width=281) (actual time=0.027..0.027 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
46. 10,434.795 10,434.795 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2017_28_cars_new_response_id_idx on web_responses_2017_28_cars (cost=0.29..2.05 rows=1 width=227) (actual time=0.005..0.005 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
47. 60,521.811 60,521.811 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2017_28_edmunds_new_response_id_idx on web_responses_2017_28_edmunds (cost=0.42..2.19 rows=1 width=285) (actual time=0.029..0.029 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
48. 315,130.809 315,130.809 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2017_29_cars_new_response_id_idx on web_responses_2017_29_cars (cost=0.43..2.20 rows=1 width=276) (actual time=0.151..0.151 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
49. 96,000.114 96,000.114 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2017_29_edmunds_new_response_id_idx on web_responses_2017_29_edmunds (cost=0.42..2.19 rows=1 width=291) (actual time=0.046..0.046 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
50. 638,609.454 638,609.454 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2017_30_cars_new_response_id_idx on web_responses_2017_30_cars (cost=0.56..2.33 rows=1 width=275) (actual time=0.306..0.306 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
51. 93,913.155 93,913.155 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2017_30_edmunds_new_response_id_idx on web_responses_2017_30_edmunds (cost=0.42..2.19 rows=1 width=291) (actual time=0.045..0.045 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
52. 624,000.741 624,000.741 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2017_31_cars_new_response_id_idx on web_responses_2017_31_cars (cost=0.56..2.33 rows=1 width=276) (actual time=0.299..0.299 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
53. 85,565.319 85,565.319 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2017_31_edmunds_new_response_id_idx on web_responses_2017_31_edmunds (cost=0.42..2.19 rows=1 width=284) (actual time=0.041..0.041 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
54. 632,348.577 632,348.577 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2017_32_cars_new_response_id_idx on web_responses_2017_32_cars (cost=0.56..2.33 rows=1 width=274) (actual time=0.303..0.303 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
55. 81,391.401 81,391.401 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2017_32_edmunds_new_response_id_idx on web_responses_2017_32_edmunds (cost=0.42..2.19 rows=1 width=283) (actual time=0.039..0.039 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
56. 619,826.823 619,826.823 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2017_33_cars_new_response_id_idx on web_responses_2017_33_cars (cost=0.56..2.33 rows=1 width=272) (actual time=0.297..0.297 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
57. 68,869.647 68,869.647 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2017_33_edmunds_new_response_id_idx on web_responses_2017_33_edmunds (cost=0.42..2.19 rows=1 width=284) (actual time=0.033..0.033 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
58. 617,739.864 617,739.864 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2017_34_cars_new_response_id_idx on web_responses_2017_34_cars (cost=0.56..2.33 rows=1 width=273) (actual time=0.296..0.296 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
59. 60,521.811 60,521.811 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2017_34_edmunds_new_response_id_idx on web_responses_2017_34_edmunds (cost=0.42..2.19 rows=1 width=285) (actual time=0.029..0.029 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
60. 611,478.987 611,478.987 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2017_35_cars_new_response_id_idx on web_responses_2017_35_cars (cost=0.56..2.33 rows=1 width=273) (actual time=0.293..0.293 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
61. 60,521.811 60,521.811 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2017_35_edmunds_new_response_id_idx on web_responses_2017_35_edmunds (cost=0.42..2.19 rows=1 width=284) (actual time=0.029..0.029 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
62. 605,218.110 605,218.110 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2017_36_cars_new_response_id_idx on web_responses_2017_36_cars (cost=0.56..2.33 rows=1 width=274) (actual time=0.290..0.290 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
63. 58,434.852 58,434.852 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2017_36_edmunds_new_response_id_idx on web_responses_2017_36_edmunds (cost=0.42..2.19 rows=1 width=284) (actual time=0.028..0.028 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
64. 611,478.987 611,478.987 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2017_37_cars_new_response_id_idx on web_responses_2017_37_cars (cost=0.56..2.33 rows=1 width=273) (actual time=0.293..0.293 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
65. 56,347.893 56,347.893 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2017_37_edmunds_new_response_id_idx on web_responses_2017_37_edmunds (cost=0.42..2.19 rows=1 width=283) (actual time=0.027..0.027 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
66. 617,739.864 617,739.864 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2017_38_cars_new_response_id_idx on web_responses_2017_38_cars (cost=0.56..2.33 rows=1 width=273) (actual time=0.296..0.296 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
67. 60,521.811 60,521.811 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2017_38_edmunds_new_response_id_idx on web_responses_2017_38_edmunds (cost=0.42..2.19 rows=1 width=284) (actual time=0.029..0.029 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
68. 617,739.864 617,739.864 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2017_39_cars_new_response_id_idx on web_responses_2017_39_cars (cost=0.56..2.33 rows=1 width=276) (actual time=0.296..0.296 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
69. 62,608.770 62,608.770 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2017_39_edmunds_new_response_id_idx on web_responses_2017_39_edmunds (cost=0.42..2.19 rows=1 width=285) (actual time=0.030..0.030 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
70. 603,131.151 603,131.151 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2017_40_cars_new_response_id_idx on web_responses_2017_40_cars (cost=0.56..2.33 rows=1 width=275) (actual time=0.289..0.289 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
71. 60,521.811 60,521.811 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2017_40_edmunds_new_response_id_idx on web_responses_2017_40_edmunds (cost=0.42..2.19 rows=1 width=284) (actual time=0.029..0.029 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
72. 603,131.151 603,131.151 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2017_41_cars_new_response_id_idx on web_responses_2017_41_cars (cost=0.56..2.33 rows=1 width=275) (actual time=0.289..0.289 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
73. 75,130.524 75,130.524 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2017_41_edmunds_new_response_id_idx on web_responses_2017_41_edmunds (cost=0.42..2.19 rows=1 width=281) (actual time=0.036..0.036 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
74. 611,478.987 611,478.987 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2017_42_cars_new_response_id_idx on web_responses_2017_42_cars (cost=0.56..2.33 rows=1 width=269) (actual time=0.293..0.293 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
75. 100,174.032 100,174.032 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2017_42_edmunds_new_response_id_idx on web_responses_2017_42_edmunds (cost=0.42..2.19 rows=1 width=273) (actual time=0.048..0.048 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
76. 617,739.864 617,739.864 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2017_43_cars_new_response_id_idx on web_responses_2017_43_cars (cost=0.56..2.33 rows=1 width=261) (actual time=0.296..0.296 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
77. 93,913.155 93,913.155 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2017_43_edmunds_new_response_id_idx on web_responses_2017_43_edmunds (cost=0.42..2.19 rows=1 width=272) (actual time=0.045..0.045 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
78. 605,218.110 605,218.110 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2017_44_cars_new_response_id_idx on web_responses_2017_44_cars (cost=0.56..2.33 rows=1 width=260) (actual time=0.290..0.290 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
79. 60,521.811 60,521.811 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2017_44_edmunds_new_response_id_idx on web_responses_2017_44_edmunds (cost=0.42..2.19 rows=1 width=273) (actual time=0.029..0.029 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
80. 613,565.946 613,565.946 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2017_45_cars_new_response_id_idx on web_responses_2017_45_cars (cost=0.56..2.33 rows=1 width=261) (actual time=0.294..0.294 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
81. 56,347.893 56,347.893 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2017_45_edmunds_new_response_id_idx on web_responses_2017_45_edmunds (cost=0.42..2.19 rows=1 width=272) (actual time=0.027..0.027 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
82. 619,826.823 619,826.823 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2017_46_cars_new_response_id_idx on web_responses_2017_46_cars (cost=0.56..2.33 rows=1 width=261) (actual time=0.297..0.297 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
83. 56,347.893 56,347.893 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2017_46_edmunds_new_response_id_idx on web_responses_2017_46_edmunds (cost=0.42..2.19 rows=1 width=272) (actual time=0.027..0.027 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
84. 596,870.274 596,870.274 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2017_47_cars_new_response_id_idx on web_responses_2017_47_cars (cost=0.56..2.33 rows=1 width=260) (actual time=0.286..0.286 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
85. 56,347.893 56,347.893 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2017_47_edmunds_new_response_id_idx on web_responses_2017_47_edmunds (cost=0.42..2.19 rows=1 width=273) (actual time=0.027..0.027 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
86. 603,131.151 603,131.151 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2017_48_cars_new_response_id_idx on web_responses_2017_48_cars (cost=0.56..2.33 rows=1 width=259) (actual time=0.289..0.289 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
87. 56,347.893 56,347.893 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2017_48_edmunds_new_response_id_idx on web_responses_2017_48_edmunds (cost=0.42..2.19 rows=1 width=270) (actual time=0.027..0.027 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
88. 596,870.274 596,870.274 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2017_49_cars_new_response_id_idx on web_responses_2017_49_cars (cost=0.56..2.33 rows=1 width=260) (actual time=0.286..0.286 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
89. 58,434.852 58,434.852 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2017_49_edmunds_new_response_id_idx on web_responses_2017_49_edmunds (cost=0.42..2.19 rows=1 width=270) (actual time=0.028..0.028 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
90. 588,522.438 588,522.438 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2017_50_cars_new_response_id_idx on web_responses_2017_50_cars (cost=0.56..2.33 rows=1 width=260) (actual time=0.282..0.282 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
91. 58,434.852 58,434.852 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2017_50_edmunds_new_response_id_idx on web_responses_2017_50_edmunds (cost=0.42..2.19 rows=1 width=271) (actual time=0.028..0.028 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
92. 594,783.315 594,783.315 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2017_51_cars_new_response_id_idx on web_responses_2017_51_cars (cost=0.56..2.33 rows=1 width=261) (actual time=0.285..0.285 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
93. 58,434.852 58,434.852 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2017_51_edmunds_new_response_id_idx on web_responses_2017_51_edmunds (cost=0.42..2.19 rows=1 width=270) (actual time=0.028..0.028 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
94. 605,218.110 605,218.110 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2017_52_cars_new_response_id_idx on web_responses_2017_52_cars (cost=0.56..2.33 rows=1 width=262) (actual time=0.290..0.290 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
95. 58,434.852 58,434.852 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2017_52_edmunds_new_response_id_idx on web_responses_2017_52_edmunds (cost=0.42..2.19 rows=1 width=270) (actual time=0.028..0.028 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
96. 751,305.240 751,305.240 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2018_01_new_response_id_idx on web_responses_2018_01 (cost=0.56..2.33 rows=1 width=278) (actual time=0.360..0.360 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
97. 580,174.602 580,174.602 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2018_01_cars_new_response_id_idx on web_responses_2018_01_cars (cost=0.56..2.33 rows=1 width=262) (actual time=0.278..0.278 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
98. 141,913.212 141,913.212 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2018_01_edmunds_new_response_id_idx on web_responses_2018_01_edmunds (cost=0.43..2.19 rows=1 width=270) (actual time=0.068..0.068 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
99. 738,783.486 738,783.486 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2018_02_new_response_id_idx on web_responses_2018_02 (cost=0.56..2.33 rows=1 width=280) (actual time=0.354..0.354 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
100. 605,218.110 605,218.110 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2018_02_cars_new_response_id_idx on web_responses_2018_02_cars (cost=0.56..2.33 rows=1 width=262) (actual time=0.290..0.290 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
101. 369,391.743 369,391.743 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2018_02_edmunds_new_response_id_idx on web_responses_2018_02_edmunds (cost=0.43..2.20 rows=1 width=271) (actual time=0.177..0.177 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
102. 843,131.436 843,131.436 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2018_03_new_response_id_idx on web_responses_2018_03 (cost=0.56..2.33 rows=1 width=285) (actual time=0.404..0.404 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
103. 619,826.823 619,826.823 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2018_03_cars_new_response_id_idx on web_responses_2018_03_cars (cost=0.56..2.33 rows=1 width=263) (actual time=0.297..0.297 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
104. 373,565.661 373,565.661 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2018_03_edmunds_new_response_id_idx on web_responses_2018_03_edmunds (cost=0.43..2.20 rows=1 width=272) (actual time=0.179..0.179 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
105. 757,566.117 757,566.117 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2018_04_new_response_id_idx on web_responses_2018_04 (cost=0.56..2.33 rows=1 width=293) (actual time=0.363..0.363 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
106. 634,435.536 634,435.536 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2018_04_cars_new_response_id_idx on web_responses_2018_04_cars (cost=0.56..2.33 rows=1 width=263) (actual time=0.304..0.304 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
107. 417,391.800 417,391.800 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2018_04_edmunds_new_response_id_idx on web_responses_2018_04_edmunds (cost=0.43..2.20 rows=1 width=272) (actual time=0.200..0.200 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
108. 692,870.388 692,870.388 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2018_05_response_id_idx on web_responses_2018_05 (cost=0.56..2.33 rows=1 width=291) (actual time=0.332..0.332 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
109. 653,218.167 653,218.167 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2018_05_cars_new_response_id_idx on web_responses_2018_05_cars (cost=0.56..2.33 rows=1 width=263) (actual time=0.313..0.313 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
110. 415,304.841 415,304.841 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2018_05_edmunds_new_response_id_idx on web_responses_2018_05_edmunds (cost=0.43..2.20 rows=1 width=272) (actual time=0.199..0.199 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
111. 686,609.511 686,609.511 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2018_06_response_id_idx on web_responses_2018_06 (cost=0.56..2.33 rows=1 width=290) (actual time=0.329..0.329 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
112. 638,609.454 638,609.454 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2018_06_cars_new_response_id_idx1 on web_responses_2018_06_cars (cost=0.56..2.33 rows=1 width=264) (actual time=0.306..0.306 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
113. 331,826.481 331,826.481 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2018_06_edmunds_new_response_id_idx on web_responses_2018_06_edmunds (cost=0.43..2.20 rows=1 width=270) (actual time=0.159..0.159 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
114. 715,826.937 715,826.937 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2018_07_response_id_idx on web_responses_2018_07 (cost=0.56..2.33 rows=1 width=293) (actual time=0.343..0.343 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
115. 644,870.331 644,870.331 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2018_07_cars_new_response_id_idx on web_responses_2018_07_cars (cost=0.56..2.33 rows=1 width=264) (actual time=0.309..0.309 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
116. 377,739.579 377,739.579 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2018_07_edmunds_new_response_id_idx on web_responses_2018_07_edmunds (cost=0.43..2.20 rows=1 width=269) (actual time=0.181..0.181 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
117. 734,609.568 734,609.568 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2018_08_response_id_idx on web_responses_2018_08 (cost=0.56..2.33 rows=1 width=294) (actual time=0.352..0.352 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
118. 669,913.839 669,913.839 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2018_08_cars_new_response_id_idx on web_responses_2018_08_cars (cost=0.56..2.33 rows=1 width=265) (actual time=0.321..0.321 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
119. 400,696.128 400,696.128 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2018_08_edmunds_new_response_id_idx on web_responses_2018_08_edmunds (cost=0.43..2.20 rows=1 width=273) (actual time=0.192..0.192 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
120. 876,522.780 876,522.780 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2018_09_response_id_idx on web_responses_2018_09 (cost=0.56..2.33 rows=1 width=290) (actual time=0.420..0.420 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
121. 646,957.290 646,957.290 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2018_09_cars_new_response_id_idx on web_responses_2018_09_cars (cost=0.56..2.33 rows=1 width=263) (actual time=0.309..0.310 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
122. 381,913.497 381,913.497 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2018_09_edmunds_new_response_id_idx on web_responses_2018_09_edmunds (cost=0.43..2.20 rows=1 width=273) (actual time=0.183..0.183 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
123. 824,348.805 824,348.805 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2018_10_response_id_idx on web_responses_2018_10 (cost=0.56..2.33 rows=1 width=284) (actual time=0.395..0.395 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
124. 657,392.085 657,392.085 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2018_10_cars_new_response_id_idx on web_responses_2018_10_cars (cost=0.56..2.33 rows=1 width=268) (actual time=0.315..0.315 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
125. 304,696.014 304,696.014 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2018_10_edmunds_new_response_id_idx on web_responses_2018_10_edmunds (cost=0.43..2.20 rows=1 width=272) (actual time=0.146..0.146 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
126. 845,218.395 845,218.395 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2018_11_response_id_idx on web_responses_2018_11 (cost=0.56..2.33 rows=1 width=277) (actual time=0.405..0.405 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
127. 659,479.044 659,479.044 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2018_11_cars_new_response_id_idx on web_responses_2018_11_cars (cost=0.56..2.33 rows=1 width=267) (actual time=0.316..0.316 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
128. 298,435.137 298,435.137 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2018_11_edmunds_new_response_id_idx on web_responses_2018_11_edmunds (cost=0.43..2.20 rows=1 width=271) (actual time=0.143..0.143 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
129. 845,218.395 845,218.395 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2018_12_response_id_idx on web_responses_2018_12 (cost=0.56..2.33 rows=1 width=278) (actual time=0.405..0.405 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
130. 661,566.003 661,566.003 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2018_12_cars_new_response_id_idx on web_responses_2018_12_cars (cost=0.56..2.33 rows=1 width=266) (actual time=0.317..0.317 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
131. 290,087.301 290,087.301 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2018_12_edmunds_new_response_id_idx on web_responses_2018_12_edmunds (cost=0.43..2.20 rows=1 width=274) (actual time=0.139..0.139 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
132. 653,218.167 653,218.167 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2018_13_cars_new_response_id_idx on web_responses_2018_13_cars (cost=0.56..2.33 rows=1 width=267) (actual time=0.313..0.313 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
133. 271,304.670 271,304.670 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2018_13_edmunds_new_response_id_idx on web_responses_2018_13_edmunds (cost=0.43..2.20 rows=1 width=271) (actual time=0.130..0.130 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
134. 659,479.044 659,479.044 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2018_14_cars_new_response_id_idx on web_responses_2018_14_cars (cost=0.56..2.33 rows=1 width=268) (actual time=0.316..0.316 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
135. 277,565.547 277,565.547 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2018_14_edmunds_new_response_id_idx on web_responses_2018_14_edmunds (cost=0.43..2.20 rows=1 width=271) (actual time=0.133..0.133 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
136. 669,913.839 669,913.839 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2018_15_cars_new_response_id_idx on web_responses_2018_15_cars (cost=0.56..2.33 rows=1 width=268) (actual time=0.321..0.321 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
137. 256,695.957 256,695.957 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2018_15_edmunds_new_response_id_idx on web_responses_2018_15_edmunds (cost=0.43..2.20 rows=1 width=271) (actual time=0.123..0.123 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
138. 659,479.044 659,479.044 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2018_16_cars_new_response_id_idx on web_responses_2018_16_cars (cost=0.56..2.33 rows=1 width=268) (actual time=0.316..0.316 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
139. 252,522.039 252,522.039 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2018_16_edmunds_new_response_id_idx on web_responses_2018_16_edmunds (cost=0.43..2.20 rows=1 width=271) (actual time=0.121..0.121 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
140. 646,957.290 646,957.290 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2018_17_cars_new_response_id_idx on web_responses_2018_17_cars (cost=0.56..2.33 rows=1 width=265) (actual time=0.310..0.310 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
141. 317,217.768 317,217.768 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2018_17_edmunds_new_response_id_idx on web_responses_2018_17_edmunds (cost=0.43..2.20 rows=1 width=272) (actual time=0.152..0.152 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
142. 638,609.454 638,609.454 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2018_18_cars_response_id_idx on web_responses_2018_18_cars (cost=0.56..2.33 rows=1 width=266) (actual time=0.306..0.306 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
143. 283,826.424 283,826.424 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2018_18_edmunds_response_id_idx on web_responses_2018_18_edmunds (cost=0.43..2.20 rows=1 width=273) (actual time=0.136..0.136 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
144. 717,913.896 717,913.896 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2018_19_cars_response_id_idx on web_responses_2018_19_cars (cost=0.56..2.33 rows=1 width=266) (actual time=0.344..0.344 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
145. 294,261.219 294,261.219 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2018_19_edmunds_response_id_idx on web_responses_2018_19_edmunds (cost=0.43..2.20 rows=1 width=274) (actual time=0.141..0.141 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
146. 692,870.388 692,870.388 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2018_20_cars_response_id_idx on web_responses_2018_20_cars (cost=0.56..2.33 rows=1 width=270) (actual time=0.332..0.332 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
147. 296,348.178 296,348.178 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2018_20_edmunds_response_id_idx on web_responses_2018_20_edmunds (cost=0.43..2.20 rows=1 width=279) (actual time=0.142..0.142 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
148. 669,913.839 669,913.839 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2018_21_cars_response_id_idx on web_responses_2018_21_cars (cost=0.56..2.33 rows=1 width=277) (actual time=0.321..0.321 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
149. 290,087.301 290,087.301 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2018_21_edmunds_response_id_idx on web_responses_2018_21_edmunds (cost=0.43..2.20 rows=1 width=281) (actual time=0.139..0.139 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
150. 642,783.372 642,783.372 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2018_22_cars_response_id_idx on web_responses_2018_22_cars (cost=0.56..2.33 rows=1 width=273) (actual time=0.308..0.308 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
151. 250,435.080 250,435.080 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2018_22_edmunds_response_id_idx on web_responses_2018_22_edmunds (cost=0.43..2.20 rows=1 width=280) (actual time=0.120..0.120 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
152. 720,000.855 720,000.855 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2018_23_cars_response_id_idx on web_responses_2018_23_cars (cost=0.56..2.33 rows=1 width=270) (actual time=0.345..0.345 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
153. 281,739.465 281,739.465 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2018_23_edmunds_response_id_idx on web_responses_2018_23_edmunds (cost=0.43..2.20 rows=1 width=281) (actual time=0.135..0.135 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
154. 705,392.142 705,392.142 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2018_24_cars_response_id_idx on web_responses_2018_24_cars (cost=0.56..2.33 rows=1 width=270) (actual time=0.338..0.338 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
155. 277,565.547 277,565.547 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2018_24_edmunds_response_id_idx on web_responses_2018_24_edmunds (cost=0.43..2.20 rows=1 width=282) (actual time=0.133..0.133 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
156. 707,479.101 707,479.101 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2018_25_cars_response_id_idx on web_responses_2018_25_cars (cost=0.56..2.33 rows=1 width=271) (actual time=0.339..0.339 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
157. 294,261.219 294,261.219 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2018_25_edmunds_response_id_idx on web_responses_2018_25_edmunds (cost=0.43..2.20 rows=1 width=283) (actual time=0.141..0.141 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
158. 713,739.978 713,739.978 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2018_26_cars_response_id_idx on web_responses_2018_26_cars (cost=0.56..2.33 rows=1 width=269) (actual time=0.342..0.342 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
159. 300,522.096 300,522.096 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2018_26_edmunds_response_id_idx on web_responses_2018_26_edmunds (cost=0.43..2.20 rows=1 width=286) (actual time=0.144..0.144 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
160. 667,826.880 667,826.880 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2018_27_cars_response_id_idx on web_responses_2018_27_cars (cost=0.56..2.33 rows=1 width=269) (actual time=0.320..0.320 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
161. 302,609.055 302,609.055 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2018_27_edmunds_response_id_idx on web_responses_2018_27_edmunds (cost=0.43..2.20 rows=1 width=279) (actual time=0.145..0.145 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
162. 682,435.593 682,435.593 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2018_28_cars_response_id_idx on web_responses_2018_28_cars (cost=0.56..2.33 rows=1 width=268) (actual time=0.327..0.327 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
163. 300,522.096 300,522.096 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2018_28_edmunds_response_id_idx on web_responses_2018_28_edmunds (cost=0.43..2.20 rows=1 width=279) (actual time=0.144..0.144 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
164. 688,696.470 688,696.470 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2018_29_cars_response_id_idx on web_responses_2018_29_cars (cost=0.56..2.33 rows=1 width=269) (actual time=0.330..0.330 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
165. 300,522.096 300,522.096 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2018_29_edmunds_response_id_idx on web_responses_2018_29_edmunds (cost=0.43..2.20 rows=1 width=278) (actual time=0.144..0.144 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
166. 692,870.388 692,870.388 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2018_30_cars_response_id_idx on web_responses_2018_30_cars (cost=0.56..2.33 rows=1 width=270) (actual time=0.332..0.332 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
167. 298,435.137 298,435.137 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2018_30_edmunds_response_id_idx on web_responses_2018_30_edmunds (cost=0.43..2.20 rows=1 width=282) (actual time=0.143..0.143 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
168. 697,044.306 697,044.306 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2018_31_cars_response_id_idx on web_responses_2018_31_cars (cost=0.56..2.33 rows=1 width=271) (actual time=0.334..0.334 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
169. 296,348.178 296,348.178 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2018_31_edmunds_response_id_idx on web_responses_2018_31_edmunds (cost=0.43..2.20 rows=1 width=284) (actual time=0.142..0.142 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
170. 705,392.142 705,392.142 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2018_32_cars_response_id_idx on web_responses_2018_32_cars (cost=0.56..2.33 rows=1 width=272) (actual time=0.338..0.338 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
171. 298,435.137 298,435.137 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2018_32_edmunds_response_id_idx on web_responses_2018_32_edmunds (cost=0.43..2.20 rows=1 width=290) (actual time=0.143..0.143 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
172. 709,566.060 709,566.060 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2018_33_cars_response_id_idx on web_responses_2018_33_cars (cost=0.56..2.33 rows=1 width=272) (actual time=0.340..0.340 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
173. 298,435.137 298,435.137 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2018_33_edmunds_response_id_idx on web_responses_2018_33_edmunds (cost=0.43..2.20 rows=1 width=283) (actual time=0.143..0.143 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
174. 715,826.937 715,826.937 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2018_34_cars_response_id_idx on web_responses_2018_34_cars (cost=0.56..2.33 rows=1 width=270) (actual time=0.343..0.343 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
175. 300,522.096 300,522.096 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2018_34_edmunds_response_id_idx on web_responses_2018_34_edmunds (cost=0.43..2.20 rows=1 width=277) (actual time=0.144..0.144 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
176. 624,000.741 624,000.741 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2018_35_cars_response_id_idx on web_responses_2018_35_cars (cost=0.56..2.33 rows=1 width=271) (actual time=0.299..0.299 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
177. 231,652.449 231,652.449 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2018_35_edmunds_response_id_idx on web_responses_2018_35_edmunds (cost=0.43..2.20 rows=1 width=275) (actual time=0.111..0.111 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
178. 536,348.463 536,348.463 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2018_36_cars_response_id_idx on web_responses_2018_36_cars (cost=0.56..2.33 rows=1 width=272) (actual time=0.257..0.257 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
179. 177,391.515 177,391.515 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2018_36_edmunds_response_id_idx on web_responses_2018_36_edmunds (cost=0.43..2.20 rows=1 width=276) (actual time=0.085..0.085 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
180. 4,173.918 4,173.918 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2018_37_cars_response_id_idx on web_responses_2018_37_cars (cost=0.14..0.96 rows=1 width=100) (actual time=0.002..0.002 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
181. 4,173.918 4,173.918 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2018_37_edmunds_response_id_idx on web_responses_2018_37_edmunds (cost=0.14..0.96 rows=1 width=100) (actual time=0.002..0.002 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
182. 4,173.918 4,173.918 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2018_38_cars_response_id_idx on web_responses_2018_38_cars (cost=0.14..0.96 rows=1 width=100) (actual time=0.002..0.002 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
183. 4,173.918 4,173.918 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2018_38_edmunds_response_id_idx on web_responses_2018_38_edmunds (cost=0.14..0.96 rows=1 width=100) (actual time=0.002..0.002 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
184. 742,957.404 742,957.404 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2018_39_cars_response_id_idx on web_responses_2018_39_cars (cost=0.56..2.33 rows=1 width=270) (actual time=0.356..0.356 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
185. 271,304.670 271,304.670 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2018_39_edmunds_response_id_idx on web_responses_2018_39_edmunds (cost=0.43..2.20 rows=1 width=277) (actual time=0.130..0.130 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
186. 682,435.593 682,435.593 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2018_40_cars_response_id_idx on web_responses_2018_40_cars (cost=0.56..2.33 rows=1 width=266) (actual time=0.327..0.327 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
187. 244,174.203 244,174.203 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2018_40_edmunds_response_id_idx on web_responses_2018_40_edmunds (cost=0.43..2.20 rows=1 width=277) (actual time=0.117..0.117 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
188. 680,348.634 680,348.634 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2018_41_cars_response_id_idx on web_responses_2018_41_cars (cost=0.56..2.33 rows=1 width=267) (actual time=0.326..0.326 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
189. 219,130.695 219,130.695 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2018_41_edmunds_response_id_idx on web_responses_2018_41_edmunds (cost=0.43..2.20 rows=1 width=275) (actual time=0.105..0.105 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
190. 676,174.716 676,174.716 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2018_42_cars_response_id_idx on web_responses_2018_42_cars (cost=0.56..2.33 rows=1 width=266) (actual time=0.324..0.324 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
191. 244,174.203 244,174.203 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2018_42_edmunds_response_id_idx on web_responses_2018_42_edmunds (cost=0.43..2.20 rows=1 width=273) (actual time=0.117..0.117 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
192. 682,435.593 682,435.593 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2018_43_cars_response_id_idx on web_responses_2018_43_cars (cost=0.56..2.33 rows=1 width=272) (actual time=0.327..0.327 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
193. 244,174.203 244,174.203 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2018_43_edmunds_response_id_idx on web_responses_2018_43_edmunds (cost=0.43..2.20 rows=1 width=273) (actual time=0.117..0.117 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
194. 665,739.921 665,739.921 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2018_44_cars_response_id_idx on web_responses_2018_44_cars (cost=0.56..2.33 rows=1 width=272) (actual time=0.319..0.319 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
195. 231,652.449 231,652.449 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2018_44_edmunds_response_id_idx on web_responses_2018_44_edmunds (cost=0.43..2.20 rows=1 width=273) (actual time=0.111..0.111 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
196. 655,305.126 655,305.126 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2018_45_cars_response_id_idx on web_responses_2018_45_cars (cost=0.56..2.33 rows=1 width=270) (actual time=0.314..0.314 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
197. 221,217.654 221,217.654 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2018_45_edmunds_response_id_idx on web_responses_2018_45_edmunds (cost=0.43..2.20 rows=1 width=273) (actual time=0.106..0.106 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
198. 659,479.044 659,479.044 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2018_46_cars_response_id_idx on web_responses_2018_46_cars (cost=0.56..2.33 rows=1 width=272) (actual time=0.316..0.316 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
199. 219,130.695 219,130.695 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2018_46_edmunds_response_id_idx on web_responses_2018_46_edmunds (cost=0.43..2.20 rows=1 width=274) (actual time=0.105..0.105 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
200. 649,044.249 649,044.249 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2018_47_cars_response_id_idx on web_responses_2018_47_cars (cost=0.56..2.33 rows=1 width=262) (actual time=0.311..0.311 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
201. 173,217.597 173,217.597 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2018_47_edmunds_response_id_idx on web_responses_2018_47_edmunds (cost=0.43..2.20 rows=1 width=268) (actual time=0.083..0.083 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
202. 672,000.798 672,000.798 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2018_48_cars_response_id_idx on web_responses_2018_48_cars (cost=0.56..2.33 rows=1 width=263) (actual time=0.322..0.322 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
203. 181,565.433 181,565.433 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2018_48_edmunds_response_id_idx on web_responses_2018_48_edmunds (cost=0.43..2.20 rows=1 width=265) (actual time=0.087..0.087 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
204. 628,174.659 628,174.659 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2018_49_cars_response_id_idx on web_responses_2018_49_cars (cost=0.56..2.33 rows=1 width=271) (actual time=0.301..0.301 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
205. 210,782.859 210,782.859 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2018_49_edmunds_response_id_idx on web_responses_2018_49_edmunds (cost=0.43..2.20 rows=1 width=270) (actual time=0.101..0.101 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
206. 628,174.659 628,174.659 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2018_50_cars_response_id_idx on web_responses_2018_50_cars (cost=0.56..2.33 rows=1 width=269) (actual time=0.301..0.301 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
207. 217,043.736 217,043.736 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2018_50_edmunds_response_id_idx on web_responses_2018_50_edmunds (cost=0.43..2.20 rows=1 width=269) (actual time=0.104..0.104 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
208. 628,174.659 628,174.659 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2018_51_cars_response_id_idx on web_responses_2018_51_cars (cost=0.56..2.33 rows=1 width=269) (actual time=0.301..0.301 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
209. 210,782.859 210,782.859 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2018_51_edmunds_response_id_idx on web_responses_2018_51_edmunds (cost=0.43..2.20 rows=1 width=271) (actual time=0.101..0.101 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
210. 640,696.413 640,696.413 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2018_52_cars_response_id_idx on web_responses_2018_52_cars (cost=0.56..2.33 rows=1 width=265) (actual time=0.307..0.307 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
211. 223,304.613 223,304.613 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2018_52_edmunds_response_id_idx on web_responses_2018_52_edmunds (cost=0.43..2.20 rows=1 width=270) (actual time=0.107..0.107 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
212. 4,173.918 4,173.918 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2018_53_cars_response_id_idx on web_responses_2018_53_cars (cost=0.14..0.96 rows=1 width=100) (actual time=0.002..0.002 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
213. 4,173.918 4,173.918 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2018_53_edmunds_response_id_idx on web_responses_2018_53_edmunds (cost=0.14..0.96 rows=1 width=100) (actual time=0.002..0.002 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
214. 903,653.247 903,653.247 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2019_01_response_id_idx on web_responses_2019_01 (cost=0.56..2.33 rows=1 width=275) (actual time=0.433..0.433 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
215. 550,957.176 550,957.176 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2019_01_cars_response_id_idx on web_responses_2019_01_cars (cost=0.56..2.33 rows=1 width=269) (actual time=0.264..0.264 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
216. 219,130.695 219,130.695 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2019_01_edmunds_response_id_idx on web_responses_2019_01_edmunds (cost=0.43..2.20 rows=1 width=263) (actual time=0.105..0.105 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
217. 924,522.837 924,522.837 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2019_02_response_id_idx on web_responses_2019_02 (cost=0.56..2.33 rows=1 width=276) (actual time=0.443..0.443 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
218. 594,783.315 594,783.315 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2019_02_cars_response_id_idx on web_responses_2019_02_cars (cost=0.56..2.33 rows=1 width=268) (actual time=0.285..0.285 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
219. 223,304.613 223,304.613 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2019_02_edmunds_response_id_idx on web_responses_2019_02_edmunds (cost=0.43..2.20 rows=1 width=265) (actual time=0.107..0.107 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
220. 968,348.976 968,348.976 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2019_03_response_id_idx on web_responses_2019_03 (cost=0.56..2.33 rows=1 width=273) (actual time=0.464..0.464 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
221. 632,348.577 632,348.577 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2019_03_cars_response_id_idx on web_responses_2019_03_cars (cost=0.56..2.33 rows=1 width=270) (actual time=0.303..0.303 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
222. 208,695.900 208,695.900 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2019_03_edmunds_response_id_idx on web_responses_2019_03_edmunds (cost=0.43..2.20 rows=1 width=266) (actual time=0.100..0.100 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
223. 912,001.083 912,001.083 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2019_04_response_id_idx on web_responses_2019_04 (cost=0.56..2.33 rows=1 width=278) (actual time=0.437..0.437 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
224. 644,870.331 644,870.331 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2019_04_cars_response_id_idx on web_responses_2019_04_cars (cost=0.56..2.33 rows=1 width=272) (actual time=0.309..0.309 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
225. 219,130.695 219,130.695 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2019_04_edmunds_response_id_idx on web_responses_2019_04_edmunds (cost=0.43..2.20 rows=1 width=266) (actual time=0.105..0.105 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
226. 1,204,175.343 1,204,175.343 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2019_05_response_id_idx on web_responses_2019_05 (cost=0.57..2.34 rows=1 width=409) (actual time=0.577..0.577 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
227. 655,305.126 655,305.126 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2019_05_cars_response_id_idx on web_responses_2019_05_cars (cost=0.56..2.33 rows=1 width=271) (actual time=0.314..0.314 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
228. 210,782.859 210,782.859 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2019_05_edmunds_response_id_idx on web_responses_2019_05_edmunds (cost=0.43..2.20 rows=1 width=264) (actual time=0.101..0.101 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
229. 1,045,566.459 1,045,566.459 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2019_06_response_id_idx on web_responses_2019_06 (cost=0.56..2.34 rows=1 width=375) (actual time=0.501..0.501 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
230. 682,435.593 682,435.593 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2019_06_cars_response_id_idx on web_responses_2019_06_cars (cost=0.56..2.33 rows=1 width=280) (actual time=0.327..0.327 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
231. 212,869.818 212,869.818 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2019_06_edmunds_response_id_idx on web_responses_2019_06_edmunds (cost=0.43..2.20 rows=1 width=265) (actual time=0.102..0.102 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
232. 672,000.798 672,000.798 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2019_07_cars_response_id_idx on web_responses_2019_07_cars (cost=0.56..2.33 rows=1 width=277) (actual time=0.322..0.322 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
233. 219,130.695 219,130.695 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2019_07_edmunds_response_id_idx on web_responses_2019_07_edmunds (cost=0.43..2.20 rows=1 width=266) (actual time=0.105..0.105 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
234. 10,434.795 10,434.795 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2019_08_cars_response_id_idx on web_responses_2019_08_cars (cost=0.29..2.06 rows=1 width=296) (actual time=0.005..0.005 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
235. 221,217.654 221,217.654 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2019_08_edmunds_response_id_idx on web_responses_2019_08_edmunds (cost=0.43..2.20 rows=1 width=266) (actual time=0.106..0.106 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
236. 10,434.795 10,434.795 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2019_09_cars_response_id_idx on web_responses_2019_09_cars (cost=0.29..2.04 rows=1 width=292) (actual time=0.005..0.005 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
237. 219,130.695 219,130.695 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2019_09_edmunds_response_id_idx on web_responses_2019_09_edmunds (cost=0.43..2.20 rows=1 width=265) (actual time=0.105..0.105 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
238. 8,347.836 8,347.836 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2019_10_cars_response_id_idx on web_responses_2019_10_cars (cost=0.28..2.04 rows=1 width=289) (actual time=0.004..0.004 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
239. 217,043.736 217,043.736 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2019_10_edmunds_response_id_idx on web_responses_2019_10_edmunds (cost=0.43..2.20 rows=1 width=266) (actual time=0.104..0.104 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
240. 8,347.836 8,347.836 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2019_11_cars_response_id_idx on web_responses_2019_11_cars (cost=0.28..1.98 rows=1 width=284) (actual time=0.004..0.004 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
241. 227,478.531 227,478.531 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2019_11_edmunds_response_id_idx on web_responses_2019_11_edmunds (cost=0.43..2.20 rows=1 width=265) (actual time=0.109..0.109 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
242. 8,347.836 8,347.836 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2019_12_cars_response_id_idx on web_responses_2019_12_cars (cost=0.28..1.98 rows=1 width=284) (actual time=0.004..0.004 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
243. 242,087.244 242,087.244 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2019_12_edmunds_response_id_idx on web_responses_2019_12_edmunds (cost=0.43..2.20 rows=1 width=267) (actual time=0.116..0.116 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
244. 8,347.836 8,347.836 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2019_13_cars_response_id_idx on web_responses_2019_13_cars (cost=0.28..1.94 rows=1 width=282) (actual time=0.004..0.004 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
245. 233,739.408 233,739.408 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2019_13_edmunds_response_id_idx on web_responses_2019_13_edmunds (cost=0.43..2.20 rows=1 width=263) (actual time=0.112..0.112 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
246. 8,347.836 8,347.836 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2019_14_cars_response_id_idx on web_responses_2019_14_cars (cost=0.28..2.01 rows=1 width=280) (actual time=0.004..0.004 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
247. 242,087.244 242,087.244 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2019_14_edmunds_response_id_idx on web_responses_2019_14_edmunds (cost=0.43..2.20 rows=1 width=262) (actual time=0.116..0.116 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
248. 8,347.836 8,347.836 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2019_15_cars_response_id_idx on web_responses_2019_15_cars (cost=0.28..2.02 rows=1 width=279) (actual time=0.004..0.004 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
249. 240,000.285 240,000.285 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2019_15_edmunds_response_id_idx on web_responses_2019_15_edmunds (cost=0.43..2.20 rows=1 width=263) (actual time=0.115..0.115 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
250. 8,347.836 8,347.836 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2019_16_cars_response_id_idx on web_responses_2019_16_cars (cost=0.28..1.95 rows=1 width=279) (actual time=0.004..0.004 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
251. 250,435.080 250,435.080 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2019_16_edmunds_response_id_idx on web_responses_2019_16_edmunds (cost=0.43..2.20 rows=1 width=264) (actual time=0.120..0.120 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
252. 8,347.836 8,347.836 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2019_17_cars_response_id_idx on web_responses_2019_17_cars (cost=0.27..1.96 rows=1 width=271) (actual time=0.004..0.004 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
253. 248,348.121 248,348.121 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2019_17_edmunds_response_id_idx on web_responses_2019_17_edmunds (cost=0.43..2.20 rows=1 width=264) (actual time=0.119..0.119 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
254. 8,347.836 8,347.836 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2019_18_cars_response_id_idx on web_responses_2019_18_cars (cost=0.27..1.96 rows=1 width=273) (actual time=0.004..0.004 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
255. 240,000.285 240,000.285 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2019_18_edmunds_response_id_idx on web_responses_2019_18_edmunds (cost=0.43..2.20 rows=1 width=264) (actual time=0.115..0.115 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
256. 6,260.877 6,260.877 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2019_19_cars_response_id_idx on web_responses_2019_19_cars (cost=0.27..1.92 rows=1 width=271) (actual time=0.003..0.003 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
257. 229,565.490 229,565.490 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2019_19_edmunds_response_id_idx on web_responses_2019_19_edmunds (cost=0.43..2.20 rows=1 width=262) (actual time=0.110..0.110 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
258. 734,609.568 734,609.568 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2019_20_autotrader_response_id_idx on web_responses_2019_20_autotrader (cost=0.56..2.33 rows=1 width=481) (actual time=0.352..0.352 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
259. 8,347.836 8,347.836 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2019_20_cars_response_id_idx on web_responses_2019_20_cars (cost=0.27..1.95 rows=1 width=286) (actual time=0.004..0.004 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
260. 256,695.957 256,695.957 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2019_20_edmunds_response_id_idx on web_responses_2019_20_edmunds (cost=0.43..2.20 rows=1 width=265) (actual time=0.123..0.123 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
261. 4,173.918 4,173.918 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2019_20_kbb_response_id_idx on web_responses_2019_20_kbb (cost=0.14..0.96 rows=1 width=100) (actual time=0.002..0.002 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
262. 715,826.937 715,826.937 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2019_21_autotrader_response_id_idx on web_responses_2019_21_autotrader (cost=0.56..2.33 rows=1 width=473) (actual time=0.343..0.343 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
263. 8,347.836 8,347.836 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2019_21_cars_response_id_idx on web_responses_2019_21_cars (cost=0.27..1.95 rows=1 width=266) (actual time=0.004..0.004 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
264. 277,565.547 277,565.547 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2019_21_edmunds_response_id_idx on web_responses_2019_21_edmunds (cost=0.43..2.20 rows=1 width=266) (actual time=0.133..0.133 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
265. 8,347.836 8,347.836 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2019_21_kbb_response_id_idx on web_responses_2019_21_kbb (cost=0.28..1.94 rows=1 width=239) (actual time=0.004..0.004 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
266. 717,913.896 717,913.896 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2019_22_autotrader_response_id_idx on web_responses_2019_22_autotrader (cost=0.56..2.33 rows=1 width=470) (actual time=0.344..0.344 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
267. 6,260.877 6,260.877 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2019_22_cars_response_id_idx on web_responses_2019_22_cars (cost=0.14..1.48 rows=1 width=277) (actual time=0.003..0.003 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
268. 267,130.752 267,130.752 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2019_22_edmunds_response_id_idx on web_responses_2019_22_edmunds (cost=0.43..2.20 rows=1 width=265) (actual time=0.128..0.128 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
269. 210,782.859 210,782.859 ↓ 0.0 0 2,086,959

Index Scan using web_responses_2019_22_kbb_response_id_idx on web_responses_2019_22_kbb (cost=0.43..2.20 rows=1 width=296) (actual time=0.101..0.101 rows=0 loops=2,086,959)

  • Index Cond: (response_id = pfe.response_id)
  • Filter: ((pfe.property_id IS NOT NULL) OR (property_id IS NOT NULL))
270. 7,524.340 2,870,405.980 ↑ 66.0 1 64,865

Append (cost=0.42..108.56 rows=66 width=23) (actual time=24.563..44.252 rows=1 loops=64,865)

271. 13,037.865 13,037.865 ↓ 0.0 0 64,865

Index Only Scan using wr_ip_rels_2014_07_response_id_ip_address_idx on wr_ip_rels_2014_07 (cost=0.42..1.31 rows=1 width=23) (actual time=0.201..0.201 rows=0 loops=64,865)

  • Index Cond: (response_id = pfe.response_id)
  • Heap Fetches: 0
272. 13,362.190 13,362.190 ↓ 0.0 0 64,865

Index Only Scan using wr_ip_rels_2014_08_response_id_ip_address_idx on wr_ip_rels_2014_08 (cost=0.42..1.31 rows=1 width=23) (actual time=0.206..0.206 rows=0 loops=64,865)

  • Index Cond: (response_id = pfe.response_id)
  • Heap Fetches: 0
273. 13,751.380 13,751.380 ↓ 0.0 0 64,865

Index Only Scan using wr_ip_rels_2014_11_response_id_ip_address_idx on wr_ip_rels_2014_11 (cost=0.42..1.31 rows=1 width=23) (actual time=0.212..0.212 rows=0 loops=64,865)

  • Index Cond: (response_id = pfe.response_id)
  • Heap Fetches: 0
274. 14,594.625 14,594.625 ↓ 0.0 0 64,865

Index Only Scan using wr_ip_rels_2014_12_response_id_ip_address_idx on wr_ip_rels_2014_12 (cost=0.42..1.31 rows=1 width=23) (actual time=0.225..0.225 rows=0 loops=64,865)

  • Index Cond: (response_id = pfe.response_id)
  • Heap Fetches: 0
275. 9,664.885 9,664.885 ↓ 0.0 0 64,865

Index Only Scan using wr_ip_rels_2014_01_response_id_ip_address_idx on wr_ip_rels_2014_01 (cost=0.42..1.31 rows=1 width=23) (actual time=0.149..0.149 rows=0 loops=64,865)

  • Index Cond: (response_id = pfe.response_id)
  • Heap Fetches: 0
276. 9,794.615 9,794.615 ↓ 0.0 0 64,865

Index Only Scan using wr_ip_rels_2014_02_response_id_ip_address_idx on wr_ip_rels_2014_02 (cost=0.42..1.31 rows=1 width=23) (actual time=0.151..0.151 rows=0 loops=64,865)

  • Index Cond: (response_id = pfe.response_id)
  • Heap Fetches: 0
277. 16,540.575 16,540.575 ↓ 0.0 0 64,865

Index Only Scan using wr_ip_rels_2015_03_response_id_ip_address_idx on wr_ip_rels_2015_03 (cost=0.42..1.31 rows=1 width=23) (actual time=0.255..0.255 rows=0 loops=64,865)

  • Index Cond: (response_id = pfe.response_id)
  • Heap Fetches: 0
278. 11,351.375 11,351.375 ↓ 0.0 0 64,865

Index Only Scan using wr_ip_rels_2014_03_response_id_ip_address_idx on wr_ip_rels_2014_03 (cost=0.42..1.31 rows=1 width=23) (actual time=0.175..0.175 rows=0 loops=64,865)

  • Index Cond: (response_id = pfe.response_id)
  • Heap Fetches: 0
279. 10,962.185 10,962.185 ↓ 0.0 0 64,865

Index Only Scan using wr_ip_rels_2014_04_response_id_ip_address_idx on wr_ip_rels_2014_04 (cost=0.42..1.31 rows=1 width=23) (actual time=0.169..0.169 rows=0 loops=64,865)

  • Index Cond: (response_id = pfe.response_id)
  • Heap Fetches: 0
280. 11,027.050 11,027.050 ↓ 0.0 0 64,865

Index Only Scan using wr_ip_rels_2014_05_response_id_ip_address_idx on wr_ip_rels_2014_05 (cost=0.42..1.31 rows=1 width=23) (actual time=0.170..0.170 rows=0 loops=64,865)

  • Index Cond: (response_id = pfe.response_id)
  • Heap Fetches: 0
281. 11,935.160 11,935.160 ↓ 0.0 0 64,865

Index Only Scan using wr_ip_rels_2014_06_response_id_ip_address_idx on wr_ip_rels_2014_06 (cost=0.42..1.31 rows=1 width=23) (actual time=0.184..0.184 rows=0 loops=64,865)

  • Index Cond: (response_id = pfe.response_id)
  • Heap Fetches: 0
282. 12,973.000 12,973.000 ↓ 0.0 0 64,865

Index Only Scan using wr_ip_rels_2014_09_response_id_ip_address_idx on wr_ip_rels_2014_09 (cost=0.42..1.31 rows=1 width=23) (actual time=0.200..0.200 rows=0 loops=64,865)

  • Index Cond: (response_id = pfe.response_id)
  • Heap Fetches: 0
283. 13,102.730 13,102.730 ↓ 0.0 0 64,865

Index Only Scan using wr_ip_rels_2014_10_response_id_ip_address_idx on wr_ip_rels_2014_10 (cost=0.42..1.31 rows=1 width=23) (actual time=0.202..0.202 rows=0 loops=64,865)

  • Index Cond: (response_id = pfe.response_id)
  • Heap Fetches: 0
284. 15,113.545 15,113.545 ↓ 0.0 0 64,865

Index Only Scan using wr_ip_rels_2015_01_response_id_ip_address_idx on wr_ip_rels_2015_01 (cost=0.42..1.31 rows=1 width=23) (actual time=0.233..0.233 rows=0 loops=64,865)

  • Index Cond: (response_id = pfe.response_id)
  • Heap Fetches: 0
285. 15,243.275 15,243.275 ↓ 0.0 0 64,865

Index Only Scan using wr_ip_rels_2015_02_response_id_ip_address_idx on wr_ip_rels_2015_02 (cost=0.42..1.31 rows=1 width=23) (actual time=0.235..0.235 rows=0 loops=64,865)

  • Index Cond: (response_id = pfe.response_id)
  • Heap Fetches: 0
286. 62,335.265 62,335.265 ↓ 0.0 0 64,865

Index Only Scan using wr_ip_rels_2019_01_response_id_ip_address_idx on wr_ip_rels_2019_01 (cost=0.57..2.34 rows=1 width=23) (actual time=0.961..0.961 rows=0 loops=64,865)

  • Index Cond: (response_id = pfe.response_id)
  • Heap Fetches: 2
287. 69,859.605 69,859.605 ↓ 0.0 0 64,865

Index Only Scan using wr_ip_rels_2018_08_response_id_ip_address_idx on wr_ip_rels_2018_08 (cost=0.57..1.46 rows=1 width=23) (actual time=1.077..1.077 rows=0 loops=64,865)

  • Index Cond: (response_id = pfe.response_id)
  • Heap Fetches: 0
288. 24,648.700 24,648.700 ↓ 0.0 0 64,865

Index Only Scan using wr_ip_rels_2015_04_new_response_id_ip_address_idx on wr_ip_rels_2015_04 (cost=0.42..1.32 rows=1 width=23) (actual time=0.380..0.380 rows=0 loops=64,865)

  • Index Cond: (response_id = pfe.response_id)
  • Heap Fetches: 0
289. 24,129.780 24,129.780 ↓ 0.0 0 64,865

Index Only Scan using wr_ip_rels_2015_05_new_response_id_ip_address_idx on wr_ip_rels_2015_05 (cost=0.42..1.32 rows=1 width=23) (actual time=0.372..0.372 rows=0 loops=64,865)

  • Index Cond: (response_id = pfe.response_id)
  • Heap Fetches: 0
290. 26,464.920 26,464.920 ↓ 0.0 0 64,865

Index Only Scan using wr_ip_rels_2015_06_new_response_id_ip_address_idx on wr_ip_rels_2015_06 (cost=0.42..1.32 rows=1 width=23) (actual time=0.408..0.408 rows=0 loops=64,865)

  • Index Cond: (response_id = pfe.response_id)
  • Heap Fetches: 0
291. 28,864.925 28,864.925 ↓ 0.0 0 64,865

Index Only Scan using wr_ip_rels_2015_07_new_response_id_ip_address_idx on wr_ip_rels_2015_07 (cost=0.42..1.32 rows=1 width=23) (actual time=0.445..0.445 rows=0 loops=64,865)

  • Index Cond: (response_id = pfe.response_id)
  • Heap Fetches: 0
292. 29,383.845 29,383.845 ↓ 0.0 0 64,865

Index Only Scan using wr_ip_rels_2015_08_new_response_id_ip_address_idx on wr_ip_rels_2015_08 (cost=0.43..1.32 rows=1 width=23) (actual time=0.453..0.453 rows=0 loops=64,865)

  • Index Cond: (response_id = pfe.response_id)
  • Heap Fetches: 0
293. 29,448.710 29,448.710 ↓ 0.0 0 64,865

Index Only Scan using wr_ip_rels_2015_09_new_response_id_ip_address_idx on wr_ip_rels_2015_09 (cost=0.43..1.32 rows=1 width=23) (actual time=0.454..0.454 rows=0 loops=64,865)

  • Index Cond: (response_id = pfe.response_id)
  • Heap Fetches: 0
294. 48,648.750 48,648.750 ↓ 0.0 0 64,865

Index Only Scan using wr_ip_rels_2016_04_new_response_id_ip_address_idx on wr_ip_rels_2016_04 (cost=0.56..1.45 rows=1 width=23) (actual time=0.750..0.750 rows=0 loops=64,865)

  • Index Cond: (response_id = pfe.response_id)
  • Heap Fetches: 0
295. 61,621.750 61,621.750 ↓ 0.0 0 64,865

Index Only Scan using wr_ip_rels_2018_09_response_id_ip_address_idx on wr_ip_rels_2018_09 (cost=0.57..2.34 rows=1 width=23) (actual time=0.950..0.950 rows=0 loops=64,865)

  • Index Cond: (response_id = pfe.response_id)
  • Heap Fetches: 35
296. 59,092.015 59,092.015 ↓ 0.0 0 64,865

Index Only Scan using wr_ip_rels_2018_11_response_id_ip_address_idx on wr_ip_rels_2018_11 (cost=0.57..2.34 rows=1 width=23) (actual time=0.911..0.911 rows=0 loops=64,865)

  • Index Cond: (response_id = pfe.response_id)
  • Heap Fetches: 2
297. 72,713.665 72,713.665 ↓ 0.0 0 64,865

Index Only Scan using wr_ip_rels_2018_04_new_response_id_ip_address_idx on wr_ip_rels_2018_04 (cost=0.57..2.34 rows=1 width=23) (actual time=1.120..1.121 rows=0 loops=64,865)

  • Index Cond: (response_id = pfe.response_id)
  • Heap Fetches: 2674
298. 57,729.850 57,729.850 ↓ 0.0 0 64,865

Index Only Scan using wr_ip_rels_2019_06_response_id_ip_address_idx on wr_ip_rels_2019_06 (cost=0.57..2.34 rows=1 width=23) (actual time=0.888..0.890 rows=0 loops=64,865)

  • Index Cond: (response_id = pfe.response_id)
  • Heap Fetches: 15652
299. 68,692.035 68,692.035 ↓ 0.0 0 64,865

Index Only Scan using wr_ip_rels_2018_06_response_id_ip_address_idx on wr_ip_rels_2018_06 (cost=0.57..1.46 rows=1 width=23) (actual time=1.059..1.059 rows=0 loops=64,865)

  • Index Cond: (response_id = pfe.response_id)
  • Heap Fetches: 0
300. 69,340.685 69,340.685 ↓ 0.0 0 64,865

Index Only Scan using wr_ip_rels_2018_07_response_id_ip_address_idx on wr_ip_rels_2018_07 (cost=0.57..1.46 rows=1 width=23) (actual time=1.069..1.069 rows=0 loops=64,865)

  • Index Cond: (response_id = pfe.response_id)
  • Heap Fetches: 0
301. 59,675.800 59,675.800 ↓ 0.0 0 64,865

Index Only Scan using wr_ip_rels_2018_12_response_id_ip_address_idx on wr_ip_rels_2018_12 (cost=0.57..2.34 rows=1 width=23) (actual time=0.920..0.920 rows=0 loops=64,865)

  • Index Cond: (response_id = pfe.response_id)
  • Heap Fetches: 8
302. 70,573.120 70,573.120 ↓ 0.0 0 64,865

Index Only Scan using wr_ip_rels_2018_02_new_response_id_ip_address_idx on wr_ip_rels_2018_02 (cost=0.57..2.06 rows=1 width=23) (actual time=1.088..1.088 rows=0 loops=64,865)

  • Index Cond: (response_id = pfe.response_id)
  • Heap Fetches: 0
303. 60,064.990 60,064.990 ↓ 0.0 0 64,865

Index Only Scan using wr_ip_rels_2019_05_response_id_ip_address_idx on wr_ip_rels_2019_05 (cost=0.57..2.34 rows=1 width=23) (actual time=0.926..0.926 rows=0 loops=64,865)

  • Index Cond: (response_id = pfe.response_id)
  • Heap Fetches: 2
304. 69,859.605 69,859.605 ↓ 0.0 0 64,865

Index Only Scan using wr_ip_rels_2018_01_new_response_id_ip_address_idx on wr_ip_rels_2018_01 (cost=0.57..2.34 rows=1 width=23) (actual time=1.076..1.077 rows=0 loops=64,865)

  • Index Cond: (response_id = pfe.response_id)
  • Heap Fetches: 1
305. 72,583.935 72,583.935 ↓ 0.0 0 64,865

Index Only Scan using wr_ip_rels_2018_03_new_response_id_ip_address_idx on wr_ip_rels_2018_03 (cost=0.57..2.34 rows=1 width=23) (actual time=1.119..1.119 rows=0 loops=64,865)

  • Index Cond: (response_id = pfe.response_id)
  • Heap Fetches: 2081
306. 63,956.890 63,956.890 ↓ 0.0 0 64,865

Index Only Scan using wr_ip_rels_2017_12_new_response_id_ip_address_idx on wr_ip_rels_2017_12 (cost=0.57..1.46 rows=1 width=23) (actual time=0.986..0.986 rows=0 loops=64,865)

  • Index Cond: (response_id = pfe.response_id)
  • Heap Fetches: 0
307. 60,194.720 60,194.720 ↓ 0.0 0 64,865

Index Only Scan using wr_ip_rels_2018_10_response_id_ip_address_idx on wr_ip_rels_2018_10 (cost=0.57..2.34 rows=1 width=23) (actual time=0.928..0.928 rows=0 loops=64,865)

  • Index Cond: (response_id = pfe.response_id)
  • Heap Fetches: 18
308. 68,886.630 68,886.630 ↓ 0.0 0 64,865

Index Only Scan using wr_ip_rels_2018_05_response_id_ip_address_idx on wr_ip_rels_2018_05 (cost=0.57..1.46 rows=1 width=23) (actual time=1.062..1.062 rows=0 loops=64,865)

  • Index Cond: (response_id = pfe.response_id)
  • Heap Fetches: 0
309. 64,800.135 64,800.135 ↓ 0.0 0 64,865

Index Only Scan using wr_ip_rels_2017_09_new_response_id_ip_address_idx on wr_ip_rels_2017_09 (cost=0.57..1.46 rows=1 width=23) (actual time=0.998..0.999 rows=0 loops=64,865)

  • Index Cond: (response_id = pfe.response_id)
  • Heap Fetches: 0
310. 63,892.025 63,892.025 ↓ 0.0 0 64,865

Index Only Scan using wr_ip_rels_2017_08_new_response_id_ip_address_idx on wr_ip_rels_2017_08 (cost=0.56..1.46 rows=1 width=23) (actual time=0.985..0.985 rows=0 loops=64,865)

  • Index Cond: (response_id = pfe.response_id)
  • Heap Fetches: 0
311. 56,173.090 56,173.090 ↓ 0.0 0 64,865

Index Only Scan using wr_ip_rels_2017_07_new_response_id_ip_address_idx on wr_ip_rels_2017_07 (cost=0.56..2.33 rows=1 width=23) (actual time=0.866..0.866 rows=0 loops=64,865)

  • Index Cond: (response_id = pfe.response_id)
  • Heap Fetches: 0
312. 43,200.090 43,200.090 ↓ 0.0 0 64,865

Index Only Scan using wr_ip_rels_2017_04_new_response_id_ip_address_idx on wr_ip_rels_2017_04 (cost=0.56..2.33 rows=1 width=23) (actual time=0.666..0.666 rows=0 loops=64,865)

  • Index Cond: (response_id = pfe.response_id)
  • Heap Fetches: 14
313. 51,437.945 51,437.945 ↓ 0.0 0 64,865

Index Only Scan using wr_ip_rels_2017_06_new_response_id_ip_address_idx on wr_ip_rels_2017_06 (cost=0.56..1.46 rows=1 width=23) (actual time=0.793..0.793 rows=0 loops=64,865)

  • Index Cond: (response_id = pfe.response_id)
  • Heap Fetches: 0
314. 51,956.865 51,956.865 ↓ 0.0 0 64,865

Index Only Scan using wr_ip_rels_2017_03_new_response_id_ip_address_idx on wr_ip_rels_2017_03 (cost=0.56..1.46 rows=1 width=23) (actual time=0.801..0.801 rows=0 loops=64,865)

  • Index Cond: (response_id = pfe.response_id)
  • Heap Fetches: 0
315. 51,567.675 51,567.675 ↓ 0.0 0 64,865

Index Only Scan using wr_ip_rels_2017_05_new_response_id_ip_address_idx on wr_ip_rels_2017_05 (cost=0.56..1.45 rows=1 width=23) (actual time=0.795..0.795 rows=0 loops=64,865)

  • Index Cond: (response_id = pfe.response_id)
  • Heap Fetches: 0
316. 49,946.050 49,946.050 ↓ 0.0 0 64,865

Index Only Scan using wr_ip_rels_2017_02_new_response_id_ip_address_idx on wr_ip_rels_2017_02 (cost=0.56..1.45 rows=1 width=23) (actual time=0.770..0.770 rows=0 loops=64,865)

  • Index Cond: (response_id = pfe.response_id)
  • Heap Fetches: 0
317. 55,394.710 55,394.710 ↓ 0.0 0 64,865

Index Only Scan using wr_ip_rels_2019_03_response_id_ip_address_idx on wr_ip_rels_2019_03 (cost=0.57..2.34 rows=1 width=23) (actual time=0.854..0.854 rows=0 loops=64,865)

  • Index Cond: (response_id = pfe.response_id)
  • Heap Fetches: 4
318. 66,875.815 66,875.815 ↓ 0.0 0 64,865

Index Only Scan using wr_ip_rels_2017_11_new_response_id_ip_address_idx on wr_ip_rels_2017_11 (cost=0.57..2.34 rows=1 width=23) (actual time=1.031..1.031 rows=0 loops=64,865)

  • Index Cond: (response_id = pfe.response_id)
  • Heap Fetches: 1690
319. 64,475.810 64,475.810 ↓ 0.0 0 64,865

Index Only Scan using wr_ip_rels_2017_10_new_response_id_ip_address_idx on wr_ip_rels_2017_10 (cost=0.57..2.34 rows=1 width=23) (actual time=0.994..0.994 rows=0 loops=64,865)

  • Index Cond: (response_id = pfe.response_id)
  • Heap Fetches: 0
320. 52,021.730 52,021.730 ↓ 0.0 0 64,865

Index Only Scan using wr_ip_rels_2017_01_new_response_id_ip_address_idx on wr_ip_rels_2017_01 (cost=0.56..1.46 rows=1 width=23) (actual time=0.802..0.802 rows=0 loops=64,865)

  • Index Cond: (response_id = pfe.response_id)
  • Heap Fetches: 0
321. 55,200.115 55,200.115 ↓ 0.0 0 64,865

Index Only Scan using wr_ip_rels_2019_04_response_id_ip_address_idx on wr_ip_rels_2019_04 (cost=0.56..2.33 rows=1 width=23) (actual time=0.851..0.851 rows=0 loops=64,865)

  • Index Cond: (response_id = pfe.response_id)
  • Heap Fetches: 2
322. 41,578.465 41,578.465 ↓ 0.0 0 64,865

Index Only Scan using wr_ip_rels_2016_09_new_response_id_ip_address_idx on wr_ip_rels_2016_09 (cost=0.56..1.45 rows=1 width=23) (actual time=0.641..0.641 rows=0 loops=64,865)

  • Index Cond: (response_id = pfe.response_id)
  • Heap Fetches: 0
323. 46,378.475 46,378.475 ↓ 0.0 0 64,865

Index Only Scan using wr_ip_rels_2016_08_new_response_id_ip_address_idx on wr_ip_rels_2016_08 (cost=0.56..1.45 rows=1 width=23) (actual time=0.715..0.715 rows=0 loops=64,865)

  • Index Cond: (response_id = pfe.response_id)
  • Heap Fetches: 0
324. 31,394.660 31,394.660 ↓ 0.0 0 64,865

Index Only Scan using wr_ip_rels_2015_10_new_response_id_ip_address_idx on wr_ip_rels_2015_10 (cost=0.43..1.32 rows=1 width=23) (actual time=0.484..0.484 rows=0 loops=64,865)

  • Index Cond: (response_id = pfe.response_id)
  • Heap Fetches: 0
325. 35,675.750 35,675.750 ↓ 0.0 0 64,865

Index Only Scan using wr_ip_rels_2015_11_new_response_id_ip_address_idx on wr_ip_rels_2015_11 (cost=0.56..1.45 rows=1 width=23) (actual time=0.550..0.550 rows=0 loops=64,865)

  • Index Cond: (response_id = pfe.response_id)
  • Heap Fetches: 0
326. 38,205.485 38,205.485 ↓ 0.0 0 64,865

Index Only Scan using wr_ip_rels_2015_12_new_response_id_ip_address_idx on wr_ip_rels_2015_12 (cost=0.56..1.45 rows=1 width=23) (actual time=0.589..0.589 rows=0 loops=64,865)

  • Index Cond: (response_id = pfe.response_id)
  • Heap Fetches: 0
327. 50,464.970 50,464.970 ↓ 0.0 0 64,865

Index Only Scan using wr_ip_rels_2016_07_new_response_id_ip_address_idx on wr_ip_rels_2016_07 (cost=0.56..1.45 rows=1 width=23) (actual time=0.778..0.778 rows=0 loops=64,865)

  • Index Cond: (response_id = pfe.response_id)
  • Heap Fetches: 0
328. 49,232.535 49,232.535 ↓ 0.0 0 64,865

Index Only Scan using wr_ip_rels_2016_06_new_response_id_ip_address_idx on wr_ip_rels_2016_06 (cost=0.56..1.45 rows=1 width=23) (actual time=0.759..0.759 rows=0 loops=64,865)

  • Index Cond: (response_id = pfe.response_id)
  • Heap Fetches: 0
329. 49,362.265 49,362.265 ↓ 0.0 0 64,865

Index Only Scan using wr_ip_rels_2016_05_new_response_id_ip_address_idx on wr_ip_rels_2016_05 (cost=0.56..1.45 rows=1 width=23) (actual time=0.761..0.761 rows=0 loops=64,865)

  • Index Cond: (response_id = pfe.response_id)
  • Heap Fetches: 0
330. 48,000.100 48,000.100 ↓ 0.0 0 64,865

Index Only Scan using wr_ip_rels_2016_03_new_response_id_ip_address_idx on wr_ip_rels_2016_03 (cost=0.56..1.45 rows=1 width=23) (actual time=0.740..0.740 rows=0 loops=64,865)

  • Index Cond: (response_id = pfe.response_id)
  • Heap Fetches: 0
331. 45,405.500 45,405.500 ↓ 0.0 0 64,865

Index Only Scan using wr_ip_rels_2016_02_new_response_id_ip_address_idx on wr_ip_rels_2016_02 (cost=0.56..1.45 rows=1 width=23) (actual time=0.700..0.700 rows=0 loops=64,865)

  • Index Cond: (response_id = pfe.response_id)
  • Heap Fetches: 0
332. 47,675.775 47,675.775 ↓ 0.0 0 64,865

Index Only Scan using wr_ip_rels_2016_10_new_response_id_ip_address_idx on wr_ip_rels_2016_10 (cost=0.56..1.45 rows=1 width=23) (actual time=0.735..0.735 rows=0 loops=64,865)

  • Index Cond: (response_id = pfe.response_id)
  • Heap Fetches: 0
333. 49,362.265 49,362.265 ↓ 0.0 0 64,865

Index Only Scan using wr_ip_rels_2016_11_new_response_id_ip_address_idx on wr_ip_rels_2016_11 (cost=0.56..1.45 rows=1 width=23) (actual time=0.761..0.761 rows=0 loops=64,865)

  • Index Cond: (response_id = pfe.response_id)
  • Heap Fetches: 0
334. 49,491.995 49,491.995 ↓ 0.0 0 64,865

Index Only Scan using wr_ip_rels_2016_12_new_response_id_ip_address_idx on wr_ip_rels_2016_12 (cost=0.56..1.45 rows=1 width=23) (actual time=0.763..0.763 rows=0 loops=64,865)

  • Index Cond: (response_id = pfe.response_id)
  • Heap Fetches: 0
335. 44,108.200 44,108.200 ↓ 0.0 0 64,865

Index Only Scan using wr_ip_rels_2016_01_new_response_id_ip_address_idx on wr_ip_rels_2016_01 (cost=0.56..1.45 rows=1 width=23) (actual time=0.680..0.680 rows=0 loops=64,865)

  • Index Cond: (response_id = pfe.response_id)
  • Heap Fetches: 0
336. 58,378.500 58,378.500 ↓ 0.0 0 64,865

Index Only Scan using wr_ip_rels_2019_02_response_id_ip_address_idx on wr_ip_rels_2019_02 (cost=0.57..2.34 rows=1 width=23) (actual time=0.900..0.900 rows=0 loops=64,865)

  • Index Cond: (response_id = pfe.response_id)
  • Heap Fetches: 6