explain.depesz.com

PostgreSQL's explain analyze made readable

Result: rfvh

Settings
# exclusive inclusive rows x rows loops node
1. 0.059 1,021.622 ↑ 1.0 100 1

Limit (cost=4.11..2,624.40 rows=100 width=2,268) (actual time=973.109..1,021.622 rows=100 loops=1)

2. 1.129 1,021.563 ↑ 446,314,253.4 100 1

Nested Loop Left Join (cost=4.11..1,169,469,922,842.65 rows=44,631,425,335 width=2,268) (actual time=973.109..1,021.563 rows=100 loops=1)

  • Join Filter: (nst.id = nsp.type_id)
  • Rows Removed by Join Filter: 1800
3. 0.082 1,018.252 ↑ 446,314,253.4 100 1

Nested Loop Left Join (cost=4.11..330,620,353,244.98 rows=44,631,425,335 width=1,540) (actual time=972.903..1,018.252 rows=100 loops=1)

4. 0.082 1,018.170 ↑ 446,314,253.4 100 1

Nested Loop Left Join (cost=3.97..323,257,690,963.54 rows=44,631,425,335 width=1,426) (actual time=972.895..1,018.170 rows=100 loops=1)

5. 0.135 1,018.088 ↑ 446,314,253.4 100 1

Nested Loop Left Join (cost=3.82..315,895,028,682.10 rows=44,631,425,335 width=1,312) (actual time=972.889..1,018.088 rows=100 loops=1)

  • Join Filter: (pst.id = psp.type_id)
  • Rows Removed by Join Filter: 1800
6. 0.213 1,017.853 ↑ 446,314,253.4 100 1

Nested Loop Left Join (cost=3.82..305,739,448,992.04 rows=44,631,425,335 width=1,243) (actual time=972.877..1,017.853 rows=100 loops=1)

7. 0.142 1,017.640 ↑ 446,314,253.4 100 1

Nested Loop Left Join (cost=3.38..285,208,972,555.72 rows=44,631,425,335 width=1,223) (actual time=972.862..1,017.640 rows=100 loops=1)

  • Join Filter: (nft.id = nfp.type_id)
  • Rows Removed by Join Filter: 1800
8. 0.079 1,017.398 ↑ 446,314,253.4 100 1

Nested Loop Left Join (cost=3.38..275,053,392,865.66 rows=44,631,425,335 width=1,154) (actual time=972.850..1,017.398 rows=100 loops=1)

9. 0.062 1,017.319 ↑ 446,314,253.4 100 1

Nested Loop Left Join (cost=3.23..267,690,730,584.21 rows=44,631,425,335 width=1,040) (actual time=972.844..1,017.319 rows=100 loops=1)

10. 0.127 1,017.157 ↑ 446,314,253.4 100 1

Nested Loop Left Join (cost=3.08..260,328,068,302.77 rows=44,631,425,335 width=868) (actual time=972.834..1,017.157 rows=100 loops=1)

  • Join Filter: (ct.id = cp.type_id)
  • Rows Removed by Join Filter: 405
11. 0.108 1,017.030 ↑ 446,314,253.4 100 1

Nested Loop Left Join (cost=3.08..250,172,488,612.71 rows=44,631,425,335 width=783) (actual time=972.825..1,017.030 rows=100 loops=1)

12. 0.179 1,016.722 ↑ 446,314,253.4 100 1

Nested Loop Left Join (cost=2.65..230,311,483,556.42 rows=44,631,425,335 width=755) (actual time=972.816..1,016.722 rows=100 loops=1)

13. 0.127 1,016.543 ↑ 446,314,253.4 100 1

Nested Loop Left Join (cost=2.21..209,781,007,120.09 rows=44,631,425,335 width=735) (actual time=972.803..1,016.543 rows=100 loops=1)

  • Join Filter: (pft.id = pfp.type_id)
  • Rows Removed by Join Filter: 1800
14. 0.137 1,016.316 ↑ 446,314,253.4 100 1

Nested Loop Left Join (cost=2.21..199,625,427,430.03 rows=44,631,425,335 width=666) (actual time=972.791..1,016.316 rows=100 loops=1)

  • Join Filter: (nt.id = np.type_id)
  • Rows Removed by Join Filter: 1800
15. 0.067 1,016.079 ↑ 446,314,253.4 100 1

Nested Loop Left Join (cost=2.21..189,469,847,739.98 rows=44,631,425,335 width=597) (actual time=972.779..1,016.079 rows=100 loops=1)

16. 0.071 1,016.012 ↑ 446,314,253.4 100 1

Nested Loop Left Join (cost=2.06..182,107,185,458.53 rows=44,631,425,335 width=483) (actual time=972.774..1,016.012 rows=100 loops=1)

17. 0.078 1,015.941 ↑ 446,314,253.4 100 1

Nested Loop Left Join (cost=1.92..174,744,523,177.09 rows=44,631,425,335 width=369) (actual time=972.768..1,015.941 rows=100 loops=1)

18. 0.187 1,015.863 ↑ 446,314,253.4 100 1

Nested Loop Left Join (cost=1.77..167,381,860,895.65 rows=44,631,425,335 width=255) (actual time=972.761..1,015.863 rows=100 loops=1)

19. 0.174 1,015.676 ↑ 446,314,253.4 100 1

Nested Loop Left Join (cost=1.33..146,851,384,459.32 rows=44,631,425,335 width=231) (actual time=972.748..1,015.676 rows=100 loops=1)

20. 0.191 1,015.502 ↑ 446,314,253.4 100 1

Nested Loop Left Join (cost=0.89..126,320,908,023.00 rows=44,631,425,335 width=207) (actual time=972.735..1,015.502 rows=100 loops=1)

21. 0.140 1,015.311 ↑ 446,314,253.4 100 1

Nested Loop Left Join (cost=0.44..105,790,431,586.68 rows=44,631,425,335 width=183) (actual time=972.717..1,015.311 rows=100 loops=1)

  • Join Filter: (pt.id = pp.type_id)
  • Rows Removed by Join Filter: 1800
22. 0.219 1,015.071 ↑ 446,314,253.4 100 1

Nested Loop Left Join (cost=0.44..95,634,851,896.62 rows=44,631,425,335 width=114) (actual time=972.695..1,015.071 rows=100 loops=1)

  • -> Index Scan using t_card_period_pkey on t_card_period pp (cost=0.44..0.46 rows=1 width=28) (actual time=0.000..0.000 rows=0 (...)
23. 1,014.751 1,014.852 ↑ 446,314,253.4 100 1

Append (cost=0.00..74,658,061,206.95 rows=44,631,425,335 width=90) (actual time=972.674..1,014.852 rows=100 loops=1)

  • -> Subquery Scan on "*SELECT* 2" (cost=108533.13..74434904080.28 rows=44631425334 width=38) (actual time=972.672..1014.8 (...)
  • Index Cond: (id = (SubPlan 66))
24. 0.001 0.001 ↓ 0.0 0 1

Result (cost=0.00..0.00 rows=0 width=90) (actual time=0.001..0.001 rows=0 loops=1)

  • One-Time Filter: false
  • -> Hash Join (cost=108533.13..73877011263.60 rows=44631425334 width=34) (actual time=972.670..1014.807 rows=100 lo (...)
25.          

SubPlan (for Result)

26. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.43..1.65 rows=1 width=4) (never executed)

  • -> Index Only Scan using t_card_period_pkey on t_card_period cp_1 (cost=0.43..1.65 rows=1 width=4) (never (...)
  • Index Cond: (id = loyal_period_id)
  • Heap Fetches: 0
  • Hash Cond: (s.club_card_scan_code = c.scan_code)
  • -> Nested Loop (cost=0.42..6314717.52 rows=44631425334 width=38) (actual time=0.125..41.812 rows=100 loops=1 (...)
27. 7.616 7.616 ↑ 501.7 24,883 1

Append (cost=0.00..486,482.76 rows=12,484,664 width=18) (actual time=0.009..7.616 rows=24,883 loops=1)

  • -> Seq Scan on t_roznica_outcome_head_2018 h (cost=0.00..3778.29 rows=113949 width=18) (actual t (...)
  • -> Seq Scan on t_roznica_outcome_head_2019 h_1 (cost=0.00..420209.85 rows=12368985 width=18) (ne (...)
  • -> Seq Scan on t_roznica_outcome_head_2020 h_2 (cost=0.00..13.80 rows=180 width=70) (never execu (...)
  • -> Seq Scan on t_roznica_outcome_head_default h_3 (cost=0.00..57.50 rows=1550 width=18) (never e (...)
28. 24.883 24.883 ↓ 0.0 0 24,883

Append (cost=0.42..0.46 rows=1 width=28) (actual time=0.001..0.001 rows=0 loops=24,883)

  • -> Index Scan using t_roznica_outcome_service_def_pivot_roznica_outcome_head_id_idx on t_roznica_ (...)
  • Index Cond: (pivot_roznica_outcome_head_id = h.pivot_roznica_outcome_head_id)
  • Filter: ((club_card_scan_code IS NOT NULL) AND (service_id = 3) AND ((outcome_date_sale)::da (...)
29. 967.899 967.899 ↓ 1.0 3,183,867 1

Hash (cost=69,110.09..69,110.09 rows=3,153,809 width=12) (actual time=967.899..967.899 rows=3,183,867 loops=1)

  • Buckets: 4194304 Batches: 1 Memory Usage: 182012kB
  • -> Seq Scan on t_card c (cost=0.00..69110.09 rows=3153809 width=12) (actual time=0.014..390.683 rows=3 (...)
30.          

SubPlan (for Limit)

31. 0.300 0.300 ↑ 1.0 1 100

Limit (cost=0.43..1.65 rows=1 width=4) (actual time=0.003..0.003 rows=1 loops=100)

  • -> Index Only Scan using t_card_period_pkey on t_card_period pe (cost=0.43..1.65 rows=1 width=4) (ac (...)
  • Index Cond: (id = h.loyal_period_id)
  • Heap Fetches: 19
32.          

SubPlan (for Append)

33. 0.000 0.100 ↓ 0.0 0 100

Limit (cost=0.01..0.02 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=100)

34. 0.100 0.100 ↓ 0.0 0 100

Sort (cost=0.01..0.02 rows=0 width=8) (actual time=0.001..0.001 rows=0 loops=100)

  • Sort Key: ((outcome_date_sale)::date) DESC
  • Sort Method: quicksort Memory: 25kB
35. 0.000 0.000 ↓ 0.0 0 100

Result (cost=0.00..0.00 rows=0 width=8) (actual time=0.000..0.000 rows=0 loops=100)

  • One-Time Filter: false
36. 0.088 0.100 ↓ 1.1 18 100

Materialize (cost=0.00..1.44 rows=16 width=77) (actual time=0.000..0.001 rows=18 loops=100)

37. 0.012 0.012 ↓ 1.1 18 1

Seq Scan on t_card_period_type pt (cost=0.00..1.36 rows=16 width=77) (actual time=0.009..0.012 rows=18 loops=1)

38. 0.000 0.000 ↓ 0.0 0 100

Index Scan using t_card_period_pkey on t_card_period nfp (cost=0.44..0.46 rows=1 width=24) (actual time=0.000..0.000 rows=0 loops=100)

  • Index Cond: (id = (SubPlan 70))
39.          

SubPlan (for Index Scan)

40. 0.000 0.100 ↓ 0.0 0 100

Limit (cost=0.01..0.02 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=100)

41. 0.100 0.100 ↓ 0.0 0 100

Sort (cost=0.01..0.02 rows=0 width=8) (actual time=0.001..0.001 rows=0 loops=100)

  • Sort Key: ((outcome_date_sale)::date)
  • Sort Method: quicksort Memory: 25kB
42. 0.000 0.000 ↓ 0.0 0 100

Result (cost=0.00..0.00 rows=0 width=8) (actual time=0.000..0.000 rows=0 loops=100)

  • One-Time Filter: false
43. 0.000 0.000 ↓ 0.0 0 100

Index Scan using t_card_period_pkey on t_card_period np (cost=0.44..0.46 rows=1 width=28) (actual time=0.000..0.000 rows=0 loops=100)

  • Index Cond: (id = (SubPlan 69))
44.          

SubPlan (for Index Scan)

45. 0.100 0.100 ↓ 0.0 0 100

Limit (cost=0.01..0.02 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=100)

46. 0.000 0.000 ↓ 0.0 0 100

Sort (cost=0.01..0.02 rows=0 width=8) (actual time=0.000..0.000 rows=0 loops=100)

  • Sort Key: ((outcome_date_sale)::date)
  • Sort Method: quicksort Memory: 25kB
47. 0.000 0.000 ↓ 0.0 0 100

Result (cost=0.00..0.00 rows=0 width=8) (actual time=0.000..0.000 rows=0 loops=100)

  • One-Time Filter: false
48. 0.000 0.000 ↓ 0.0 0 100

Index Scan using t_card_period_pkey on t_card_period pfp (cost=0.44..0.46 rows=1 width=24) (actual time=0.000..0.000 rows=0 loops=100)

  • Index Cond: (id = (SubPlan 67))
49.          

SubPlan (for Index Scan)

50. 0.100 0.100 ↓ 0.0 0 100

Limit (cost=0.01..0.02 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=100)

51. 0.000 0.000 ↓ 0.0 0 100

Sort (cost=0.01..0.02 rows=0 width=8) (actual time=0.000..0.000 rows=0 loops=100)

  • Sort Key: ((outcome_date_sale)::date) DESC
  • Sort Method: quicksort Memory: 25kB
52. 0.000 0.000 ↓ 0.0 0 100

Result (cost=0.00..0.00 rows=0 width=8) (actual time=0.000..0.000 rows=0 loops=100)

  • One-Time Filter: false
53. 0.000 0.000 ↓ 0.0 0 100

Index Scan using t_card_period_status_pkey on t_card_period_status ps (cost=0.15..0.17 rows=1 width=122) (actual time=0.000..0.000 rows=0 loops=100)

  • Index Cond: (id = pp.status_id)
54. 0.000 0.000 ↓ 0.0 0 100

Index Scan using t_card_period_status_pkey on t_card_period_status pfs (cost=0.15..0.17 rows=1 width=122) (actual time=0.000..0.000 rows=0 loops=100)

  • Index Cond: (id = pfp.status_id)
55. 0.000 0.000 ↓ 0.0 0 100

Index Scan using t_card_period_status_pkey on t_card_period_status nfs (cost=0.15..0.17 rows=1 width=122) (actual time=0.000..0.000 rows=0 loops=100)

  • Index Cond: (id = nfp.status_id)
56. 0.095 0.100 ↓ 1.1 18 100

Materialize (cost=0.00..1.44 rows=16 width=77) (actual time=0.000..0.001 rows=18 loops=100)

57. 0.005 0.005 ↓ 1.1 18 1

Seq Scan on t_card_period_type nt (cost=0.00..1.36 rows=16 width=77) (actual time=0.002..0.005 rows=18 loops=1)

58. 0.096 0.100 ↓ 1.1 18 100

Materialize (cost=0.00..1.44 rows=16 width=77) (actual time=0.000..0.001 rows=18 loops=100)

59. 0.004 0.004 ↓ 1.1 18 1

Seq Scan on t_card_period_type pft (cost=0.00..1.36 rows=16 width=77) (actual time=0.002..0.004 rows=18 loops=1)

60. 0.000 0.000 ↓ 0.0 0 100

Index Scan using t_card_period_pkey on t_card_period nsp (cost=0.44..0.46 rows=1 width=24) (actual time=0.000..0.000 rows=0 loops=100)

  • Index Cond: (id = (SubPlan 71))
61.          

SubPlan (for Index Scan)

62. 0.100 0.100 ↓ 0.0 0 100

Limit (cost=0.01..0.02 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=100)

63. 0.000 0.000 ↓ 0.0 0 100

Sort (cost=0.01..0.02 rows=0 width=8) (actual time=0.000..0.000 rows=0 loops=100)

  • Sort Key: ((outcome_date_sale)::date)
  • Sort Method: quicksort Memory: 25kB
64. 0.000 0.000 ↓ 0.0 0 100

Result (cost=0.00..0.00 rows=0 width=8) (actual time=0.000..0.000 rows=0 loops=100)

  • One-Time Filter: false
65. 0.200 0.200 ↑ 1.0 1 100

Index Scan using t_card_period_pkey on t_card_period cp (cost=0.43..0.45 rows=1 width=28) (actual time=0.002..0.002 rows=1 loops=100)

  • Index Cond: (id = ((SubPlan 72)))
66. 0.000 0.000 ↑ 3.2 5 100

Materialize (cost=0.00..1.44 rows=16 width=89) (actual time=0.000..0.000 rows=5 loops=100)

67. 0.005 0.005 ↓ 1.1 18 1

Seq Scan on t_card_period_type ct (cost=0.00..1.36 rows=16 width=89) (actual time=0.002..0.005 rows=18 loops=1)

68. 0.100 0.100 ↑ 1.0 1 100

Index Scan using t_card_period_status_pkey on t_card_period_status cs (cost=0.15..0.17 rows=1 width=180) (actual time=0.001..0.001 rows=1 loops=100)

  • Index Cond: (id = cp.status_id)
69. 0.000 0.000 ↓ 0.0 0 100

Index Scan using t_card_period_status_pkey on t_card_period_status ns (cost=0.15..0.17 rows=1 width=122) (actual time=0.000..0.000 rows=0 loops=100)

  • Index Cond: (id = np.status_id)
70. 0.096 0.100 ↓ 1.1 18 100

Materialize (cost=0.00..1.44 rows=16 width=77) (actual time=0.000..0.001 rows=18 loops=100)

71. 0.004 0.004 ↓ 1.1 18 1

Seq Scan on t_card_period_type nft (cost=0.00..1.36 rows=16 width=77) (actual time=0.002..0.004 rows=18 loops=1)

72. 0.000 0.000 ↓ 0.0 0 100

Index Scan using t_card_period_pkey on t_card_period psp (cost=0.44..0.46 rows=1 width=24) (actual time=0.000..0.000 rows=0 loops=100)

  • Index Cond: (id = (SubPlan 68))
73.          

SubPlan (for Index Scan)

74. 0.000 0.100 ↓ 0.0 0 100

Limit (cost=0.01..0.02 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=100)

75. 0.100 0.100 ↓ 0.0 0 100

Sort (cost=0.01..0.02 rows=0 width=8) (actual time=0.001..0.001 rows=0 loops=100)

  • Sort Key: ((outcome_date_sale)::date) DESC
  • Sort Method: quicksort Memory: 25kB
76. 0.000 0.000 ↓ 0.0 0 100

Result (cost=0.00..0.00 rows=0 width=8) (actual time=0.000..0.000 rows=0 loops=100)

  • One-Time Filter: false
77. 0.096 0.100 ↓ 1.1 18 100

Materialize (cost=0.00..1.44 rows=16 width=77) (actual time=0.000..0.001 rows=18 loops=100)

78. 0.004 0.004 ↓ 1.1 18 1

Seq Scan on t_card_period_type pst (cost=0.00..1.36 rows=16 width=77) (actual time=0.002..0.004 rows=18 loops=1)

79. 0.000 0.000 ↓ 0.0 0 100

Index Scan using t_card_period_status_pkey on t_card_period_status pss (cost=0.15..0.17 rows=1 width=122) (actual time=0.000..0.000 rows=0 loops=100)

  • Index Cond: (id = psp.status_id)
80. 0.000 0.000 ↓ 0.0 0 100

Index Scan using t_card_period_status_pkey on t_card_period_status nss (cost=0.15..0.17 rows=1 width=122) (actual time=0.000..0.000 rows=0 loops=100)

  • Index Cond: (id = nsp.status_id)
81. 0.096 0.100 ↓ 1.1 18 100

Materialize (cost=0.00..1.44 rows=16 width=77) (actual time=0.000..0.001 rows=18 loops=100)

82. 0.004 0.004 ↓ 1.1 18 1

Seq Scan on t_card_period_type nst (cost=0.00..1.36 rows=16 width=77) (actual time=0.002..0.004 rows=18 loops=1)

83.          

SubPlan (for Nested Loop Left Join)

84. 0.000 0.100 ↓ 0.0 0 100

Limit (cost=0.01..0.02 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=100)

85. 0.100 0.100 ↓ 0.0 0 100

Sort (cost=0.01..0.02 rows=0 width=4) (actual time=0.001..0.001 rows=0 loops=100)

  • Sort Key: ((outcome_date_sale)::date) DESC
  • Sort Method: quicksort Memory: 25kB
86. 0.000 0.000 ↓ 0.0 0 100

Result (cost=0.00..0.00 rows=0 width=4) (actual time=0.000..0.000 rows=0 loops=100)

  • One-Time Filter: false
87. 0.000 0.007 ↓ 0.0 0 7

Limit (cost=0.01..0.02 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=7)

88. 0.007 0.007 ↓ 0.0 0 7

Sort (cost=0.01..0.02 rows=0 width=4) (actual time=0.001..0.001 rows=0 loops=7)

  • Sort Key: ((outcome_date_sale)::date)
  • Sort Method: quicksort Memory: 25kB
89. 0.000 0.000 ↓ 0.0 0 7

Result (cost=0.00..0.00 rows=0 width=4) (actual time=0.000..0.000 rows=0 loops=7)

  • One-Time Filter: false
90. 0.000 0.035 ↑ 1.0 1 7

Limit (cost=0.43..2.85 rows=1 width=4) (actual time=0.005..0.005 rows=1 loops=7)

91. 0.007 0.035 ↑ 1.0 1 7

Result (cost=0.43..2.85 rows=1 width=4) (actual time=0.005..0.005 rows=1 loops=7)

  • One-Time Filter: (COALESCE(((SubPlan 72)), 0) <= 0)
92. 0.028 0.028 ↑ 1.0 1 7

Index Scan using t_card_pkey on t_card ca (cost=0.43..2.85 rows=1 width=4) (actual time=0.004..0.004 rows=1 loops=7)

  • Index Cond: (id = loyal_card_id)
93. 0.000 0.007 ↓ 0.0 0 7

Limit (cost=0.01..0.02 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=7)

94. 0.007 0.007 ↓ 0.0 0 7

Sort (cost=0.01..0.02 rows=0 width=4) (actual time=0.001..0.001 rows=0 loops=7)

  • Sort Key: ((outcome_date_sale)::date)
  • Sort Method: quicksort Memory: 25kB
95. 0.000 0.000 ↓ 0.0 0 7

Result (cost=0.00..0.00 rows=0 width=4) (actual time=0.000..0.000 rows=0 loops=7)

  • One-Time Filter: false
96. 0.000 0.021 ↑ 1.0 1 7

Limit (cost=0.43..2.85 rows=1 width=4) (actual time=0.003..0.003 rows=1 loops=7)

97. 0.007 0.021 ↑ 1.0 1 7

Result (cost=0.43..2.85 rows=1 width=4) (actual time=0.003..0.003 rows=1 loops=7)

  • One-Time Filter: (COALESCE(((SubPlan 72)), 0) <= 0)
98. 0.014 0.014 ↑ 1.0 1 7

Index Scan using t_card_pkey on t_card ca_1 (cost=0.43..2.85 rows=1 width=4) (actual time=0.002..0.002 rows=1 loops=7)

  • Index Cond: (id = loyal_card_id)
99. 0.000 0.100 ↓ 0.0 0 100

Limit (cost=0.01..0.02 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=100)

100. 0.100 0.100 ↓ 0.0 0 100

Sort (cost=0.01..0.02 rows=0 width=8) (actual time=0.001..0.001 rows=0 loops=100)

  • Sort Key: ((outcome_date_sale)::date) DESC
  • Sort Method: quicksort Memory: 25kB
101. 0.000 0.000 ↓ 0.0 0 100

Result (cost=0.00..0.00 rows=0 width=8) (actual time=0.000..0.000 rows=0 loops=100)

  • One-Time Filter: false
102. 0.100 0.100 ↓ 0.0 0 100

Limit (cost=0.01..0.02 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=100)

103. 0.000 0.000 ↓ 0.0 0 100

Sort (cost=0.01..0.02 rows=0 width=8) (actual time=0.000..0.000 rows=0 loops=100)

  • Sort Key: ((outcome_date_sale)::date) DESC
  • Sort Method: quicksort Memory: 25kB
104. 0.000 0.000 ↓ 0.0 0 100

Result (cost=0.00..0.00 rows=0 width=8) (actual time=0.000..0.000 rows=0 loops=100)

  • One-Time Filter: false
105. 0.000 0.000 ↓ 0.0 0 100

Limit (cost=0.01..0.02 rows=1 width=8) (actual time=0.000..0.000 rows=0 loops=100)

106. 0.000 0.000 ↓ 0.0 0 100

Sort (cost=0.01..0.02 rows=0 width=8) (actual time=0.000..0.000 rows=0 loops=100)

  • Sort Key: ((outcome_date_sale)::date) DESC
  • Sort Method: quicksort Memory: 25kB
107. 0.000 0.000 ↓ 0.0 0 100

Result (cost=0.00..0.00 rows=0 width=8) (actual time=0.000..0.000 rows=0 loops=100)

  • One-Time Filter: false
108. 0.100 0.100 ↓ 0.0 0 100

Limit (cost=0.01..0.02 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=100)

109. 0.000 0.000 ↓ 0.0 0 100

Sort (cost=0.01..0.02 rows=0 width=8) (actual time=0.000..0.000 rows=0 loops=100)

  • Sort Key: ((outcome_date_sale)::date) DESC
  • Sort Method: quicksort Memory: 25kB
110. 0.000 0.000 ↓ 0.0 0 100

Result (cost=0.00..0.00 rows=0 width=8) (actual time=0.000..0.000 rows=0 loops=100)

  • One-Time Filter: false
111. 0.100 0.100 ↓ 0.0 0 100

Limit (cost=0.01..0.02 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=100)

112. 0.000 0.000 ↓ 0.0 0 100

Sort (cost=0.01..0.02 rows=0 width=8) (actual time=0.000..0.000 rows=0 loops=100)

  • Sort Key: ((outcome_date_sale)::date) DESC
  • Sort Method: quicksort Memory: 25kB
113. 0.000 0.000 ↓ 0.0 0 100

Result (cost=0.00..0.00 rows=0 width=8) (actual time=0.000..0.000 rows=0 loops=100)

  • One-Time Filter: false
114. 0.100 0.100 ↓ 0.0 0 100

Limit (cost=0.01..0.02 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=100)

115. 0.000 0.000 ↓ 0.0 0 100

Sort (cost=0.01..0.02 rows=0 width=8) (actual time=0.000..0.000 rows=0 loops=100)

  • Sort Key: ((outcome_date_sale)::date) DESC
  • Sort Method: quicksort Memory: 25kB
116. 0.000 0.000 ↓ 0.0 0 100

Result (cost=0.00..0.00 rows=0 width=8) (actual time=0.000..0.000 rows=0 loops=100)

  • One-Time Filter: false
117. 0.100 0.100 ↓ 0.0 0 100

Limit (cost=0.01..0.02 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=100)

118. 0.000 0.000 ↓ 0.0 0 100

Sort (cost=0.01..0.02 rows=0 width=8) (actual time=0.000..0.000 rows=0 loops=100)

  • Sort Key: ((outcome_date_sale)::date)
  • Sort Method: quicksort Memory: 25kB
119. 0.000 0.000 ↓ 0.0 0 100

Result (cost=0.00..0.00 rows=0 width=8) (actual time=0.000..0.000 rows=0 loops=100)

  • One-Time Filter: false
120. 0.100 0.100 ↓ 0.0 0 100

Limit (cost=0.01..0.02 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=100)

121. 0.000 0.000 ↓ 0.0 0 100

Sort (cost=0.01..0.02 rows=0 width=8) (actual time=0.000..0.000 rows=0 loops=100)

  • Sort Key: ((outcome_date_sale)::date)
  • Sort Method: quicksort Memory: 25kB
122. 0.000 0.000 ↓ 0.0 0 100

Result (cost=0.00..0.00 rows=0 width=8) (actual time=0.000..0.000 rows=0 loops=100)

  • One-Time Filter: false
123. 0.100 0.100 ↓ 0.0 0 100

Limit (cost=0.01..0.02 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=100)

124. 0.000 0.000 ↓ 0.0 0 100

Sort (cost=0.01..0.02 rows=0 width=8) (actual time=0.000..0.000 rows=0 loops=100)

  • Sort Key: ((outcome_date_sale)::date)
  • Sort Method: quicksort Memory: 25kB
125. 0.000 0.000 ↓ 0.0 0 100

Result (cost=0.00..0.00 rows=0 width=8) (actual time=0.000..0.000 rows=0 loops=100)

  • One-Time Filter: false
126. 0.100 0.100 ↓ 0.0 0 100

Limit (cost=0.01..0.02 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=100)

127. 0.000 0.000 ↓ 0.0 0 100

Sort (cost=0.01..0.02 rows=0 width=8) (actual time=0.000..0.000 rows=0 loops=100)

  • Sort Key: ((outcome_date_sale)::date)
  • Sort Method: quicksort Memory: 25kB
128. 0.000 0.000 ↓ 0.0 0 100

Result (cost=0.00..0.00 rows=0 width=8) (actual time=0.000..0.000 rows=0 loops=100)

  • One-Time Filter: false
129. 0.100 0.100 ↓ 0.0 0 100

Limit (cost=0.01..0.02 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=100)

130. 0.000 0.000 ↓ 0.0 0 100

Sort (cost=0.01..0.02 rows=0 width=8) (actual time=0.000..0.000 rows=0 loops=100)

  • Sort Key: ((outcome_date_sale)::date)
  • Sort Method: quicksort Memory: 25kB
131. 0.000 0.000 ↓ 0.0 0 100

Result (cost=0.00..0.00 rows=0 width=8) (actual time=0.000..0.000 rows=0 loops=100)

  • One-Time Filter: false
132. 0.100 0.100 ↓ 0.0 0 100

Limit (cost=0.01..0.02 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=100)

133. 0.000 0.000 ↓ 0.0 0 100

Sort (cost=0.01..0.02 rows=0 width=8) (actual time=0.000..0.000 rows=0 loops=100)

  • Sort Key: ((outcome_date_sale)::date)
  • Sort Method: quicksort Memory: 25kB
134. 0.000 0.000 ↓ 0.0 0 100

Result (cost=0.00..0.00 rows=0 width=8) (actual time=0.000..0.000 rows=0 loops=100)

  • One-Time Filter: false
135. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.01..0.02 rows=1 width=8) (never executed)

136. 0.000 0.000 ↓ 0.0 0

Sort (cost=0.01..0.02 rows=0 width=8) (never executed)

  • Sort Key: ((outcome_date_sale)::date) DESC
137. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.00 rows=0 width=8) (never executed)

  • One-Time Filter: false
138. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.01..0.02 rows=1 width=8) (never executed)

139. 0.000 0.000 ↓ 0.0 0

Sort (cost=0.01..0.02 rows=0 width=8) (never executed)

  • Sort Key: ((outcome_date_sale)::date) DESC
140. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.00 rows=0 width=8) (never executed)

  • One-Time Filter: false
141. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.01..0.02 rows=1 width=8) (never executed)

142. 0.000 0.000 ↓ 0.0 0

Sort (cost=0.01..0.02 rows=0 width=8) (never executed)

  • Sort Key: ((outcome_date_sale)::date) DESC
143. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.00 rows=0 width=8) (never executed)

  • One-Time Filter: false
144. 0.093 0.093 ↓ 0.0 0 93

Limit (cost=0.01..0.02 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=93)

145. 0.000 0.000 ↓ 0.0 0 93

Sort (cost=0.01..0.02 rows=0 width=8) (actual time=0.000..0.000 rows=0 loops=93)

  • Sort Key: ((outcome_date_sale)::date) DESC
  • Sort Method: quicksort Memory: 25kB
146. 0.000 0.000 ↓ 0.0 0 93

Result (cost=0.00..0.00 rows=0 width=8) (actual time=0.000..0.000 rows=0 loops=93)

  • One-Time Filter: false
147. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.01..0.02 rows=1 width=8) (never executed)

148. 0.000 0.000 ↓ 0.0 0

Sort (cost=0.01..0.02 rows=0 width=8) (never executed)

  • Sort Key: ((outcome_date_sale)::date) DESC
149. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.00 rows=0 width=8) (never executed)

  • One-Time Filter: false
150. 0.000 0.014 ↓ 0.0 0 7

Limit (cost=0.01..0.02 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=7)

151. 0.014 0.014 ↓ 0.0 0 7

Sort (cost=0.01..0.02 rows=0 width=8) (actual time=0.002..0.002 rows=0 loops=7)

  • Sort Key: ((outcome_date_sale)::date) DESC
  • Sort Method: quicksort Memory: 25kB
152. 0.000 0.000 ↓ 0.0 0 7

Result (cost=0.00..0.00 rows=0 width=8) (actual time=0.000..0.000 rows=0 loops=7)

  • One-Time Filter: false
153. 0.000 0.007 ↓ 0.0 0 7

Limit (cost=0.01..0.02 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=7)

154. 0.007 0.007 ↓ 0.0 0 7

Sort (cost=0.01..0.02 rows=0 width=8) (actual time=0.001..0.001 rows=0 loops=7)

  • Sort Key: ((outcome_date_sale)::date) DESC
  • Sort Method: quicksort Memory: 25kB
155. 0.000 0.000 ↓ 0.0 0 7

Result (cost=0.00..0.00 rows=0 width=8) (actual time=0.000..0.000 rows=0 loops=7)

  • One-Time Filter: false
156. 0.000 0.007 ↓ 0.0 0 7

Limit (cost=0.01..0.02 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=7)

157. 0.007 0.007 ↓ 0.0 0 7

Sort (cost=0.01..0.02 rows=0 width=8) (actual time=0.001..0.001 rows=0 loops=7)

  • Sort Key: ((outcome_date_sale)::date) DESC
  • Sort Method: quicksort Memory: 25kB
158. 0.000 0.000 ↓ 0.0 0 7

Result (cost=0.00..0.00 rows=0 width=8) (actual time=0.000..0.000 rows=0 loops=7)

  • One-Time Filter: false
159. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.01..0.02 rows=1 width=8) (never executed)

160. 0.000 0.000 ↓ 0.0 0

Sort (cost=0.01..0.02 rows=0 width=8) (never executed)

  • Sort Key: ((outcome_date_sale)::date)
161. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.00 rows=0 width=8) (never executed)

  • One-Time Filter: false
162. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.01..0.02 rows=1 width=8) (never executed)

163. 0.000 0.000 ↓ 0.0 0

Sort (cost=0.01..0.02 rows=0 width=8) (never executed)

  • Sort Key: ((outcome_date_sale)::date)
164. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.00 rows=0 width=8) (never executed)

  • One-Time Filter: false
165. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.01..0.02 rows=1 width=8) (never executed)

166. 0.000 0.000 ↓ 0.0 0

Sort (cost=0.01..0.02 rows=0 width=8) (never executed)

  • Sort Key: ((outcome_date_sale)::date)
167. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.00 rows=0 width=8) (never executed)

  • One-Time Filter: false
168. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.01..0.02 rows=1 width=8) (never executed)

169. 0.000 0.000 ↓ 0.0 0

Sort (cost=0.01..0.02 rows=0 width=8) (never executed)

  • Sort Key: ((outcome_date_sale)::date)
170. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.00 rows=0 width=8) (never executed)

  • One-Time Filter: false
171. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.01..0.02 rows=1 width=8) (never executed)

172. 0.000 0.000 ↓ 0.0 0

Sort (cost=0.01..0.02 rows=0 width=8) (never executed)

  • Sort Key: ((outcome_date_sale)::date)
173. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.00 rows=0 width=8) (never executed)

  • One-Time Filter: false
174. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.01..0.02 rows=1 width=8) (never executed)

175. 0.000 0.000 ↓ 0.0 0

Sort (cost=0.01..0.02 rows=0 width=8) (never executed)

  • Sort Key: ((outcome_date_sale)::date)
176. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.00 rows=0 width=8) (never executed)

  • One-Time Filter: false
177. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.01..0.02 rows=1 width=8) (never executed)

178. 0.000 0.000 ↓ 0.0 0

Sort (cost=0.01..0.02 rows=0 width=8) (never executed)

  • Sort Key: ((outcome_date_sale)::date)
179. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.00 rows=0 width=8) (never executed)

  • One-Time Filter: false
180. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.01..0.02 rows=1 width=8) (never executed)

181. 0.000 0.000 ↓ 0.0 0

Sort (cost=0.01..0.02 rows=0 width=8) (never executed)

  • Sort Key: ((outcome_date_sale)::date)
182. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.00 rows=0 width=8) (never executed)

  • One-Time Filter: false
183. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.01..0.02 rows=1 width=8) (never executed)

184. 0.000 0.000 ↓ 0.0 0

Sort (cost=0.01..0.02 rows=0 width=8) (never executed)

  • Sort Key: ((outcome_date_sale)::date)
185. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.00 rows=0 width=8) (never executed)

  • One-Time Filter: false
186. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.01..0.02 rows=1 width=8) (never executed)

187. 0.000 0.000 ↓ 0.0 0

Sort (cost=0.01..0.02 rows=0 width=8) (never executed)

  • Sort Key: ((outcome_date_sale)::date)
188. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.00 rows=0 width=8) (never executed)

  • One-Time Filter: false
189. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.01..0.02 rows=1 width=8) (never executed)

190. 0.000 0.000 ↓ 0.0 0

Sort (cost=0.01..0.02 rows=0 width=8) (never executed)

  • Sort Key: ((outcome_date_sale)::date)
191. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.00 rows=0 width=8) (never executed)

  • One-Time Filter: false
192. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.01..0.02 rows=1 width=8) (never executed)

193. 0.000 0.000 ↓ 0.0 0

Sort (cost=0.01..0.02 rows=0 width=8) (never executed)

  • Sort Key: ((outcome_date_sale)::date)
194. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.00 rows=0 width=8) (never executed)

  • One-Time Filter: false
195. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.01..0.02 rows=1 width=8) (never executed)

196. 0.000 0.000 ↓ 0.0 0

Sort (cost=0.01..0.02 rows=0 width=8) (never executed)

  • Sort Key: ((outcome_date_sale)::date)
197. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.00 rows=0 width=8) (never executed)

  • One-Time Filter: false
198. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.01..0.02 rows=1 width=8) (never executed)

199. 0.000 0.000 ↓ 0.0 0

Sort (cost=0.01..0.02 rows=0 width=8) (never executed)

  • Sort Key: ((outcome_date_sale)::date)
200. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.00 rows=0 width=8) (never executed)

  • One-Time Filter: false
201. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.01..0.02 rows=1 width=8) (never executed)

202. 0.000 0.000 ↓ 0.0 0

Sort (cost=0.01..0.02 rows=0 width=8) (never executed)

  • Sort Key: ((outcome_date_sale)::date)
203. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.00 rows=0 width=8) (never executed)

  • One-Time Filter: false
204. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.01..0.02 rows=1 width=8) (never executed)

205. 0.000 0.000 ↓ 0.0 0

Sort (cost=0.01..0.02 rows=0 width=8) (never executed)

  • Sort Key: ((outcome_date_sale)::date)
206. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.00 rows=0 width=8) (never executed)

  • One-Time Filter: false
207. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.01..0.02 rows=1 width=8) (never executed)

208. 0.000 0.000 ↓ 0.0 0

Sort (cost=0.01..0.02 rows=0 width=8) (never executed)

  • Sort Key: ((outcome_date_sale)::date)
209. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.00 rows=0 width=8) (never executed)

  • One-Time Filter: false
210. 0.093 0.093 ↓ 0.0 0 93

Limit (cost=0.01..0.02 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=93)

211. 0.000 0.000 ↓ 0.0 0 93

Sort (cost=0.01..0.02 rows=0 width=8) (actual time=0.000..0.000 rows=0 loops=93)

  • Sort Key: ((outcome_date_sale)::date)
  • Sort Method: quicksort Memory: 25kB
212. 0.000 0.000 ↓ 0.0 0 93

Result (cost=0.00..0.00 rows=0 width=8) (actual time=0.000..0.000 rows=0 loops=93)

  • One-Time Filter: false
213. 0.093 0.093 ↓ 0.0 0 93

Limit (cost=0.01..0.02 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=93)

214. 0.000 0.000 ↓ 0.0 0 93

Sort (cost=0.01..0.02 rows=0 width=8) (actual time=0.000..0.000 rows=0 loops=93)

  • Sort Key: ((outcome_date_sale)::date)
  • Sort Method: quicksort Memory: 25kB
215. 0.000 0.000 ↓ 0.0 0 93

Result (cost=0.00..0.00 rows=0 width=8) (actual time=0.000..0.000 rows=0 loops=93)

  • One-Time Filter: false
216. 0.093 0.093 ↓ 0.0 0 93

Limit (cost=0.01..0.02 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=93)

217. 0.000 0.000 ↓ 0.0 0 93

Sort (cost=0.01..0.02 rows=0 width=8) (actual time=0.000..0.000 rows=0 loops=93)

  • Sort Key: ((outcome_date_sale)::date)
  • Sort Method: quicksort Memory: 25kB
218. 0.000 0.000 ↓ 0.0 0 93

Result (cost=0.00..0.00 rows=0 width=8) (actual time=0.000..0.000 rows=0 loops=93)

  • One-Time Filter: false
219. 0.000 0.000 ↓ 0.0 0 93

Limit (cost=0.01..0.02 rows=1 width=8) (actual time=0.000..0.000 rows=0 loops=93)

220. 0.000 0.000 ↓ 0.0 0 93

Sort (cost=0.01..0.02 rows=0 width=8) (actual time=0.000..0.000 rows=0 loops=93)

  • Sort Key: ((outcome_date_sale)::date)
  • Sort Method: quicksort Memory: 25kB
221. 0.000 0.000 ↓ 0.0 0 93

Result (cost=0.00..0.00 rows=0 width=8) (actual time=0.000..0.000 rows=0 loops=93)

  • One-Time Filter: false
222. 0.093 0.093 ↓ 0.0 0 93

Limit (cost=0.01..0.02 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=93)

223. 0.000 0.000 ↓ 0.0 0 93

Sort (cost=0.01..0.02 rows=0 width=8) (actual time=0.000..0.000 rows=0 loops=93)

  • Sort Key: ((outcome_date_sale)::date)
  • Sort Method: quicksort Memory: 25kB
224. 0.000 0.000 ↓ 0.0 0 93

Result (cost=0.00..0.00 rows=0 width=8) (actual time=0.000..0.000 rows=0 loops=93)

  • One-Time Filter: false
225. 0.093 0.093 ↓ 0.0 0 93

Limit (cost=0.01..0.02 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=93)

226. 0.000 0.000 ↓ 0.0 0 93

Sort (cost=0.01..0.02 rows=0 width=8) (actual time=0.000..0.000 rows=0 loops=93)

  • Sort Key: ((outcome_date_sale)::date)
  • Sort Method: quicksort Memory: 25kB
227. 0.000 0.000 ↓ 0.0 0 93

Result (cost=0.00..0.00 rows=0 width=8) (actual time=0.000..0.000 rows=0 loops=93)

  • One-Time Filter: false
228. 0.093 0.093 ↓ 0.0 0 93

Limit (cost=0.01..0.02 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=93)

229. 0.000 0.000 ↓ 0.0 0 93

Sort (cost=0.01..0.02 rows=0 width=8) (actual time=0.000..0.000 rows=0 loops=93)

  • Sort Key: ((outcome_date_sale)::date)
  • Sort Method: quicksort Memory: 25kB
230. 0.000 0.000 ↓ 0.0 0 93

Result (cost=0.00..0.00 rows=0 width=8) (actual time=0.000..0.000 rows=0 loops=93)

  • One-Time Filter: false
231. 0.000 0.007 ↓ 0.0 0 7

Limit (cost=0.01..0.02 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=7)

232. 0.007 0.007 ↓ 0.0 0 7

Sort (cost=0.01..0.02 rows=0 width=8) (actual time=0.001..0.001 rows=0 loops=7)

  • Sort Key: ((outcome_date_sale)::date)
  • Sort Method: quicksort Memory: 25kB
233. 0.000 0.000 ↓ 0.0 0 7

Result (cost=0.00..0.00 rows=0 width=8) (actual time=0.000..0.000 rows=0 loops=7)

  • One-Time Filter: false
234. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.01..0.02 rows=1 width=8) (never executed)

235. 0.000 0.000 ↓ 0.0 0

Sort (cost=0.01..0.02 rows=0 width=8) (never executed)

  • Sort Key: ((outcome_date_sale)::date) DESC
236. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.00 rows=0 width=8) (never executed)

  • One-Time Filter: false
237. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.01..0.02 rows=1 width=8) (never executed)

238. 0.000 0.000 ↓ 0.0 0

Sort (cost=0.01..0.02 rows=0 width=8) (never executed)

  • Sort Key: ((outcome_date_sale)::date) DESC
239. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.00 rows=0 width=8) (never executed)

  • One-Time Filter: false
240. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.01..0.02 rows=1 width=8) (never executed)

241. 0.000 0.000 ↓ 0.0 0

Sort (cost=0.01..0.02 rows=0 width=8) (never executed)

  • Sort Key: ((outcome_date_sale)::date) DESC
242. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.00 rows=0 width=8) (never executed)

  • One-Time Filter: false
243. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.01..0.02 rows=1 width=8) (never executed)

244. 0.000 0.000 ↓ 0.0 0

Sort (cost=0.01..0.02 rows=0 width=8) (never executed)

  • Sort Key: ((outcome_date_sale)::date) DESC
245. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.00 rows=0 width=8) (never executed)

  • One-Time Filter: false
246. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.01..0.02 rows=1 width=8) (never executed)

247. 0.000 0.000 ↓ 0.0 0

Sort (cost=0.01..0.02 rows=0 width=8) (never executed)

  • Sort Key: ((outcome_date_sale)::date) DESC
248. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.00 rows=0 width=8) (never executed)

  • One-Time Filter: false
249. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.01..0.02 rows=1 width=8) (never executed)

250. 0.000 0.000 ↓ 0.0 0

Sort (cost=0.01..0.02 rows=0 width=8) (never executed)

  • Sort Key: ((outcome_date_sale)::date) DESC
251. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.00 rows=0 width=8) (never executed)

  • One-Time Filter: false
252. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.01..0.02 rows=1 width=8) (never executed)

253. 0.000 0.000 ↓ 0.0 0

Sort (cost=0.01..0.02 rows=0 width=8) (never executed)

  • Sort Key: ((outcome_date_sale)::date) DESC
254. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.00 rows=0 width=8) (never executed)

  • One-Time Filter: false
255. 0.000 0.007 ↓ 0.0 0 7

Limit (cost=0.01..0.02 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=7)

256. 0.007 0.007 ↓ 0.0 0 7

Sort (cost=0.01..0.02 rows=0 width=4) (actual time=0.001..0.001 rows=0 loops=7)

  • Sort Key: ((outcome_date_sale)::date)
  • Sort Method: quicksort Memory: 25kB
257. 0.000 0.000 ↓ 0.0 0 7

Result (cost=0.00..0.00 rows=0 width=4) (actual time=0.000..0.000 rows=0 loops=7)

  • One-Time Filter: false
258. 0.000 0.021 ↑ 1.0 1 7

Limit (cost=0.43..2.85 rows=1 width=4) (actual time=0.003..0.003 rows=1 loops=7)

259. 0.007 0.021 ↑ 1.0 1 7

Result (cost=0.43..2.85 rows=1 width=4) (actual time=0.003..0.003 rows=1 loops=7)

  • One-Time Filter: (COALESCE(((SubPlan 72)), 0) <= 0)
260. 0.014 0.014 ↑ 1.0 1 7

Index Scan using t_card_pkey on t_card ca_2 (cost=0.43..2.85 rows=1 width=4) (actual time=0.002..0.002 rows=1 loops=7)

  • Index Cond: (id = loyal_card_id)
261. 0.007 0.014 ↓ 0.0 0 7

Limit (cost=0.01..0.02 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=7)

262. 0.007 0.007 ↓ 0.0 0 7

Sort (cost=0.01..0.02 rows=0 width=4) (actual time=0.001..0.001 rows=0 loops=7)

  • Sort Key: ((outcome_date_sale)::date)
  • Sort Method: quicksort Memory: 25kB
263. 0.000 0.000 ↓ 0.0 0 7

Result (cost=0.00..0.00 rows=0 width=4) (actual time=0.000..0.000 rows=0 loops=7)

  • One-Time Filter: false
264. 0.000 0.021 ↑ 1.0 1 7

Limit (cost=0.43..2.85 rows=1 width=4) (actual time=0.003..0.003 rows=1 loops=7)

265. 0.007 0.021 ↑ 1.0 1 7

Result (cost=0.43..2.85 rows=1 width=4) (actual time=0.003..0.003 rows=1 loops=7)

  • One-Time Filter: (COALESCE(((SubPlan 72)), 0) <= 0)
266. 0.014 0.014 ↑ 1.0 1 7

Index Scan using t_card_pkey on t_card ca_3 (cost=0.43..2.85 rows=1 width=4) (actual time=0.002..0.002 rows=1 loops=7)

  • Index Cond: (id = loyal_card_id)
267. 0.000 0.014 ↓ 0.0 0 7

Limit (cost=0.01..0.02 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=7)

268. 0.014 0.014 ↓ 0.0 0 7

Sort (cost=0.01..0.02 rows=0 width=4) (actual time=0.002..0.002 rows=0 loops=7)

  • Sort Key: ((outcome_date_sale)::date)
  • Sort Method: quicksort Memory: 25kB
269. 0.000 0.000 ↓ 0.0 0 7

Result (cost=0.00..0.00 rows=0 width=4) (actual time=0.000..0.000 rows=0 loops=7)

  • One-Time Filter: false
270. 0.000 0.021 ↑ 1.0 1 7

Limit (cost=0.43..2.85 rows=1 width=4) (actual time=0.003..0.003 rows=1 loops=7)

271. 0.007 0.021 ↑ 1.0 1 7

Result (cost=0.43..2.85 rows=1 width=4) (actual time=0.003..0.003 rows=1 loops=7)

  • One-Time Filter: (COALESCE(((SubPlan 72)), 0) <= 0)
272. 0.014 0.014 ↑ 1.0 1 7

Index Scan using t_card_pkey on t_card ca_4 (cost=0.43..2.85 rows=1 width=4) (actual time=0.002..0.002 rows=1 loops=7)

  • Index Cond: (id = loyal_card_id)
273. 0.000 0.007 ↓ 0.0 0 7

Limit (cost=0.01..0.02 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=7)

274. 0.007 0.007 ↓ 0.0 0 7

Sort (cost=0.01..0.02 rows=0 width=4) (actual time=0.001..0.001 rows=0 loops=7)

  • Sort Key: ((outcome_date_sale)::date)
  • Sort Method: quicksort Memory: 25kB
275. 0.000 0.000 ↓ 0.0 0 7

Result (cost=0.00..0.00 rows=0 width=4) (actual time=0.000..0.000 rows=0 loops=7)

  • One-Time Filter: false
276. 0.000 0.021 ↑ 1.0 1 7

Limit (cost=0.43..2.85 rows=1 width=4) (actual time=0.003..0.003 rows=1 loops=7)

277. 0.007 0.021 ↑ 1.0 1 7

Result (cost=0.43..2.85 rows=1 width=4) (actual time=0.003..0.003 rows=1 loops=7)

  • One-Time Filter: (COALESCE(((SubPlan 72)), 0) <= 0)
278. 0.014 0.014 ↑ 1.0 1 7

Index Scan using t_card_pkey on t_card ca_5 (cost=0.43..2.85 rows=1 width=4) (actual time=0.002..0.002 rows=1 loops=7)

  • Index Cond: (id = loyal_card_id)
Planning time : 209.006 ms
Execution time : 1,023.056 ms