explain.depesz.com

PostgreSQL's explain analyze made readable

Result: FmDZ

Settings
# exclusive inclusive rows x rows loops node
1. 593.779 4,140.229 ↑ 21.3 1,881 1

HashAggregate (cost=1,557,741.41..1,558,141.41 rows=40,000 width=16) (actual time=4,139.828..4,140.229 rows=1,881 loops=1)

  • Group Key: os.station_id, os.daypart_placed_id
2. 3,244.189 3,546.450 ↓ 1.1 3,020,184 1

Append (cost=0.00..1,537,006.76 rows=2,764,619 width=12) (actual time=0.026..3,546.450 rows=3,020,184 loops=1)

3. 0.005 0.005 ↓ 0.0 0 1

Seq Scan on rsg_order_spot os (cost=0.00..0.00 rows=1 width=12) (actual time=0.005..0.005 rows=0 loops=1)

  • Filter: ((sch_run_date >= '2019-02-01'::date) AND (sch_run_date <= '2019-02-28'::date) AND (station_id = ANY ('{230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390,391,392,393,394,395,396,397,398,399,400,401,402,403,404,405,406,407,408,409,410,411,412,413,414,415,416,417,418,419,420,421,422,423,424,425,433,442,451,452,453,454,455,456,457,462,464,465,466,467,468,469,470,471,472,473,474,475,476,477,478,479,480,481,482,483,484,485,486,487,488,489,490,491,492,493,495,496,497,498,499,500,501,502,503,504,505,506,507,508,509,510,511,512,513,514,515,516,517,518,519,520,521,522,523,524,525,526,527,528,529,530,531,532,533,534,535,562,563,564,565,566,426,427,428,429,430,431,432,434,435,436,437,438,439,440,441,443,444,445,446,447,448,449,450,458,459,460,461,463,494,574,575,576,577,578,579,580,581,582,583,584,585,586,587,588,589,590,591,592,593,594}'::integer[])))
4. 0.035 0.035 ↑ 1.0 9 1

Index Scan using unique_rsg_order_spot_363 on rsg_order_spot_363 os_1 (cost=0.14..10.18 rows=9 width=12) (actual time=0.021..0.035 rows=9 loops=1)

  • Index Cond: ((sch_run_date >= '2019-02-01'::date) AND (sch_run_date <= '2019-02-28'::date))
  • Filter: (station_id = ANY ('{230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390,391,392,393,394,395,396,397,398,399,400,401,402,403,404,405,406,407,408,409,410,411,412,413,414,415,416,417,418,419,420,421,422,423,424,425,433,442,451,452,453,454,455,456,457,462,464,465,466,467,468,469,470,471,472,473,474,475,476,477,478,479,480,481,482,483,484,485,486,487,488,489,490,491,492,493,495,496,497,498,499,500,501,502,503,504,505,506,507,508,509,510,511,512,513,514,515,516,517,518,519,520,521,522,523,524,525,526,527,528,529,530,531,532,533,534,535,562,563,564,565,566,426,427,428,429,430,431,432,434,435,436,437,438,439,440,441,443,444,445,446,447,448,449,450,458,459,460,461,463,494,574,575,576,577,578,579,580,581,582,583,584,585,586,587,588,589,590,591,592,593,594}'::integer[]))
5. 0.880 0.880 ↓ 1.0 1,904 1

Index Only Scan using ix_rsg_order_spot_500__stationid__sch_run_dt__dp_placed_id__ord on rsg_order_spot_500 os_2 (cost=0.41..451.98 rows=1,814 width=12) (actual time=0.276..0.880 rows=1,904 loops=1)

  • Index Cond: ((station_id = ANY ('{230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390,391,392,393,394,395,396,397,398,399,400,401,402,403,404,405,406,407,408,409,410,411,412,413,414,415,416,417,418,419,420,421,422,423,424,425,433,442,451,452,453,454,455,456,457,462,464,465,466,467,468,469,470,471,472,473,474,475,476,477,478,479,480,481,482,483,484,485,486,487,488,489,490,491,492,493,495,496,497,498,499,500,501,502,503,504,505,506,507,508,509,510,511,512,513,514,515,516,517,518,519,520,521,522,523,524,525,526,527,528,529,530,531,532,533,534,535,562,563,564,565,566,426,427,428,429,430,431,432,434,435,436,437,438,439,440,441,443,444,445,446,447,448,449,450,458,459,460,461,463,494,574,575,576,577,578,579,580,581,582,583,584,585,586,587,588,589,590,591,592,593,594}'::integer[])) AND (sch_run_date >= '2019-02-01'::date) AND (sch_run_date <= '2019-02-28'::date))
  • Heap Fetches: 667
6. 0.940 0.940 ↓ 1.0 4,013 1

Index Only Scan using ix_rsg_order_spot_498__stationid__sch_run_dt__dp_placed_id__ord on rsg_order_spot_498 os_3 (cost=0.42..453.09 rows=3,968 width=12) (actual time=0.274..0.940 rows=4,013 loops=1)

  • Index Cond: ((station_id = ANY ('{230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390,391,392,393,394,395,396,397,398,399,400,401,402,403,404,405,406,407,408,409,410,411,412,413,414,415,416,417,418,419,420,421,422,423,424,425,433,442,451,452,453,454,455,456,457,462,464,465,466,467,468,469,470,471,472,473,474,475,476,477,478,479,480,481,482,483,484,485,486,487,488,489,490,491,492,493,495,496,497,498,499,500,501,502,503,504,505,506,507,508,509,510,511,512,513,514,515,516,517,518,519,520,521,522,523,524,525,526,527,528,529,530,531,532,533,534,535,562,563,564,565,566,426,427,428,429,430,431,432,434,435,436,437,438,439,440,441,443,444,445,446,447,448,449,450,458,459,460,461,463,494,574,575,576,577,578,579,580,581,582,583,584,585,586,587,588,589,590,591,592,593,594}'::integer[])) AND (sch_run_date >= '2019-02-01'::date) AND (sch_run_date <= '2019-02-28'::date))
  • Heap Fetches: 0
7. 0.580 0.580 ↓ 1.1 999 1

Index Only Scan using ix_rsg_order_spot_501__stationid__sch_run_dt__dp_placed_id__ord on rsg_order_spot_501 os_4 (cost=0.29..200.55 rows=904 width=12) (actual time=0.218..0.580 rows=999 loops=1)

  • Index Cond: ((station_id = ANY ('{230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390,391,392,393,394,395,396,397,398,399,400,401,402,403,404,405,406,407,408,409,410,411,412,413,414,415,416,417,418,419,420,421,422,423,424,425,433,442,451,452,453,454,455,456,457,462,464,465,466,467,468,469,470,471,472,473,474,475,476,477,478,479,480,481,482,483,484,485,486,487,488,489,490,491,492,493,495,496,497,498,499,500,501,502,503,504,505,506,507,508,509,510,511,512,513,514,515,516,517,518,519,520,521,522,523,524,525,526,527,528,529,530,531,532,533,534,535,562,563,564,565,566,426,427,428,429,430,431,432,434,435,436,437,438,439,440,441,443,444,445,446,447,448,449,450,458,459,460,461,463,494,574,575,576,577,578,579,580,581,582,583,584,585,586,587,588,589,590,591,592,593,594}'::integer[])) AND (sch_run_date >= '2019-02-01'::date) AND (sch_run_date <= '2019-02-28'::date))
  • Heap Fetches: 368
8. 0.400 0.400 ↓ 1.0 652 1

Index Only Scan using ix_rsg_order_spot_270__stationid__sch_run_dt__dp_placed_id__ord on rsg_order_spot_270 os_5 (cost=0.29..262.36 rows=630 width=12) (actual time=0.039..0.400 rows=652 loops=1)

  • Index Cond: ((station_id = ANY ('{230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390,391,392,393,394,395,396,397,398,399,400,401,402,403,404,405,406,407,408,409,410,411,412,413,414,415,416,417,418,419,420,421,422,423,424,425,433,442,451,452,453,454,455,456,457,462,464,465,466,467,468,469,470,471,472,473,474,475,476,477,478,479,480,481,482,483,484,485,486,487,488,489,490,491,492,493,495,496,497,498,499,500,501,502,503,504,505,506,507,508,509,510,511,512,513,514,515,516,517,518,519,520,521,522,523,524,525,526,527,528,529,530,531,532,533,534,535,562,563,564,565,566,426,427,428,429,430,431,432,434,435,436,437,438,439,440,441,443,444,445,446,447,448,449,450,458,459,460,461,463,494,574,575,576,577,578,579,580,581,582,583,584,585,586,587,588,589,590,591,592,593,594}'::integer[])) AND (sch_run_date >= '2019-02-01'::date) AND (sch_run_date <= '2019-02-28'::date))
  • Heap Fetches: 141
9. 0.400 0.400 ↑ 1.0 894 1

Index Only Scan using ix_rsg_order_spot_493__stationid__sch_run_dt__dp_placed_id__ord on rsg_order_spot_493 os_6 (cost=0.29..195.01 rows=894 width=12) (actual time=0.213..0.400 rows=894 loops=1)

  • Index Cond: ((station_id = ANY ('{230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390,391,392,393,394,395,396,397,398,399,400,401,402,403,404,405,406,407,408,409,410,411,412,413,414,415,416,417,418,419,420,421,422,423,424,425,433,442,451,452,453,454,455,456,457,462,464,465,466,467,468,469,470,471,472,473,474,475,476,477,478,479,480,481,482,483,484,485,486,487,488,489,490,491,492,493,495,496,497,498,499,500,501,502,503,504,505,506,507,508,509,510,511,512,513,514,515,516,517,518,519,520,521,522,523,524,525,526,527,528,529,530,531,532,533,534,535,562,563,564,565,566,426,427,428,429,430,431,432,434,435,436,437,438,439,440,441,443,444,445,446,447,448,449,450,458,459,460,461,463,494,574,575,576,577,578,579,580,581,582,583,584,585,586,587,588,589,590,591,592,593,594}'::integer[])) AND (sch_run_date >= '2019-02-01'::date) AND (sch_run_date <= '2019-02-28'::date))
  • Heap Fetches: 0
10. 0.290 0.290 ↓ 0.0 0 1

Index Only Scan using ix_rsg_order_spot_310__stationid__sch_run_dt__dp_placed_id__ord on rsg_order_spot_310 os_7 (cost=0.28..138.95 rows=1 width=12) (actual time=0.290..0.290 rows=0 loops=1)

  • Index Cond: ((station_id = ANY ('{230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390,391,392,393,394,395,396,397,398,399,400,401,402,403,404,405,406,407,408,409,410,411,412,413,414,415,416,417,418,419,420,421,422,423,424,425,433,442,451,452,453,454,455,456,457,462,464,465,466,467,468,469,470,471,472,473,474,475,476,477,478,479,480,481,482,483,484,485,486,487,488,489,490,491,492,493,495,496,497,498,499,500,501,502,503,504,505,506,507,508,509,510,511,512,513,514,515,516,517,518,519,520,521,522,523,524,525,526,527,528,529,530,531,532,533,534,535,562,563,564,565,566,426,427,428,429,430,431,432,434,435,436,437,438,439,440,441,443,444,445,446,447,448,449,450,458,459,460,461,463,494,574,575,576,577,578,579,580,581,582,583,584,585,586,587,588,589,590,591,592,593,594}'::integer[])) AND (sch_run_date >= '2019-02-01'::date) AND (sch_run_date <= '2019-02-28'::date))
  • Heap Fetches: 0
11. 0.235 0.235 ↓ 0.0 0 1

Index Only Scan using ix_rsg_order_spot_303__stationid__sch_run_dt__dp_placed_id__ord on rsg_order_spot_303 os_8 (cost=0.29..207.61 rows=1 width=12) (actual time=0.235..0.235 rows=0 loops=1)

  • Index Cond: ((station_id = ANY ('{230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390,391,392,393,394,395,396,397,398,399,400,401,402,403,404,405,406,407,408,409,410,411,412,413,414,415,416,417,418,419,420,421,422,423,424,425,433,442,451,452,453,454,455,456,457,462,464,465,466,467,468,469,470,471,472,473,474,475,476,477,478,479,480,481,482,483,484,485,486,487,488,489,490,491,492,493,495,496,497,498,499,500,501,502,503,504,505,506,507,508,509,510,511,512,513,514,515,516,517,518,519,520,521,522,523,524,525,526,527,528,529,530,531,532,533,534,535,562,563,564,565,566,426,427,428,429,430,431,432,434,435,436,437,438,439,440,441,443,444,445,446,447,448,449,450,458,459,460,461,463,494,574,575,576,577,578,579,580,581,582,583,584,585,586,587,588,589,590,591,592,593,594}'::integer[])) AND (sch_run_date >= '2019-02-01'::date) AND (sch_run_date <= '2019-02-28'::date))
  • Heap Fetches: 0
12. 0.269 0.269 ↓ 1.0 234 1

Index Only Scan using ix_rsg_order_spot_388__stationid__sch_run_dt__dp_placed_id__ord on rsg_order_spot_388 os_9 (cost=0.28..120.37 rows=226 width=12) (actual time=0.129..0.269 rows=234 loops=1)

  • Index Cond: ((station_id = ANY ('{230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390,391,392,393,394,395,396,397,398,399,400,401,402,403,404,405,406,407,408,409,410,411,412,413,414,415,416,417,418,419,420,421,422,423,424,425,433,442,451,452,453,454,455,456,457,462,464,465,466,467,468,469,470,471,472,473,474,475,476,477,478,479,480,481,482,483,484,485,486,487,488,489,490,491,492,493,495,496,497,498,499,500,501,502,503,504,505,506,507,508,509,510,511,512,513,514,515,516,517,518,519,520,521,522,523,524,525,526,527,528,529,530,531,532,533,534,535,562,563,564,565,566,426,427,428,429,430,431,432,434,435,436,437,438,439,440,441,443,444,445,446,447,448,449,450,458,459,460,461,463,494,574,575,576,577,578,579,580,581,582,583,584,585,586,587,588,589,590,591,592,593,594}'::integer[])) AND (sch_run_date >= '2019-02-01'::date) AND (sch_run_date <= '2019-02-28'::date))
  • Heap Fetches: 0
13. 1.398 1.398 ↓ 1.1 4,428 1

Index Only Scan using ix_rsg_order_spot_377__stationid__sch_run_dt__dp_placed_id__ord on rsg_order_spot_377 os_10 (cost=0.42..575.61 rows=4,039 width=12) (actual time=0.160..1.398 rows=4,428 loops=1)

  • Index Cond: ((station_id = ANY ('{230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390,391,392,393,394,395,396,397,398,399,400,401,402,403,404,405,406,407,408,409,410,411,412,413,414,415,416,417,418,419,420,421,422,423,424,425,433,442,451,452,453,454,455,456,457,462,464,465,466,467,468,469,470,471,472,473,474,475,476,477,478,479,480,481,482,483,484,485,486,487,488,489,490,491,492,493,495,496,497,498,499,500,501,502,503,504,505,506,507,508,509,510,511,512,513,514,515,516,517,518,519,520,521,522,523,524,525,526,527,528,529,530,531,532,533,534,535,562,563,564,565,566,426,427,428,429,430,431,432,434,435,436,437,438,439,440,441,443,444,445,446,447,448,449,450,458,459,460,461,463,494,574,575,576,577,578,579,580,581,582,583,584,585,586,587,588,589,590,591,592,593,594}'::integer[])) AND (sch_run_date >= '2019-02-01'::date) AND (sch_run_date <= '2019-02-28'::date))
  • Heap Fetches: 839
14. 0.659 0.659 ↓ 1.0 990 1

Index Only Scan using ix_rsg_order_spot_385__stationid__sch_run_dt__dp_placed_id__ord on rsg_order_spot_385 os_11 (cost=0.28..228.75 rows=970 width=12) (actual time=0.131..0.659 rows=990 loops=1)

  • Index Cond: ((station_id = ANY ('{230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390,391,392,393,394,395,396,397,398,399,400,401,402,403,404,405,406,407,408,409,410,411,412,413,414,415,416,417,418,419,420,421,422,423,424,425,433,442,451,452,453,454,455,456,457,462,464,465,466,467,468,469,470,471,472,473,474,475,476,477,478,479,480,481,482,483,484,485,486,487,488,489,490,491,492,493,495,496,497,498,499,500,501,502,503,504,505,506,507,508,509,510,511,512,513,514,515,516,517,518,519,520,521,522,523,524,525,526,527,528,529,530,531,532,533,534,535,562,563,564,565,566,426,427,428,429,430,431,432,434,435,436,437,438,439,440,441,443,444,445,446,447,448,449,450,458,459,460,461,463,494,574,575,576,577,578,579,580,581,582,583,584,585,586,587,588,589,590,591,592,593,594}'::integer[])) AND (sch_run_date >= '2019-02-01'::date) AND (sch_run_date <= '2019-02-28'::date))
  • Heap Fetches: 648
15. 0.260 0.260 ↑ 1.0 2 1

Index Only Scan using ix_rsg_order_spot_368__stationid__sch_run_dt__dp_placed_id__ord on rsg_order_spot_368 os_12 (cost=0.29..205.62 rows=2 width=12) (actual time=0.112..0.260 rows=2 loops=1)

  • Index Cond: ((station_id = ANY ('{230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390,391,392,393,394,395,396,397,398,399,400,401,402,403,404,405,406,407,408,409,410,411,412,413,414,415,416,417,418,419,420,421,422,423,424,425,433,442,451,452,453,454,455,456,457,462,464,465,466,467,468,469,470,471,472,473,474,475,476,477,478,479,480,481,482,483,484,485,486,487,488,489,490,491,492,493,495,496,497,498,499,500,501,502,503,504,505,506,507,508,509,510,511,512,513,514,515,516,517,518,519,520,521,522,523,524,525,526,527,528,529,530,531,532,533,534,535,562,563,564,565,566,426,427,428,429,430,431,432,434,435,436,437,438,439,440,441,443,444,445,446,447,448,449,450,458,459,460,461,463,494,574,575,576,577,578,579,580,581,582,583,584,585,586,587,588,589,590,591,592,593,594}'::integer[])) AND (sch_run_date >= '2019-02-01'::date) AND (sch_run_date <= '2019-02-28'::date))
  • Heap Fetches: 0
16. 0.004 0.004 ↓ 0.0 0 1

Index Scan using unique_rsg_order_spot_355 on rsg_order_spot_355 os_13 (cost=0.14..4.56 rows=1 width=12) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: ((sch_run_date >= '2019-02-01'::date) AND (sch_run_date <= '2019-02-28'::date))
  • Filter: (station_id = ANY ('{230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390,391,392,393,394,395,396,397,398,399,400,401,402,403,404,405,406,407,408,409,410,411,412,413,414,415,416,417,418,419,420,421,422,423,424,425,433,442,451,452,453,454,455,456,457,462,464,465,466,467,468,469,470,471,472,473,474,475,476,477,478,479,480,481,482,483,484,485,486,487,488,489,490,491,492,493,495,496,497,498,499,500,501,502,503,504,505,506,507,508,509,510,511,512,513,514,515,516,517,518,519,520,521,522,523,524,525,526,527,528,529,530,531,532,533,534,535,562,563,564,565,566,426,427,428,429,430,431,432,434,435,436,437,438,439,440,441,443,444,445,446,447,448,449,450,458,459,460,461,463,494,574,575,576,577,578,579,580,581,582,583,584,585,586,587,588,589,590,591,592,593,594}'::integer[]))
17. 0.524 0.524 ↓ 1.1 820 1

Index Only Scan using ix_rsg_order_spot_328__stationid__sch_run_dt__dp_placed_id__ord on rsg_order_spot_328 os_14 (cost=0.29..255.36 rows=717 width=12) (actual time=0.086..0.524 rows=820 loops=1)

  • Index Cond: ((station_id = ANY ('{230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390,391,392,393,394,395,396,397,398,399,400,401,402,403,404,405,406,407,408,409,410,411,412,413,414,415,416,417,418,419,420,421,422,423,424,425,433,442,451,452,453,454,455,456,457,462,464,465,466,467,468,469,470,471,472,473,474,475,476,477,478,479,480,481,482,483,484,485,486,487,488,489,490,491,492,493,495,496,497,498,499,500,501,502,503,504,505,506,507,508,509,510,511,512,513,514,515,516,517,518,519,520,521,522,523,524,525,526,527,528,529,530,531,532,533,534,535,562,563,564,565,566,426,427,428,429,430,431,432,434,435,436,437,438,439,440,441,443,444,445,446,447,448,449,450,458,459,460,461,463,494,574,575,576,577,578,579,580,581,582,583,584,585,586,587,588,589,590,591,592,593,594}'::integer[])) AND (sch_run_date >= '2019-02-01'::date) AND (sch_run_date <= '2019-02-28'::date))
  • Heap Fetches: 332
18. 3.249 3.249 ↓ 1.1 5,518 1

Index Only Scan using ix_rsg_order_spot_263__stationid__sch_run_dt__dp_placed_id__ord on rsg_order_spot_263 os_15 (cost=0.42..1,043.46 rows=4,944 width=12) (actual time=0.050..3.249 rows=5,518 loops=1)

  • Index Cond: ((station_id = ANY ('{230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390,391,392,393,394,395,396,397,398,399,400,401,402,403,404,405,406,407,408,409,410,411,412,413,414,415,416,417,418,419,420,421,422,423,424,425,433,442,451,452,453,454,455,456,457,462,464,465,466,467,468,469,470,471,472,473,474,475,476,477,478,479,480,481,482,483,484,485,486,487,488,489,490,491,492,493,495,496,497,498,499,500,501,502,503,504,505,506,507,508,509,510,511,512,513,514,515,516,517,518,519,520,521,522,523,524,525,526,527,528,529,530,531,532,533,534,535,562,563,564,565,566,426,427,428,429,430,431,432,434,435,436,437,438,439,440,441,443,444,445,446,447,448,449,450,458,459,460,461,463,494,574,575,576,577,578,579,580,581,582,583,584,585,586,587,588,589,590,591,592,593,594}'::integer[])) AND (sch_run_date >= '2019-02-01'::date) AND (sch_run_date <= '2019-02-28'::date))
  • Heap Fetches: 4445
19. 0.145 0.145 ↓ 1.1 30 1

Index Scan using unique_rsg_order_spot_473 on rsg_order_spot_473 os_16 (cost=0.28..70.43 rows=27 width=12) (actual time=0.021..0.145 rows=30 loops=1)

  • Index Cond: ((sch_run_date >= '2019-02-01'::date) AND (sch_run_date <= '2019-02-28'::date))
  • Filter: (station_id = ANY ('{230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390,391,392,393,394,395,396,397,398,399,400,401,402,403,404,405,406,407,408,409,410,411,412,413,414,415,416,417,418,419,420,421,422,423,424,425,433,442,451,452,453,454,455,456,457,462,464,465,466,467,468,469,470,471,472,473,474,475,476,477,478,479,480,481,482,483,484,485,486,487,488,489,490,491,492,493,495,496,497,498,499,500,501,502,503,504,505,506,507,508,509,510,511,512,513,514,515,516,517,518,519,520,521,522,523,524,525,526,527,528,529,530,531,532,533,534,535,562,563,564,565,566,426,427,428,429,430,431,432,434,435,436,437,438,439,440,441,443,444,445,446,447,448,449,450,458,459,460,461,463,494,574,575,576,577,578,579,580,581,582,583,584,585,586,587,588,589,590,591,592,593,594}'::integer[]))
20. 0.360 0.360 ↓ 1.2 212 1

Index Only Scan using ix_rsg_order_spot_417__stationid__sch_run_dt__dp_placed_id__ord on rsg_order_spot_417 os_17 (cost=0.28..158.46 rows=183 width=12) (actual time=0.159..0.360 rows=212 loops=1)

  • Index Cond: ((station_id = ANY ('{230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390,391,392,393,394,395,396,397,398,399,400,401,402,403,404,405,406,407,408,409,410,411,412,413,414,415,416,417,418,419,420,421,422,423,424,425,433,442,451,452,453,454,455,456,457,462,464,465,466,467,468,469,470,471,472,473,474,475,476,477,478,479,480,481,482,483,484,485,486,487,488,489,490,491,492,493,495,496,497,498,499,500,501,502,503,504,505,506,507,508,509,510,511,512,513,514,515,516,517,518,519,520,521,522,523,524,525,526,527,528,529,530,531,532,533,534,535,562,563,564,565,566,426,427,428,429,430,431,432,434,435,436,437,438,439,440,441,443,444,445,446,447,448,449,450,458,459,460,461,463,494,574,575,576,577,578,579,580,581,582,583,584,585,586,587,588,589,590,591,592,593,594}'::integer[])) AND (sch_run_date >= '2019-02-01'::date) AND (sch_run_date <= '2019-02-28'::date))
  • Heap Fetches: 139
21. 0.941 0.941 ↓ 1.3 1,286 1

Index Only Scan using ix_rsg_order_spot_419__stationid__sch_run_dt__dp_placed_id__ord on rsg_order_spot_419 os_18 (cost=0.42..483.19 rows=1,025 width=12) (actual time=0.212..0.941 rows=1,286 loops=1)

  • Index Cond: ((station_id = ANY ('{230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390,391,392,393,394,395,396,397,398,399,400,401,402,403,404,405,406,407,408,409,410,411,412,413,414,415,416,417,418,419,420,421,422,423,424,425,433,442,451,452,453,454,455,456,457,462,464,465,466,467,468,469,470,471,472,473,474,475,476,477,478,479,480,481,482,483,484,485,486,487,488,489,490,491,492,493,495,496,497,498,499,500,501,502,503,504,505,506,507,508,509,510,511,512,513,514,515,516,517,518,519,520,521,522,523,524,525,526,527,528,529,530,531,532,533,534,535,562,563,564,565,566,426,427,428,429,430,431,432,434,435,436,437,438,439,440,441,443,444,445,446,447,448,449,450,458,459,460,461,463,494,574,575,576,577,578,579,580,581,582,583,584,585,586,587,588,589,590,591,592,593,594}'::integer[])) AND (sch_run_date >= '2019-02-01'::date) AND (sch_run_date <= '2019-02-28'::date))
  • Heap Fetches: 868
22. 6.303 6.303 ↓ 1.0 15,446 1

Index Only Scan using ix_rsg_order_spot_300__stationid__sch_run_dt__dp_placed_id__ord on rsg_order_spot_300 os_19 (cost=0.42..1,561.95 rows=14,931 width=12) (actual time=0.095..6.303 rows=15,446 loops=1)

  • Index Cond: ((station_id = ANY ('{230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390,391,392,393,394,395,396,397,398,399,400,401,402,403,404,405,406,407,408,409,410,411,412,413,414,415,416,417,418,419,420,421,422,423,424,425,433,442,451,452,453,454,455,456,457,462,464,465,466,467,468,469,470,471,472,473,474,475,476,477,478,479,480,481,482,483,484,485,486,487,488,489,490,491,492,493,495,496,497,498,499,500,501,502,503,504,505,506,507,508,509,510,511,512,513,514,515,516,517,518,519,520,521,522,523,524,525,526,527,528,529,530,531,532,533,534,535,562,563,564,565,566,426,427,428,429,430,431,432,434,435,436,437,438,439,440,441,443,444,445,446,447,448,449,450,458,459,460,461,463,494,574,575,576,577,578,579,580,581,582,583,584,585,586,587,588,589,590,591,592,593,594}'::integer[])) AND (sch_run_date >= '2019-02-01'::date) AND (sch_run_date <= '2019-02-28'::date))
  • Heap Fetches: 7549
23. 5.381 5.381 ↓ 1.2 13,377 1

Index Only Scan using ix_rsg_order_spot_289__stationid__sch_run_dt__dp_placed_id__ord on rsg_order_spot_289 os_20 (cost=0.42..1,322.08 rows=11,519 width=12) (actual time=0.087..5.381 rows=13,377 loops=1)

  • Index Cond: ((station_id = ANY ('{230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390,391,392,393,394,395,396,397,398,399,400,401,402,403,404,405,406,407,408,409,410,411,412,413,414,415,416,417,418,419,420,421,422,423,424,425,433,442,451,452,453,454,455,456,457,462,464,465,466,467,468,469,470,471,472,473,474,475,476,477,478,479,480,481,482,483,484,485,486,487,488,489,490,491,492,493,495,496,497,498,499,500,501,502,503,504,505,506,507,508,509,510,511,512,513,514,515,516,517,518,519,520,521,522,523,524,525,526,527,528,529,530,531,532,533,534,535,562,563,564,565,566,426,427,428,429,430,431,432,434,435,436,437,438,439,440,441,443,444,445,446,447,448,449,450,458,459,460,461,463,494,574,575,576,577,578,579,580,581,582,583,584,585,586,587,588,589,590,591,592,593,594}'::integer[])) AND (sch_run_date >= '2019-02-01'::date) AND (sch_run_date <= '2019-02-28'::date))
  • Heap Fetches: 5768
24. 5.782 5.782 ↓ 1.1 13,873 1

Index Only Scan using ix_rsg_order_spot_454__stationid__sch_run_dt__dp_placed_id__ord on rsg_order_spot_454 os_21 (cost=0.42..1,753.25 rows=12,332 width=12) (actual time=0.256..5.782 rows=13,873 loops=1)

  • Index Cond: ((station_id = ANY ('{230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390,391,392,393,394,395,396,397,398,399,400,401,402,403,404,405,406,407,408,409,410,411,412,413,414,415,416,417,418,419,420,421,422,423,424,425,433,442,451,452,453,454,455,456,457,462,464,465,466,467,468,469,470,471,472,473,474,475,476,477,478,479,480,481,482,483,484,485,486,487,488,489,490,491,492,493,495,496,497,498,499,500,501,502,503,504,505,506,507,508,509,510,511,512,513,514,515,516,517,518,519,520,521,522,523,524,525,526,527,528,529,530,531,532,533,534,535,562,563,564,565,566,426,427,428,429,430,431,432,434,435,436,437,438,439,440,441,443,444,445,446,447,448,449,450,458,459,460,461,463,494,574,575,576,577,578,579,580,581,582,583,584,585,586,587,588,589,590,591,592,593,594}'::integer[])) AND (sch_run_date >= '2019-02-01'::date) AND (sch_run_date <= '2019-02-28'::date))
  • Heap Fetches: 6792
25. 0.270 0.270 ↓ 0.0 0 1

Index Scan using unique_rsg_order_spot_348 on rsg_order_spot_348 os_22 (cost=0.28..133.60 rows=1 width=12) (actual time=0.270..0.270 rows=0 loops=1)

  • Index Cond: ((sch_run_date >= '2019-02-01'::date) AND (sch_run_date <= '2019-02-28'::date))
  • Filter: (station_id = ANY ('{230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390,391,392,393,394,395,396,397,398,399,400,401,402,403,404,405,406,407,408,409,410,411,412,413,414,415,416,417,418,419,420,421,422,423,424,425,433,442,451,452,453,454,455,456,457,462,464,465,466,467,468,469,470,471,472,473,474,475,476,477,478,479,480,481,482,483,484,485,486,487,488,489,490,491,492,493,495,496,497,498,499,500,501,502,503,504,505,506,507,508,509,510,511,512,513,514,515,516,517,518,519,520,521,522,523,524,525,526,527,528,529,530,531,532,533,534,535,562,563,564,565,566,426,427,428,429,430,431,432,434,435,436,437,438,439,440,441,443,444,445,446,447,448,449,450,458,459,460,461,463,494,574,575,576,577,578,579,580,581,582,583,584,585,586,587,588,589,590,591,592,593,594}'::integer[]))
26. 6.270 6.270 ↓ 1.1 12,399 1

Index Only Scan using ix_rsg_order_spot_343__stationid__sch_run_dt__dp_placed_id__ord on rsg_order_spot_343 os_23 (cost=0.42..1,778.22 rows=10,856 width=12) (actual time=0.135..6.270 rows=12,399 loops=1)

  • Index Cond: ((station_id = ANY ('{230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390,391,392,393,394,395,396,397,398,399,400,401,402,403,404,405,406,407,408,409,410,411,412,413,414,415,416,417,418,419,420,421,422,423,424,425,433,442,451,452,453,454,455,456,457,462,464,465,466,467,468,469,470,471,472,473,474,475,476,477,478,479,480,481,482,483,484,485,486,487,488,489,490,491,492,493,495,496,497,498,499,500,501,502,503,504,505,506,507,508,509,510,511,512,513,514,515,516,517,518,519,520,521,522,523,524,525,526,527,528,529,530,531,532,533,534,535,562,563,564,565,566,426,427,428,429,430,431,432,434,435,436,437,438,439,440,441,443,444,445,446,447,448,449,450,458,459,460,461,463,494,574,575,576,577,578,579,580,581,582,583,584,585,586,587,588,589,590,591,592,593,594}'::integer[])) AND (sch_run_date >= '2019-02-01'::date) AND (sch_run_date <= '2019-02-28'::date))
  • Heap Fetches: 9233
27. 6.655 6.655 ↑ 1.0 23,631 1

Index Only Scan using ix_rsg_order_spot_256__stationid__sch_run_dt__dp_placed_id__ord on rsg_order_spot_256 os_24 (cost=0.42..1,517.47 rows=23,846 width=12) (actual time=0.040..6.655 rows=23,631 loops=1)

  • Index Cond: ((station_id = ANY ('{230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390,391,392,393,394,395,396,397,398,399,400,401,402,403,404,405,406,407,408,409,410,411,412,413,414,415,416,417,418,419,420,421,422,423,424,425,433,442,451,452,453,454,455,456,457,462,464,465,466,467,468,469,470,471,472,473,474,475,476,477,478,479,480,481,482,483,484,485,486,487,488,489,490,491,492,493,495,496,497,498,499,500,501,502,503,504,505,506,507,508,509,510,511,512,513,514,515,516,517,518,519,520,521,522,523,524,525,526,527,528,529,530,531,532,533,534,535,562,563,564,565,566,426,427,428,429,430,431,432,434,435,436,437,438,439,440,441,443,444,445,446,447,448,449,450,458,459,460,461,463,494,574,575,576,577,578,579,580,581,582,583,584,585,586,587,588,589,590,591,592,593,594}'::integer[])) AND (sch_run_date >= '2019-02-01'::date) AND (sch_run_date <= '2019-02-28'::date))
  • Heap Fetches: 5462
28. 4.631 4.631 ↓ 1.2 8,388 1

Index Only Scan using ix_rsg_order_spot_242__stationid__sch_run_dt__dp_placed_id__ord on rsg_order_spot_242 os_25 (cost=0.42..1,415.20 rows=6,947 width=12) (actual time=0.028..4.631 rows=8,388 loops=1)

  • Index Cond: ((station_id = ANY ('{230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390,391,392,393,394,395,396,397,398,399,400,401,402,403,404,405,406,407,408,409,410,411,412,413,414,415,416,417,418,419,420,421,422,423,424,425,433,442,451,452,453,454,455,456,457,462,464,465,466,467,468,469,470,471,472,473,474,475,476,477,478,479,480,481,482,483,484,485,486,487,488,489,490,491,492,493,495,496,497,498,499,500,501,502,503,504,505,506,507,508,509,510,511,512,513,514,515,516,517,518,519,520,521,522,523,524,525,526,527,528,529,530,531,532,533,534,535,562,563,564,565,566,426,427,428,429,430,431,432,434,435,436,437,438,439,440,441,443,444,445,446,447,448,449,450,458,459,460,461,463,494,574,575,576,577,578,579,580,581,582,583,584,585,586,587,588,589,590,591,592,593,594}'::integer[])) AND (sch_run_date >= '2019-02-01'::date) AND (sch_run_date <= '2019-02-28'::date))
  • Heap Fetches: 6304
29. 1.685 1.685 ↓ 1.1 2,684 1

Index Only Scan using ix_rsg_order_spot_360__stationid__sch_run_dt__dp_placed_id__ord on rsg_order_spot_360 os_26 (cost=0.42..696.89 rows=2,485 width=12) (actual time=0.146..1.685 rows=2,684 loops=1)

  • Index Cond: ((station_id = ANY ('{230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390,391,392,393,394,395,396,397,398,399,400,401,402,403,404,405,406,407,408,409,410,411,412,413,414,415,416,417,418,419,420,421,422,423,424,425,433,442,451,452,453,454,455,456,457,462,464,465,466,467,468,469,470,471,472,473,474,475,476,477,478,479,480,481,482,483,484,485,486,487,488,489,490,491,492,493,495,496,497,498,499,500,501,502,503,504,505,506,507,508,509,510,511,512,513,514,515,516,517,518,519,520,521,522,523,524,525,526,527,528,529,530,531,532,533,534,535,562,563,564,565,566,426,427,428,429,430,431,432,434,435,436,437,438,439,440,441,443,444,445,446,447,448,449,450,458,459,460,461,463,494,574,575,576,577,578,579,580,581,582,583,584,585,586,587,588,589,590,591,592,593,594}'::integer[])) AND (sch_run_date >= '2019-02-01'::date) AND (sch_run_date <= '2019-02-28'::date))
  • Heap Fetches: 2120
30. 7.185 7.185 ↓ 1.1 14,499 1

Index Only Scan using ix_rsg_order_spot_424__stationid__sch_run_dt__dp_placed_id__ord on rsg_order_spot_424 os_27 (cost=0.42..1,988.63 rows=13,386 width=12) (actual time=0.216..7.185 rows=14,499 loops=1)

  • Index Cond: ((station_id = ANY ('{230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390,391,392,393,394,395,396,397,398,399,400,401,402,403,404,405,406,407,408,409,410,411,412,413,414,415,416,417,418,419,420,421,422,423,424,425,433,442,451,452,453,454,455,456,457,462,464,465,466,467,468,469,470,471,472,473,474,475,476,477,478,479,480,481,482,483,484,485,486,487,488,489,490,491,492,493,495,496,497,498,499,500,501,502,503,504,505,506,507,508,509,510,511,512,513,514,515,516,517,518,519,520,521,522,523,524,525,526,527,528,529,530,531,532,533,534,535,562,563,564,565,566,426,427,428,429,430,431,432,434,435,436,437,438,439,440,441,443,444,445,446,447,448,449,450,458,459,460,461,463,494,574,575,576,577,578,579,580,581,582,583,584,585,586,587,588,589,590,591,592,593,594}'::integer[])) AND (sch_run_date >= '2019-02-01'::date) AND (sch_run_date <= '2019-02-28'::date))
  • Heap Fetches: 9602
31. 6.909 6.909 ↓ 1.1 20,694 1

Index Only Scan using ix_rsg_order_spot_490__stationid__sch_run_dt__dp_placed_id__ord on rsg_order_spot_490 os_28 (cost=0.42..1,396.56 rows=19,079 width=12) (actual time=0.304..6.909 rows=20,694 loops=1)

  • Index Cond: ((station_id = ANY ('{230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390,391,392,393,394,395,396,397,398,399,400,401,402,403,404,405,406,407,408,409,410,411,412,413,414,415,416,417,418,419,420,421,422,423,424,425,433,442,451,452,453,454,455,456,457,462,464,465,466,467,468,469,470,471,472,473,474,475,476,477,478,479,480,481,482,483,484,485,486,487,488,489,490,491,492,493,495,496,497,498,499,500,501,502,503,504,505,506,507,508,509,510,511,512,513,514,515,516,517,518,519,520,521,522,523,524,525,526,527,528,529,530,531,532,533,534,535,562,563,564,565,566,426,427,428,429,430,431,432,434,435,436,437,438,439,440,441,443,444,445,446,447,448,449,450,458,459,460,461,463,494,574,575,576,577,578,579,580,581,582,583,584,585,586,587,588,589,590,591,592,593,594}'::integer[])) AND (sch_run_date >= '2019-02-01'::date) AND (sch_run_date <= '2019-02-28'::date))
  • Heap Fetches: 6985
32. 9.127 9.127 ↓ 1.1 22,502 1

Index Only Scan using ix_rsg_order_spot_292__stationid__sch_run_dt__dp_placed_id__ord on rsg_order_spot_292 os_29 (cost=0.42..2,195.89 rows=21,339 width=12) (actual time=0.084..9.127 rows=22,502 loops=1)

  • Index Cond: ((station_id = ANY ('{230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390,391,392,393,394,395,396,397,398,399,400,401,402,403,404,405,406,407,408,409,410,411,412,413,414,415,416,417,418,419,420,421,422,423,424,425,433,442,451,452,453,454,455,456,457,462,464,465,466,467,468,469,470,471,472,473,474,475,476,477,478,479,480,481,482,483,484,485,486,487,488,489,490,491,492,493,495,496,497,498,499,500,501,502,503,504,505,506,507,508,509,510,511,512,513,514,515,516,517,518,519,520,521,522,523,524,525,526,527,528,529,530,531,532,533,534,535,562,563,564,565,566,426,427,428,429,430,431,432,434,435,436,437,438,439,440,441,443,444,445,446,447,448,449,450,458,459,460,461,463,494,574,575,576,577,578,579,580,581,582,583,584,585,586,587,588,589,590,591,592,593,594}'::integer[])) AND (sch_run_date >= '2019-02-01'::date) AND (sch_run_date <= '2019-02-28'::date))
  • Heap Fetches: 10370
33. 14.677 14.677 ↓ 1.1 24,741 1

Index Only Scan using ix_rsg_order_spot_345__stationid__sch_run_dt__dp_placed_id__ord on rsg_order_spot_345 os_30 (cost=0.42..3,819.13 rows=21,665 width=12) (actual time=0.169..14.677 rows=24,741 loops=1)

  • Index Cond: ((station_id = ANY ('{230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390,391,392,393,394,395,396,397,398,399,400,401,402,403,404,405,406,407,408,409,410,411,412,413,414,415,416,417,418,419,420,421,422,423,424,425,433,442,451,452,453,454,455,456,457,462,464,465,466,467,468,469,470,471,472,473,474,475,476,477,478,479,480,481,482,483,484,485,486,487,488,489,490,491,492,493,495,496,497,498,499,500,501,502,503,504,505,506,507,508,509,510,511,512,513,514,515,516,517,518,519,520,521,522,523,524,525,526,527,528,529,530,531,532,533,534,535,562,563,564,565,566,426,427,428,429,430,431,432,434,435,436,437,438,439,440,441,443,444,445,446,447,448,449,450,458,459,460,461,463,494,574,575,576,577,578,579,580,581,582,583,584,585,586,587,588,589,590,591,592,593,594}'::integer[])) AND (sch_run_date >= '2019-02-01'::date) AND (sch_run_date <= '2019-02-28'::date))
  • Heap Fetches: 24266
34. 4.612 4.612 ↓ 1.1 8,720 1

Index Only Scan using ix_rsg_order_spot_392__stationid__sch_run_dt__dp_placed_id__ord on rsg_order_spot_392 os_31 (cost=0.42..1,472.69 rows=8,007 width=12) (actual time=0.182..4.612 rows=8,720 loops=1)

  • Index Cond: ((station_id = ANY ('{230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390,391,392,393,394,395,396,397,398,399,400,401,402,403,404,405,406,407,408,409,410,411,412,413,414,415,416,417,418,419,420,421,422,423,424,425,433,442,451,452,453,454,455,456,457,462,464,465,466,467,468,469,470,471,472,473,474,475,476,477,478,479,480,481,482,483,484,485,486,487,488,489,490,491,492,493,495,496,497,498,499,500,501,502,503,504,505,506,507,508,509,510,511,512,513,514,515,516,517,518,519,520,521,522,523,524,525,526,527,528,529,530,531,532,533,534,535,562,563,564,565,566,426,427,428,429,430,431,432,434,435,436,437,438,439,440,441,443,444,445,446,447,448,449,450,458,459,460,461,463,494,574,575,576,577,578,579,580,581,582,583,584,585,586,587,588,589,590,591,592,593,594}'::integer[])) AND (sch_run_date >= '2019-02-01'::date) AND (sch_run_date <= '2019-02-28'::date))
  • Heap Fetches: 6003
35. 4.715 4.715 ↓ 1.1 10,316 1

Index Only Scan using ix_rsg_order_spot_397__stationid__sch_run_dt__dp_placed_id__ord on rsg_order_spot_397 os_32 (cost=0.42..1,379.43 rows=9,291 width=12) (actual time=0.194..4.715 rows=10,316 loops=1)

  • Index Cond: ((station_id = ANY ('{230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390,391,392,393,394,395,396,397,398,399,400,401,402,403,404,405,406,407,408,409,410,411,412,413,414,415,416,417,418,419,420,421,422,423,424,425,433,442,451,452,453,454,455,456,457,462,464,465,466,467,468,469,470,471,472,473,474,475,476,477,478,479,480,481,482,483,484,485,486,487,488,489,490,491,492,493,495,496,497,498,499,500,501,502,503,504,505,506,507,508,509,510,511,512,513,514,515,516,517,518,519,520,521,522,523,524,525,526,527,528,529,530,531,532,533,534,535,562,563,564,565,566,426,427,428,429,430,431,432,434,435,436,437,438,439,440,441,443,444,445,446,447,448,449,450,458,459,460,461,463,494,574,575,576,577,578,579,580,581,582,583,584,585,586,587,588,589,590,591,592,593,594}'::integer[])) AND (sch_run_date >= '2019-02-01'::date) AND (sch_run_date <= '2019-02-28'::date))
  • Heap Fetches: 5983
36. 12.440 12.440 ↓ 1.1 23,451 1

Index Only Scan using ix_rsg_order_spot_420__stationid__sch_run_dt__dp_placed_id__ord on rsg_order_spot_420 os_33 (cost=0.42..3,342.85 rows=22,145 width=12) (actual time=0.219..12.440 rows=23,451 loops=1)

  • Index Cond: ((station_id = ANY ('{230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390,391,392,393,394,395,396,397,398,399,400,401,402,403,404,405,406,407,408,409,410,411,412,413,414,415,416,417,418,419,420,421,422,423,424,425,433,442,451,452,453,454,455,456,457,462,464,465,466,467,468,469,470,471,472,473,474,475,476,477,478,479,480,481,482,483,484,485,486,487,488,489,490,491,492,493,495,496,497,498,499,500,501,502,503,504,505,506,507,508,509,510,511,512,513,514,515,516,517,518,519,520,521,522,523,524,525,526,527,528,529,530,531,532,533,534,535,562,563,564,565,566,426,427,428,429,430,431,432,434,435,436,437,438,439,440,441,443,444,445,446,447,448,449,450,458,459,460,461,463,494,574,575,576,577,578,579,580,581,582,583,584,585,586,587,588,589,590,591,592,593,594}'::integer[])) AND (sch_run_date >= '2019-02-01'::date) AND (sch_run_date <= '2019-02-28'::date))
  • Heap Fetches: 18445
37. 5.111 5.111 ↓ 1.1 16,327 1

Index Only Scan using ix_rsg_order_spot_284__stationid__sch_run_dt__dp_placed_id__ord on rsg_order_spot_284 os_34 (cost=0.42..997.36 rows=15,045 width=12) (actual time=0.080..5.111 rows=16,327 loops=1)

  • Index Cond: ((station_id = ANY ('{230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390,391,392,393,394,395,396,397,398,399,400,401,402,403,404,405,406,407,408,409,410,411,412,413,414,415,416,417,418,419,420,421,422,423,424,425,433,442,451,452,453,454,455,456,457,462,464,465,466,467,468,469,470,471,472,473,474,475,476,477,478,479,480,481,482,483,484,485,486,487,488,489,490,491,492,493,495,496,497,498,499,500,501,502,503,504,505,506,507,508,509,510,511,512,513,514,515,516,517,518,519,520,521,522,523,524,525,526,527,528,529,530,531,532,533,534,535,562,563,564,565,566,426,427,428,429,430,431,432,434,435,436,437,438,439,440,441,443,444,445,446,447,448,449,450,458,459,460,461,463,494,574,575,576,577,578,579,580,581,582,583,584,585,586,587,588,589,590,591,592,593,594}'::integer[])) AND (sch_run_date >= '2019-02-01'::date) AND (sch_run_date <= '2019-02-28'::date))
  • Heap Fetches: 4235
38. 5.037 5.037 ↓ 1.1 12,099 1

Index Only Scan using ix_rsg_order_spot_414__stationid__sch_run_dt__dp_placed_id__ord on rsg_order_spot_414 os_35 (cost=0.42..1,174.77 rows=10,805 width=12) (actual time=0.220..5.037 rows=12,099 loops=1)

  • Index Cond: ((station_id = ANY ('{230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390,391,392,393,394,395,396,397,398,399,400,401,402,403,404,405,406,407,408,409,410,411,412,413,414,415,416,417,418,419,420,421,422,423,424,425,433,442,451,452,453,454,455,456,457,462,464,465,466,467,468,469,470,471,472,473,474,475,476,477,478,479,480,481,482,483,484,485,486,487,488,489,490,491,492,493,495,496,497,498,499,500,501,502,503,504,505,506,507,508,509,510,511,512,513,514,515,516,517,518,519,520,521,522,523,524,525,526,527,528,529,530,531,532,533,534,535,562,563,564,565,566,426,427,428,429,430,431,432,434,435,436,437,438,439,440,441,443,444,445,446,447,448,449,450,458,459,460,461,463,494,574,575,576,577,578,579,580,581,582,583,584,585,586,587,588,589,590,591,592,593,594}'::integer[])) AND (sch_run_date >= '2019-02-01'::date) AND (sch_run_date <= '2019-02-28'::date))
  • Heap Fetches: 5530
39. 1.376 1.376 ↓ 1.0 6,616 1

Index Only Scan using ix_rsg_order_spot_341__stationid__sch_run_dt__dp_placed_id__ord on rsg_order_spot_341 os_36 (cost=0.42..534.60 rows=6,499 width=12) (actual time=0.138..1.376 rows=6,616 loops=1)

  • Index Cond: ((station_id = ANY ('{230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390,391,392,393,394,395,396,397,398,399,400,401,402,403,404,405,406,407,408,409,410,411,412,413,414,415,416,417,418,419,420,421,422,423,424,425,433,442,451,452,453,454,455,456,457,462,464,465,466,467,468,469,470,471,472,473,474,475,476,477,478,479,480,481,482,483,484,485,486,487,488,489,490,491,492,493,495,496,497,498,499,500,501,502,503,504,505,506,507,508,509,510,511,512,513,514,515,516,517,518,519,520,521,522,523,524,525,526,527,528,529,530,531,532,533,534,535,562,563,564,565,566,426,427,428,429,430,431,432,434,435,436,437,438,439,440,441,443,444,445,446,447,448,449,450,458,459,460,461,463,494,574,575,576,577,578,579,580,581,582,583,584,585,586,587,588,589,590,591,592,593,594}'::integer[])) AND (sch_run_date >= '2019-02-01'::date) AND (sch_run_date <= '2019-02-28'::date))
  • Heap Fetches: 0
40. 7.847 7.847 ↓ 1.0 20,842 1

Index Only Scan using ix_rsg_order_spot_391__stationid__sch_run_dt__dp_placed_id__ord on rsg_order_spot_391 os_37 (cost=0.42..1,890.26 rows=19,968 width=12) (actual time=0.188..7.847 rows=20,842 loops=1)

  • Index Cond: ((station_id = ANY ('{230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390,391,392,393,394,395,396,397,398,399,400,401,402,403,404,405,406,407,408,409,410,411,412,413,414,415,416,417,418,419,420,421,422,423,424,425,433,442,451,452,453,454,455,456,457,462,464,465,466,467,468,469,470,471,472,473,474,475,476,477,478,479,480,481,482,483,484,485,486,487,488,489,490,491,492,493,495,496,497,498,499,500,501,502,503,504,505,506,507,508,509,510,511,512,513,514,515,516,517,518,519,520,521,522,523,524,525,526,527,528,529,530,531,532,533,534,535,562,563,564,565,566,426,427,428,429,430,431,432,434,435,436,437,438,439,440,441,443,444,445,446,447,448,449,450,458,459,460,461,463,494,574,575,576,577,578,579,580,581,582,583,584,585,586,587,588,589,590,591,592,593,594}'::integer[])) AND (sch_run_date >= '2019-02-01'::date) AND (sch_run_date <= '2019-02-28'::date))
  • Heap Fetches: 9321
41. 3.307 3.307 ↓ 1.1 10,544 1

Index Only Scan using ix_rsg_order_spot_271__stationid__sch_run_dt__dp_placed_id__ord on rsg_order_spot_271 os_38 (cost=0.42..845.51 rows=10,018 width=12) (actual time=0.054..3.307 rows=10,544 loops=1)

  • Index Cond: ((station_id = ANY ('{230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390,391,392,393,394,395,396,397,398,399,400,401,402,403,404,405,406,407,408,409,410,411,412,413,414,415,416,417,418,419,420,421,422,423,424,425,433,442,451,452,453,454,455,456,457,462,464,465,466,467,468,469,470,471,472,473,474,475,476,477,478,479,480,481,482,483,484,485,486,487,488,489,490,491,492,493,495,496,497,498,499,500,501,502,503,504,505,506,507,508,509,510,511,512,513,514,515,516,517,518,519,520,521,522,523,524,525,526,527,528,529,530,531,532,533,534,535,562,563,564,565,566,426,427,428,429,430,431,432,434,435,436,437,438,439,440,441,443,444,445,446,447,448,449,450,458,459,460,461,463,494,574,575,576,577,578,579,580,581,582,583,584,585,586,587,588,589,590,591,592,593,594}'::integer[])) AND (sch_run_date >= '2019-02-01'::date) AND (sch_run_date <= '2019-02-28'::date))
  • Heap Fetches: 2569
42. 7.779 7.779 ↑ 1.0 16,421 1

Index Only Scan using ix_rsg_order_spot_248__stationid__sch_run_dt__dp_placed_id__ord on rsg_order_spot_248 os_39 (cost=0.42..2,303.53 rows=16,687 width=12) (actual time=0.035..7.779 rows=16,421 loops=1)

  • Index Cond: ((station_id = ANY ('{230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390,391,392,393,394,395,396,397,398,399,400,401,402,403,404,405,406,407,408,409,410,411,412,413,414,415,416,417,418,419,420,421,422,423,424,425,433,442,451,452,453,454,455,456,457,462,464,465,466,467,468,469,470,471,472,473,474,475,476,477,478,479,480,481,482,483,484,485,486,487,488,489,490,491,492,493,495,496,497,498,499,500,501,502,503,504,505,506,507,508,509,510,511,512,513,514,515,516,517,518,519,520,521,522,523,524,525,526,527,528,529,530,531,532,533,534,535,562,563,564,565,566,426,427,428,429,430,431,432,434,435,436,437,438,439,440,441,443,444,445,446,447,448,449,450,458,459,460,461,463,494,574,575,576,577,578,579,580,581,582,583,584,585,586,587,588,589,590,591,592,593,594}'::integer[])) AND (sch_run_date >= '2019-02-01'::date) AND (sch_run_date <= '2019-02-28'::date))
  • Heap Fetches: 9398
43. 5.998 5.998 ↓ 1.1 11,522 1

Index Only Scan using ix_rsg_order_spot_413__stationid__sch_run_dt__dp_placed_id__ord on rsg_order_spot_413 os_40 (cost=0.42..1,723.64 rows=10,217 width=12) (actual time=0.212..5.998 rows=11,522 loops=1)

  • Index Cond: ((station_id = ANY ('{230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390,391,392,393,394,395,396,397,398,399,400,401,402,403,404,405,406,407,408,409,410,411,412,413,414,415,416,417,418,419,420,421,422,423,424,425,433,442,451,452,453,454,455,456,457,462,464,465,466,467,468,469,470,471,472,473,474,475,476,477,478,479,480,481,482,483,484,485,486,487,488,489,490,491,492,493,495,496,497,498,499,500,501,502,503,504,505,506,507,508,509,510,511,512,513,514,515,516,517,518,519,520,521,522,523,524,525,526,527,528,529,530,531,532,533,534,535,562,563,564,565,566,426,427,428,429,430,431,432,434,435,436,437,438,439,440,441,443,444,445,446,447,448,449,450,458,459,460,461,463,494,574,575,576,577,578,579,580,581,582,583,584,585,586,587,588,589,590,591,592,593,594}'::integer[])) AND (sch_run_date >= '2019-02-01'::date) AND (sch_run_date <= '2019-02-28'::date))
  • Heap Fetches: 8302
44. 5.569 5.569 ↓ 1.1 12,318 1

Index Only Scan using ix_rsg_order_spot_405__stationid__sch_run_dt__dp_placed_id__ord on rsg_order_spot_405 os_41 (cost=0.42..1,400.37 rows=11,637 width=12) (actual time=0.199..5.569 rows=12,318 loops=1)

  • Index Cond: ((station_id = ANY ('{230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390,391,392,393,394,395,396,397,398,399,400,401,402,403,404,405,406,407,408,409,410,411,412,413,414,415,416,417,418,419,420,421,422,423,424,425,433,442,451,452,453,454,455,456,457,462,464,465,466,467,468,469,470,471,472,473,474,475,476,477,478,479,480,481,482,483,484,485,486,487,488,489,490,491,492,493,495,496,497,498,499,500,501,502,503,504,505,506,507,508,509,510,511,512,513,514,515,516,517,518,519,520,521,522,523,524,525,526,527,528,529,530,531,532,533,534,535,562,563,564,565,566,426,427,428,429,430,431,432,434,435,436,437,438,439,440,441,443,444,445,446,447,448,449,450,458,459,460,461,463,494,574,575,576,577,578,579,580,581,582,583,584,585,586,587,588,589,590,591,592,593,594}'::integer[])) AND (sch_run_date >= '2019-02-01'::date) AND (sch_run_date <= '2019-02-28'::date))
  • Heap Fetches: 7259
45. 4.581 4.581 ↓ 1.1 13,919 1

Index Only Scan using ix_rsg_order_spot_367__stationid__sch_run_dt__dp_placed_id__ord on rsg_order_spot_367 os_42 (cost=0.42..1,033.24 rows=12,380 width=12) (actual time=0.168..4.581 rows=13,919 loops=1)

  • Index Cond: ((station_id = ANY ('{230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390,391,392,393,394,395,396,397,398,399,400,401,402,403,404,405,406,407,408,409,410,411,412,413,414,415,416,417,418,419,420,421,422,423,424,425,433,442,451,452,453,454,455,456,457,462,464,465,466,467,468,469,470,471,472,473,474,475,476,477,478,479,480,481,482,483,484,485,486,487,488,489,490,491,492,493,495,496,497,498,499,500,501,502,503,504,505,506,507,508,509,510,511,512,513,514,515,516,517,518,519,520,521,522,523,524,525,526,527,528,529,530,531,532,533,534,535,562,563,564,565,566,426,427,428,429,430,431,432,434,435,436,437,438,439,440,441,443,444,445,446,447,448,449,450,458,459,460,461,463,494,574,575,576,577,578,579,580,581,582,583,584,585,586,587,588,589,590,591,592,593,594}'::integer[])) AND (sch_run_date >= '2019-02-01'::date) AND (sch_run_date <= '2019-02-28'::date))
  • Heap Fetches: 3367
46. 7.248 7.248 ↓ 1.2 17,569 1

Index Only Scan using ix_rsg_order_spot_293__stationid__sch_run_dt__dp_placed_id__ord on rsg_order_spot_293 os_43 (cost=0.42..1,724.83 rows=15,204 width=12) (actual time=0.084..7.248 rows=17,569 loops=1)

  • Index Cond: ((station_id = ANY ('{230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390,391,392,393,394,395,396,397,398,399,400,401,402,403,404,405,406,407,408,409,410,411,412,413,414,415,416,417,418,419,420,421,422,423,424,425,433,442,451,452,453,454,455,456,457,462,464,465,466,467,468,469,470,471,472,473,474,475,476,477,478,479,480,481,482,483,484,485,486,487,488,489,490,491,492,493,495,496,497,498,499,500,501,502,503,504,505,506,507,508,509,510,511,512,513,514,515,516,517,518,519,520,521,522,523,524,525,526,527,528,529,530,531,532,533,534,535,562,563,564,565,566,426,427,428,429,430,431,432,434,435,436,437,438,439,440,441,443,444,445,446,447,448,449,450,458,459,460,461,463,494,574,575,576,577,578,579,580,581,582,583,584,585,586,587,588,589,590,591,592,593,594}'::integer[])) AND (sch_run_date >= '2019-02-01'::date) AND (sch_run_date <= '2019-02-28'::date))
  • Heap Fetches: 8859
47. 4.529 4.529 ↓ 1.0 12,830 1

Index Only Scan using ix_rsg_order_spot_230__stationid__sch_run_dt__dp_placed_id__ord on rsg_order_spot_230 os_44 (cost=0.42..1,151.15 rows=12,568 width=12) (actual time=0.009..4.529 rows=12,830 loops=1)

  • Index Cond: ((station_id = ANY ('{230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390,391,392,393,394,395,396,397,398,399,400,401,402,403,404,405,406,407,408,409,410,411,412,413,414,415,416,417,418,419,420,421,422,423,424,425,433,442,451,452,453,454,455,456,457,462,464,465,466,467,468,469,470,471,472,473,474,475,476,477,478,479,480,481,482,483,484,485,486,487,488,489,490,491,492,493,495,496,497,498,499,500,501,502,503,504,505,506,507,508,509,510,511,512,513,514,515,516,517,518,519,520,521,522,523,524,525,526,527,528,529,530,531,532,533,534,535,562,563,564,565,566,426,427,428,429,430,431,432,434,435,436,437,438,439,440,441,443,444,445,446,447,448,449,450,458,459,460,461,463,494,574,575,576,577,578,579,580,581,582,583,584,585,586,587,588,589,590,591,592,593,594}'::integer[])) AND (sch_run_date >= '2019-02-01'::date) AND (sch_run_date <= '2019-02-28'::date))
  • Heap Fetches: 4220
48. 14.079 14.079 ↓ 1.1 30,114 1

Index Only Scan using ix_rsg_order_spot_407__stationid__sch_run_dt__dp_placed_id__ord on rsg_order_spot_407 os_45 (cost=0.42..3,544.12 rows=27,582 width=12) (actual time=0.202..14.079 rows=30,114 loops=1)

  • Index Cond: ((station_id = ANY ('{230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390,391,392,393,394,395,396,397,398,399,400,401,402,403,404,405,406,407,408,409,410,411,412,413,414,415,416,417,418,419,420,421,422,423,424,425,433,442,451,452,453,454,455,456,457,462,464,465,466,467,468,469,470,471,472,473,474,475,476,477,478,479,480,481,482,483,484,485,486,487,488,489,490,491,492,493,495,496,497,498,499,500,501,502,503,504,505,506,507,508,509,510,511,512,513,514,515,516,517,518,519,520,521,522,523,524,525,526,527,528,529,530,531,532,533,534,535,562,563,564,565,566,426,427,428,429,430,431,432,434,435,436,437,438,439,440,441,443,444,445,446,447,448,449,450,458,459,460,461,463,494,574,575,576,577,578,579,580,581,582,583,584,585,586,587,588,589,590,591,592,593,594}'::integer[])) AND (sch_run_date >= '2019-02-01'::date) AND (sch_run_date <= '2019-02-28'::date))
  • Heap Fetches: 19222
49. 4.640 4.640 ↓ 1.1 11,128 1

Index Only Scan using ix_rsg_order_spot_524__stationid__sch_run_dt__dp_placed_id__ord on rsg_order_spot_524 os_46 (cost=0.42..1,112.48 rows=10,084 width=12) (actual time=0.337..4.640 rows=11,128 loops=1)

  • Index Cond: ((station_id = ANY ('{230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390,391,392,393,394,395,396,397,398,399,400,401,402,403,404,405,406,407,408,409,410,411,412,413,414,415,416,417,418,419,420,421,422,423,424,425,433,442,451,452,453,454,455,456,457,462,464,465,466,467,468,469,470,471,472,473,474,475,476,477,478,479,480,481,482,483,484,485,486,487,488,489,490,491,492,493,495,496,497,498,499,500,501,502,503,504,505,506,507,508,509,510,511,512,513,514,515,516,517,518,519,520,521,522,523,524,525,526,527,528,529,530,531,532,533,534,535,562,563,564,565,566,426,427,428,429,430,431,432,434,435,436,437,438,439,440,441,443,444,445,446,447,448,449,450,458,459,460,461,463,494,574,575,576,577,578,579,580,581,582,583,584,585,586,587,588,589,590,591,592,593,594}'::integer[])) AND (sch_run_date >= '2019-02-01'::date) AND (sch_run_date <= '2019-02-28'::date))
  • Heap Fetches: 5777
50. 7.200 7.200 ↓ 1.0 16,955 1

Index Only Scan using ix_rsg_order_spot_491__stationid__sch_run_dt__dp_placed_id__ord on rsg_order_spot_491 os_47 (cost=0.42..1,706.86 rows=16,355 width=12) (actual time=0.299..7.200 rows=16,955 loops=1)

  • Index Cond: ((station_id = ANY ('{230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390,391,392,393,394,395,396,397,398,399,400,401,402,403,404,405,406,407,408,409,410,411,412,413,414,415,416,417,418,419,420,421,422,423,424,425,433,442,451,452,453,454,455,456,457,462,464,465,466,467,468,469,470,471,472,473,474,475,476,477,478,479,480,481,482,483,484,485,486,487,488,489,490,491,492,493,495,496,497,498,499,500,501,502,503,504,505,506,507,508,509,510,511,512,513,514,515,516,517,518,519,520,521,522,523,524,525,526,527,528,529,530,531,532,533,534,535,562,563,564,565,566,426,427,428,429,430,431,432,434,435,436,437,438,439,440,441,443,444,445,446,447,448,449,450,458,459,460,461,463,494,574,575,576,577,578,579,580,581,582,583,584,585,586,587,588,589,590,591,592,593,594}'::integer[])) AND (sch_run_date >= '2019-02-01'::date) AND (sch_run_date <= '2019-02-28'::date))
  • Heap Fetches: 7892
51. 4.457 4.457 ↓ 1.0 13,923 1

Index Only Scan using ix_rsg_order_spot_288__stationid__sch_run_dt__dp_placed_id__ord on rsg_order_spot_288 os_48 (cost=0.42..990.41 rows=13,580 width=12) (actual time=0.087..4.457 rows=13,923 loops=1)

  • Index Cond: ((station_id = ANY ('{230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390,391,392,393,394,395,396,397,398,399,400,401,402,403,404,405,406,407,408,409,410,411,412,413,414,415,416,417,418,419,420,421,422,423,424,425,433,442,451,452,453,454,455,456,457,462,464,465,466,467,468,469,470,471,472,473,474,475,476,477,478,479,480,481,482,483,484,485,486,487,488,489,490,491,492,493,495,496,497,498,499,500,501,502,503,504,505,506,507,508,509,510,511,512,513,514,515,516,517,518,519,520,521,522,523,524,525,526,527,528,529,530,531,532,533,534,535,562,563,564,565,566,426,427,428,429,430,431,432,434,435,436,437,438,439,440,441,443,444,445,446,447,448,449,450,458,459,460,461,463,494,574,575,576,577,578,579,580,581,582,583,584,585,586,587,588,589,590,591,592,593,594}'::integer[])) AND (sch_run_date >= '2019-02-01'::date) AND (sch_run_date <= '2019-02-28'::date))
  • Heap Fetches: 4283
52. 4.529 4.529 ↓ 1.1 9,665 1

Index Only Scan using ix_rsg_order_spot_406__stationid__sch_run_dt__dp_placed_id__ord on rsg_order_spot_406 os_49 (cost=0.42..1,282.71 rows=8,444 width=12) (actual time=0.213..4.529 rows=9,665 loops=1)

  • Index Cond: ((station_id = ANY ('{230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390,391,392,393,394,395,396,397,398,399,400,401,402,403,404,405,406,407,408,409,410,411,412,413,414,415,416,417,418,419,420,421,422,423,424,425,433,442,451,452,453,454,455,456,457,462,464,465,466,467,468,469,470,471,472,473,474,475,476,477,478,479,480,481,482,483,484,485,486,487,488,489,490,491,492,493,495,496,497,498,499,500,501,502,503,504,505,506,507,508,509,510,511,512,513,514,515,516,517,518,519,520,521,522,523,524,525,526,527,528,529,530,531,532,533,534,535,562,563,564,565,566,426,427,428,429,430,431,432,434,435,436,437,438,439,440,441,443,444,445,446,447,448,449,450,458,459,460,461,463,494,574,575,576,577,578,579,580,581,582,583,584,585,586,587,588,589,590,591,592,593,594}'::integer[])) AND (sch_run_date >= '2019-02-01'::date) AND (sch_run_date <= '2019-02-28'::date))
  • Heap Fetches: 5993
53. 5.948 5.948 ↓ 1.1 12,037 1

Index Only Scan using ix_rsg_order_spot_404__stationid__sch_run_dt__dp_placed_id__ord on rsg_order_spot_404 os_50 (cost=0.42..1,673.08 rows=11,384 width=12) (actual time=0.204..5.948 rows=12,037 loops=1)

  • Index Cond: ((station_id = ANY ('{230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390,391,392,393,394,395,396,397,398,399,400,401,402,403,404,405,406,407,408,409,410,411,412,413,414,415,416,417,418,419,420,421,422,423,424,425,433,442,451,452,453,454,455,456,457,462,464,465,466,467,468,469,470,471,472,473,474,475,476,477,478,479,480,481,482,483,484,485,486,487,488,489,490,491,492,493,495,496,497,498,499,500,501,502,503,504,505,506,507,508,509,510,511,512,513,514,515,516,517,518,519,520,521,522,523,524,525,526,527,528,529,530,531,532,533,534,535,562,563,564,565,566,426,427,428,429,430,431,432,434,435,436,437,438,439,440,441,443,444,445,446,447,448,449,450,458,459,460,461,463,494,574,575,576,577,578,579,580,581,582,583,584,585,586,587,588,589,590,591,592,593,594}'::integer[])) AND (sch_run_date >= '2019-02-01'::date) AND (sch_run_date <= '2019-02-28'::date))
  • Heap Fetches: 8063
54. 3.737 3.737 ↓ 1.1 8,482 1

Index Only Scan using ix_rsg_order_spot_422__stationid__sch_run_dt__dp_placed_id__ord on rsg_order_spot_422 os_51 (cost=0.42..908.59 rows=7,433 width=12) (actual time=0.219..3.737 rows=8,482 loops=1)

  • Index Cond: ((station_id = ANY ('{230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390,391,392,393,394,395,396,397,398,399,400,401,402,403,404,405,406,407,408,409,410,411,412,413,414,415,416,417,418,419,420,421,422,423,424,425,433,442,451,452,453,454,455,456,457,462,464,465,466,467,468,469,470,471,472,473,474,475,476,477,478,479,480,481,482,483,484,485,486,487,488,489,490,491,492,493,495,496,497,498,499,500,501,502,503,504,505,506,507,508,509,510,511,512,513,514,515,516,517,518,519,520,521,522,523,524,525,526,527,528,529,530,531,532,533,534,535,562,563,564,565,566,426,427,428,429,430,431,432,434,435,436,437,438,439,440,441,443,444,445,446,447,448,449,450,458,459,460,461,463,494,574,575,576,577,578,579,580,581,582,583,584,585,586,587,588,589,590,591,592,593,594}'::integer[])) AND (sch_run_date >= '2019-02-01'::date) AND (sch_run_date <= '2019-02-28'::date))
  • Heap Fetches: 4274
55. 1.665 1.665 ↓ 1.1 5,438 1

Index Only Scan using ix_rsg_order_spot_516__stationid__sch_run_dt__dp_placed_id__ord on rsg_order_spot_516 os_52 (cost=0.42..599.33 rows=5,087 width=12) (actual time=0.323..1.665 rows=5,438 loops=1)

  • Index Cond: ((station_id = ANY ('{230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390,391,392,393,394,395,396,397,398,399,400,401,402,403,404,405,406,407,408,409,410,411,412,413,414,415,416,417,418,419,420,421,422,423,424,425,433,442,451,452,453,454,455,456,457,462,464,465,466,467,468,469,470,471,472,473,474,475,476,477,478,479,480,481,482,483,484,485,486,487,488,489,490,491,492,493,495,496,497,498,499,500,501,502,503,504,505,506,507,508,509,510,511,512,513,514,515,516,517,518,519,520,521,522,523,524,525,526,527,528,529,530,531,532,533,534,535,562,563,564,565,566,426,427,428,429,430,431,432,434,435,436,437,438,439,440,441,443,444,445,446,447,448,449,450,458,459,460,461,463,494,574,575,576,577,578,579,580,581,582,583,584,585,586,587,588,589,590,591,592,593,594}'::integer[])) AND (sch_run_date >= '2019-02-01'::date) AND (sch_run_date <= '2019-02-28'::date))
  • Heap Fetches: 1106
56. 5.122 5.122 ↓ 1.2 10,863 1

Index Only Scan using ix_rsg_order_spot_462__stationid__sch_run_dt__dp_placed_id__ord on rsg_order_spot_462 os_53 (cost=0.42..1,173.34 rows=9,193 width=12) (actual time=0.255..5.122 rows=10,863 loops=1)

  • Index Cond: ((station_id = ANY ('{230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390,391,392,393,394,395,396,397,398,399,400,401,402,403,404,405,406,407,408,409,410,411,412,413,414,415,416,417,418,419,420,421,422,423,424,425,433,442,451,452,453,454,455,456,457,462,464,465,466,467,468,469,470,471,472,473,474,475,476,477,478,479,480,481,482,483,484,485,486,487,488,489,490,491,492,493,495,496,497,498,499,500,501,502,503,504,505,506,507,508,509,510,511,512,513,514,515,516,517,518,519,520,521,522,523,524,525,526,527,528,529,530,531,532,533,534,535,562,563,564,565,566,426,427,428,429,430,431,432,434,435,436,437,438,439,440,441,443,444,445,446,447,448,449,450,458,459,460,461,463,494,574,575,576,577,578,579,580,581,582,583,584,585,586,587,588,589,590,591,592,593,594}'::integer[])) AND (sch_run_date >= '2019-02-01'::date) AND (sch_run_date <= '2019-02-28'::date))
  • Heap Fetches: 4700
57. 4.495 4.495 ↓ 1.2 6,335 1

Index Only Scan using ix_rsg_order_spot_527__stationid__sch_run_dt__dp_placed_id__ord on rsg_order_spot_527 os_54 (cost=0.42..895.09 rows=5,306 width=12) (actual time=0.634..4.495 rows=6,335 loops=1)

  • Index Cond: ((station_id = ANY ('{230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390,391,392,393,394,395,396,397,398,399,400,401,402,403,404,405,406,407,408,409,410,411,412,413,414,415,416,417,418,419,420,421,422,423,424,425,433,442,451,452,453,454,455,456,457,462,464,465,466,467,468,469,470,471,472,473,474,475,476,477,478,479,480,481,482,483,484,485,486,487,488,489,490,491,492,493,495,496,497,498,499,500,501,502,503,504,505,506,507,508,509,510,511,512,513,514,515,516,517,518,519,520,521,522,523,524,525,526,527,528,529,530,531,532,533,534,535,562,563,564,565,566,426,427,428,429,430,431,432,434,435,436,437,438,439,440,441,443,444,445,446,447,448,449,450,458,459,460,461,463,494,574,575,576,577,578,579,580,581,582,583,584,585,586,587,588,589,590,591,592,593,594}'::integer[])) AND (sch_run_date >= '2019-02-01'::date) AND (sch_run_date <= '2019-02-28'::date))
  • Heap Fetches: 4099
58. 11.606 11.606 ↓ 1.2 27,289 1

Index Only Scan using ix_rsg_order_spot_291__stationid__sch_run_dt__dp_placed_id__ord on rsg_order_spot_291 os_55 (cost=0.42..2,282.38 rows=22,392 width=12) (actual time=0.085..11.606 rows=27,289 loops=1)

  • Index Cond: ((station_id = ANY ('{230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390,391,392,393,394,395,396,397,398,399,400,401,402,403,404,405,406,407,408,409,410,411,412,413,414,415,416,417,418,419,420,421,422,423,424,425,433,442,451,452,453,454,455,456,457,462,464,465,466,467,468,469,470,471,472,473,474,475,476,477,478,479,480,481,482,483,484,485,486,487,488,489,490,491,492,493,495,496,497,498,499,500,501,502,503,504,505,506,507,508,509,510,511,512,513,514,515,516,517,518,519,520,521,522,523,524,525,526,527,528,529,530,531,532,533,534,535,562,563,564,565,566,426,427,428,429,430,431,432,434,435,436,437,438,439,440,441,443,444,445,446,447,448,449,450,458,459,460,461,463,494,574,575,576,577,578,579,580,581,582,583,584,585,586,587,588,589,590,591,592,593,594}'::integer[])) AND (sch_run_date >= '2019-02-01'::date) AND (sch_run_date <= '2019-02-28'::date))
  • Heap Fetches: 12365
59. 9.875 9.875 ↓ 1.1 19,899 1

Index Only Scan using ix_rsg_order_spot_356__stationid__sch_run_dt__dp_placed_id__ord on rsg_order_spot_356 os_56 (cost=0.42..2,191.57 rows=17,868 width=12) (actual time=0.176..9.875 rows=19,899 loops=1)

  • Index Cond: ((station_id = ANY ('{230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390,391,392,393,394,395,396,397,398,399,400,401,402,403,404,405,406,407,408,409,410,411,412,413,414,415,416,417,418,419,420,421,422,423,424,425,433,442,451,452,453,454,455,456,457,462,464,465,466,467,468,469,470,471,472,473,474,475,476,477,478,479,480,481,482,483,484,485,486,487,488,489,490,491,492,493,495,496,497,498,499,500,501,502,503,504,505,506,507,508,509,510,511,512,513,514,515,516,517,518,519,520,521,522,523,524,525,526,527,528,529,530,531,532,533,534,535,562,563,564,565,566,426,427,428,429,430,431,432,434,435,436,437,438,439,440,441,443,444,445,446,447,448,449,450,458,459,460,461,463,494,574,575,576,577,578,579,580,581,582,583,584,585,586,587,588,589,590,591,592,593,594}'::integer[])) AND (sch_run_date >= '2019-02-01'::date) AND (sch_run_date <= '2019-02-28'::date))
  • Heap Fetches: 12012
60. 4.081 4.081 ↓ 1.2 7,732 1

Index Only Scan using ix_rsg_order_spot_238__stationid__sch_run_dt__dp_placed_id__ord on rsg_order_spot_238 os_57 (cost=0.42..1,131.84 rows=6,482 width=12) (actual time=0.021..4.081 rows=7,732 loops=1)

  • Index Cond: ((station_id = ANY ('{230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390,391,392,393,394,395,396,397,398,399,400,401,402,403,404,405,406,407,408,409,410,411,412,413,414,415,416,417,418,419,420,421,422,423,424,425,433,442,451,452,453,454,455,456,457,462,464,465,466,467,468,469,470,471,472,473,474,475,476,477,478,479,480,481,482,483,484,485,486,487,488,489,490,491,492,493,495,496,497,498,499,500,501,502,503,504,505,506,507,508,509,510,511,512,513,514,515,516,517,518,519,520,521,522,523,524,525,526,527,528,529,530,531,532,533,534,535,562,563,564,565,566,426,427,428,429,430,431,432,434,435,436,437,438,439,440,441,443,444,445,446,447,448,449,450,458,459,460,461,463,494,574,575,576,577,578,579,580,581,582,583,584,585,586,587,588,589,590,591,592,593,594}'::integer[])) AND (sch_run_date >= '2019-02-01'::date) AND (sch_run_date <= '2019-02-28'::date))
  • Heap Fetches: 4844
61. 7.257 7.257 ↓ 1.1 16,658 1

Index Only Scan using ix_rsg_order_spot_273__stationid__sch_run_dt__dp_placed_id__ord on rsg_order_spot_273 os_58 (cost=0.42..1,628.92 rows=14,801 width=12) (actual time=0.060..7.257 rows=16,658 loops=1)

  • Index Cond: ((station_id = ANY ('{230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390,391,392,393,394,395,396,397,398,399,400,401,402,403,404,405,406,407,408,409,410,411,412,413,414,415,416,417,418,419,420,421,422,423,424,425,433,442,451,452,453,454,455,456,457,462,464,465,466,467,468,469,470,471,472,473,474,475,476,477,478,479,480,481,482,483,484,485,486,487,488,489,490,491,492,493,495,496,497,498,499,500,501,502,503,504,505,506,507,508,509,510,511,512,513,514,515,516,517,518,519,520,521,522,523,524,525,526,527,528,529,530,531,532,533,534,535,562,563,564,565,566,426,427,428,429,430,431,432,434,435,436,437,438,439,440,441,443,444,445,446,447,448,449,450,458,459,460,461,463,494,574,575,576,577,578,579,580,581,582,583,584,585,586,587,588,589,590,591,592,593,594}'::integer[])) AND (sch_run_date >= '2019-02-01'::date) AND (sch_run_date <= '2019-02-28'::date))
  • Heap Fetches: 8498
62. 3.087 3.087 ↓ 1.2 6,752 1

Index Only Scan using ix_rsg_order_spot_251__stationid__sch_run_dt__dp_placed_id__ord on rsg_order_spot_251 os_59 (cost=0.42..795.57 rows=5,537 width=12) (actual time=0.035..3.087 rows=6,752 loops=1)

  • Index Cond: ((station_id = ANY ('{230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390,391,392,393,394,395,396,397,398,399,400,401,402,403,404,405,406,407,408,409,410,411,412,413,414,415,416,417,418,419,420,421,422,423,424,425,433,442,451,452,453,454,455,456,457,462,464,465,466,467,468,469,470,471,472,473,474,475,476,477,478,479,480,481,482,483,484,485,486,487,488,489,490,491,492,493,495,496,497,498,499,500,501,502,503,504,505,506,507,508,509,510,511,512,513,514,515,516,517,518,519,520,521,522,523,524,525,526,527,528,529,530,531,532,533,534,535,562,563,564,565,566,426,427,428,429,430,431,432,434,435,436,437,438,439,440,441,443,444,445,446,447,448,449,450,458,459,460,461,463,494,574,575,576,577,578,579,580,581,582,583,584,585,586,587,588,589,590,591,592,593,594}'::integer[])) AND (sch_run_date >= '2019-02-01'::date) AND (sch_run_date <= '2019-02-28'::date))
  • Heap Fetches: 3627
63. 6.092 6.092 ↓ 1.0 14,070 1

Index Only Scan using ix_rsg_order_spot_522__stationid__sch_run_dt__dp_placed_id__ord on rsg_order_spot_522 os_60 (cost=0.42..1,547.41 rows=13,829 width=12) (actual time=0.327..6.092 rows=14,070 loops=1)

  • Index Cond: ((station_id = ANY ('{230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390,391,392,393,394,395,396,397,398,399,400,401,402,403,404,405,406,407,408,409,410,411,412,413,414,415,416,417,418,419,420,421,422,423,424,425,433,442,451,452,453,454,455,456,457,462,464,465,466,467,468,469,470,471,472,473,474,475,476,477,478,479,480,481,482,483,484,485,486,487,488,489,490,491,492,493,495,496,497,498,499,500,501,502,503,504,505,506,507,508,509,510,511,512,513,514,515,516,517,518,519,520,521,522,523,524,525,526,527,528,529,530,531,532,533,534,535,562,563,564,565,566,426,427,428,429,430,431,432,434,435,436,437,438,439,440,441,443,444,445,446,447,448,449,450,458,459,460,461,463,494,574,575,576,577,578,579,580,581,582,583,584,585,586,587,588,589,590,591,592,593,594}'::integer[])) AND (sch_run_date >= '2019-02-01'::date) AND (sch_run_date <= '2019-02-28'::date))
  • Heap Fetches: 7447
64. 8.078 8.078 ↓ 1.1 21,740 1

Index Only Scan using ix_rsg_order_spot_245__stationid__sch_run_dt__dp_placed_id__ord on rsg_order_spot_245 os_61 (cost=0.42..1,681.74 rows=19,213 width=12) (actual time=0.037..8.078 rows=21,740 loops=1)

  • Index Cond: ((station_id = ANY ('{230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390,391,392,393,394,395,396,397,398,399,400,401,402,403,404,405,406,407,408,409,410,411,412,413,414,415,416,417,418,419,420,421,422,423,424,425,433,442,451,452,453,454,455,456,457,462,464,465,466,467,468,469,470,471,472,473,474,475,476,477,478,479,480,481,482,483,484,485,486,487,488,489,490,491,492,493,495,496,497,498,499,500,501,502,503,504,505,506,507,508,509,510,511,512,513,514,515,516,517,518,519,520,521,522,523,524,525,526,527,528,529,530,531,532,533,534,535,562,563,564,565,566,426,427,428,429,430,431,432,434,435,436,437,438,439,440,441,443,444,445,446,447,448,449,450,458,459,460,461,463,494,574,575,576,577,578,579,580,581,582,583,584,585,586,587,588,589,590,591,592,593,594}'::integer[])) AND (sch_run_date >= '2019-02-01'::date) AND (sch_run_date <= '2019-02-28'::date))
  • Heap Fetches: 8173
65. 6.236 6.236 ↓ 1.2 20,450 1

Index Only Scan using ix_rsg_order_spot_241__stationid__sch_run_dt__dp_placed_id__ord on rsg_order_spot_241 os_62 (cost=0.42..1,056.58 rows=16,448 width=12) (actual time=0.033..6.236 rows=20,450 loops=1)

  • Index Cond: ((station_id = ANY ('{230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390,391,392,393,394,395,396,397,398,399,400,401,402,403,404,405,406,407,408,409,410,411,412,413,414,415,416,417,418,419,420,421,422,423,424,425,433,442,451,452,453,454,455,456,457,462,464,465,466,467,468,469,470,471,472,473,474,475,476,477,478,479,480,481,482,483,484,485,486,487,488,489,490,491,492,493,495,496,497,498,499,500,501,502,503,504,505,506,507,508,509,510,511,512,513,514,515,516,517,518,519,520,521,522,523,524,525,526,527,528,529,530,531,532,533,534,535,562,563,564,565,566,426,427,428,429,430,431,432,434,435,436,437,438,439,440,441,443,444,445,446,447,448,449,450,458,459,460,461,463,494,574,575,576,577,578,579,580,581,582,583,584,585,586,587,588,589,590,591,592,593,594}'::integer[])) AND (sch_run_date >= '2019-02-01'::date) AND (sch_run_date <= '2019-02-28'::date))
  • Heap Fetches: 5057
66. 5.962 5.962 ↓ 1.1 13,606 1

Index Only Scan using ix_rsg_order_spot_342__stationid__sch_run_dt__dp_placed_id__ord on rsg_order_spot_342 os_63 (cost=0.42..1,437.07 rows=12,169 width=12) (actual time=0.143..5.962 rows=13,606 loops=1)

  • Index Cond: ((station_id = ANY ('{230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390,391,392,393,394,395,396,397,398,399,400,401,402,403,404,405,406,407,408,409,410,411,412,413,414,415,416,417,418,419,420,421,422,423,424,425,433,442,451,452,453,454,455,456,457,462,464,465,466,467,468,469,470,471,472,473,474,475,476,477,478,479,480,481,482,483,484,485,486,487,488,489,490,491,492,493,495,496,497,498,499,500,501,502,503,504,505,506,507,508,509,510,511,512,513,514,515,516,517,518,519,520,521,522,523,524,525,526,527,528,529,530,531,532,533,534,535,562,563,564,565,566,426,427,428,429,430,431,432,434,435,436,437,438,439,440,441,443,444,445,446,447,448,449,450,458,459,460,461,463,494,574,575,576,577,578,579,580,581,582,583,584,585,586,587,588,589,590,591,592,593,594}'::integer[])) AND (sch_run_date >= '2019-02-01'::date) AND (sch_run_date <= '2019-02-28'::date))
  • Heap Fetches: 7214
67. 8.664 8.664 ↓ 1.0 20,247 1

Index Only Scan using ix_rsg_order_spot_232__stationid__sch_run_dt__dp_placed_id__ord on rsg_order_spot_232 os_64 (cost=0.42..2,289.96 rows=19,811 width=12) (actual time=0.018..8.664 rows=20,247 loops=1)

  • Index Cond: ((station_id = ANY ('{230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390,391,392,393,394,395,396,397,398,399,400,401,402,403,404,405,406,407,408,409,410,411,412,413,414,415,416,417,418,419,420,421,422,423,424,425,433,442,451,452,453,454,455,456,457,462,464,465,466,467,468,469,470,471,472,473,474,475,476,477,478,479,480,481,482,483,484,485,486,487,488,489,490,491,492,493,495,496,497,498,499,500,501,502,503,504,505,506,507,508,509,510,511,512,513,514,515,516,517,518,519,520,521,522,523,524,525,526,527,528,529,530,531,532,533,534,535,562,563,564,565,566,426,427,428,429,430,431,432,434,435,436,437,438,439,440,441,443,444,445,446,447,448,449,450,458,459,460,461,463,494,574,575,576,577,578,579,580,581,582,583,584,585,586,587,588,589,590,591,592,593,594}'::integer[])) AND (sch_run_date >= '2019-02-01'::date) AND (sch_run_date <= '2019-02-28'::date))
  • Heap Fetches: 10750
68. 8.853 8.853 ↓ 1.1 20,285 1

Index Only Scan using ix_rsg_order_spot_357__stationid__sch_run_dt__dp_placed_id__ord on rsg_order_spot_357 os_65 (cost=0.42..1,852.98 rows=18,271 width=12) (actual time=0.156..8.853 rows=20,285 loops=1)

  • Index Cond: ((station_id = ANY ('{230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390,391,392,393,394,395,396,397,398,399,400,401,402,403,404,405,406,407,408,409,410,411,412,413,414,415,416,417,418,419,420,421,422,423,424,425,433,442,451,452,453,454,455,456,457,462,464,465,466,467,468,469,470,471,472,473,474,475,476,477,478,479,480,481,482,483,484,485,486,487,488,489,490,491,492,493,495,496,497,498,499,500,501,502,503,504,505,506,507,508,509,510,511,512,513,514,515,516,517,518,519,520,521,522,523,524,525,526,527,528,529,530,531,532,533,534,535,562,563,564,565,566,426,427,428,429,430,431,432,434,435,436,437,438,439,440,441,443,444,445,446,447,448,449,450,458,459,460,461,463,494,574,575,576,577,578,579,580,581,582,583,584,585,586,587,588,589,590,591,592,593,594}'::integer[])) AND (sch_run_date >= '2019-02-01'::date) AND (sch_run_date <= '2019-02-28'::date))
  • Heap Fetches: 11127