explain.depesz.com

PostgreSQL's explain analyze made readable

Result: CG9Y

Settings
# exclusive inclusive rows x rows loops node
1. 586.614 4,094.464 ↑ 21.3 1,881 1

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

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

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

3. 0.004 0.004 ↓ 0.0 0 1

Seq Scan on rsg_order_spot os (cost=0.00..0.00 rows=1 width=12) (actual time=0.004..0.004 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.033 0.033 ↑ 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.020..0.033 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.909 0.909 ↓ 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.277..0.909 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.272..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.616 0.616 ↓ 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.253..0.616 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.406 0.406 ↓ 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.038..0.406 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.413 0.413 ↑ 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.413 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.249 0.249 ↓ 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.249..0.249 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.264 0.264 ↓ 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.127..0.264 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.399 1.399 ↓ 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.162..1.399 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.687 0.687 ↓ 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.132..0.687 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.258 0.258 ↑ 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.258 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.517 0.517 ↓ 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.517 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.240 3.240 ↓ 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.240 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.140 0.140 ↓ 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.023..0.140 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.362 0.362 ↓ 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.160..0.362 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.993 0.993 ↓ 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.993 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.316 6.316 ↓ 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.092..6.316 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.463 5.463 ↓ 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.078..5.463 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.811 5.811 ↓ 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.262..5.811 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.330 6.330 ↓ 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.137..6.330 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.683 6.683 ↑ 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.683 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.582 4.582 ↓ 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.582 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.687 1.687 ↓ 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.148..1.687 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.096 7.096 ↓ 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.215..7.096 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.876 6.876 ↓ 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.303..6.876 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.229 9.229 ↓ 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.083..9.229 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.699 14.699 ↓ 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.170..14.699 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.654 4.654 ↓ 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.184..4.654 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.854 4.854 ↓ 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.854 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.585 12.585 ↓ 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.585 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.062 5.062 ↓ 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.084..5.062 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. 4.729 4.729 ↓ 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.216..4.729 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.349 1.349 ↓ 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.349 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.870 7.870 ↓ 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.187..7.870 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.347 3.347 ↓ 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.055..3.347 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.784 7.784 ↑ 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.036..7.784 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.209..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.485 5.485 ↓ 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.196..5.485 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.703 4.703 ↓ 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.165..4.703 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.196 7.196 ↓ 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.083..7.196 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.536 4.536 ↓ 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.536 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.071 14.071 ↓ 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.201..14.071 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.764 4.764 ↓ 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.354..4.764 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.139 7.139 ↓ 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.139 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.543 4.543 ↓ 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.085..4.543 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.484 4.484 ↓ 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.211..4.484 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.886 5.886 ↓ 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.202..5.886 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.732 3.732 ↓ 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.732 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.624 1.624 ↓ 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.321..1.624 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. 4.345 4.345 ↓ 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.259..4.345 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. 3.156 3.156 ↓ 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.334..3.156 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. 10.898 10.898 ↓ 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.084..10.898 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.370 9.370 ↓ 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.175..9.370 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. 3.997 3.997 ↓ 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.020..3.997 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.124 7.124 ↓ 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.057..7.124 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.733 3.733 ↓ 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.733 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.105 6.105 ↓ 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.333..6.105 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. 7.712 7.712 ↓ 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.038..7.712 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.299 6.299 ↓ 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.034..6.299 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. 6.093 6.093 ↓ 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.146..6.093 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. 10.743 10.743 ↓ 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..10.743 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. 9.197 9.197 ↓ 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.162..9.197 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