explain.depesz.com

PostgreSQL's explain analyze made readable

Result: GfeE

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

HashAggregate (cost=13,878,530.01..13,878,535.01 rows=200 width=200) (actual rows= loops=)

  • Group Key: pre_pl_l.se_id
2.          

CTE pre_pl_l

3. 0.000 0.000 ↓ 0.0

HashAggregate (cost=13,854,754.69..13,859,760.02 rows=500,533 width=200) (actual rows= loops=)

  • Group Key: pl.ref_se_id, (sum(pl.debet) FILTER (WHERE (CASE WHEN (pl.reason_code = ANY ('{1001,1040,1060}'::integer[])) THEN 1001 WHEN (pl.reason_code = ANY ('{1010,1011,1012}'::integer[])) THEN 1010 WHEN (pl.reason_code = 1054) THEN 1054 WHEN (pl.reason_code = ANY ('{1023,1024}'::integer[])) THEN 1023 WHEN (pl.reason_code = 1061) THEN 1061 ELSE 1000 END = 1001))), (sum(pl.debet) FILTER (WHERE (CASE WHEN (pl.reason_code = ANY ('{1001,1040,1060}'::integer[])) THEN 1001 WHEN (pl.reason_code = ANY ('{1010,1011,1012}'::integer[])) THEN 1010 WHEN (pl.reason_code = 1054) THEN 1054 WHEN (pl.reason_code = ANY ('{1023,1024}'::integer[])) THEN 1023 WHEN (pl.reason_code = 1061) THEN 1061 ELSE 1000 END = 1010))), (sum(pl.debet) FILTER (WHERE (CASE WHEN (pl.reason_code = ANY ('{1001,1040,1060}'::integer[])) THEN 1001 WHEN (pl.reason_code = ANY ('{1010,1011,1012}'::integer[])) THEN 1010 WHEN (pl.reason_code = 1054) THEN 1054 WHEN (pl.reason_code = ANY ('{1023,1024}'::integer[])) THEN 1023 WHEN (pl.reason_code = 1061) THEN 1061 ELSE 1000 END = 1054))), (sum(pl.debet) FILTER (WHERE (CASE WHEN (pl.reason_code = ANY ('{1001,1040,1060}'::integer[])) THEN 1001 WHEN (pl.reason_code = ANY ('{1010,1011,1012}'::integer[])) THEN 1010 WHEN (pl.reason_code = 1054) THEN 1054 WHEN (pl.reason_code = ANY ('{1023,1024}'::integer[])) THEN 1023 WHEN (pl.reason_code = 1061) THEN 1061 ELSE 1000 END = 1023))), (sum(pl.debet) FILTER (WHERE (CASE WHEN (pl.reason_code = ANY ('{1001,1040,1060}'::integer[])) THEN 1001 WHEN (pl.reason_code = ANY ('{1010,1011,1012}'::integer[])) THEN 1010 WHEN (pl.reason_code = 1054) THEN 1054 WHEN (pl.reason_code = ANY ('{1023,1024}'::integer[])) THEN 1023 WHEN (pl.reason_code = 1061) THEN 1061 ELSE 1000 END = 1000))), (sum(pl.debet) FILTER (WHERE (CASE WHEN (pl.reason_code = ANY ('{1001,1040,1060}'::integer[])) THEN 1001 WHEN (pl.reason_code = ANY ('{1010,1011,1012}'::integer[])) THEN 1010 WHEN (pl.reason_code = 1054) THEN 1054 WHEN (pl.reason_code = ANY ('{1023,1024}'::integer[])) THEN 1023 WHEN (pl.reason_code = 1061) THEN 1061 ELSE 1000 END = 1061)))
4. 0.000 0.000 ↓ 0.0

Append (cost=1,023,789.93..13,845,995.36 rows=500,533 width=200) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

HashAggregate (cost=1,023,789.93..1,029,754.03 rows=238,564 width=200) (actual rows= loops=)

  • Group Key: pl.ref_se_id
6. 0.000 0.000 ↓ 0.0

Nested Loop (cost=14,763.37..73,532.08 rows=7,757,207 width=16) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

HashAggregate (cost=14,762.95..14,764.95 rows=200 width=4) (actual rows= loops=)

  • Group Key: bs0.se_id
8. 0.000 0.000 ↓ 0.0

Seq Scan on bs0 (cost=0.00..12,745.96 rows=806,796 width=4) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Append (cost=0.42..292.35 rows=149 width=16) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Index Scan using p_log_pkey on p_log pl (cost=0.42..2.65 rows=1 width=16) (actual rows= loops=)

  • Index Cond: ((p_id >= 1453882561) AND (p_id < 1470070965))
  • Filter: (bs0.se_id = ref_se_id)
11. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201811_on_zero_pass_idx on p_log_201811 pl_1 (cost=0.56..2.78 rows=1 width=16) (actual rows= loops=)

  • Index Cond: ((p_id >= 1453882561) AND (p_id < 1470070965))
  • Filter: (bs0.se_id = ref_se_id)
12. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201812_pkey on p_log_201812 pl_2 (cost=0.43..2.66 rows=1 width=16) (actual rows= loops=)

  • Index Cond: ((p_id >= 1453882561) AND (p_id < 1470070965))
  • Filter: (bs0.se_id = ref_se_id)
13. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201111_on_zero_pass_idx on p_log_201111 pl_3 (cost=0.42..2.65 rows=1 width=15) (actual rows= loops=)

  • Index Cond: ((p_id >= 1453882561) AND (p_id < 1470070965))
  • Filter: (bs0.se_id = ref_se_id)
14. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201110_ref_se_id_idx on p_log_201110 pl_4 (cost=0.28..1.88 rows=1 width=15) (actual rows= loops=)

  • Index Cond: (ref_se_id = bs0.se_id)
  • Filter: ((p_id >= 1453882561) AND (p_id < 1470070965))
15. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201112_ref_se_id_idx on p_log_201112 pl_5 (cost=0.42..2.11 rows=1 width=14) (actual rows= loops=)

  • Index Cond: (ref_se_id = bs0.se_id)
  • Filter: ((p_id >= 1453882561) AND (p_id < 1470070965))
16. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201201_on_zero_pass_idx on p_log_201201 pl_6 (cost=0.42..2.65 rows=1 width=15) (actual rows= loops=)

  • Index Cond: ((p_id >= 1453882561) AND (p_id < 1470070965))
  • Filter: (bs0.se_id = ref_se_id)
17. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201202_on_zero_pass_idx on p_log_201202 pl_7 (cost=0.42..2.65 rows=1 width=15) (actual rows= loops=)

  • Index Cond: ((p_id >= 1453882561) AND (p_id < 1470070965))
  • Filter: (bs0.se_id = ref_se_id)
18. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201203_on_zero_pass_idx on p_log_201203 pl_8 (cost=0.42..2.65 rows=1 width=15) (actual rows= loops=)

  • Index Cond: ((p_id >= 1453882561) AND (p_id < 1470070965))
  • Filter: (bs0.se_id = ref_se_id)
19. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201204_on_zero_pass_idx on p_log_201204 pl_9 (cost=0.42..2.65 rows=1 width=15) (actual rows= loops=)

  • Index Cond: ((p_id >= 1453882561) AND (p_id < 1470070965))
  • Filter: (bs0.se_id = ref_se_id)
20. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201901_pkey on p_log_201901 pl_10 (cost=0.43..2.66 rows=1 width=16) (actual rows= loops=)

  • Index Cond: ((p_id >= 1453882561) AND (p_id < 1470070965))
  • Filter: (bs0.se_id = ref_se_id)
21. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201902_pkey on p_log_201902 pl_11 (cost=0.43..2.66 rows=1 width=16) (actual rows= loops=)

  • Index Cond: ((p_id >= 1453882561) AND (p_id < 1470070965))
  • Filter: (bs0.se_id = ref_se_id)
22. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201903_pkey on p_log_201903 pl_12 (cost=0.43..2.66 rows=1 width=16) (actual rows= loops=)

  • Index Cond: ((p_id >= 1453882561) AND (p_id < 1470070965))
  • Filter: (bs0.se_id = ref_se_id)
23. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201904_ref_se_id_idx on p_log_201904 pl_13 (cost=0.43..30.52 rows=53 width=16) (actual rows= loops=)

  • Index Cond: (ref_se_id = bs0.se_id)
  • Filter: ((p_id >= 1453882561) AND (p_id < 1470070965))
24. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201905_ref_se_id_idx on p_log_201905 pl_14 (cost=0.43..13.20 rows=1 width=16) (actual rows= loops=)

  • Index Cond: (ref_se_id = bs0.se_id)
  • Filter: ((p_id >= 1453882561) AND (p_id < 1470070965))
25. 0.000 0.000 ↓ 0.0

Index Scan using p_log_200901_201012_pkey on p_log_200901_201012 pl_15 (cost=0.43..2.65 rows=1 width=14) (actual rows= loops=)

  • Index Cond: ((p_id >= 1453882561) AND (p_id < 1470070965))
  • Filter: (bs0.se_id = ref_se_id)
26. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201101_201112_pkey on p_log_201101_201112 pl_16 (cost=0.43..2.65 rows=1 width=14) (actual rows= loops=)

  • Index Cond: ((p_id >= 1453882561) AND (p_id < 1470070965))
  • Filter: (bs0.se_id = ref_se_id)
27. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201201_201204_on_zero_pass_idx on p_log_201201_201204 pl_17 (cost=0.14..2.37 rows=1 width=14) (actual rows= loops=)

  • Index Cond: ((p_id >= 1453882561) AND (p_id < 1470070965))
  • Filter: (bs0.se_id = ref_se_id)
28. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201205_ref_se_id_idx on p_log_201205 pl_18 (cost=0.42..2.11 rows=1 width=14) (actual rows= loops=)

  • Index Cond: (ref_se_id = bs0.se_id)
  • Filter: ((p_id >= 1453882561) AND (p_id < 1470070965))
29. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201206_ref_se_id_idx on p_log_201206 pl_19 (cost=0.42..2.11 rows=1 width=14) (actual rows= loops=)

  • Index Cond: (ref_se_id = bs0.se_id)
  • Filter: ((p_id >= 1453882561) AND (p_id < 1470070965))
30. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201207_ref_se_id_idx on p_log_201207 pl_20 (cost=0.42..2.11 rows=1 width=15) (actual rows= loops=)

  • Index Cond: (ref_se_id = bs0.se_id)
  • Filter: ((p_id >= 1453882561) AND (p_id < 1470070965))
31. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201208_ref_se_id_idx on p_log_201208 pl_21 (cost=0.42..2.11 rows=1 width=15) (actual rows= loops=)

  • Index Cond: (ref_se_id = bs0.se_id)
  • Filter: ((p_id >= 1453882561) AND (p_id < 1470070965))
32. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201209_pkey on p_log_201209 pl_22 (cost=0.43..2.66 rows=1 width=16) (actual rows= loops=)

  • Index Cond: ((p_id >= 1453882561) AND (p_id < 1470070965))
  • Filter: (bs0.se_id = ref_se_id)
33. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201210_pkey on p_log_201210 pl_23 (cost=0.43..2.66 rows=1 width=16) (actual rows= loops=)

  • Index Cond: ((p_id >= 1453882561) AND (p_id < 1470070965))
  • Filter: (bs0.se_id = ref_se_id)
34. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201211_pkey on p_log_201211 pl_24 (cost=0.43..2.66 rows=1 width=16) (actual rows= loops=)

  • Index Cond: ((p_id >= 1453882561) AND (p_id < 1470070965))
  • Filter: (bs0.se_id = ref_se_id)
35. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201212_pkey on p_log_201212 pl_25 (cost=0.43..2.66 rows=1 width=16) (actual rows= loops=)

  • Index Cond: ((p_id >= 1453882561) AND (p_id < 1470070965))
  • Filter: (bs0.se_id = ref_se_id)
36. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201301_pkey on p_log_201301 pl_26 (cost=0.43..2.66 rows=1 width=16) (actual rows= loops=)

  • Index Cond: ((p_id >= 1453882561) AND (p_id < 1470070965))
  • Filter: (bs0.se_id = ref_se_id)
37. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201302_pkey on p_log_201302 pl_27 (cost=0.43..2.66 rows=1 width=16) (actual rows= loops=)

  • Index Cond: ((p_id >= 1453882561) AND (p_id < 1470070965))
  • Filter: (bs0.se_id = ref_se_id)
38. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201303_pkey on p_log_201303 pl_28 (cost=0.43..2.66 rows=1 width=16) (actual rows= loops=)

  • Index Cond: ((p_id >= 1453882561) AND (p_id < 1470070965))
  • Filter: (bs0.se_id = ref_se_id)
39. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201304_pkey on p_log_201304 pl_29 (cost=0.43..2.66 rows=1 width=16) (actual rows= loops=)

  • Index Cond: ((p_id >= 1453882561) AND (p_id < 1470070965))
  • Filter: (bs0.se_id = ref_se_id)
40. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201305_pkey on p_log_201305 pl_30 (cost=0.43..2.66 rows=1 width=16) (actual rows= loops=)

  • Index Cond: ((p_id >= 1453882561) AND (p_id < 1470070965))
  • Filter: (bs0.se_id = ref_se_id)
41. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201306_pkey on p_log_201306 pl_31 (cost=0.43..2.66 rows=1 width=16) (actual rows= loops=)

  • Index Cond: ((p_id >= 1453882561) AND (p_id < 1470070965))
  • Filter: (bs0.se_id = ref_se_id)
42. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201307_pkey on p_log_201307 pl_32 (cost=0.43..2.66 rows=1 width=16) (actual rows= loops=)

  • Index Cond: ((p_id >= 1453882561) AND (p_id < 1470070965))
  • Filter: (bs0.se_id = ref_se_id)
43. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201308_pkey on p_log_201308 pl_33 (cost=0.43..2.66 rows=1 width=16) (actual rows= loops=)

  • Index Cond: ((p_id >= 1453882561) AND (p_id < 1470070965))
  • Filter: (bs0.se_id = ref_se_id)
44. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201309_pkey on p_log_201309 pl_34 (cost=0.43..2.66 rows=1 width=16) (actual rows= loops=)

  • Index Cond: ((p_id >= 1453882561) AND (p_id < 1470070965))
  • Filter: (bs0.se_id = ref_se_id)
45. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201310_pkey on p_log_201310 pl_35 (cost=0.43..2.66 rows=1 width=16) (actual rows= loops=)

  • Index Cond: ((p_id >= 1453882561) AND (p_id < 1470070965))
  • Filter: (bs0.se_id = ref_se_id)
46. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201311_pkey on p_log_201311 pl_36 (cost=0.43..2.66 rows=1 width=16) (actual rows= loops=)

  • Index Cond: ((p_id >= 1453882561) AND (p_id < 1470070965))
  • Filter: (bs0.se_id = ref_se_id)
47. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201312_pkey on p_log_201312 pl_37 (cost=0.43..2.66 rows=1 width=16) (actual rows= loops=)

  • Index Cond: ((p_id >= 1453882561) AND (p_id < 1470070965))
  • Filter: (bs0.se_id = ref_se_id)
48. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201401_pkey on p_log_201401 pl_38 (cost=0.43..2.66 rows=1 width=16) (actual rows= loops=)

  • Index Cond: ((p_id >= 1453882561) AND (p_id < 1470070965))
  • Filter: (bs0.se_id = ref_se_id)
49. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201402_pkey on p_log_201402 pl_39 (cost=0.43..2.66 rows=1 width=16) (actual rows= loops=)

  • Index Cond: ((p_id >= 1453882561) AND (p_id < 1470070965))
  • Filter: (bs0.se_id = ref_se_id)
50. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201403_pkey on p_log_201403 pl_40 (cost=0.43..2.66 rows=1 width=16) (actual rows= loops=)

  • Index Cond: ((p_id >= 1453882561) AND (p_id < 1470070965))
  • Filter: (bs0.se_id = ref_se_id)
51. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201404_pkey on p_log_201404 pl_41 (cost=0.43..2.66 rows=1 width=16) (actual rows= loops=)

  • Index Cond: ((p_id >= 1453882561) AND (p_id < 1470070965))
  • Filter: (bs0.se_id = ref_se_id)
52. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201405_pkey on p_log_201405 pl_42 (cost=0.43..2.66 rows=1 width=16) (actual rows= loops=)

  • Index Cond: ((p_id >= 1453882561) AND (p_id < 1470070965))
  • Filter: (bs0.se_id = ref_se_id)
53. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201406_pkey on p_log_201406 pl_43 (cost=0.43..2.66 rows=1 width=16) (actual rows= loops=)

  • Index Cond: ((p_id >= 1453882561) AND (p_id < 1470070965))
  • Filter: (bs0.se_id = ref_se_id)
54. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201407_pkey on p_log_201407 pl_44 (cost=0.43..2.66 rows=1 width=16) (actual rows= loops=)

  • Index Cond: ((p_id >= 1453882561) AND (p_id < 1470070965))
  • Filter: (bs0.se_id = ref_se_id)
55. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201408_pkey on p_log_201408 pl_45 (cost=0.43..2.66 rows=1 width=16) (actual rows= loops=)

  • Index Cond: ((p_id >= 1453882561) AND (p_id < 1470070965))
  • Filter: (bs0.se_id = ref_se_id)
56. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201409_pkey on p_log_201409 pl_46 (cost=0.43..2.66 rows=1 width=16) (actual rows= loops=)

  • Index Cond: ((p_id >= 1453882561) AND (p_id < 1470070965))
  • Filter: (bs0.se_id = ref_se_id)
57. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201410_pkey on p_log_201410 pl_47 (cost=0.43..2.66 rows=1 width=16) (actual rows= loops=)

  • Index Cond: ((p_id >= 1453882561) AND (p_id < 1470070965))
  • Filter: (bs0.se_id = ref_se_id)
58. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201411_pkey on p_log_201411 pl_48 (cost=0.43..2.66 rows=1 width=16) (actual rows= loops=)

  • Index Cond: ((p_id >= 1453882561) AND (p_id < 1470070965))
  • Filter: (bs0.se_id = ref_se_id)
59. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201412_pkey on p_log_201412 pl_49 (cost=0.43..2.66 rows=1 width=16) (actual rows= loops=)

  • Index Cond: ((p_id >= 1453882561) AND (p_id < 1470070965))
  • Filter: (bs0.se_id = ref_se_id)
60. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201501_pkey on p_log_201501 pl_50 (cost=0.43..2.66 rows=1 width=16) (actual rows= loops=)

  • Index Cond: ((p_id >= 1453882561) AND (p_id < 1470070965))
  • Filter: (bs0.se_id = ref_se_id)
61. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201502_pkey on p_log_201502 pl_51 (cost=0.43..2.66 rows=1 width=16) (actual rows= loops=)

  • Index Cond: ((p_id >= 1453882561) AND (p_id < 1470070965))
  • Filter: (bs0.se_id = ref_se_id)
62. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201503_pkey on p_log_201503 pl_52 (cost=0.43..2.66 rows=1 width=16) (actual rows= loops=)

  • Index Cond: ((p_id >= 1453882561) AND (p_id < 1470070965))
  • Filter: (bs0.se_id = ref_se_id)
63. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201504_pkey on p_log_201504 pl_53 (cost=0.43..2.66 rows=1 width=16) (actual rows= loops=)

  • Index Cond: ((p_id >= 1453882561) AND (p_id < 1470070965))
  • Filter: (bs0.se_id = ref_se_id)
64. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201505_pkey on p_log_201505 pl_54 (cost=0.43..2.66 rows=1 width=16) (actual rows= loops=)

  • Index Cond: ((p_id >= 1453882561) AND (p_id < 1470070965))
  • Filter: (bs0.se_id = ref_se_id)
65. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201506_pkey on p_log_201506 pl_55 (cost=0.43..2.66 rows=1 width=16) (actual rows= loops=)

  • Index Cond: ((p_id >= 1453882561) AND (p_id < 1470070965))
  • Filter: (bs0.se_id = ref_se_id)
66. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201507_pkey on p_log_201507 pl_56 (cost=0.43..2.66 rows=1 width=16) (actual rows= loops=)

  • Index Cond: ((p_id >= 1453882561) AND (p_id < 1470070965))
  • Filter: (bs0.se_id = ref_se_id)
67. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201508_pkey on p_log_201508 pl_57 (cost=0.43..2.66 rows=1 width=16) (actual rows= loops=)

  • Index Cond: ((p_id >= 1453882561) AND (p_id < 1470070965))
  • Filter: (bs0.se_id = ref_se_id)
68. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201509_pkey on p_log_201509 pl_58 (cost=0.43..2.66 rows=1 width=16) (actual rows= loops=)

  • Index Cond: ((p_id >= 1453882561) AND (p_id < 1470070965))
  • Filter: (bs0.se_id = ref_se_id)
69. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201510_pkey on p_log_201510 pl_59 (cost=0.43..2.66 rows=1 width=16) (actual rows= loops=)

  • Index Cond: ((p_id >= 1453882561) AND (p_id < 1470070965))
  • Filter: (bs0.se_id = ref_se_id)
70. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201511_pkey on p_log_201511 pl_60 (cost=0.43..2.66 rows=1 width=16) (actual rows= loops=)

  • Index Cond: ((p_id >= 1453882561) AND (p_id < 1470070965))
  • Filter: (bs0.se_id = ref_se_id)
71. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201512_pkey on p_log_201512 pl_61 (cost=0.43..2.66 rows=1 width=16) (actual rows= loops=)

  • Index Cond: ((p_id >= 1453882561) AND (p_id < 1470070965))
  • Filter: (bs0.se_id = ref_se_id)
72. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201601_pkey on p_log_201601 pl_62 (cost=0.43..2.66 rows=1 width=16) (actual rows= loops=)

  • Index Cond: ((p_id >= 1453882561) AND (p_id < 1470070965))
  • Filter: (bs0.se_id = ref_se_id)
73. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201602_pkey on p_log_201602 pl_63 (cost=0.43..2.66 rows=1 width=16) (actual rows= loops=)

  • Index Cond: ((p_id >= 1453882561) AND (p_id < 1470070965))
  • Filter: (bs0.se_id = ref_se_id)
74. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201603_pkey on p_log_201603 pl_64 (cost=0.43..2.66 rows=1 width=16) (actual rows= loops=)

  • Index Cond: ((p_id >= 1453882561) AND (p_id < 1470070965))
  • Filter: (bs0.se_id = ref_se_id)
75. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201604_pkey on p_log_201604 pl_65 (cost=0.43..2.66 rows=1 width=16) (actual rows= loops=)

  • Index Cond: ((p_id >= 1453882561) AND (p_id < 1470070965))
  • Filter: (bs0.se_id = ref_se_id)
76. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201605_pkey on p_log_201605 pl_66 (cost=0.43..2.66 rows=1 width=16) (actual rows= loops=)

  • Index Cond: ((p_id >= 1453882561) AND (p_id < 1470070965))
  • Filter: (bs0.se_id = ref_se_id)
77. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201606_pkey on p_log_201606 pl_67 (cost=0.43..2.66 rows=1 width=16) (actual rows= loops=)

  • Index Cond: ((p_id >= 1453882561) AND (p_id < 1470070965))
  • Filter: (bs0.se_id = ref_se_id)
78. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201607_pkey on p_log_201607 pl_68 (cost=0.43..2.66 rows=1 width=16) (actual rows= loops=)

  • Index Cond: ((p_id >= 1453882561) AND (p_id < 1470070965))
  • Filter: (bs0.se_id = ref_se_id)
79. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201608_pkey on p_log_201608 pl_69 (cost=0.43..2.66 rows=1 width=16) (actual rows= loops=)

  • Index Cond: ((p_id >= 1453882561) AND (p_id < 1470070965))
  • Filter: (bs0.se_id = ref_se_id)
80. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201609_pkey on p_log_201609 pl_70 (cost=0.43..2.66 rows=1 width=16) (actual rows= loops=)

  • Index Cond: ((p_id >= 1453882561) AND (p_id < 1470070965))
  • Filter: (bs0.se_id = ref_se_id)
81. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201610_pkey on p_log_201610 pl_71 (cost=0.43..2.66 rows=1 width=16) (actual rows= loops=)

  • Index Cond: ((p_id >= 1453882561) AND (p_id < 1470070965))
  • Filter: (bs0.se_id = ref_se_id)
82. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201611_pkey on p_log_201611 pl_72 (cost=0.43..2.66 rows=1 width=16) (actual rows= loops=)

  • Index Cond: ((p_id >= 1453882561) AND (p_id < 1470070965))
  • Filter: (bs0.se_id = ref_se_id)
83. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201612_pkey on p_log_201612 pl_73 (cost=0.43..2.66 rows=1 width=16) (actual rows= loops=)

  • Index Cond: ((p_id >= 1453882561) AND (p_id < 1470070965))
  • Filter: (bs0.se_id = ref_se_id)
84. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201701_pkey on p_log_201701 pl_74 (cost=0.43..2.66 rows=1 width=16) (actual rows= loops=)

  • Index Cond: ((p_id >= 1453882561) AND (p_id < 1470070965))
  • Filter: (bs0.se_id = ref_se_id)
85. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201702_pkey on p_log_201702 pl_75 (cost=0.43..2.66 rows=1 width=16) (actual rows= loops=)

  • Index Cond: ((p_id >= 1453882561) AND (p_id < 1470070965))
  • Filter: (bs0.se_id = ref_se_id)
86. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201703_pkey on p_log_201703 pl_76 (cost=0.43..2.66 rows=1 width=16) (actual rows= loops=)

  • Index Cond: ((p_id >= 1453882561) AND (p_id < 1470070965))
  • Filter: (bs0.se_id = ref_se_id)
87. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201704_pkey on p_log_201704 pl_77 (cost=0.43..2.66 rows=1 width=16) (actual rows= loops=)

  • Index Cond: ((p_id >= 1453882561) AND (p_id < 1470070965))
  • Filter: (bs0.se_id = ref_se_id)
88. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201705_pkey on p_log_201705 pl_78 (cost=0.43..2.66 rows=1 width=16) (actual rows= loops=)

  • Index Cond: ((p_id >= 1453882561) AND (p_id < 1470070965))
  • Filter: (bs0.se_id = ref_se_id)
89. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201706_pkey on p_log_201706 pl_79 (cost=0.43..2.66 rows=1 width=16) (actual rows= loops=)

  • Index Cond: ((p_id >= 1453882561) AND (p_id < 1470070965))
  • Filter: (bs0.se_id = ref_se_id)
90. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201707_pkey on p_log_201707 pl_80 (cost=0.43..2.66 rows=1 width=16) (actual rows= loops=)

  • Index Cond: ((p_id >= 1453882561) AND (p_id < 1470070965))
  • Filter: (bs0.se_id = ref_se_id)
91. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201708_pkey on p_log_201708 pl_81 (cost=0.43..2.66 rows=1 width=16) (actual rows= loops=)

  • Index Cond: ((p_id >= 1453882561) AND (p_id < 1470070965))
  • Filter: (bs0.se_id = ref_se_id)
92. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201709_pkey on p_log_201709 pl_82 (cost=0.43..2.66 rows=1 width=16) (actual rows= loops=)

  • Index Cond: ((p_id >= 1453882561) AND (p_id < 1470070965))
  • Filter: (bs0.se_id = ref_se_id)
93. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201710_pkey on p_log_201710 pl_83 (cost=0.43..2.66 rows=1 width=16) (actual rows= loops=)

  • Index Cond: ((p_id >= 1453882561) AND (p_id < 1470070965))
  • Filter: (bs0.se_id = ref_se_id)
94. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201711_pkey on p_log_201711 pl_84 (cost=0.43..2.66 rows=1 width=16) (actual rows= loops=)

  • Index Cond: ((p_id >= 1453882561) AND (p_id < 1470070965))
  • Filter: (bs0.se_id = ref_se_id)
95. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201712_pkey on p_log_201712 pl_85 (cost=0.43..2.66 rows=1 width=16) (actual rows= loops=)

  • Index Cond: ((p_id >= 1453882561) AND (p_id < 1470070965))
  • Filter: (bs0.se_id = ref_se_id)
96. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201801_pkey on p_log_201801 pl_86 (cost=0.43..2.66 rows=1 width=16) (actual rows= loops=)

  • Index Cond: ((p_id >= 1453882561) AND (p_id < 1470070965))
  • Filter: (bs0.se_id = ref_se_id)
97. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201802_pkey on p_log_201802 pl_87 (cost=0.43..2.66 rows=1 width=16) (actual rows= loops=)

  • Index Cond: ((p_id >= 1453882561) AND (p_id < 1470070965))
  • Filter: (bs0.se_id = ref_se_id)
98. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201803_pkey on p_log_201803 pl_88 (cost=0.43..2.66 rows=1 width=16) (actual rows= loops=)

  • Index Cond: ((p_id >= 1453882561) AND (p_id < 1470070965))
  • Filter: (bs0.se_id = ref_se_id)
99. 0.000 0.000 ↓ 0.0

Index Scan using p_log_before_2009_pkey on p_log_before_2009 pl_89 (cost=0.43..2.65 rows=1 width=15) (actual rows= loops=)

  • Index Cond: ((p_id >= 1453882561) AND (p_id < 1470070965))
  • Filter: (bs0.se_id = ref_se_id)
100. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201804_pkey on p_log_201804 pl_90 (cost=0.43..2.66 rows=1 width=16) (actual rows= loops=)

  • Index Cond: ((p_id >= 1453882561) AND (p_id < 1470070965))
  • Filter: (bs0.se_id = ref_se_id)
101. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201805_pkey on p_log_201805 pl_91 (cost=0.43..2.66 rows=1 width=16) (actual rows= loops=)

  • Index Cond: ((p_id >= 1453882561) AND (p_id < 1470070965))
  • Filter: (bs0.se_id = ref_se_id)
102. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201806_pkey on p_log_201806 pl_92 (cost=0.43..2.66 rows=1 width=16) (actual rows= loops=)

  • Index Cond: ((p_id >= 1453882561) AND (p_id < 1470070965))
  • Filter: (bs0.se_id = ref_se_id)
103. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201807_pkey on p_log_201807 pl_93 (cost=0.43..2.66 rows=1 width=16) (actual rows= loops=)

  • Index Cond: ((p_id >= 1453882561) AND (p_id < 1470070965))
  • Filter: (bs0.se_id = ref_se_id)
104. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201808_pkey on p_log_201808 pl_94 (cost=0.43..2.66 rows=1 width=16) (actual rows= loops=)

  • Index Cond: ((p_id >= 1453882561) AND (p_id < 1470070965))
  • Filter: (bs0.se_id = ref_se_id)
105. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201809_pkey on p_log_201809 pl_95 (cost=0.43..2.66 rows=1 width=16) (actual rows= loops=)

  • Index Cond: ((p_id >= 1453882561) AND (p_id < 1470070965))
  • Filter: (bs0.se_id = ref_se_id)
106. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201810_pkey on p_log_201810 pl_96 (cost=0.43..2.66 rows=1 width=16) (actual rows= loops=)

  • Index Cond: ((p_id >= 1453882561) AND (p_id < 1470070965))
  • Filter: (bs0.se_id = ref_se_id)
107. 0.000 0.000 ↓ 0.0

Subquery Scan on *SELECT* 2 (cost=12,804,031.85..12,813,855.69 rows=261,969 width=200) (actual rows= loops=)

108. 0.000 0.000 ↓ 0.0

HashAggregate (cost=12,804,031.85..12,807,961.39 rows=261,969 width=84) (actual rows= loops=)

  • Group Key: pd.ref_se_id
109. 0.000 0.000 ↓ 0.0

Nested Loop (cost=14,762.95..33,393.43 rows=2,086,465 width=14) (actual rows= loops=)

110. 0.000 0.000 ↓ 0.0

HashAggregate (cost=14,762.95..14,764.95 rows=200 width=4) (actual rows= loops=)

  • Group Key: bs0_1.se_id
111. 0.000 0.000 ↓ 0.0

Seq Scan on bs0 bs0_1 (cost=0.00..12,745.96 rows=806,796 width=4) (actual rows= loops=)

112. 0.000 0.000 ↓ 0.0

Append (cost=0.00..92.10 rows=104 width=14) (actual rows= loops=)

113. 0.000 0.000 ↓ 0.0

Seq Scan on ntk_p_log_detail pd (cost=0.00..0.00 rows=1 width=28) (actual rows= loops=)

  • Filter: ((offer_id IS NULL) AND (p_log_id >= 1453884788) AND (p_log_id < 1470070537) AND (bs0_1.se_id = ref_se_id))
114. 0.000 0.000 ↓ 0.0

Index Scan using ntk_p_log_detail_201811_ref_se_id_idx on ntk_p_log_detail_201811 pd_1 (cost=0.43..1.17 rows=1 width=14) (actual rows= loops=)

  • Index Cond: (ref_se_id = bs0_1.se_id)
  • Filter: ((offer_id IS NULL) AND (p_log_id >= 1453884788) AND (p_log_id < 1470070537))
115. 0.000 0.000 ↓ 0.0

Index Scan using ntk_p_log_detail_201812_ref_se_id_idx on ntk_p_log_detail_201812 pd_2 (cost=0.43..1.20 rows=1 width=14) (actual rows= loops=)

  • Index Cond: (ref_se_id = bs0_1.se_id)
  • Filter: ((offer_id IS NULL) AND (p_log_id >= 1453884788) AND (p_log_id < 1470070537))
116. 0.000 0.000 ↓ 0.0

Index Scan using ntk_p_log_detail_201901_ref_se_id_idx on ntk_p_log_detail_201901 pd_3 (cost=0.43..1.18 rows=1 width=14) (actual rows= loops=)

  • Index Cond: (ref_se_id = bs0_1.se_id)
  • Filter: ((offer_id IS NULL) AND (p_log_id >= 1453884788) AND (p_log_id < 1470070537))
117. 0.000 0.000 ↓ 0.0

Index Scan using ntk_p_log_detail_201902_ref_se_id_idx on ntk_p_log_detail_201902 pd_4 (cost=0.43..1.13 rows=1 width=14) (actual rows= loops=)

  • Index Cond: (ref_se_id = bs0_1.se_id)
  • Filter: ((offer_id IS NULL) AND (p_log_id >= 1453884788) AND (p_log_id < 1470070537))
118. 0.000 0.000 ↓ 0.0

Index Scan using ntk_p_log_detail_201903_ref_se_id_idx on ntk_p_log_detail_201903 pd_5 (cost=0.43..1.19 rows=1 width=14) (actual rows= loops=)

  • Index Cond: (ref_se_id = bs0_1.se_id)
  • Filter: ((offer_id IS NULL) AND (p_log_id >= 1453884788) AND (p_log_id < 1470070537))
119. 0.000 0.000 ↓ 0.0

Index Scan using ntk_p_log_detail_201904_ref_se_id_idx on ntk_p_log_detail_201904 pd_6 (cost=0.43..1.16 rows=26 width=14) (actual rows= loops=)

  • Index Cond: (ref_se_id = bs0_1.se_id)
  • Filter: ((offer_id IS NULL) AND (p_log_id >= 1453884788) AND (p_log_id < 1470070537))
120. 0.000 0.000 ↓ 0.0

Index Scan using ntk_p_log_detail_201905_ref_se_id_idx on ntk_p_log_detail_201905 pd_7 (cost=0.43..0.79 rows=1 width=14) (actual rows= loops=)

  • Index Cond: (ref_se_id = bs0_1.se_id)
  • Filter: ((offer_id IS NULL) AND (p_log_id >= 1453884788) AND (p_log_id < 1470070537))
121. 0.000 0.000 ↓ 0.0

Index Scan using ntk_p_log_detail_201301_ref_se_id_idx on ntk_p_log_detail_201301 pd_8 (cost=0.43..1.14 rows=1 width=14) (actual rows= loops=)

  • Index Cond: (ref_se_id = bs0_1.se_id)
  • Filter: ((offer_id IS NULL) AND (p_log_id >= 1453884788) AND (p_log_id < 1470070537))
122. 0.000 0.000 ↓ 0.0

Index Scan using ntk_p_log_detail_201302_ref_se_id_idx on ntk_p_log_detail_201302 pd_9 (cost=0.43..1.08 rows=1 width=14) (actual rows= loops=)

  • Index Cond: (ref_se_id = bs0_1.se_id)
  • Filter: ((offer_id IS NULL) AND (p_log_id >= 1453884788) AND (p_log_id < 1470070537))
123. 0.000 0.000 ↓ 0.0

Index Scan using ntk_p_log_detail_201303_ref_se_id_idx on ntk_p_log_detail_201303 pd_10 (cost=0.43..1.18 rows=1 width=14) (actual rows= loops=)

  • Index Cond: (ref_se_id = bs0_1.se_id)
  • Filter: ((offer_id IS NULL) AND (p_log_id >= 1453884788) AND (p_log_id < 1470070537))
124. 0.000 0.000 ↓ 0.0

Index Scan using ntk_p_log_detail_201304_ref_se_id_idx on ntk_p_log_detail_201304 pd_11 (cost=0.43..1.15 rows=1 width=13) (actual rows= loops=)

  • Index Cond: (ref_se_id = bs0_1.se_id)
  • Filter: ((offer_id IS NULL) AND (p_log_id >= 1453884788) AND (p_log_id < 1470070537))
125. 0.000 0.000 ↓ 0.0

Index Scan using ntk_p_log_detail_201305_ref_se_id_idx on ntk_p_log_detail_201305 pd_12 (cost=0.43..1.18 rows=1 width=14) (actual rows= loops=)

  • Index Cond: (ref_se_id = bs0_1.se_id)
  • Filter: ((offer_id IS NULL) AND (p_log_id >= 1453884788) AND (p_log_id < 1470070537))
126. 0.000 0.000 ↓ 0.0

Index Scan using ntk_p_log_detail_201306_ref_se_id_idx on ntk_p_log_detail_201306 pd_13 (cost=0.43..1.15 rows=1 width=13) (actual rows= loops=)

  • Index Cond: (ref_se_id = bs0_1.se_id)
  • Filter: ((offer_id IS NULL) AND (p_log_id >= 1453884788) AND (p_log_id < 1470070537))
127. 0.000 0.000 ↓ 0.0

Index Scan using ntk_p_log_detail_201307_ref_se_id_idx on ntk_p_log_detail_201307 pd_14 (cost=0.43..1.18 rows=1 width=14) (actual rows= loops=)

  • Index Cond: (ref_se_id = bs0_1.se_id)
  • Filter: ((offer_id IS NULL) AND (p_log_id >= 1453884788) AND (p_log_id < 1470070537))
128. 0.000 0.000 ↓ 0.0

Index Scan using ntk_p_log_detail_201308_ref_se_id_idx on ntk_p_log_detail_201308 pd_15 (cost=0.43..1.18 rows=1 width=14) (actual rows= loops=)

  • Index Cond: (ref_se_id = bs0_1.se_id)
  • Filter: ((offer_id IS NULL) AND (p_log_id >= 1453884788) AND (p_log_id < 1470070537))
129. 0.000 0.000 ↓ 0.0

Index Scan using ntk_p_log_detail_201309_ref_se_id_idx on ntk_p_log_detail_201309 pd_16 (cost=0.43..1.16 rows=1 width=13) (actual rows= loops=)

  • Index Cond: (ref_se_id = bs0_1.se_id)
  • Filter: ((offer_id IS NULL) AND (p_log_id >= 1453884788) AND (p_log_id < 1470070537))
130. 0.000 0.000 ↓ 0.0

Index Scan using ntk_p_log_detail_201310_ref_se_id_idx on ntk_p_log_detail_201310 pd_17 (cost=0.43..1.18 rows=1 width=14) (actual rows= loops=)

  • Index Cond: (ref_se_id = bs0_1.se_id)
  • Filter: ((offer_id IS NULL) AND (p_log_id >= 1453884788) AND (p_log_id < 1470070537))
131. 0.000 0.000 ↓ 0.0

Index Scan using ntk_p_log_detail_201311_ref_se_id_idx on ntk_p_log_detail_201311 pd_18 (cost=0.43..1.16 rows=1 width=13) (actual rows= loops=)

  • Index Cond: (ref_se_id = bs0_1.se_id)
  • Filter: ((offer_id IS NULL) AND (p_log_id >= 1453884788) AND (p_log_id < 1470070537))
132. 0.000 0.000 ↓ 0.0

Index Scan using ntk_p_log_detail_201312_ref_se_id_idx on ntk_p_log_detail_201312 pd_19 (cost=0.43..1.19 rows=1 width=14) (actual rows= loops=)

  • Index Cond: (ref_se_id = bs0_1.se_id)
  • Filter: ((offer_id IS NULL) AND (p_log_id >= 1453884788) AND (p_log_id < 1470070537))
133. 0.000 0.000 ↓ 0.0

Index Scan using ntk_p_log_detail_201401_ref_se_id_idx on ntk_p_log_detail_201401 pd_20 (cost=0.43..1.19 rows=1 width=14) (actual rows= loops=)

  • Index Cond: (ref_se_id = bs0_1.se_id)
  • Filter: ((offer_id IS NULL) AND (p_log_id >= 1453884788) AND (p_log_id < 1470070537))
134. 0.000 0.000 ↓ 0.0

Index Scan using ntk_p_log_detail_201402_ref_se_id_idx on ntk_p_log_detail_201402 pd_21 (cost=0.43..1.14 rows=1 width=14) (actual rows= loops=)

  • Index Cond: (ref_se_id = bs0_1.se_id)
  • Filter: ((offer_id IS NULL) AND (p_log_id >= 1453884788) AND (p_log_id < 1470070537))
135. 0.000 0.000 ↓ 0.0

Index Scan using ntk_p_log_detail_201403_ref_se_id_idx on ntk_p_log_detail_201403 pd_22 (cost=0.43..1.19 rows=1 width=14) (actual rows= loops=)

  • Index Cond: (ref_se_id = bs0_1.se_id)
  • Filter: ((offer_id IS NULL) AND (p_log_id >= 1453884788) AND (p_log_id < 1470070537))
136. 0.000 0.000 ↓ 0.0

Index Scan using ntk_p_log_detail_201404_ref_se_id_idx on ntk_p_log_detail_201404 pd_23 (cost=0.43..1.16 rows=1 width=14) (actual rows= loops=)

  • Index Cond: (ref_se_id = bs0_1.se_id)
  • Filter: ((offer_id IS NULL) AND (p_log_id >= 1453884788) AND (p_log_id < 1470070537))
137. 0.000 0.000 ↓ 0.0

Index Scan using ntk_p_log_detail_201405_ref_se_id_idx on ntk_p_log_detail_201405 pd_24 (cost=0.43..1.19 rows=1 width=14) (actual rows= loops=)

  • Index Cond: (ref_se_id = bs0_1.se_id)
  • Filter: ((offer_id IS NULL) AND (p_log_id >= 1453884788) AND (p_log_id < 1470070537))
138. 0.000 0.000 ↓ 0.0

Index Scan using ntk_p_log_detail_201406_ref_se_id_idx on ntk_p_log_detail_201406 pd_25 (cost=0.43..1.16 rows=1 width=14) (actual rows= loops=)

  • Index Cond: (ref_se_id = bs0_1.se_id)
  • Filter: ((offer_id IS NULL) AND (p_log_id >= 1453884788) AND (p_log_id < 1470070537))
139. 0.000 0.000 ↓ 0.0

Index Scan using ntk_p_log_detail_201407_ref_se_id_idx on ntk_p_log_detail_201407 pd_26 (cost=0.43..1.19 rows=1 width=14) (actual rows= loops=)

  • Index Cond: (ref_se_id = bs0_1.se_id)
  • Filter: ((offer_id IS NULL) AND (p_log_id >= 1453884788) AND (p_log_id < 1470070537))
140. 0.000 0.000 ↓ 0.0

Index Scan using ntk_p_log_detail_201408_ref_se_id_idx on ntk_p_log_detail_201408 pd_27 (cost=0.43..1.19 rows=1 width=14) (actual rows= loops=)

  • Index Cond: (ref_se_id = bs0_1.se_id)
  • Filter: ((offer_id IS NULL) AND (p_log_id >= 1453884788) AND (p_log_id < 1470070537))
141. 0.000 0.000 ↓ 0.0

Index Scan using ntk_p_log_detail_201409_ref_se_id_idx on ntk_p_log_detail_201409 pd_28 (cost=0.43..1.17 rows=1 width=14) (actual rows= loops=)

  • Index Cond: (ref_se_id = bs0_1.se_id)
  • Filter: ((offer_id IS NULL) AND (p_log_id >= 1453884788) AND (p_log_id < 1470070537))
142. 0.000 0.000 ↓ 0.0

Index Scan using ntk_p_log_detail_201410_ref_se_id_idx on ntk_p_log_detail_201410 pd_29 (cost=0.43..1.22 rows=1 width=14) (actual rows= loops=)

  • Index Cond: (ref_se_id = bs0_1.se_id)
  • Filter: ((offer_id IS NULL) AND (p_log_id >= 1453884788) AND (p_log_id < 1470070537))
143. 0.000 0.000 ↓ 0.0

Index Scan using ntk_p_log_detail_201411_ref_se_id_idx on ntk_p_log_detail_201411 pd_30 (cost=0.43..1.19 rows=1 width=14) (actual rows= loops=)

  • Index Cond: (ref_se_id = bs0_1.se_id)
  • Filter: ((offer_id IS NULL) AND (p_log_id >= 1453884788) AND (p_log_id < 1470070537))
144. 0.000 0.000 ↓ 0.0

Index Scan using ntk_p_log_detail_201412_ref_se_id_idx on ntk_p_log_detail_201412 pd_31 (cost=0.43..1.19 rows=1 width=14) (actual rows= loops=)

  • Index Cond: (ref_se_id = bs0_1.se_id)
  • Filter: ((offer_id IS NULL) AND (p_log_id >= 1453884788) AND (p_log_id < 1470070537))
145. 0.000 0.000 ↓ 0.0

Index Scan using ntk_p_log_detail_201501_ref_se_id_idx on ntk_p_log_detail_201501 pd_32 (cost=0.43..1.19 rows=1 width=14) (actual rows= loops=)

  • Index Cond: (ref_se_id = bs0_1.se_id)
  • Filter: ((offer_id IS NULL) AND (p_log_id >= 1453884788) AND (p_log_id < 1470070537))
146. 0.000 0.000 ↓ 0.0

Index Scan using ntk_p_log_detail_201502_ref_se_id_idx on ntk_p_log_detail_201502 pd_33 (cost=0.43..1.12 rows=1 width=14) (actual rows= loops=)

  • Index Cond: (ref_se_id = bs0_1.se_id)
  • Filter: ((offer_id IS NULL) AND (p_log_id >= 1453884788) AND (p_log_id < 1470070537))
147. 0.000 0.000 ↓ 0.0

Index Scan using ntk_p_log_detail_201503_ref_se_id_idx on ntk_p_log_detail_201503 pd_34 (cost=0.43..1.19 rows=1 width=14) (actual rows= loops=)

  • Index Cond: (ref_se_id = bs0_1.se_id)
  • Filter: ((offer_id IS NULL) AND (p_log_id >= 1453884788) AND (p_log_id < 1470070537))
148. 0.000 0.000 ↓ 0.0

Index Scan using ntk_p_log_detail_201504_ref_se_id_idx on ntk_p_log_detail_201504 pd_35 (cost=0.43..1.17 rows=1 width=14) (actual rows= loops=)

  • Index Cond: (ref_se_id = bs0_1.se_id)
  • Filter: ((offer_id IS NULL) AND (p_log_id >= 1453884788) AND (p_log_id < 1470070537))
149. 0.000 0.000 ↓ 0.0

Index Scan using ntk_p_log_detail_201505_ref_se_id_idx on ntk_p_log_detail_201505 pd_36 (cost=0.43..1.21 rows=1 width=14) (actual rows= loops=)

  • Index Cond: (ref_se_id = bs0_1.se_id)
  • Filter: ((offer_id IS NULL) AND (p_log_id >= 1453884788) AND (p_log_id < 1470070537))
150. 0.000 0.000 ↓ 0.0

Index Scan using ntk_p_log_detail_201506_ref_se_id_idx on ntk_p_log_detail_201506 pd_37 (cost=0.43..1.16 rows=1 width=14) (actual rows= loops=)

  • Index Cond: (ref_se_id = bs0_1.se_id)
  • Filter: ((offer_id IS NULL) AND (p_log_id >= 1453884788) AND (p_log_id < 1470070537))
151. 0.000 0.000 ↓ 0.0

Index Scan using ntk_p_log_detail_201507_ref_se_id_idx on ntk_p_log_detail_201507 pd_38 (cost=0.43..1.21 rows=1 width=14) (actual rows= loops=)

  • Index Cond: (ref_se_id = bs0_1.se_id)
  • Filter: ((offer_id IS NULL) AND (p_log_id >= 1453884788) AND (p_log_id < 1470070537))
152. 0.000 0.000 ↓ 0.0

Index Scan using ntk_p_log_detail_201508_ref_se_id_idx on ntk_p_log_detail_201508 pd_39 (cost=0.43..1.19 rows=1 width=14) (actual rows= loops=)

  • Index Cond: (ref_se_id = bs0_1.se_id)
  • Filter: ((offer_id IS NULL) AND (p_log_id >= 1453884788) AND (p_log_id < 1470070537))
153. 0.000 0.000 ↓ 0.0

Index Scan using ntk_p_log_detail_201509_ref_se_id_idx on ntk_p_log_detail_201509 pd_40 (cost=0.43..1.19 rows=1 width=14) (actual rows= loops=)

  • Index Cond: (ref_se_id = bs0_1.se_id)
  • Filter: ((offer_id IS NULL) AND (p_log_id >= 1453884788) AND (p_log_id < 1470070537))
154. 0.000 0.000 ↓ 0.0

Index Scan using ntk_p_log_detail_201510_ref_se_id_idx on ntk_p_log_detail_201510 pd_41 (cost=0.43..1.21 rows=1 width=14) (actual rows= loops=)

  • Index Cond: (ref_se_id = bs0_1.se_id)
  • Filter: ((offer_id IS NULL) AND (p_log_id >= 1453884788) AND (p_log_id < 1470070537))
155. 0.000 0.000 ↓ 0.0

Index Scan using ntk_p_log_detail_201511_ref_se_id_idx on ntk_p_log_detail_201511 pd_42 (cost=0.43..1.19 rows=1 width=14) (actual rows= loops=)

  • Index Cond: (ref_se_id = bs0_1.se_id)
  • Filter: ((offer_id IS NULL) AND (p_log_id >= 1453884788) AND (p_log_id < 1470070537))
156. 0.000 0.000 ↓ 0.0

Index Scan using ntk_p_log_detail_201512_ref_se_id_idx on ntk_p_log_detail_201512 pd_43 (cost=0.43..1.21 rows=1 width=14) (actual rows= loops=)

  • Index Cond: (ref_se_id = bs0_1.se_id)
  • Filter: ((offer_id IS NULL) AND (p_log_id >= 1453884788) AND (p_log_id < 1470070537))
157. 0.000 0.000 ↓ 0.0

Index Scan using ntk_p_log_detail_201601_ref_se_id_idx on ntk_p_log_detail_201601 pd_44 (cost=0.43..1.21 rows=1 width=14) (actual rows= loops=)

  • Index Cond: (ref_se_id = bs0_1.se_id)
  • Filter: ((offer_id IS NULL) AND (p_log_id >= 1453884788) AND (p_log_id < 1470070537))
158. 0.000 0.000 ↓ 0.0

Index Scan using ntk_p_log_detail_201602_ref_se_id_idx on ntk_p_log_detail_201602 pd_45 (cost=0.43..1.16 rows=1 width=14) (actual rows= loops=)

  • Index Cond: (ref_se_id = bs0_1.se_id)
  • Filter: ((offer_id IS NULL) AND (p_log_id >= 1453884788) AND (p_log_id < 1470070537))
159. 0.000 0.000 ↓ 0.0

Index Scan using ntk_p_log_detail_201603_ref_se_id_idx on ntk_p_log_detail_201603 pd_46 (cost=0.43..1.22 rows=1 width=14) (actual rows= loops=)

  • Index Cond: (ref_se_id = bs0_1.se_id)
  • Filter: ((offer_id IS NULL) AND (p_log_id >= 1453884788) AND (p_log_id < 1470070537))
160. 0.000 0.000 ↓ 0.0

Index Scan using ntk_p_log_detail_201604_ref_se_id_idx on ntk_p_log_detail_201604 pd_47 (cost=0.43..1.17 rows=1 width=14) (actual rows= loops=)

  • Index Cond: (ref_se_id = bs0_1.se_id)
  • Filter: ((offer_id IS NULL) AND (p_log_id >= 1453884788) AND (p_log_id < 1470070537))
161. 0.000 0.000 ↓ 0.0

Index Scan using ntk_p_log_detail_201605_ref_se_id_idx on ntk_p_log_detail_201605 pd_48 (cost=0.43..1.22 rows=1 width=14) (actual rows= loops=)

  • Index Cond: (ref_se_id = bs0_1.se_id)
  • Filter: ((offer_id IS NULL) AND (p_log_id >= 1453884788) AND (p_log_id < 1470070537))
162. 0.000 0.000 ↓ 0.0

Index Scan using ntk_p_log_detail_201606_ref_se_id_idx on ntk_p_log_detail_201606 pd_49 (cost=0.43..1.17 rows=1 width=14) (actual rows= loops=)

  • Index Cond: (ref_se_id = bs0_1.se_id)
  • Filter: ((offer_id IS NULL) AND (p_log_id >= 1453884788) AND (p_log_id < 1470070537))
163. 0.000 0.000 ↓ 0.0

Index Scan using ntk_p_log_detail_201607_ref_se_id_idx on ntk_p_log_detail_201607 pd_50 (cost=0.43..1.22 rows=1 width=14) (actual rows= loops=)

  • Index Cond: (ref_se_id = bs0_1.se_id)
  • Filter: ((offer_id IS NULL) AND (p_log_id >= 1453884788) AND (p_log_id < 1470070537))
164. 0.000 0.000 ↓ 0.0

Index Scan using ntk_p_log_detail_201608_ref_se_id_idx on ntk_p_log_detail_201608 pd_51 (cost=0.43..1.22 rows=1 width=14) (actual rows= loops=)

  • Index Cond: (ref_se_id = bs0_1.se_id)
  • Filter: ((offer_id IS NULL) AND (p_log_id >= 1453884788) AND (p_log_id < 1470070537))
165. 0.000 0.000 ↓ 0.0

Index Scan using ntk_p_log_detail_201609_ref_se_id_idx on ntk_p_log_detail_201609 pd_52 (cost=0.43..1.17 rows=1 width=14) (actual rows= loops=)

  • Index Cond: (ref_se_id = bs0_1.se_id)
  • Filter: ((offer_id IS NULL) AND (p_log_id >= 1453884788) AND (p_log_id < 1470070537))
166. 0.000 0.000 ↓ 0.0

Index Scan using ntk_p_log_detail_201610_ref_se_id_idx on ntk_p_log_detail_201610 pd_53 (cost=0.43..1.20 rows=1 width=14) (actual rows= loops=)

  • Index Cond: (ref_se_id = bs0_1.se_id)
  • Filter: ((offer_id IS NULL) AND (p_log_id >= 1453884788) AND (p_log_id < 1470070537))
167. 0.000 0.000 ↓ 0.0

Index Scan using ntk_p_log_detail_201611_ref_se_id_idx on ntk_p_log_detail_201611 pd_54 (cost=0.43..1.20 rows=1 width=14) (actual rows= loops=)

  • Index Cond: (ref_se_id = bs0_1.se_id)
  • Filter: ((offer_id IS NULL) AND (p_log_id >= 1453884788) AND (p_log_id < 1470070537))
168. 0.000 0.000 ↓ 0.0

Index Scan using ntk_p_log_detail_201612_ref_se_id_idx on ntk_p_log_detail_201612 pd_55 (cost=0.43..1.20 rows=1 width=14) (actual rows= loops=)

  • Index Cond: (ref_se_id = bs0_1.se_id)
  • Filter: ((offer_id IS NULL) AND (p_log_id >= 1453884788) AND (p_log_id < 1470070537))
169. 0.000 0.000 ↓ 0.0

Index Scan using ntk_p_log_detail_201701_ref_se_id_idx on ntk_p_log_detail_201701 pd_56 (cost=0.43..1.22 rows=1 width=14) (actual rows= loops=)

  • Index Cond: (ref_se_id = bs0_1.se_id)
  • Filter: ((offer_id IS NULL) AND (p_log_id >= 1453884788) AND (p_log_id < 1470070537))
170. 0.000 0.000 ↓ 0.0

Index Scan using ntk_p_log_detail_201702_ref_se_id_idx on ntk_p_log_detail_201702 pd_57 (cost=0.43..1.15 rows=1 width=14) (actual rows= loops=)

  • Index Cond: (ref_se_id = bs0_1.se_id)
  • Filter: ((offer_id IS NULL) AND (p_log_id >= 1453884788) AND (p_log_id < 1470070537))
171. 0.000 0.000 ↓ 0.0

Index Scan using ntk_p_log_detail_201703_ref_se_id_idx on ntk_p_log_detail_201703 pd_58 (cost=0.43..1.22 rows=1 width=14) (actual rows= loops=)

  • Index Cond: (ref_se_id = bs0_1.se_id)
  • Filter: ((offer_id IS NULL) AND (p_log_id >= 1453884788) AND (p_log_id < 1470070537))
172. 0.000 0.000 ↓ 0.0

Index Scan using ntk_p_log_detail_201704_ref_se_id_idx on ntk_p_log_detail_201704 pd_59 (cost=0.43..1.19 rows=1 width=14) (actual rows= loops=)

  • Index Cond: (ref_se_id = bs0_1.se_id)
  • Filter: ((offer_id IS NULL) AND (p_log_id >= 1453884788) AND (p_log_id < 1470070537))
173. 0.000 0.000 ↓ 0.0

Index Scan using ntk_p_log_detail_201705_ref_se_id_idx on ntk_p_log_detail_201705 pd_60 (cost=0.43..1.22 rows=1 width=14) (actual rows= loops=)

  • Index Cond: (ref_se_id = bs0_1.se_id)
  • Filter: ((offer_id IS NULL) AND (p_log_id >= 1453884788) AND (p_log_id < 1470070537))
174. 0.000 0.000 ↓ 0.0

Index Scan using ntk_p_log_detail_201706_ref_se_id_idx on ntk_p_log_detail_201706 pd_61 (cost=0.43..1.19 rows=1 width=14) (actual rows= loops=)

  • Index Cond: (ref_se_id = bs0_1.se_id)
  • Filter: ((offer_id IS NULL) AND (p_log_id >= 1453884788) AND (p_log_id < 1470070537))
175. 0.000 0.000 ↓ 0.0

Index Scan using ntk_p_log_detail_201707_ref_se_id_idx on ntk_p_log_detail_201707 pd_62 (cost=0.43..1.21 rows=1 width=14) (actual rows= loops=)

  • Index Cond: (ref_se_id = bs0_1.se_id)
  • Filter: ((offer_id IS NULL) AND (p_log_id >= 1453884788) AND (p_log_id < 1470070537))
176. 0.000 0.000 ↓ 0.0

Index Scan using ntk_p_log_detail_201708_ref_se_id_idx on ntk_p_log_detail_201708 pd_63 (cost=0.43..1.21 rows=1 width=14) (actual rows= loops=)

  • Index Cond: (ref_se_id = bs0_1.se_id)
  • Filter: ((offer_id IS NULL) AND (p_log_id >= 1453884788) AND (p_log_id < 1470070537))
177. 0.000 0.000 ↓ 0.0

Index Scan using ntk_p_log_detail_201709_ref_se_id_idx on ntk_p_log_detail_201709 pd_64 (cost=0.43..1.19 rows=1 width=14) (actual rows= loops=)

  • Index Cond: (ref_se_id = bs0_1.se_id)
  • Filter: ((offer_id IS NULL) AND (p_log_id >= 1453884788) AND (p_log_id < 1470070537))
178. 0.000 0.000 ↓ 0.0

Index Scan using ntk_p_log_detail_201710_ref_se_id_idx on ntk_p_log_detail_201710 pd_65 (cost=0.43..1.21 rows=1 width=14) (actual rows= loops=)

  • Index Cond: (ref_se_id = bs0_1.se_id)
  • Filter: ((offer_id IS NULL) AND (p_log_id >= 1453884788) AND (p_log_id < 1470070537))
179. 0.000 0.000 ↓ 0.0

Index Scan using ntk_p_log_detail_201711_ref_se_id_idx on ntk_p_log_detail_201711 pd_66 (cost=0.43..1.19 rows=1 width=14) (actual rows= loops=)

  • Index Cond: (ref_se_id = bs0_1.se_id)
  • Filter: ((offer_id IS NULL) AND (p_log_id >= 1453884788) AND (p_log_id < 1470070537))
180. 0.000 0.000 ↓ 0.0

Index Scan using ntk_p_log_detail_201712_ref_se_id_idx on ntk_p_log_detail_201712 pd_67 (cost=0.43..1.21 rows=1 width=14) (actual rows= loops=)

  • Index Cond: (ref_se_id = bs0_1.se_id)
  • Filter: ((offer_id IS NULL) AND (p_log_id >= 1453884788) AND (p_log_id < 1470070537))
181. 0.000 0.000 ↓ 0.0

Index Scan using ntk_p_log_detail_201801_ref_se_id_idx on ntk_p_log_detail_201801 pd_68 (cost=0.43..1.21 rows=1 width=14) (actual rows= loops=)

  • Index Cond: (ref_se_id = bs0_1.se_id)
  • Filter: ((offer_id IS NULL) AND (p_log_id >= 1453884788) AND (p_log_id < 1470070537))
182. 0.000 0.000 ↓ 0.0

Index Scan using ntk_p_log_detail_201802_ref_se_id_idx on ntk_p_log_detail_201802 pd_69 (cost=0.43..1.13 rows=1 width=14) (actual rows= loops=)

  • Index Cond: (ref_se_id = bs0_1.se_id)
  • Filter: ((offer_id IS NULL) AND (p_log_id >= 1453884788) AND (p_log_id < 1470070537))
183. 0.000 0.000 ↓ 0.0

Index Scan using ntk_p_log_detail_201803_ref_se_id_idx on ntk_p_log_detail_201803 pd_70 (cost=0.43..1.21 rows=1 width=14) (actual rows= loops=)

  • Index Cond: (ref_se_id = bs0_1.se_id)
  • Filter: ((offer_id IS NULL) AND (p_log_id >= 1453884788) AND (p_log_id < 1470070537))
184. 0.000 0.000 ↓ 0.0

Index Scan using ntk_p_log_detail_before_2013_ref_se_id_idx on ntk_p_log_detail_before_2013 pd_71 (cost=0.43..1.28 rows=1 width=14) (actual rows= loops=)

  • Index Cond: (ref_se_id = bs0_1.se_id)
  • Filter: ((offer_id IS NULL) AND (p_log_id >= 1453884788) AND (p_log_id < 1470070537))
185. 0.000 0.000 ↓ 0.0

Index Scan using ntk_p_log_detail_201804_ref_se_id_idx on ntk_p_log_detail_201804 pd_72 (cost=0.43..1.19 rows=1 width=14) (actual rows= loops=)

  • Index Cond: (ref_se_id = bs0_1.se_id)
  • Filter: ((offer_id IS NULL) AND (p_log_id >= 1453884788) AND (p_log_id < 1470070537))
186. 0.000 0.000 ↓ 0.0

Index Scan using ntk_p_log_detail_201805_ref_se_id_idx on ntk_p_log_detail_201805 pd_73 (cost=0.43..1.21 rows=1 width=14) (actual rows= loops=)

  • Index Cond: (ref_se_id = bs0_1.se_id)
  • Filter: ((offer_id IS NULL) AND (p_log_id >= 1453884788) AND (p_log_id < 1470070537))
187. 0.000 0.000 ↓ 0.0

Index Scan using ntk_p_log_detail_201806_ref_se_id_idx on ntk_p_log_detail_201806 pd_74 (cost=0.43..1.18 rows=1 width=14) (actual rows= loops=)

  • Index Cond: (ref_se_id = bs0_1.se_id)
  • Filter: ((offer_id IS NULL) AND (p_log_id >= 1453884788) AND (p_log_id < 1470070537))
188. 0.000 0.000 ↓ 0.0

Index Scan using ntk_p_log_detail_201807_ref_se_id_idx on ntk_p_log_detail_201807 pd_75 (cost=0.43..1.21 rows=1 width=14) (actual rows= loops=)

  • Index Cond: (ref_se_id = bs0_1.se_id)
  • Filter: ((offer_id IS NULL) AND (p_log_id >= 1453884788) AND (p_log_id < 1470070537))
189. 0.000 0.000 ↓ 0.0

Index Scan using ntk_p_log_detail_201808_ref_se_id_idx on ntk_p_log_detail_201808 pd_76 (cost=0.43..1.21 rows=1 width=14) (actual rows= loops=)

  • Index Cond: (ref_se_id = bs0_1.se_id)
  • Filter: ((offer_id IS NULL) AND (p_log_id >= 1453884788) AND (p_log_id < 1470070537))
190. 0.000 0.000 ↓ 0.0

Index Scan using ntk_p_log_detail_201809_ref_se_id_idx on ntk_p_log_detail_201809 pd_77 (cost=0.43..1.15 rows=1 width=14) (actual rows= loops=)

  • Index Cond: (ref_se_id = bs0_1.se_id)
  • Filter: ((offer_id IS NULL) AND (p_log_id >= 1453884788) AND (p_log_id < 1470070537))
191. 0.000 0.000 ↓ 0.0

Index Scan using ntk_p_log_detail_201810_ref_se_id_idx on ntk_p_log_detail_201810 pd_78 (cost=0.43..1.20 rows=1 width=14) (actual rows= loops=)

  • Index Cond: (ref_se_id = bs0_1.se_id)
  • Filter: ((offer_id IS NULL) AND (p_log_id >= 1453884788) AND (p_log_id < 1470070537))
192.          

SubPlan (forHashAggregate)

193. 0.000 0.000 ↓ 0.0

Append (cost=0.42..255.45 rows=97 width=0) (actual rows= loops=)

194. 0.000 0.000 ↓ 0.0

Index Scan using p_log_pkey on p_log p_log_2 (cost=0.42..2.65 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
195. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201811_on_zero_pass_idx on p_log_201811 p_log_201811_2 (cost=0.56..2.78 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
196. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201812_pkey on p_log_201812 p_log_201812_2 (cost=0.43..2.66 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
197. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201111_on_zero_pass_idx on p_log_201111 p_log_201111_2 (cost=0.42..2.64 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
198. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201110_on_zero_pass_idx on p_log_201110 p_log_201110_2 (cost=0.28..2.50 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
199. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201112_on_zero_pass_idx on p_log_201112 p_log_201112_2 (cost=0.42..2.64 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
200. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201201_on_zero_pass_idx on p_log_201201 p_log_201201_2 (cost=0.42..2.64 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
201. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201202_on_zero_pass_idx on p_log_201202 p_log_201202_2 (cost=0.42..2.64 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
202. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201203_on_zero_pass_idx on p_log_201203 p_log_201203_2 (cost=0.42..2.64 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
203. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201204_on_zero_pass_idx on p_log_201204 p_log_201204_2 (cost=0.42..2.64 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
204. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201901_pkey on p_log_201901 p_log_201901_2 (cost=0.43..2.66 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
205. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201902_pkey on p_log_201902 p_log_201902_2 (cost=0.43..2.66 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
206. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201903_pkey on p_log_201903 p_log_201903_2 (cost=0.43..2.66 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
207. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201904_pkey on p_log_201904 p_log_201904_2 (cost=0.43..2.66 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
208. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201905_pkey on p_log_201905 p_log_201905_2 (cost=0.43..2.65 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
209. 0.000 0.000 ↓ 0.0

Index Scan using p_log_200901_201012_reason_code_idx on p_log_200901_201012 p_log_200901_201012_2 (cost=0.43..2.56 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
  • Filter: (p_id = pd.p_log_id)
210. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201101_201112_pkey on p_log_201101_201112 p_log_201101_201112_2 (cost=0.43..2.65 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
211. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201201_201204_on_zero_pass_idx on p_log_201201_201204 p_log_201201_201204_2 (cost=0.14..2.37 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
212. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201205_pkey on p_log_201205 p_log_201205_2 (cost=0.42..2.64 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
213. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201206_pkey on p_log_201206 p_log_201206_2 (cost=0.42..2.64 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
214. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201207_pkey on p_log_201207 p_log_201207_2 (cost=0.42..2.64 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
215. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201208_pkey on p_log_201208 p_log_201208_2 (cost=0.42..2.64 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
216. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201209_reason_code_idx on p_log_201209 p_log_201209_2 (cost=0.43..2.01 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
  • Filter: (p_id = pd.p_log_id)
217. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201210_pkey on p_log_201210 p_log_201210_2 (cost=0.43..2.65 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
218. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201211_pkey on p_log_201211 p_log_201211_2 (cost=0.43..2.65 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
219. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201212_pkey on p_log_201212 p_log_201212_2 (cost=0.43..2.65 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
220. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201301_reason_code_idx on p_log_201301 p_log_201301_2 (cost=0.43..1.83 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
  • Filter: (p_id = pd.p_log_id)
221. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201302_reason_code_idx on p_log_201302 p_log_201302_2 (cost=0.43..2.65 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
  • Filter: (p_id = pd.p_log_id)
222. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201303_pkey on p_log_201303 p_log_201303_2 (cost=0.43..2.65 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
223. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201304_pkey on p_log_201304 p_log_201304_2 (cost=0.43..2.65 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
224. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201305_pkey on p_log_201305 p_log_201305_2 (cost=0.43..2.65 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
225. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201306_pkey on p_log_201306 p_log_201306_2 (cost=0.43..2.65 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
226. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201307_pkey on p_log_201307 p_log_201307_2 (cost=0.43..2.65 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
227. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201308_pkey on p_log_201308 p_log_201308_2 (cost=0.43..2.65 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
228. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201309_pkey on p_log_201309 p_log_201309_2 (cost=0.43..2.65 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
229. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201310_pkey on p_log_201310 p_log_201310_2 (cost=0.43..2.65 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
230. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201311_pkey on p_log_201311 p_log_201311_2 (cost=0.43..2.65 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
231. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201312_pkey on p_log_201312 p_log_201312_2 (cost=0.43..2.65 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
232. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201401_pkey on p_log_201401 p_log_201401_2 (cost=0.43..2.65 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
233. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201402_pkey on p_log_201402 p_log_201402_2 (cost=0.43..2.65 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
234. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201403_pkey on p_log_201403 p_log_201403_2 (cost=0.43..2.66 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
235. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201404_pkey on p_log_201404 p_log_201404_2 (cost=0.43..2.65 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
236. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201405_pkey on p_log_201405 p_log_201405_2 (cost=0.43..2.66 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
237. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201406_pkey on p_log_201406 p_log_201406_2 (cost=0.43..2.65 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
238. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201407_pkey on p_log_201407 p_log_201407_2 (cost=0.43..2.65 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
239. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201408_pkey on p_log_201408 p_log_201408_2 (cost=0.43..2.65 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
240. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201409_pkey on p_log_201409 p_log_201409_2 (cost=0.43..2.65 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
241. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201410_pkey on p_log_201410 p_log_201410_2 (cost=0.43..2.66 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
242. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201411_pkey on p_log_201411 p_log_201411_2 (cost=0.43..2.66 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
243. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201412_pkey on p_log_201412 p_log_201412_2 (cost=0.43..2.66 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
244. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201501_pkey on p_log_201501 p_log_201501_2 (cost=0.43..2.66 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
245. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201502_pkey on p_log_201502 p_log_201502_2 (cost=0.43..2.65 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
246. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201503_pkey on p_log_201503 p_log_201503_2 (cost=0.43..2.66 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
247. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201504_pkey on p_log_201504 p_log_201504_2 (cost=0.43..2.66 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
248. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201505_pkey on p_log_201505 p_log_201505_2 (cost=0.43..2.66 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
249. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201506_pkey on p_log_201506 p_log_201506_2 (cost=0.43..2.66 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
250. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201507_pkey on p_log_201507 p_log_201507_2 (cost=0.43..2.66 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
251. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201508_pkey on p_log_201508 p_log_201508_2 (cost=0.43..2.66 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
252. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201509_pkey on p_log_201509 p_log_201509_2 (cost=0.43..2.66 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
253. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201510_pkey on p_log_201510 p_log_201510_2 (cost=0.43..2.66 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
254. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201511_pkey on p_log_201511 p_log_201511_2 (cost=0.43..2.66 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
255. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201512_pkey on p_log_201512 p_log_201512_2 (cost=0.43..2.66 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
256. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201601_pkey on p_log_201601 p_log_201601_2 (cost=0.43..2.66 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
257. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201602_pkey on p_log_201602 p_log_201602_2 (cost=0.43..2.66 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
258. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201603_pkey on p_log_201603 p_log_201603_2 (cost=0.43..2.66 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
259. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201604_pkey on p_log_201604 p_log_201604_2 (cost=0.43..2.66 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
260. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201605_pkey on p_log_201605 p_log_201605_2 (cost=0.43..2.66 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
261. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201606_pkey on p_log_201606 p_log_201606_2 (cost=0.43..2.66 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
262. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201607_pkey on p_log_201607 p_log_201607_2 (cost=0.43..2.66 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
263. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201608_pkey on p_log_201608 p_log_201608_2 (cost=0.43..2.66 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
264. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201609_pkey on p_log_201609 p_log_201609_2 (cost=0.43..2.66 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
265. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201610_pkey on p_log_201610 p_log_201610_2 (cost=0.43..2.66 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
266. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201611_pkey on p_log_201611 p_log_201611_2 (cost=0.43..2.66 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
267. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201612_pkey on p_log_201612 p_log_201612_2 (cost=0.43..2.66 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
268. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201701_pkey on p_log_201701 p_log_201701_2 (cost=0.43..2.66 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
269. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201702_pkey on p_log_201702 p_log_201702_2 (cost=0.43..2.66 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
270. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201703_pkey on p_log_201703 p_log_201703_2 (cost=0.43..2.66 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
271. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201704_pkey on p_log_201704 p_log_201704_2 (cost=0.43..2.66 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
272. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201705_pkey on p_log_201705 p_log_201705_2 (cost=0.43..2.66 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
273. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201706_pkey on p_log_201706 p_log_201706_2 (cost=0.43..2.66 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
274. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201707_pkey on p_log_201707 p_log_201707_2 (cost=0.43..2.66 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
275. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201708_pkey on p_log_201708 p_log_201708_2 (cost=0.43..2.66 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
276. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201709_pkey on p_log_201709 p_log_201709_2 (cost=0.43..2.66 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
277. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201710_pkey on p_log_201710 p_log_201710_2 (cost=0.43..2.66 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
278. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201711_pkey on p_log_201711 p_log_201711_2 (cost=0.43..2.66 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
279. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201712_pkey on p_log_201712 p_log_201712_2 (cost=0.43..2.66 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
280. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201801_pkey on p_log_201801 p_log_201801_2 (cost=0.43..2.66 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
281. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201802_pkey on p_log_201802 p_log_201802_2 (cost=0.43..2.66 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
282. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201803_pkey on p_log_201803 p_log_201803_2 (cost=0.43..2.66 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
283. 0.000 0.000 ↓ 0.0

Index Scan using p_log_before_2009_pkey on p_log_before_2009 p_log_before_2009_2 (cost=0.43..2.65 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
284. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201804_pkey on p_log_201804 p_log_201804_2 (cost=0.43..2.66 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
285. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201805_pkey on p_log_201805 p_log_201805_2 (cost=0.43..2.66 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
286. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201806_pkey on p_log_201806 p_log_201806_2 (cost=0.43..2.66 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
287. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201807_pkey on p_log_201807 p_log_201807_2 (cost=0.43..2.66 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
288. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201808_pkey on p_log_201808 p_log_201808_2 (cost=0.43..2.66 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
289. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201809_pkey on p_log_201809 p_log_201809_2 (cost=0.43..2.66 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
290. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201810_pkey on p_log_201810 p_log_201810_2 (cost=0.43..2.66 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
291. 0.000 0.000 ↓ 0.0

Append (cost=0.00..3,910,624.72 rows=12,724,697 width=8) (actual rows= loops=)

292. 0.000 0.000 ↓ 0.0

Seq Scan on p_log p_log_3 (cost=0.00..30,796.91 rows=1 width=8) (actual rows= loops=)

  • Filter: (reason_code = 1061)
293. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201811_reason_code_idx on p_log_201811 p_log_201811_3 (cost=0.56..59,802.39 rows=203,353 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
294. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201812_reason_code_idx on p_log_201812 p_log_201812_3 (cost=0.43..59,842.85 rows=207,285 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
295. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201111_reason_code_idx on p_log_201111 p_log_201111_3 (cost=0.42..205.49 rows=226 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
296. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201110_reason_code_idx on p_log_201110 p_log_201110_3 (cost=0.28..2.50 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
297. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201112_reason_code_idx on p_log_201112 p_log_201112_3 (cost=0.42..140.01 rows=148 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
298. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201201_reason_code_idx on p_log_201201 p_log_201201_3 (cost=0.42..143.18 rows=175 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
299. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201202_reason_code_idx on p_log_201202 p_log_201202_3 (cost=0.42..129.64 rows=155 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
300. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201203_reason_code_idx on p_log_201203 p_log_201203_3 (cost=0.42..151.42 rows=169 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
301. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201204_reason_code_idx on p_log_201204 p_log_201204_3 (cost=0.42..146.47 rows=165 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
302. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201901_reason_code_idx on p_log_201901 p_log_201901_3 (cost=0.43..62,283.77 rows=214,542 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
303. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201902_reason_code_idx on p_log_201902 p_log_201902_3 (cost=0.43..53,211.45 rows=178,243 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
304. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201903_reason_code_idx on p_log_201903 p_log_201903_3 (cost=0.43..59,287.79 rows=204,035 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
305. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201904_reason_code_idx on p_log_201904 p_log_201904_3 (cost=0.43..55,289.51 rows=187,002 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
306. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201905_reason_code_idx on p_log_201905 p_log_201905_3 (cost=0.43..27,573.55 rows=88,710 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
307. 0.000 0.000 ↓ 0.0

Index Scan using p_log_200901_201012_reason_code_idx on p_log_200901_201012 p_log_200901_201012_3 (cost=0.43..2.56 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
308. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201101_201112_reason_code_idx on p_log_201101_201112 p_log_201101_201112_3 (cost=0.43..1,338.98 rows=1,294 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
309. 0.000 0.000 ↓ 0.0

Seq Scan on p_log_201201_201204 p_log_201201_201204_3 (cost=0.00..11.62 rows=1 width=8) (actual rows= loops=)

  • Filter: (reason_code = 1061)
310. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201205_reason_code_idx on p_log_201205 p_log_201205_3 (cost=0.42..95.57 rows=126 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
311. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201206_reason_code_idx on p_log_201206 p_log_201206_3 (cost=0.42..73.49 rows=104 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
312. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201207_reason_code_idx on p_log_201207 p_log_201207_3 (cost=0.42..66.01 rows=101 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
313. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201208_reason_code_idx on p_log_201208 p_log_201208_3 (cost=0.42..126.97 rows=117 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
314. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201209_reason_code_idx on p_log_201209 p_log_201209_3 (cost=0.43..2.01 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
315. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201210_reason_code_idx on p_log_201210 p_log_201210_3 (cost=0.43..521.74 rows=1,507 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
316. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201211_reason_code_idx on p_log_201211 p_log_201211_3 (cost=0.43..758.01 rows=2,167 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
317. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201212_reason_code_idx on p_log_201212 p_log_201212_3 (cost=0.43..657.96 rows=1,913 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
318. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201301_reason_code_idx on p_log_201301 p_log_201301_3 (cost=0.43..1.83 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
319. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201302_reason_code_idx on p_log_201302 p_log_201302_3 (cost=0.43..2.65 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
320. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201303_reason_code_idx on p_log_201303 p_log_201303_3 (cost=0.43..888.50 rows=2,273 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
321. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201304_reason_code_idx on p_log_201304 p_log_201304_3 (cost=0.43..720.26 rows=2,160 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
322. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201305_reason_code_idx on p_log_201305 p_log_201305_3 (cost=0.43..8,199.87 rows=26,347 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
323. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201306_reason_code_idx on p_log_201306 p_log_201306_3 (cost=0.43..11,171.26 rows=37,062 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
324. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201307_reason_code_idx on p_log_201307 p_log_201307_3 (cost=0.43..13,959.23 rows=46,728 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
325. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201308_reason_code_idx on p_log_201308 p_log_201308_3 (cost=0.43..15,711.78 rows=51,730 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
326. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201309_reason_code_idx on p_log_201309 p_log_201309_3 (cost=0.43..16,563.43 rows=55,143 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
327. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201310_reason_code_idx on p_log_201310 p_log_201310_3 (cost=0.43..18,954.21 rows=61,646 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
328. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201311_reason_code_idx on p_log_201311 p_log_201311_3 (cost=0.43..20,971.59 rows=69,940 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
329. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201312_reason_code_idx on p_log_201312 p_log_201312_3 (cost=0.43..23,163.47 rows=75,714 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
330. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201401_reason_code_idx on p_log_201401 p_log_201401_3 (cost=0.43..25,314.25 rows=82,805 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
331. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201402_reason_code_idx on p_log_201402 p_log_201402_3 (cost=0.43..26,115.60 rows=81,518 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
332. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201403_reason_code_idx on p_log_201403 p_log_201403_3 (cost=0.43..30,901.43 rows=97,201 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
333. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201404_reason_code_idx on p_log_201404 p_log_201404_3 (cost=0.43..32,880.36 rows=103,530 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
334. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201405_reason_code_idx on p_log_201405 p_log_201405_3 (cost=0.43..33,035.81 rows=107,809 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
335. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201406_reason_code_idx on p_log_201406 p_log_201406_3 (cost=0.43..36,309.01 rows=116,368 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
336. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201407_reason_code_idx on p_log_201407 p_log_201407_3 (cost=0.43..36,245.44 rows=123,958 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
337. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201408_reason_code_idx on p_log_201408 p_log_201408_3 (cost=0.43..37,780.60 rows=129,865 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
338. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201409_reason_code_idx on p_log_201409 p_log_201409_3 (cost=0.43..35,815.36 rows=124,600 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
339. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201410_reason_code_idx on p_log_201410 p_log_201410_3 (cost=0.43..38,674.09 rows=139,123 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
340. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201411_reason_code_idx on p_log_201411 p_log_201411_3 (cost=0.43..38,124.94 rows=134,832 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
341. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201412_reason_code_idx on p_log_201412 p_log_201412_3 (cost=0.43..40,355.46 rows=143,113 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
342. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201501_reason_code_idx on p_log_201501 p_log_201501_3 (cost=0.43..41,645.66 rows=145,099 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
343. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201502_reason_code_idx on p_log_201502 p_log_201502_3 (cost=0.43..40,266.43 rows=135,374 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
344. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201503_reason_code_idx on p_log_201503 p_log_201503_3 (cost=0.43..45,619.65 rows=157,194 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
345. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201504_reason_code_idx on p_log_201504 p_log_201504_3 (cost=0.43..47,342.73 rows=155,776 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
346. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201505_reason_code_idx on p_log_201505 p_log_201505_3 (cost=0.43..49,664.38 rows=167,001 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
347. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201506_reason_code_idx on p_log_201506 p_log_201506_3 (cost=0.43..51,805.97 rows=171,787 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
348. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201507_reason_code_idx on p_log_201507 p_log_201507_3 (cost=0.43..56,380.73 rows=182,794 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
349. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201508_reason_code_idx on p_log_201508 p_log_201508_3 (cost=0.43..58,631.69 rows=188,014 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
350. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201509_reason_code_idx on p_log_201509 p_log_201509_3 (cost=0.43..56,264.92 rows=181,671 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
351. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201510_reason_code_idx on p_log_201510 p_log_201510_3 (cost=0.43..61,677.45 rows=198,554 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
352. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201511_reason_code_idx on p_log_201511 p_log_201511_3 (cost=0.43..61,914.58 rows=196,342 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
353. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201512_reason_code_idx on p_log_201512 p_log_201512_3 (cost=0.43..64,075.27 rows=204,932 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
354. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201601_reason_code_idx on p_log_201601 p_log_201601_3 (cost=0.43..63,762.82 rows=204,629 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
355. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201602_reason_code_idx on p_log_201602 p_log_201602_3 (cost=0.43..67,010.65 rows=207,590 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
356. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201603_reason_code_idx on p_log_201603 p_log_201603_3 (cost=0.43..68,193.52 rows=214,934 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
357. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201604_reason_code_idx on p_log_201604 p_log_201604_3 (cost=0.43..64,344.65 rows=204,626 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
358. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201605_reason_code_idx on p_log_201605 p_log_201605_3 (cost=0.43..68,859.53 rows=223,755 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
359. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201606_reason_code_idx on p_log_201606 p_log_201606_3 (cost=0.43..63,225.99 rows=203,464 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
360. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201607_reason_code_idx on p_log_201607 p_log_201607_3 (cost=0.43..65,713.31 rows=214,327 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
361. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201608_reason_code_idx on p_log_201608 p_log_201608_3 (cost=0.43..67,616.00 rows=222,351 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
362. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201609_reason_code_idx on p_log_201609 p_log_201609_3 (cost=0.43..62,284.55 rows=207,201 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
363. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201610_reason_code_idx on p_log_201610 p_log_201610_3 (cost=0.43..66,232.54 rows=219,734 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
364. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201611_reason_code_idx on p_log_201611 p_log_201611_3 (cost=0.43..68,849.48 rows=223,076 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
365. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201612_reason_code_idx on p_log_201612 p_log_201612_3 (cost=0.43..70,946.90 rows=229,729 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
366. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201701_reason_code_idx on p_log_201701 p_log_201701_3 (cost=0.43..67,379.33 rows=222,886 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
367. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201702_reason_code_idx on p_log_201702 p_log_201702_3 (cost=0.43..64,607.13 rows=202,189 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
368. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201703_reason_code_idx on p_log_201703 p_log_201703_3 (cost=0.43..74,178.88 rows=234,938 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
369. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201704_reason_code_idx on p_log_201704 p_log_201704_3 (cost=0.43..74,323.16 rows=231,586 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
370. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201705_reason_code_idx on p_log_201705 p_log_201705_3 (cost=0.43..74,942.00 rows=238,138 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
371. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201706_reason_code_idx on p_log_201706 p_log_201706_3 (cost=0.43..73,042.99 rows=229,820 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
372. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201707_reason_code_idx on p_log_201707 p_log_201707_3 (cost=0.43..78,285.97 rows=243,016 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
373. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201708_reason_code_idx on p_log_201708 p_log_201708_3 (cost=0.43..74,519.60 rows=236,219 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
374. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201709_reason_code_idx on p_log_201709 p_log_201709_3 (cost=0.43..71,900.95 rows=232,853 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
375. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201710_reason_code_idx on p_log_201710 p_log_201710_3 (cost=0.43..74,472.80 rows=240,769 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
376. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201711_reason_code_idx on p_log_201711 p_log_201711_3 (cost=0.43..70,303.98 rows=225,959 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
377. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201712_reason_code_idx on p_log_201712 p_log_201712_3 (cost=0.43..72,944.43 rows=238,646 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
378. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201801_reason_code_idx on p_log_201801 p_log_201801_3 (cost=0.43..70,482.52 rows=240,901 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
379. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201802_reason_code_idx on p_log_201802 p_log_201802_3 (cost=0.43..65,788.15 rows=210,706 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
380. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201803_reason_code_idx on p_log_201803 p_log_201803_3 (cost=0.43..69,309.64 rows=231,379 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
381. 0.000 0.000 ↓ 0.0

Index Scan using p_log_before_2009_reason_code_idx on p_log_before_2009 p_log_before_2009_3 (cost=0.43..973.30 rows=1,031 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
382. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201804_reason_code_idx on p_log_201804 p_log_201804_3 (cost=0.43..69,070.28 rows=224,520 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
383. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201805_reason_code_idx on p_log_201805 p_log_201805_3 (cost=0.43..66,339.20 rows=221,926 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
384. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201806_reason_code_idx on p_log_201806 p_log_201806_3 (cost=0.43..64,084.32 rows=213,197 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
385. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201807_reason_code_idx on p_log_201807 p_log_201807_3 (cost=0.43..64,282.64 rows=218,199 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
386. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201808_reason_code_idx on p_log_201808 p_log_201808_3 (cost=0.43..63,096.48 rows=210,326 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
387. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201809_reason_code_idx on p_log_201809 p_log_201809_3 (cost=0.43..58,494.82 rows=199,430 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
388. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201810_reason_code_idx on p_log_201810 p_log_201810_3 (cost=0.43..60,950.49 rows=211,100 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
389. 0.000 0.000 ↓ 0.0

Append (cost=0.42..255.45 rows=97 width=0) (actual rows= loops=)

390. 0.000 0.000 ↓ 0.0

Index Scan using p_log_pkey on p_log (cost=0.42..2.65 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
391. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201811_on_zero_pass_idx on p_log_201811 (cost=0.56..2.78 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
392. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201812_pkey on p_log_201812 (cost=0.43..2.66 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
393. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201111_on_zero_pass_idx on p_log_201111 (cost=0.42..2.64 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
394. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201110_on_zero_pass_idx on p_log_201110 (cost=0.28..2.50 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
395. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201112_on_zero_pass_idx on p_log_201112 (cost=0.42..2.64 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
396. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201201_on_zero_pass_idx on p_log_201201 (cost=0.42..2.64 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
397. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201202_on_zero_pass_idx on p_log_201202 (cost=0.42..2.64 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
398. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201203_on_zero_pass_idx on p_log_201203 (cost=0.42..2.64 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
399. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201204_on_zero_pass_idx on p_log_201204 (cost=0.42..2.64 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
400. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201901_pkey on p_log_201901 (cost=0.43..2.66 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
401. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201902_pkey on p_log_201902 (cost=0.43..2.66 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
402. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201903_pkey on p_log_201903 (cost=0.43..2.66 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
403. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201904_pkey on p_log_201904 (cost=0.43..2.66 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
404. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201905_pkey on p_log_201905 (cost=0.43..2.65 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
405. 0.000 0.000 ↓ 0.0

Index Scan using p_log_200901_201012_reason_code_idx on p_log_200901_201012 (cost=0.43..2.56 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
  • Filter: (p_id = pd.p_log_id)
406. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201101_201112_pkey on p_log_201101_201112 (cost=0.43..2.65 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
407. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201201_201204_on_zero_pass_idx on p_log_201201_201204 (cost=0.14..2.37 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
408. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201205_pkey on p_log_201205 (cost=0.42..2.64 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
409. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201206_pkey on p_log_201206 (cost=0.42..2.64 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
410. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201207_pkey on p_log_201207 (cost=0.42..2.64 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
411. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201208_pkey on p_log_201208 (cost=0.42..2.64 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
412. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201209_reason_code_idx on p_log_201209 (cost=0.43..2.01 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
  • Filter: (p_id = pd.p_log_id)
413. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201210_pkey on p_log_201210 (cost=0.43..2.65 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
414. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201211_pkey on p_log_201211 (cost=0.43..2.65 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
415. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201212_pkey on p_log_201212 (cost=0.43..2.65 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
416. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201301_reason_code_idx on p_log_201301 (cost=0.43..1.83 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
  • Filter: (p_id = pd.p_log_id)
417. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201302_reason_code_idx on p_log_201302 (cost=0.43..2.65 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
  • Filter: (p_id = pd.p_log_id)
418. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201303_pkey on p_log_201303 (cost=0.43..2.65 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
419. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201304_pkey on p_log_201304 (cost=0.43..2.65 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
420. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201305_pkey on p_log_201305 (cost=0.43..2.65 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
421. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201306_pkey on p_log_201306 (cost=0.43..2.65 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
422. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201307_pkey on p_log_201307 (cost=0.43..2.65 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
423. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201308_pkey on p_log_201308 (cost=0.43..2.65 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
424. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201309_pkey on p_log_201309 (cost=0.43..2.65 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
425. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201310_pkey on p_log_201310 (cost=0.43..2.65 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
426. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201311_pkey on p_log_201311 (cost=0.43..2.65 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
427. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201312_pkey on p_log_201312 (cost=0.43..2.65 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
428. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201401_pkey on p_log_201401 (cost=0.43..2.65 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
429. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201402_pkey on p_log_201402 (cost=0.43..2.65 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
430. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201403_pkey on p_log_201403 (cost=0.43..2.66 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
431. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201404_pkey on p_log_201404 (cost=0.43..2.65 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
432. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201405_pkey on p_log_201405 (cost=0.43..2.66 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
433. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201406_pkey on p_log_201406 (cost=0.43..2.65 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
434. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201407_pkey on p_log_201407 (cost=0.43..2.65 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
435. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201408_pkey on p_log_201408 (cost=0.43..2.65 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
436. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201409_pkey on p_log_201409 (cost=0.43..2.65 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
437. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201410_pkey on p_log_201410 (cost=0.43..2.66 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
438. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201411_pkey on p_log_201411 (cost=0.43..2.66 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
439. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201412_pkey on p_log_201412 (cost=0.43..2.66 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
440. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201501_pkey on p_log_201501 (cost=0.43..2.66 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
441. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201502_pkey on p_log_201502 (cost=0.43..2.65 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
442. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201503_pkey on p_log_201503 (cost=0.43..2.66 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
443. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201504_pkey on p_log_201504 (cost=0.43..2.66 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
444. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201505_pkey on p_log_201505 (cost=0.43..2.66 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
445. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201506_pkey on p_log_201506 (cost=0.43..2.66 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
446. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201507_pkey on p_log_201507 (cost=0.43..2.66 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
447. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201508_pkey on p_log_201508 (cost=0.43..2.66 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
448. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201509_pkey on p_log_201509 (cost=0.43..2.66 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
449. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201510_pkey on p_log_201510 (cost=0.43..2.66 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
450. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201511_pkey on p_log_201511 (cost=0.43..2.66 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
451. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201512_pkey on p_log_201512 (cost=0.43..2.66 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
452. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201601_pkey on p_log_201601 (cost=0.43..2.66 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
453. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201602_pkey on p_log_201602 (cost=0.43..2.66 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
454. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201603_pkey on p_log_201603 (cost=0.43..2.66 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
455. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201604_pkey on p_log_201604 (cost=0.43..2.66 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
456. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201605_pkey on p_log_201605 (cost=0.43..2.66 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
457. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201606_pkey on p_log_201606 (cost=0.43..2.66 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
458. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201607_pkey on p_log_201607 (cost=0.43..2.66 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
459. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201608_pkey on p_log_201608 (cost=0.43..2.66 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
460. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201609_pkey on p_log_201609 (cost=0.43..2.66 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
461. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201610_pkey on p_log_201610 (cost=0.43..2.66 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
462. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201611_pkey on p_log_201611 (cost=0.43..2.66 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
463. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201612_pkey on p_log_201612 (cost=0.43..2.66 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
464. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201701_pkey on p_log_201701 (cost=0.43..2.66 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
465. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201702_pkey on p_log_201702 (cost=0.43..2.66 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
466. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201703_pkey on p_log_201703 (cost=0.43..2.66 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
467. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201704_pkey on p_log_201704 (cost=0.43..2.66 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
468. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201705_pkey on p_log_201705 (cost=0.43..2.66 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
469. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201706_pkey on p_log_201706 (cost=0.43..2.66 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
470. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201707_pkey on p_log_201707 (cost=0.43..2.66 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
471. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201708_pkey on p_log_201708 (cost=0.43..2.66 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
472. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201709_pkey on p_log_201709 (cost=0.43..2.66 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
473. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201710_pkey on p_log_201710 (cost=0.43..2.66 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
474. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201711_pkey on p_log_201711 (cost=0.43..2.66 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
475. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201712_pkey on p_log_201712 (cost=0.43..2.66 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
476. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201801_pkey on p_log_201801 (cost=0.43..2.66 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
477. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201802_pkey on p_log_201802 (cost=0.43..2.66 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
478. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201803_pkey on p_log_201803 (cost=0.43..2.66 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
479. 0.000 0.000 ↓ 0.0

Index Scan using p_log_before_2009_pkey on p_log_before_2009 (cost=0.43..2.65 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
480. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201804_pkey on p_log_201804 (cost=0.43..2.66 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
481. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201805_pkey on p_log_201805 (cost=0.43..2.66 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
482. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201806_pkey on p_log_201806 (cost=0.43..2.66 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
483. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201807_pkey on p_log_201807 (cost=0.43..2.66 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
484. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201808_pkey on p_log_201808 (cost=0.43..2.66 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
485. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201809_pkey on p_log_201809 (cost=0.43..2.66 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
486. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201810_pkey on p_log_201810 (cost=0.43..2.66 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (p_id = pd.p_log_id)
  • Filter: (reason_code = 1061)
487. 0.000 0.000 ↓ 0.0

Append (cost=0.00..3,910,624.72 rows=12,724,697 width=8) (actual rows= loops=)

488. 0.000 0.000 ↓ 0.0

Seq Scan on p_log p_log_1 (cost=0.00..30,796.91 rows=1 width=8) (actual rows= loops=)

  • Filter: (reason_code = 1061)
489. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201811_reason_code_idx on p_log_201811 p_log_201811_1 (cost=0.56..59,802.39 rows=203,353 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
490. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201812_reason_code_idx on p_log_201812 p_log_201812_1 (cost=0.43..59,842.85 rows=207,285 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
491. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201111_reason_code_idx on p_log_201111 p_log_201111_1 (cost=0.42..205.49 rows=226 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
492. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201110_reason_code_idx on p_log_201110 p_log_201110_1 (cost=0.28..2.50 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
493. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201112_reason_code_idx on p_log_201112 p_log_201112_1 (cost=0.42..140.01 rows=148 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
494. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201201_reason_code_idx on p_log_201201 p_log_201201_1 (cost=0.42..143.18 rows=175 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
495. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201202_reason_code_idx on p_log_201202 p_log_201202_1 (cost=0.42..129.64 rows=155 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
496. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201203_reason_code_idx on p_log_201203 p_log_201203_1 (cost=0.42..151.42 rows=169 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
497. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201204_reason_code_idx on p_log_201204 p_log_201204_1 (cost=0.42..146.47 rows=165 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
498. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201901_reason_code_idx on p_log_201901 p_log_201901_1 (cost=0.43..62,283.77 rows=214,542 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
499. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201902_reason_code_idx on p_log_201902 p_log_201902_1 (cost=0.43..53,211.45 rows=178,243 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
500. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201903_reason_code_idx on p_log_201903 p_log_201903_1 (cost=0.43..59,287.79 rows=204,035 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
501. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201904_reason_code_idx on p_log_201904 p_log_201904_1 (cost=0.43..55,289.51 rows=187,002 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
502. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201905_reason_code_idx on p_log_201905 p_log_201905_1 (cost=0.43..27,573.55 rows=88,710 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
503. 0.000 0.000 ↓ 0.0

Index Scan using p_log_200901_201012_reason_code_idx on p_log_200901_201012 p_log_200901_201012_1 (cost=0.43..2.56 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
504. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201101_201112_reason_code_idx on p_log_201101_201112 p_log_201101_201112_1 (cost=0.43..1,338.98 rows=1,294 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
505. 0.000 0.000 ↓ 0.0

Seq Scan on p_log_201201_201204 p_log_201201_201204_1 (cost=0.00..11.62 rows=1 width=8) (actual rows= loops=)

  • Filter: (reason_code = 1061)
506. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201205_reason_code_idx on p_log_201205 p_log_201205_1 (cost=0.42..95.57 rows=126 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
507. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201206_reason_code_idx on p_log_201206 p_log_201206_1 (cost=0.42..73.49 rows=104 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
508. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201207_reason_code_idx on p_log_201207 p_log_201207_1 (cost=0.42..66.01 rows=101 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
509. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201208_reason_code_idx on p_log_201208 p_log_201208_1 (cost=0.42..126.97 rows=117 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
510. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201209_reason_code_idx on p_log_201209 p_log_201209_1 (cost=0.43..2.01 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
511. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201210_reason_code_idx on p_log_201210 p_log_201210_1 (cost=0.43..521.74 rows=1,507 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
512. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201211_reason_code_idx on p_log_201211 p_log_201211_1 (cost=0.43..758.01 rows=2,167 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
513. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201212_reason_code_idx on p_log_201212 p_log_201212_1 (cost=0.43..657.96 rows=1,913 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
514. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201301_reason_code_idx on p_log_201301 p_log_201301_1 (cost=0.43..1.83 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
515. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201302_reason_code_idx on p_log_201302 p_log_201302_1 (cost=0.43..2.65 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
516. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201303_reason_code_idx on p_log_201303 p_log_201303_1 (cost=0.43..888.50 rows=2,273 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
517. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201304_reason_code_idx on p_log_201304 p_log_201304_1 (cost=0.43..720.26 rows=2,160 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
518. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201305_reason_code_idx on p_log_201305 p_log_201305_1 (cost=0.43..8,199.87 rows=26,347 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
519. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201306_reason_code_idx on p_log_201306 p_log_201306_1 (cost=0.43..11,171.26 rows=37,062 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
520. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201307_reason_code_idx on p_log_201307 p_log_201307_1 (cost=0.43..13,959.23 rows=46,728 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
521. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201308_reason_code_idx on p_log_201308 p_log_201308_1 (cost=0.43..15,711.78 rows=51,730 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
522. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201309_reason_code_idx on p_log_201309 p_log_201309_1 (cost=0.43..16,563.43 rows=55,143 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
523. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201310_reason_code_idx on p_log_201310 p_log_201310_1 (cost=0.43..18,954.21 rows=61,646 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
524. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201311_reason_code_idx on p_log_201311 p_log_201311_1 (cost=0.43..20,971.59 rows=69,940 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
525. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201312_reason_code_idx on p_log_201312 p_log_201312_1 (cost=0.43..23,163.47 rows=75,714 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
526. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201401_reason_code_idx on p_log_201401 p_log_201401_1 (cost=0.43..25,314.25 rows=82,805 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
527. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201402_reason_code_idx on p_log_201402 p_log_201402_1 (cost=0.43..26,115.60 rows=81,518 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
528. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201403_reason_code_idx on p_log_201403 p_log_201403_1 (cost=0.43..30,901.43 rows=97,201 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
529. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201404_reason_code_idx on p_log_201404 p_log_201404_1 (cost=0.43..32,880.36 rows=103,530 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
530. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201405_reason_code_idx on p_log_201405 p_log_201405_1 (cost=0.43..33,035.81 rows=107,809 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
531. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201406_reason_code_idx on p_log_201406 p_log_201406_1 (cost=0.43..36,309.01 rows=116,368 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
532. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201407_reason_code_idx on p_log_201407 p_log_201407_1 (cost=0.43..36,245.44 rows=123,958 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
533. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201408_reason_code_idx on p_log_201408 p_log_201408_1 (cost=0.43..37,780.60 rows=129,865 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
534. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201409_reason_code_idx on p_log_201409 p_log_201409_1 (cost=0.43..35,815.36 rows=124,600 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
535. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201410_reason_code_idx on p_log_201410 p_log_201410_1 (cost=0.43..38,674.09 rows=139,123 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
536. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201411_reason_code_idx on p_log_201411 p_log_201411_1 (cost=0.43..38,124.94 rows=134,832 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
537. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201412_reason_code_idx on p_log_201412 p_log_201412_1 (cost=0.43..40,355.46 rows=143,113 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
538. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201501_reason_code_idx on p_log_201501 p_log_201501_1 (cost=0.43..41,645.66 rows=145,099 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
539. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201502_reason_code_idx on p_log_201502 p_log_201502_1 (cost=0.43..40,266.43 rows=135,374 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
540. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201503_reason_code_idx on p_log_201503 p_log_201503_1 (cost=0.43..45,619.65 rows=157,194 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
541. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201504_reason_code_idx on p_log_201504 p_log_201504_1 (cost=0.43..47,342.73 rows=155,776 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
542. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201505_reason_code_idx on p_log_201505 p_log_201505_1 (cost=0.43..49,664.38 rows=167,001 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
543. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201506_reason_code_idx on p_log_201506 p_log_201506_1 (cost=0.43..51,805.97 rows=171,787 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
544. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201507_reason_code_idx on p_log_201507 p_log_201507_1 (cost=0.43..56,380.73 rows=182,794 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
545. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201508_reason_code_idx on p_log_201508 p_log_201508_1 (cost=0.43..58,631.69 rows=188,014 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
546. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201509_reason_code_idx on p_log_201509 p_log_201509_1 (cost=0.43..56,264.92 rows=181,671 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
547. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201510_reason_code_idx on p_log_201510 p_log_201510_1 (cost=0.43..61,677.45 rows=198,554 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
548. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201511_reason_code_idx on p_log_201511 p_log_201511_1 (cost=0.43..61,914.58 rows=196,342 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
549. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201512_reason_code_idx on p_log_201512 p_log_201512_1 (cost=0.43..64,075.27 rows=204,932 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
550. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201601_reason_code_idx on p_log_201601 p_log_201601_1 (cost=0.43..63,762.82 rows=204,629 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
551. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201602_reason_code_idx on p_log_201602 p_log_201602_1 (cost=0.43..67,010.65 rows=207,590 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
552. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201603_reason_code_idx on p_log_201603 p_log_201603_1 (cost=0.43..68,193.52 rows=214,934 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
553. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201604_reason_code_idx on p_log_201604 p_log_201604_1 (cost=0.43..64,344.65 rows=204,626 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
554. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201605_reason_code_idx on p_log_201605 p_log_201605_1 (cost=0.43..68,859.53 rows=223,755 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
555. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201606_reason_code_idx on p_log_201606 p_log_201606_1 (cost=0.43..63,225.99 rows=203,464 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
556. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201607_reason_code_idx on p_log_201607 p_log_201607_1 (cost=0.43..65,713.31 rows=214,327 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
557. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201608_reason_code_idx on p_log_201608 p_log_201608_1 (cost=0.43..67,616.00 rows=222,351 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
558. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201609_reason_code_idx on p_log_201609 p_log_201609_1 (cost=0.43..62,284.55 rows=207,201 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
559. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201610_reason_code_idx on p_log_201610 p_log_201610_1 (cost=0.43..66,232.54 rows=219,734 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
560. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201611_reason_code_idx on p_log_201611 p_log_201611_1 (cost=0.43..68,849.48 rows=223,076 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
561. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201612_reason_code_idx on p_log_201612 p_log_201612_1 (cost=0.43..70,946.90 rows=229,729 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
562. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201701_reason_code_idx on p_log_201701 p_log_201701_1 (cost=0.43..67,379.33 rows=222,886 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
563. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201702_reason_code_idx on p_log_201702 p_log_201702_1 (cost=0.43..64,607.13 rows=202,189 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
564. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201703_reason_code_idx on p_log_201703 p_log_201703_1 (cost=0.43..74,178.88 rows=234,938 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
565. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201704_reason_code_idx on p_log_201704 p_log_201704_1 (cost=0.43..74,323.16 rows=231,586 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
566. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201705_reason_code_idx on p_log_201705 p_log_201705_1 (cost=0.43..74,942.00 rows=238,138 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
567. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201706_reason_code_idx on p_log_201706 p_log_201706_1 (cost=0.43..73,042.99 rows=229,820 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
568. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201707_reason_code_idx on p_log_201707 p_log_201707_1 (cost=0.43..78,285.97 rows=243,016 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
569. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201708_reason_code_idx on p_log_201708 p_log_201708_1 (cost=0.43..74,519.60 rows=236,219 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
570. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201709_reason_code_idx on p_log_201709 p_log_201709_1 (cost=0.43..71,900.95 rows=232,853 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
571. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201710_reason_code_idx on p_log_201710 p_log_201710_1 (cost=0.43..74,472.80 rows=240,769 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
572. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201711_reason_code_idx on p_log_201711 p_log_201711_1 (cost=0.43..70,303.98 rows=225,959 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
573. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201712_reason_code_idx on p_log_201712 p_log_201712_1 (cost=0.43..72,944.43 rows=238,646 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
574. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201801_reason_code_idx on p_log_201801 p_log_201801_1 (cost=0.43..70,482.52 rows=240,901 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
575. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201802_reason_code_idx on p_log_201802 p_log_201802_1 (cost=0.43..65,788.15 rows=210,706 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
576. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201803_reason_code_idx on p_log_201803 p_log_201803_1 (cost=0.43..69,309.64 rows=231,379 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
577. 0.000 0.000 ↓ 0.0

Index Scan using p_log_before_2009_reason_code_idx on p_log_before_2009 p_log_before_2009_1 (cost=0.43..973.30 rows=1,031 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
578. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201804_reason_code_idx on p_log_201804 p_log_201804_1 (cost=0.43..69,070.28 rows=224,520 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
579. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201805_reason_code_idx on p_log_201805 p_log_201805_1 (cost=0.43..66,339.20 rows=221,926 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
580. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201806_reason_code_idx on p_log_201806 p_log_201806_1 (cost=0.43..64,084.32 rows=213,197 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
581. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201807_reason_code_idx on p_log_201807 p_log_201807_1 (cost=0.43..64,282.64 rows=218,199 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
582. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201808_reason_code_idx on p_log_201808 p_log_201808_1 (cost=0.43..63,096.48 rows=210,326 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
583. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201809_reason_code_idx on p_log_201809 p_log_201809_1 (cost=0.43..58,494.82 rows=199,430 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
584. 0.000 0.000 ↓ 0.0

Index Scan using p_log_201810_reason_code_idx on p_log_201810 p_log_201810_1 (cost=0.43..60,950.49 rows=211,100 width=8) (actual rows= loops=)

  • Index Cond: (reason_code = 1061)
585. 0.000 0.000 ↓ 0.0

CTE Scan on pre_pl_l (cost=0.00..10,010.66 rows=500,533 width=200) (actual rows= loops=)