-- original SELECT observed_at FROM pmc_alert_level_point WHERE fingerprint=UNHEX(:fingerprint) ORDER BY observed_epoch DESC,observed_at DESC LIMIT 1; -- force_primary SELECT observed_at FROM pmc_alert_level_point FORCE INDEX (PRIMARY) WHERE fingerprint=UNHEX(:fingerprint) ORDER BY observed_epoch DESC,observed_at DESC LIMIT 1; -- select_one SELECT 1 FROM pmc_alert_level_point WHERE fingerprint=UNHEX(:fingerprint) LIMIT 1; -- exists SELECT EXISTS(SELECT 1 FROM pmc_alert_level_point WHERE fingerprint=UNHEX(:fingerprint)); -- watermark_fallback SELECT EXISTS(SELECT 1 FROM pmc_alert_observation w JOIN pmc_alert_level_point p ON p.fingerprint=w.fingerprint AND p.observed_epoch=w.observed_epoch AND p.observed_at=w.observed_at WHERE w.fingerprint=UNHEX(:fingerprint)) OR EXISTS(SELECT 1 FROM pmc_alert_level_point WHERE fingerprint=UNHEX(:fingerprint)); -- recent_fallback SELECT EXISTS ( SELECT 1 FROM pmc_alert_level_point WHERE fingerprint = UNHEX(:fingerprint) AND observed_at >= :day_start AND observed_at < :next_day ) OR EXISTS ( SELECT 1 FROM pmc_alert_level_point WHERE fingerprint = UNHEX(:fingerprint) ); -- watermark_only SELECT observed_at FROM pmc_alert_observation WHERE fingerprint=UNHEX(:fingerprint); -- exact point SELECT is_open FROM pmc_alert_level_point WHERE fingerprint=UNHEX(:fingerprint) AND observed_epoch=:epoch AND observed_at=:at; -- predecessor SELECT observed_epoch,observed_at,is_open FROM pmc_alert_level_point WHERE fingerprint=UNHEX(:fingerprint) AND (observed_epoch<:epoch OR (observed_epoch=:epoch AND observed_at<:at)) ORDER BY observed_epoch DESC,observed_at DESC LIMIT 1; -- successor SELECT observed_epoch,observed_at,is_open FROM pmc_alert_level_point WHERE fingerprint=UNHEX(:fingerprint) AND (observed_epoch>:epoch OR (observed_epoch=:epoch AND observed_at>:at)) ORDER BY observed_epoch,observed_at LIMIT 1; -- Alternative layouts (tested on disposable copies) -- INDEX when_observed(observed_epoch,observed_at) -- PARTITION BY KEY(fingerprint) PARTITIONS 16 -- Unpartitioned with PRIMARY KEY(fingerprint,observed_epoch,observed_at) MariaDB · EXPLAIN PARTITIONS SQL I / AdvisorPerformanceSchema / original id: 1 select_type: SIMPLE table: pmc_alert_level_point partitions: plegacy,p20261013,p20261014,p20261015,p20261016,p20261017,p20261018,p20261019,p20261020,p20261021,p20261022,p20261023,p20261024,p20261025,p20261026,p20261027,p20261028,p20261029,p20261030,p740286,p740287,p740288,p740289,p740290,p740291,p740292,p740293,p740294,p740295,p740296,p740297,p740298,p740299,p740300,p740301,p740302,p740303,p740304,p740305,p740306,p740307,p740308,p740309,p740310,pmax type: ref possible_keys: PRIMARY,level_neighbour,level_neighbour_epoch key: PRIMARY key_len: 32 ref: const rows: 3061 Extra: Using where; Using index SQL I / AdvisorPerformanceSchema / force_primary id: 1 select_type: SIMPLE table: pmc_alert_level_point partitions: plegacy,p20261013,p20261014,p20261015,p20261016,p20261017,p20261018,p20261019,p20261020,p20261021,p20261022,p20261023,p20261024,p20261025,p20261026,p20261027,p20261028,p20261029,p20261030,p740286,p740287,p740288,p740289,p740290,p740291,p740292,p740293,p740294,p740295,p740296,p740297,p740298,p740299,p740300,p740301,p740302,p740303,p740304,p740305,p740306,p740307,p740308,p740309,p740310,pmax type: ref possible_keys: PRIMARY key: PRIMARY key_len: 32 ref: const rows: 3061 Extra: Using where; Using index SQL I / AdvisorPerformanceSchema / select_one id: 1 select_type: SIMPLE table: pmc_alert_level_point partitions: plegacy,p20261013,p20261014,p20261015,p20261016,p20261017,p20261018,p20261019,p20261020,p20261021,p20261022,p20261023,p20261024,p20261025,p20261026,p20261027,p20261028,p20261029,p20261030,p740286,p740287,p740288,p740289,p740290,p740291,p740292,p740293,p740294,p740295,p740296,p740297,p740298,p740299,p740300,p740301,p740302,p740303,p740304,p740305,p740306,p740307,p740308,p740309,p740310,pmax type: ref possible_keys: PRIMARY,level_neighbour,level_neighbour_epoch key: PRIMARY key_len: 32 ref: const rows: 3061 Extra: Using where; Using index SQL I / AdvisorPerformanceSchema / exists id: 1 select_type: PRIMARY table: NULL partitions: NULL type: NULL possible_keys: NULL key: NULL key_len: NULL ref: NULL rows: NULL Extra: No tables used id: 2 select_type: SUBQUERY table: pmc_alert_level_point partitions: plegacy,p20261013,p20261014,p20261015,p20261016,p20261017,p20261018,p20261019,p20261020,p20261021,p20261022,p20261023,p20261024,p20261025,p20261026,p20261027,p20261028,p20261029,p20261030,p740286,p740287,p740288,p740289,p740290,p740291,p740292,p740293,p740294,p740295,p740296,p740297,p740298,p740299,p740300,p740301,p740302,p740303,p740304,p740305,p740306,p740307,p740308,p740309,p740310,pmax type: ref possible_keys: PRIMARY,level_neighbour,level_neighbour_epoch key: PRIMARY key_len: 32 ref: const rows: 3061 Extra: Using where; Using index SQL I / AdvisorPerformanceSchema / watermark_fallback id: 1 select_type: PRIMARY table: NULL partitions: NULL type: NULL possible_keys: NULL key: NULL key_len: NULL ref: NULL rows: NULL Extra: No tables used id: 3 select_type: SUBQUERY table: pmc_alert_level_point partitions: plegacy,p20261013,p20261014,p20261015,p20261016,p20261017,p20261018,p20261019,p20261020,p20261021,p20261022,p20261023,p20261024,p20261025,p20261026,p20261027,p20261028,p20261029,p20261030,p740286,p740287,p740288,p740289,p740290,p740291,p740292,p740293,p740294,p740295,p740296,p740297,p740298,p740299,p740300,p740301,p740302,p740303,p740304,p740305,p740306,p740307,p740308,p740309,p740310,pmax type: ref possible_keys: PRIMARY,level_neighbour,level_neighbour_epoch key: PRIMARY key_len: 32 ref: const rows: 3061 Extra: Using where; Using index id: 2 select_type: SUBQUERY table: w partitions: NULL type: const possible_keys: PRIMARY key: PRIMARY key_len: 32 ref: const rows: 1 Extra: id: 2 select_type: SUBQUERY table: p partitions: plegacy,p20261013,p20261014,p20261015,p20261016,p20261017,p20261018,p20261019,p20261020,p20261021,p20261022,p20261023,p20261024,p20261025,p20261026,p20261027,p20261028,p20261029,p20261030,p740286,p740287,p740288,p740289,p740290,p740291,p740292,p740293,p740294,p740295,p740296,p740297,p740298,p740299,p740300,p740301,p740302,p740303,p740304,p740305,p740306,p740307,p740308,p740309,p740310,pmax type: const possible_keys: PRIMARY,level_neighbour,level_neighbour_epoch key: PRIMARY key_len: 48 ref: const,const,const rows: 1 Extra: Using index SQL I / AdvisorTimeZoneAlignment / original id: 1 select_type: SIMPLE table: pmc_alert_level_point partitions: plegacy,p20261013,p20261014,p20261015,p20261016,p20261017,p20261018,p20261019,p20261020,p20261021,p20261022,p20261023,p20261024,p20261025,p20261026,p20261027,p20261028,p20261029,p20261030,p740286,p740287,p740288,p740289,p740290,p740291,p740292,p740293,p740294,p740295,p740296,p740297,p740298,p740299,p740300,p740301,p740302,p740303,p740304,p740305,p740306,p740307,p740308,p740309,p740310,pmax type: range possible_keys: PRIMARY,level_neighbour,level_neighbour_epoch key: PRIMARY key_len: 32 ref: NULL rows: 8619 Extra: Using where; Using index SQL I / AdvisorTimeZoneAlignment / force_primary id: 1 select_type: SIMPLE table: pmc_alert_level_point partitions: plegacy,p20261013,p20261014,p20261015,p20261016,p20261017,p20261018,p20261019,p20261020,p20261021,p20261022,p20261023,p20261024,p20261025,p20261026,p20261027,p20261028,p20261029,p20261030,p740286,p740287,p740288,p740289,p740290,p740291,p740292,p740293,p740294,p740295,p740296,p740297,p740298,p740299,p740300,p740301,p740302,p740303,p740304,p740305,p740306,p740307,p740308,p740309,p740310,pmax type: ref possible_keys: PRIMARY key: PRIMARY key_len: 32 ref: const rows: 8619 Extra: Using where; Using index SQL I / AdvisorTimeZoneAlignment / select_one id: 1 select_type: SIMPLE table: pmc_alert_level_point partitions: plegacy,p20261013,p20261014,p20261015,p20261016,p20261017,p20261018,p20261019,p20261020,p20261021,p20261022,p20261023,p20261024,p20261025,p20261026,p20261027,p20261028,p20261029,p20261030,p740286,p740287,p740288,p740289,p740290,p740291,p740292,p740293,p740294,p740295,p740296,p740297,p740298,p740299,p740300,p740301,p740302,p740303,p740304,p740305,p740306,p740307,p740308,p740309,p740310,pmax type: ref possible_keys: PRIMARY,level_neighbour,level_neighbour_epoch key: level_neighbour key_len: 32 ref: const rows: 5722 Extra: Using where; Using index SQL I / AdvisorTimeZoneAlignment / exists id: 1 select_type: PRIMARY table: NULL partitions: NULL type: NULL possible_keys: NULL key: NULL key_len: NULL ref: NULL rows: NULL Extra: No tables used id: 2 select_type: SUBQUERY table: pmc_alert_level_point partitions: plegacy,p20261013,p20261014,p20261015,p20261016,p20261017,p20261018,p20261019,p20261020,p20261021,p20261022,p20261023,p20261024,p20261025,p20261026,p20261027,p20261028,p20261029,p20261030,p740286,p740287,p740288,p740289,p740290,p740291,p740292,p740293,p740294,p740295,p740296,p740297,p740298,p740299,p740300,p740301,p740302,p740303,p740304,p740305,p740306,p740307,p740308,p740309,p740310,pmax type: ref possible_keys: PRIMARY,level_neighbour,level_neighbour_epoch key: level_neighbour key_len: 32 ref: const rows: 5722 Extra: Using where; Using index SQL I / AdvisorTimeZoneAlignment / watermark_fallback id: 1 select_type: PRIMARY table: NULL partitions: NULL type: NULL possible_keys: NULL key: NULL key_len: NULL ref: NULL rows: NULL Extra: No tables used id: 3 select_type: SUBQUERY table: pmc_alert_level_point partitions: plegacy,p20261013,p20261014,p20261015,p20261016,p20261017,p20261018,p20261019,p20261020,p20261021,p20261022,p20261023,p20261024,p20261025,p20261026,p20261027,p20261028,p20261029,p20261030,p740286,p740287,p740288,p740289,p740290,p740291,p740292,p740293,p740294,p740295,p740296,p740297,p740298,p740299,p740300,p740301,p740302,p740303,p740304,p740305,p740306,p740307,p740308,p740309,p740310,pmax type: ref possible_keys: PRIMARY,level_neighbour,level_neighbour_epoch key: level_neighbour key_len: 32 ref: const rows: 5722 Extra: Using where; Using index id: 2 select_type: SUBQUERY table: w partitions: NULL type: const possible_keys: PRIMARY key: PRIMARY key_len: 32 ref: const rows: 1 Extra: id: 2 select_type: SUBQUERY table: p partitions: plegacy,p20261013,p20261014,p20261015,p20261016,p20261017,p20261018,p20261019,p20261020,p20261021,p20261022,p20261023,p20261024,p20261025,p20261026,p20261027,p20261028,p20261029,p20261030,p740286,p740287,p740288,p740289,p740290,p740291,p740292,p740293,p740294,p740295,p740296,p740297,p740298,p740299,p740300,p740301,p740302,p740303,p740304,p740305,p740306,p740307,p740308,p740309,p740310,pmax type: const possible_keys: PRIMARY,level_neighbour,level_neighbour_epoch key: PRIMARY key_len: 48 ref: const,const,const rows: 1 Extra: Using index SQL I / AdvisorWsrepSstMethod / original id: 1 select_type: SIMPLE table: pmc_alert_level_point partitions: plegacy,p20261013,p20261014,p20261015,p20261016,p20261017,p20261018,p20261019,p20261020,p20261021,p20261022,p20261023,p20261024,p20261025,p20261026,p20261027,p20261028,p20261029,p20261030,p740286,p740287,p740288,p740289,p740290,p740291,p740292,p740293,p740294,p740295,p740296,p740297,p740298,p740299,p740300,p740301,p740302,p740303,p740304,p740305,p740306,p740307,p740308,p740309,p740310,pmax type: ref possible_keys: PRIMARY,level_neighbour,level_neighbour_epoch key: PRIMARY key_len: 32 ref: const rows: 3309 Extra: Using where; Using index SQL I / AdvisorWsrepSstMethod / force_primary id: 1 select_type: SIMPLE table: pmc_alert_level_point partitions: plegacy,p20261013,p20261014,p20261015,p20261016,p20261017,p20261018,p20261019,p20261020,p20261021,p20261022,p20261023,p20261024,p20261025,p20261026,p20261027,p20261028,p20261029,p20261030,p740286,p740287,p740288,p740289,p740290,p740291,p740292,p740293,p740294,p740295,p740296,p740297,p740298,p740299,p740300,p740301,p740302,p740303,p740304,p740305,p740306,p740307,p740308,p740309,p740310,pmax type: ref possible_keys: PRIMARY key: PRIMARY key_len: 32 ref: const rows: 3309 Extra: Using where; Using index SQL I / AdvisorWsrepSstMethod / select_one id: 1 select_type: SIMPLE table: pmc_alert_level_point partitions: plegacy,p20261013,p20261014,p20261015,p20261016,p20261017,p20261018,p20261019,p20261020,p20261021,p20261022,p20261023,p20261024,p20261025,p20261026,p20261027,p20261028,p20261029,p20261030,p740286,p740287,p740288,p740289,p740290,p740291,p740292,p740293,p740294,p740295,p740296,p740297,p740298,p740299,p740300,p740301,p740302,p740303,p740304,p740305,p740306,p740307,p740308,p740309,p740310,pmax type: ref possible_keys: PRIMARY,level_neighbour,level_neighbour_epoch key: PRIMARY key_len: 32 ref: const rows: 3309 Extra: Using where; Using index SQL I / AdvisorWsrepSstMethod / exists id: 1 select_type: PRIMARY table: NULL partitions: NULL type: NULL possible_keys: NULL key: NULL key_len: NULL ref: NULL rows: NULL Extra: No tables used id: 2 select_type: SUBQUERY table: pmc_alert_level_point partitions: plegacy,p20261013,p20261014,p20261015,p20261016,p20261017,p20261018,p20261019,p20261020,p20261021,p20261022,p20261023,p20261024,p20261025,p20261026,p20261027,p20261028,p20261029,p20261030,p740286,p740287,p740288,p740289,p740290,p740291,p740292,p740293,p740294,p740295,p740296,p740297,p740298,p740299,p740300,p740301,p740302,p740303,p740304,p740305,p740306,p740307,p740308,p740309,p740310,pmax type: ref possible_keys: PRIMARY,level_neighbour,level_neighbour_epoch key: PRIMARY key_len: 32 ref: const rows: 3309 Extra: Using where; Using index SQL I / AdvisorWsrepSstMethod / watermark_fallback id: 1 select_type: PRIMARY table: NULL partitions: NULL type: NULL possible_keys: NULL key: NULL key_len: NULL ref: NULL rows: NULL Extra: No tables used id: 3 select_type: SUBQUERY table: pmc_alert_level_point partitions: plegacy,p20261013,p20261014,p20261015,p20261016,p20261017,p20261018,p20261019,p20261020,p20261021,p20261022,p20261023,p20261024,p20261025,p20261026,p20261027,p20261028,p20261029,p20261030,p740286,p740287,p740288,p740289,p740290,p740291,p740292,p740293,p740294,p740295,p740296,p740297,p740298,p740299,p740300,p740301,p740302,p740303,p740304,p740305,p740306,p740307,p740308,p740309,p740310,pmax type: ref possible_keys: PRIMARY,level_neighbour,level_neighbour_epoch key: PRIMARY key_len: 32 ref: const rows: 3309 Extra: Using where; Using index id: 2 select_type: SUBQUERY table: w partitions: NULL type: const possible_keys: PRIMARY key: PRIMARY key_len: 32 ref: const rows: 1 Extra: id: 2 select_type: SUBQUERY table: p partitions: plegacy,p20261013,p20261014,p20261015,p20261016,p20261017,p20261018,p20261019,p20261020,p20261021,p20261022,p20261023,p20261024,p20261025,p20261026,p20261027,p20261028,p20261029,p20261030,p740286,p740287,p740288,p740289,p740290,p740291,p740292,p740293,p740294,p740295,p740296,p740297,p740298,p740299,p740300,p740301,p740302,p740303,p740304,p740305,p740306,p740307,p740308,p740309,p740310,pmax type: const possible_keys: PRIMARY,level_neighbour,level_neighbour_epoch key: PRIMARY key_len: 48 ref: const,const,const rows: 1 Extra: Using index SQL I / AdvisorWsrepSlaveThreads / original id: 1 select_type: SIMPLE table: pmc_alert_level_point partitions: plegacy,p20261013,p20261014,p20261015,p20261016,p20261017,p20261018,p20261019,p20261020,p20261021,p20261022,p20261023,p20261024,p20261025,p20261026,p20261027,p20261028,p20261029,p20261030,p740286,p740287,p740288,p740289,p740290,p740291,p740292,p740293,p740294,p740295,p740296,p740297,p740298,p740299,p740300,p740301,p740302,p740303,p740304,p740305,p740306,p740307,p740308,p740309,p740310,pmax type: ref possible_keys: PRIMARY,level_neighbour,level_neighbour_epoch key: PRIMARY key_len: 32 ref: const rows: 3533 Extra: Using where; Using index SQL I / AdvisorWsrepSlaveThreads / force_primary id: 1 select_type: SIMPLE table: pmc_alert_level_point partitions: plegacy,p20261013,p20261014,p20261015,p20261016,p20261017,p20261018,p20261019,p20261020,p20261021,p20261022,p20261023,p20261024,p20261025,p20261026,p20261027,p20261028,p20261029,p20261030,p740286,p740287,p740288,p740289,p740290,p740291,p740292,p740293,p740294,p740295,p740296,p740297,p740298,p740299,p740300,p740301,p740302,p740303,p740304,p740305,p740306,p740307,p740308,p740309,p740310,pmax type: ref possible_keys: PRIMARY key: PRIMARY key_len: 32 ref: const rows: 3533 Extra: Using where; Using index SQL I / AdvisorWsrepSlaveThreads / select_one id: 1 select_type: SIMPLE table: pmc_alert_level_point partitions: plegacy,p20261013,p20261014,p20261015,p20261016,p20261017,p20261018,p20261019,p20261020,p20261021,p20261022,p20261023,p20261024,p20261025,p20261026,p20261027,p20261028,p20261029,p20261030,p740286,p740287,p740288,p740289,p740290,p740291,p740292,p740293,p740294,p740295,p740296,p740297,p740298,p740299,p740300,p740301,p740302,p740303,p740304,p740305,p740306,p740307,p740308,p740309,p740310,pmax type: ref possible_keys: PRIMARY,level_neighbour,level_neighbour_epoch key: PRIMARY key_len: 32 ref: const rows: 3533 Extra: Using where; Using index SQL I / AdvisorWsrepSlaveThreads / exists id: 1 select_type: PRIMARY table: NULL partitions: NULL type: NULL possible_keys: NULL key: NULL key_len: NULL ref: NULL rows: NULL Extra: No tables used id: 2 select_type: SUBQUERY table: pmc_alert_level_point partitions: plegacy,p20261013,p20261014,p20261015,p20261016,p20261017,p20261018,p20261019,p20261020,p20261021,p20261022,p20261023,p20261024,p20261025,p20261026,p20261027,p20261028,p20261029,p20261030,p740286,p740287,p740288,p740289,p740290,p740291,p740292,p740293,p740294,p740295,p740296,p740297,p740298,p740299,p740300,p740301,p740302,p740303,p740304,p740305,p740306,p740307,p740308,p740309,p740310,pmax type: ref possible_keys: PRIMARY,level_neighbour,level_neighbour_epoch key: PRIMARY key_len: 32 ref: const rows: 3533 Extra: Using where; Using index SQL I / AdvisorWsrepSlaveThreads / watermark_fallback id: 1 select_type: PRIMARY table: NULL partitions: NULL type: NULL possible_keys: NULL key: NULL key_len: NULL ref: NULL rows: NULL Extra: No tables used id: 3 select_type: SUBQUERY table: pmc_alert_level_point partitions: plegacy,p20261013,p20261014,p20261015,p20261016,p20261017,p20261018,p20261019,p20261020,p20261021,p20261022,p20261023,p20261024,p20261025,p20261026,p20261027,p20261028,p20261029,p20261030,p740286,p740287,p740288,p740289,p740290,p740291,p740292,p740293,p740294,p740295,p740296,p740297,p740298,p740299,p740300,p740301,p740302,p740303,p740304,p740305,p740306,p740307,p740308,p740309,p740310,pmax type: ref possible_keys: PRIMARY,level_neighbour,level_neighbour_epoch key: PRIMARY key_len: 32 ref: const rows: 3533 Extra: Using where; Using index id: 2 select_type: SUBQUERY table: w partitions: NULL type: const possible_keys: PRIMARY key: PRIMARY key_len: 32 ref: const rows: 1 Extra: id: 2 select_type: SUBQUERY table: p partitions: plegacy,p20261013,p20261014,p20261015,p20261016,p20261017,p20261018,p20261019,p20261020,p20261021,p20261022,p20261023,p20261024,p20261025,p20261026,p20261027,p20261028,p20261029,p20261030,p740286,p740287,p740288,p740289,p740290,p740291,p740292,p740293,p740294,p740295,p740296,p740297,p740298,p740299,p740300,p740301,p740302,p740303,p740304,p740305,p740306,p740307,p740308,p740309,p740310,pmax type: const possible_keys: PRIMARY,level_neighbour,level_neighbour_epoch key: PRIMARY key_len: 48 ref: const,const,const rows: 1 Extra: Using index SQL I / AdvisorWsrepNodeName / original id: 1 select_type: SIMPLE table: pmc_alert_level_point partitions: plegacy,p20261013,p20261014,p20261015,p20261016,p20261017,p20261018,p20261019,p20261020,p20261021,p20261022,p20261023,p20261024,p20261025,p20261026,p20261027,p20261028,p20261029,p20261030,p740286,p740287,p740288,p740289,p740290,p740291,p740292,p740293,p740294,p740295,p740296,p740297,p740298,p740299,p740300,p740301,p740302,p740303,p740304,p740305,p740306,p740307,p740308,p740309,p740310,pmax type: ref possible_keys: PRIMARY,level_neighbour,level_neighbour_epoch key: PRIMARY key_len: 32 ref: const rows: 3001 Extra: Using where; Using index SQL I / AdvisorWsrepNodeName / force_primary id: 1 select_type: SIMPLE table: pmc_alert_level_point partitions: plegacy,p20261013,p20261014,p20261015,p20261016,p20261017,p20261018,p20261019,p20261020,p20261021,p20261022,p20261023,p20261024,p20261025,p20261026,p20261027,p20261028,p20261029,p20261030,p740286,p740287,p740288,p740289,p740290,p740291,p740292,p740293,p740294,p740295,p740296,p740297,p740298,p740299,p740300,p740301,p740302,p740303,p740304,p740305,p740306,p740307,p740308,p740309,p740310,pmax type: ref possible_keys: PRIMARY key: PRIMARY key_len: 32 ref: const rows: 3001 Extra: Using where; Using index SQL I / AdvisorWsrepNodeName / select_one id: 1 select_type: SIMPLE table: pmc_alert_level_point partitions: plegacy,p20261013,p20261014,p20261015,p20261016,p20261017,p20261018,p20261019,p20261020,p20261021,p20261022,p20261023,p20261024,p20261025,p20261026,p20261027,p20261028,p20261029,p20261030,p740286,p740287,p740288,p740289,p740290,p740291,p740292,p740293,p740294,p740295,p740296,p740297,p740298,p740299,p740300,p740301,p740302,p740303,p740304,p740305,p740306,p740307,p740308,p740309,p740310,pmax type: ref possible_keys: PRIMARY,level_neighbour,level_neighbour_epoch key: PRIMARY key_len: 32 ref: const rows: 3001 Extra: Using where; Using index SQL I / AdvisorWsrepNodeName / exists id: 1 select_type: PRIMARY table: NULL partitions: NULL type: NULL possible_keys: NULL key: NULL key_len: NULL ref: NULL rows: NULL Extra: No tables used id: 2 select_type: SUBQUERY table: pmc_alert_level_point partitions: plegacy,p20261013,p20261014,p20261015,p20261016,p20261017,p20261018,p20261019,p20261020,p20261021,p20261022,p20261023,p20261024,p20261025,p20261026,p20261027,p20261028,p20261029,p20261030,p740286,p740287,p740288,p740289,p740290,p740291,p740292,p740293,p740294,p740295,p740296,p740297,p740298,p740299,p740300,p740301,p740302,p740303,p740304,p740305,p740306,p740307,p740308,p740309,p740310,pmax type: ref possible_keys: PRIMARY,level_neighbour,level_neighbour_epoch key: PRIMARY key_len: 32 ref: const rows: 3001 Extra: Using where; Using index SQL I / AdvisorWsrepNodeName / watermark_fallback id: 1 select_type: PRIMARY table: NULL partitions: NULL type: NULL possible_keys: NULL key: NULL key_len: NULL ref: NULL rows: NULL Extra: No tables used id: 3 select_type: SUBQUERY table: pmc_alert_level_point partitions: plegacy,p20261013,p20261014,p20261015,p20261016,p20261017,p20261018,p20261019,p20261020,p20261021,p20261022,p20261023,p20261024,p20261025,p20261026,p20261027,p20261028,p20261029,p20261030,p740286,p740287,p740288,p740289,p740290,p740291,p740292,p740293,p740294,p740295,p740296,p740297,p740298,p740299,p740300,p740301,p740302,p740303,p740304,p740305,p740306,p740307,p740308,p740309,p740310,pmax type: ref possible_keys: PRIMARY,level_neighbour,level_neighbour_epoch key: PRIMARY key_len: 32 ref: const rows: 3001 Extra: Using where; Using index id: 2 select_type: SUBQUERY table: w partitions: NULL type: const possible_keys: PRIMARY key: PRIMARY key_len: 32 ref: const rows: 1 Extra: id: 2 select_type: SUBQUERY table: p partitions: plegacy,p20261013,p20261014,p20261015,p20261016,p20261017,p20261018,p20261019,p20261020,p20261021,p20261022,p20261023,p20261024,p20261025,p20261026,p20261027,p20261028,p20261029,p20261030,p740286,p740287,p740288,p740289,p740290,p740291,p740292,p740293,p740294,p740295,p740296,p740297,p740298,p740299,p740300,p740301,p740302,p740303,p740304,p740305,p740306,p740307,p740308,p740309,p740310,pmax type: const possible_keys: PRIMARY,level_neighbour,level_neighbour_epoch key: PRIMARY key_len: 48 ref: const,const,const rows: 1 Extra: Using index SQL II / AdvisorPerformanceSchema / original id: 1 select_type: SIMPLE table: pmc_alert_level_point partitions: plegacy,p20261013,p20261014,p20261015,p20261016,p20261017,p20261018,p20261019,p20261020,p20261021,p20261022,p20261023,p20261024,p20261025,p20261026,p20261027,p20261028,p20261029,p20261030,p740286,p740287,p740288,p740289,p740290,p740291,p740292,p740293,p740294,p740295,p740296,p740297,p740298,p740299,p740300,p740301,p740302,p740303,p740304,p740305,p740306,p740307,p740308,p740309,p740310,pmax type: ref possible_keys: PRIMARY,level_neighbour,level_neighbour_epoch key: PRIMARY key_len: 32 ref: const rows: 3061 Extra: Using where; Using index SQL II / AdvisorPerformanceSchema / recent_fallback id: 1 select_type: PRIMARY table: NULL partitions: NULL type: NULL possible_keys: NULL key: NULL key_len: NULL ref: NULL rows: NULL Extra: No tables used id: 3 select_type: SUBQUERY table: pmc_alert_level_point partitions: plegacy,p20261013,p20261014,p20261015,p20261016,p20261017,p20261018,p20261019,p20261020,p20261021,p20261022,p20261023,p20261024,p20261025,p20261026,p20261027,p20261028,p20261029,p20261030,p740286,p740287,p740288,p740289,p740290,p740291,p740292,p740293,p740294,p740295,p740296,p740297,p740298,p740299,p740300,p740301,p740302,p740303,p740304,p740305,p740306,p740307,p740308,p740309,p740310,pmax type: ref possible_keys: PRIMARY,level_neighbour,level_neighbour_epoch key: PRIMARY key_len: 32 ref: const rows: 3061 Extra: Using where; Using index id: 2 select_type: SUBQUERY table: pmc_alert_level_point partitions: p740307 type: ref possible_keys: PRIMARY,level_neighbour,level_neighbour_epoch key: level_neighbour_epoch key_len: 32 ref: const rows: 1 Extra: Using where; Using index SQL II / AdvisorPerformanceSchema / watermark_only id: 1 select_type: SIMPLE table: pmc_alert_observation partitions: NULL type: const possible_keys: PRIMARY key: PRIMARY key_len: 32 ref: const rows: 1 Extra: SQL II / AdvisorTimeZoneAlignment / original id: 1 select_type: SIMPLE table: pmc_alert_level_point partitions: plegacy,p20261013,p20261014,p20261015,p20261016,p20261017,p20261018,p20261019,p20261020,p20261021,p20261022,p20261023,p20261024,p20261025,p20261026,p20261027,p20261028,p20261029,p20261030,p740286,p740287,p740288,p740289,p740290,p740291,p740292,p740293,p740294,p740295,p740296,p740297,p740298,p740299,p740300,p740301,p740302,p740303,p740304,p740305,p740306,p740307,p740308,p740309,p740310,pmax type: range possible_keys: PRIMARY,level_neighbour,level_neighbour_epoch key: PRIMARY key_len: 32 ref: NULL rows: 8605 Extra: Using where; Using index SQL II / AdvisorTimeZoneAlignment / recent_fallback id: 1 select_type: PRIMARY table: NULL partitions: NULL type: NULL possible_keys: NULL key: NULL key_len: NULL ref: NULL rows: NULL Extra: No tables used id: 3 select_type: SUBQUERY table: pmc_alert_level_point partitions: plegacy,p20261013,p20261014,p20261015,p20261016,p20261017,p20261018,p20261019,p20261020,p20261021,p20261022,p20261023,p20261024,p20261025,p20261026,p20261027,p20261028,p20261029,p20261030,p740286,p740287,p740288,p740289,p740290,p740291,p740292,p740293,p740294,p740295,p740296,p740297,p740298,p740299,p740300,p740301,p740302,p740303,p740304,p740305,p740306,p740307,p740308,p740309,p740310,pmax type: ref possible_keys: PRIMARY,level_neighbour,level_neighbour_epoch key: level_neighbour key_len: 32 ref: const rows: 5722 Extra: Using where; Using index id: 2 select_type: SUBQUERY table: pmc_alert_level_point partitions: p740307 type: ref possible_keys: PRIMARY,level_neighbour,level_neighbour_epoch key: level_neighbour_epoch key_len: 32 ref: const rows: 1 Extra: Using where; Using index SQL II / AdvisorTimeZoneAlignment / watermark_only id: 1 select_type: SIMPLE table: pmc_alert_observation partitions: NULL type: const possible_keys: PRIMARY key: PRIMARY key_len: 32 ref: const rows: 1 Extra: SQL II / AdvisorWsrepSstMethod / original id: 1 select_type: SIMPLE table: pmc_alert_level_point partitions: plegacy,p20261013,p20261014,p20261015,p20261016,p20261017,p20261018,p20261019,p20261020,p20261021,p20261022,p20261023,p20261024,p20261025,p20261026,p20261027,p20261028,p20261029,p20261030,p740286,p740287,p740288,p740289,p740290,p740291,p740292,p740293,p740294,p740295,p740296,p740297,p740298,p740299,p740300,p740301,p740302,p740303,p740304,p740305,p740306,p740307,p740308,p740309,p740310,pmax type: ref possible_keys: PRIMARY,level_neighbour,level_neighbour_epoch key: PRIMARY key_len: 32 ref: const rows: 3316 Extra: Using where; Using index SQL II / AdvisorWsrepSstMethod / recent_fallback id: 1 select_type: PRIMARY table: NULL partitions: NULL type: NULL possible_keys: NULL key: NULL key_len: NULL ref: NULL rows: NULL Extra: No tables used id: 3 select_type: SUBQUERY table: pmc_alert_level_point partitions: plegacy,p20261013,p20261014,p20261015,p20261016,p20261017,p20261018,p20261019,p20261020,p20261021,p20261022,p20261023,p20261024,p20261025,p20261026,p20261027,p20261028,p20261029,p20261030,p740286,p740287,p740288,p740289,p740290,p740291,p740292,p740293,p740294,p740295,p740296,p740297,p740298,p740299,p740300,p740301,p740302,p740303,p740304,p740305,p740306,p740307,p740308,p740309,p740310,pmax type: ref possible_keys: PRIMARY,level_neighbour,level_neighbour_epoch key: PRIMARY key_len: 32 ref: const rows: 3316 Extra: Using where; Using index id: 2 select_type: SUBQUERY table: pmc_alert_level_point partitions: p740307 type: ref possible_keys: PRIMARY,level_neighbour,level_neighbour_epoch key: level_neighbour key_len: 32 ref: const rows: 1 Extra: Using where; Using index SQL II / AdvisorWsrepSstMethod / watermark_only id: 1 select_type: SIMPLE table: pmc_alert_observation partitions: NULL type: const possible_keys: PRIMARY key: PRIMARY key_len: 32 ref: const rows: 1 Extra: SQL II / AdvisorWsrepSlaveThreads / original id: 1 select_type: SIMPLE table: pmc_alert_level_point partitions: plegacy,p20261013,p20261014,p20261015,p20261016,p20261017,p20261018,p20261019,p20261020,p20261021,p20261022,p20261023,p20261024,p20261025,p20261026,p20261027,p20261028,p20261029,p20261030,p740286,p740287,p740288,p740289,p740290,p740291,p740292,p740293,p740294,p740295,p740296,p740297,p740298,p740299,p740300,p740301,p740302,p740303,p740304,p740305,p740306,p740307,p740308,p740309,p740310,pmax type: ref possible_keys: PRIMARY,level_neighbour,level_neighbour_epoch key: PRIMARY key_len: 32 ref: const rows: 3540 Extra: Using where; Using index SQL II / AdvisorWsrepSlaveThreads / recent_fallback id: 1 select_type: PRIMARY table: NULL partitions: NULL type: NULL possible_keys: NULL key: NULL key_len: NULL ref: NULL rows: NULL Extra: No tables used id: 3 select_type: SUBQUERY table: pmc_alert_level_point partitions: plegacy,p20261013,p20261014,p20261015,p20261016,p20261017,p20261018,p20261019,p20261020,p20261021,p20261022,p20261023,p20261024,p20261025,p20261026,p20261027,p20261028,p20261029,p20261030,p740286,p740287,p740288,p740289,p740290,p740291,p740292,p740293,p740294,p740295,p740296,p740297,p740298,p740299,p740300,p740301,p740302,p740303,p740304,p740305,p740306,p740307,p740308,p740309,p740310,pmax type: ref possible_keys: PRIMARY,level_neighbour,level_neighbour_epoch key: PRIMARY key_len: 32 ref: const rows: 3540 Extra: Using where; Using index id: 2 select_type: SUBQUERY table: pmc_alert_level_point partitions: p740307 type: ref possible_keys: PRIMARY,level_neighbour,level_neighbour_epoch key: level_neighbour key_len: 32 ref: const rows: 1 Extra: Using where; Using index SQL II / AdvisorWsrepSlaveThreads / watermark_only id: 1 select_type: SIMPLE table: pmc_alert_observation partitions: NULL type: const possible_keys: PRIMARY key: PRIMARY key_len: 32 ref: const rows: 1 Extra: SQL II / AdvisorWsrepNodeName / original id: 1 select_type: SIMPLE table: pmc_alert_level_point partitions: plegacy,p20261013,p20261014,p20261015,p20261016,p20261017,p20261018,p20261019,p20261020,p20261021,p20261022,p20261023,p20261024,p20261025,p20261026,p20261027,p20261028,p20261029,p20261030,p740286,p740287,p740288,p740289,p740290,p740291,p740292,p740293,p740294,p740295,p740296,p740297,p740298,p740299,p740300,p740301,p740302,p740303,p740304,p740305,p740306,p740307,p740308,p740309,p740310,pmax type: ref possible_keys: PRIMARY,level_neighbour,level_neighbour_epoch key: PRIMARY key_len: 32 ref: const rows: 3001 Extra: Using where; Using index SQL II / AdvisorWsrepNodeName / recent_fallback id: 1 select_type: PRIMARY table: NULL partitions: NULL type: NULL possible_keys: NULL key: NULL key_len: NULL ref: NULL rows: NULL Extra: No tables used id: 3 select_type: SUBQUERY table: pmc_alert_level_point partitions: plegacy,p20261013,p20261014,p20261015,p20261016,p20261017,p20261018,p20261019,p20261020,p20261021,p20261022,p20261023,p20261024,p20261025,p20261026,p20261027,p20261028,p20261029,p20261030,p740286,p740287,p740288,p740289,p740290,p740291,p740292,p740293,p740294,p740295,p740296,p740297,p740298,p740299,p740300,p740301,p740302,p740303,p740304,p740305,p740306,p740307,p740308,p740309,p740310,pmax type: ref possible_keys: PRIMARY,level_neighbour,level_neighbour_epoch key: PRIMARY key_len: 32 ref: const rows: 3001 Extra: Using where; Using index id: 2 select_type: SUBQUERY table: pmc_alert_level_point partitions: p740307 type: ref possible_keys: PRIMARY,level_neighbour,level_neighbour_epoch key: level_neighbour key_len: 32 ref: const rows: 1 Extra: Using where; Using index SQL II / AdvisorWsrepNodeName / watermark_only id: 1 select_type: SIMPLE table: pmc_alert_observation partitions: NULL type: const possible_keys: PRIMARY key: PRIMARY key_len: 32 ref: const rows: 1 Extra: MyRocks · 571957 / AdvisorPerformanceSchema / reference id: 1 select_type: SIMPLE table: pmc_alert_level_point partitions: plegacy,p20261013,p20261014,p20261015,p20261016,p20261017,p20261018,p20261019,p20261020,p20261021,p20261022,p20261023,p20261024,p20261025,p20261026,p20261027,p20261028,p20261029,p20261030,p740286,p740287,p740288,p740289,p740290,p740291,p740292,p740293,p740294,p740295,p740296,p740297,p740298,p740299,p740300,p740301,p740302,p740303,p740304,p740305,p740306,p740307,p740308,p740309,p740310,pmax type: range possible_keys: PRIMARY,level_neighbour,level_neighbour_epoch key: PRIMARY key_len: 32 ref: NULL rows: 6098 Extra: Using where; Using index MyRocks · 571957 / AdvisorPerformanceSchema / temporal_auto id: 1 select_type: SIMPLE table: time_candidate partitions: plegacy,p20261013,p20261014,p20261015,p20261016,p20261017,p20261018,p20261019,p20261020,p20261021,p20261022,p20261023,p20261024,p20261025,p20261026,p20261027,p20261028,p20261029,p20261030,p740286,p740287,p740288,p740289,p740290,p740291,p740292,p740293,p740294,p740295,p740296,p740297,p740298,p740299,p740300,p740301,p740302,p740303,p740304,p740305,p740306,p740307,p740308,p740309,p740310,pmax type: ref possible_keys: PRIMARY,level_neighbour,level_neighbour_epoch key: PRIMARY key_len: 32 ref: const rows: 5134 Extra: Using where; Using index MyRocks · 571957 / AdvisorPerformanceSchema / temporal_force id: 1 select_type: SIMPLE table: time_candidate partitions: plegacy,p20261013,p20261014,p20261015,p20261016,p20261017,p20261018,p20261019,p20261020,p20261021,p20261022,p20261023,p20261024,p20261025,p20261026,p20261027,p20261028,p20261029,p20261030,p740286,p740287,p740288,p740289,p740290,p740291,p740292,p740293,p740294,p740295,p740296,p740297,p740298,p740299,p740300,p740301,p740302,p740303,p740304,p740305,p740306,p740307,p740308,p740309,p740310,pmax type: index possible_keys: NULL key: when_observed key_len: 16 ref: NULL rows: 1 Extra: Using where; Using index MyRocks · 571957 / AdvisorTimeZoneAlignment / reference id: 1 select_type: SIMPLE table: pmc_alert_level_point partitions: plegacy,p20261013,p20261014,p20261015,p20261016,p20261017,p20261018,p20261019,p20261020,p20261021,p20261022,p20261023,p20261024,p20261025,p20261026,p20261027,p20261028,p20261029,p20261030,p740286,p740287,p740288,p740289,p740290,p740291,p740292,p740293,p740294,p740295,p740296,p740297,p740298,p740299,p740300,p740301,p740302,p740303,p740304,p740305,p740306,p740307,p740308,p740309,p740310,pmax type: range possible_keys: PRIMARY,level_neighbour,level_neighbour_epoch key: PRIMARY key_len: 32 ref: NULL rows: 6533 Extra: Using where; Using index MyRocks · 571957 / AdvisorTimeZoneAlignment / temporal_auto id: 1 select_type: SIMPLE table: time_candidate partitions: plegacy,p20261013,p20261014,p20261015,p20261016,p20261017,p20261018,p20261019,p20261020,p20261021,p20261022,p20261023,p20261024,p20261025,p20261026,p20261027,p20261028,p20261029,p20261030,p740286,p740287,p740288,p740289,p740290,p740291,p740292,p740293,p740294,p740295,p740296,p740297,p740298,p740299,p740300,p740301,p740302,p740303,p740304,p740305,p740306,p740307,p740308,p740309,p740310,pmax type: ref possible_keys: PRIMARY,level_neighbour,level_neighbour_epoch key: PRIMARY key_len: 32 ref: const rows: 4185 Extra: Using where; Using index MyRocks · 571957 / AdvisorTimeZoneAlignment / temporal_force id: 1 select_type: SIMPLE table: time_candidate partitions: plegacy,p20261013,p20261014,p20261015,p20261016,p20261017,p20261018,p20261019,p20261020,p20261021,p20261022,p20261023,p20261024,p20261025,p20261026,p20261027,p20261028,p20261029,p20261030,p740286,p740287,p740288,p740289,p740290,p740291,p740292,p740293,p740294,p740295,p740296,p740297,p740298,p740299,p740300,p740301,p740302,p740303,p740304,p740305,p740306,p740307,p740308,p740309,p740310,pmax type: index possible_keys: NULL key: when_observed key_len: 16 ref: NULL rows: 1 Extra: Using where; Using index MyRocks · 571957 / AdvisorWsrepSstMethod / reference id: 1 select_type: SIMPLE table: pmc_alert_level_point partitions: plegacy,p20261013,p20261014,p20261015,p20261016,p20261017,p20261018,p20261019,p20261020,p20261021,p20261022,p20261023,p20261024,p20261025,p20261026,p20261027,p20261028,p20261029,p20261030,p740286,p740287,p740288,p740289,p740290,p740291,p740292,p740293,p740294,p740295,p740296,p740297,p740298,p740299,p740300,p740301,p740302,p740303,p740304,p740305,p740306,p740307,p740308,p740309,p740310,pmax type: range possible_keys: PRIMARY,level_neighbour,level_neighbour_epoch key: PRIMARY key_len: 32 ref: NULL rows: 235342 Extra: Using where; Using index MyRocks · 571957 / AdvisorWsrepSstMethod / temporal_auto id: 1 select_type: SIMPLE table: time_candidate partitions: plegacy,p20261013,p20261014,p20261015,p20261016,p20261017,p20261018,p20261019,p20261020,p20261021,p20261022,p20261023,p20261024,p20261025,p20261026,p20261027,p20261028,p20261029,p20261030,p740286,p740287,p740288,p740289,p740290,p740291,p740292,p740293,p740294,p740295,p740296,p740297,p740298,p740299,p740300,p740301,p740302,p740303,p740304,p740305,p740306,p740307,p740308,p740309,p740310,pmax type: range possible_keys: PRIMARY,level_neighbour,level_neighbour_epoch key: PRIMARY key_len: 32 ref: NULL rows: 11304 Extra: Using where; Using index MyRocks · 571957 / AdvisorWsrepSstMethod / temporal_force id: 1 select_type: SIMPLE table: time_candidate partitions: plegacy,p20261013,p20261014,p20261015,p20261016,p20261017,p20261018,p20261019,p20261020,p20261021,p20261022,p20261023,p20261024,p20261025,p20261026,p20261027,p20261028,p20261029,p20261030,p740286,p740287,p740288,p740289,p740290,p740291,p740292,p740293,p740294,p740295,p740296,p740297,p740298,p740299,p740300,p740301,p740302,p740303,p740304,p740305,p740306,p740307,p740308,p740309,p740310,pmax type: index possible_keys: NULL key: when_observed key_len: 16 ref: NULL rows: 1 Extra: Using where; Using index MyRocks · 571957 / AdvisorWsrepSlaveThreads / reference id: 1 select_type: SIMPLE table: pmc_alert_level_point partitions: plegacy,p20261013,p20261014,p20261015,p20261016,p20261017,p20261018,p20261019,p20261020,p20261021,p20261022,p20261023,p20261024,p20261025,p20261026,p20261027,p20261028,p20261029,p20261030,p740286,p740287,p740288,p740289,p740290,p740291,p740292,p740293,p740294,p740295,p740296,p740297,p740298,p740299,p740300,p740301,p740302,p740303,p740304,p740305,p740306,p740307,p740308,p740309,p740310,pmax type: range possible_keys: PRIMARY,level_neighbour,level_neighbour_epoch key: PRIMARY key_len: 32 ref: NULL rows: 5485 Extra: Using where; Using index MyRocks · 571957 / AdvisorWsrepSlaveThreads / temporal_auto id: 1 select_type: SIMPLE table: time_candidate partitions: plegacy,p20261013,p20261014,p20261015,p20261016,p20261017,p20261018,p20261019,p20261020,p20261021,p20261022,p20261023,p20261024,p20261025,p20261026,p20261027,p20261028,p20261029,p20261030,p740286,p740287,p740288,p740289,p740290,p740291,p740292,p740293,p740294,p740295,p740296,p740297,p740298,p740299,p740300,p740301,p740302,p740303,p740304,p740305,p740306,p740307,p740308,p740309,p740310,pmax type: range possible_keys: PRIMARY,level_neighbour,level_neighbour_epoch key: PRIMARY key_len: 32 ref: NULL rows: 6306 Extra: Using where; Using index MyRocks · 571957 / AdvisorWsrepSlaveThreads / temporal_force id: 1 select_type: SIMPLE table: time_candidate partitions: plegacy,p20261013,p20261014,p20261015,p20261016,p20261017,p20261018,p20261019,p20261020,p20261021,p20261022,p20261023,p20261024,p20261025,p20261026,p20261027,p20261028,p20261029,p20261030,p740286,p740287,p740288,p740289,p740290,p740291,p740292,p740293,p740294,p740295,p740296,p740297,p740298,p740299,p740300,p740301,p740302,p740303,p740304,p740305,p740306,p740307,p740308,p740309,p740310,pmax type: index possible_keys: NULL key: when_observed key_len: 16 ref: NULL rows: 1 Extra: Using where; Using index MyRocks · 571957 / AdvisorWsrepNodeName / reference id: 1 select_type: SIMPLE table: pmc_alert_level_point partitions: plegacy,p20261013,p20261014,p20261015,p20261016,p20261017,p20261018,p20261019,p20261020,p20261021,p20261022,p20261023,p20261024,p20261025,p20261026,p20261027,p20261028,p20261029,p20261030,p740286,p740287,p740288,p740289,p740290,p740291,p740292,p740293,p740294,p740295,p740296,p740297,p740298,p740299,p740300,p740301,p740302,p740303,p740304,p740305,p740306,p740307,p740308,p740309,p740310,pmax type: range possible_keys: PRIMARY,level_neighbour,level_neighbour_epoch key: PRIMARY key_len: 32 ref: NULL rows: 6540 Extra: Using where; Using index MyRocks · 571957 / AdvisorWsrepNodeName / temporal_auto id: 1 select_type: SIMPLE table: time_candidate partitions: plegacy,p20261013,p20261014,p20261015,p20261016,p20261017,p20261018,p20261019,p20261020,p20261021,p20261022,p20261023,p20261024,p20261025,p20261026,p20261027,p20261028,p20261029,p20261030,p740286,p740287,p740288,p740289,p740290,p740291,p740292,p740293,p740294,p740295,p740296,p740297,p740298,p740299,p740300,p740301,p740302,p740303,p740304,p740305,p740306,p740307,p740308,p740309,p740310,pmax type: range possible_keys: PRIMARY,level_neighbour,level_neighbour_epoch key: PRIMARY key_len: 32 ref: NULL rows: 6541 Extra: Using where; Using index MyRocks · 571957 / AdvisorWsrepNodeName / temporal_force id: 1 select_type: SIMPLE table: time_candidate partitions: plegacy,p20261013,p20261014,p20261015,p20261016,p20261017,p20261018,p20261019,p20261020,p20261021,p20261022,p20261023,p20261024,p20261025,p20261026,p20261027,p20261028,p20261029,p20261030,p740286,p740287,p740288,p740289,p740290,p740291,p740292,p740293,p740294,p740295,p740296,p740297,p740298,p740299,p740300,p740301,p740302,p740303,p740304,p740305,p740306,p740307,p740308,p740309,p740310,pmax type: index possible_keys: NULL key: when_observed key_len: 16 ref: NULL rows: 1 Extra: Using where; Using index MyRocks · 621865 / AdvisorPerformanceSchema / reference id: 1 select_type: SIMPLE table: pmc_alert_level_point partitions: plegacy,p20261013,p20261014,p20261015,p20261016,p20261017,p20261018,p20261019,p20261020,p20261021,p20261022,p20261023,p20261024,p20261025,p20261026,p20261027,p20261028,p20261029,p20261030,p740286,p740287,p740288,p740289,p740290,p740291,p740292,p740293,p740294,p740295,p740296,p740297,p740298,p740299,p740300,p740301,p740302,p740303,p740304,p740305,p740306,p740307,p740308,p740309,p740310,pmax type: range possible_keys: PRIMARY,level_neighbour,level_neighbour_epoch key: PRIMARY key_len: 32 ref: NULL rows: 5544 Extra: Using where; Using index MyRocks · 621865 / AdvisorPerformanceSchema / temporal_auto id: 1 select_type: SIMPLE table: time_candidate partitions: plegacy,p20261013,p20261014,p20261015,p20261016,p20261017,p20261018,p20261019,p20261020,p20261021,p20261022,p20261023,p20261024,p20261025,p20261026,p20261027,p20261028,p20261029,p20261030,p740286,p740287,p740288,p740289,p740290,p740291,p740292,p740293,p740294,p740295,p740296,p740297,p740298,p740299,p740300,p740301,p740302,p740303,p740304,p740305,p740306,p740307,p740308,p740309,p740310,pmax type: range possible_keys: PRIMARY,level_neighbour,level_neighbour_epoch key: PRIMARY key_len: 32 ref: NULL rows: 5638 Extra: Using where; Using index MyRocks · 621865 / AdvisorPerformanceSchema / temporal_force id: 1 select_type: SIMPLE table: time_candidate partitions: plegacy,p20261013,p20261014,p20261015,p20261016,p20261017,p20261018,p20261019,p20261020,p20261021,p20261022,p20261023,p20261024,p20261025,p20261026,p20261027,p20261028,p20261029,p20261030,p740286,p740287,p740288,p740289,p740290,p740291,p740292,p740293,p740294,p740295,p740296,p740297,p740298,p740299,p740300,p740301,p740302,p740303,p740304,p740305,p740306,p740307,p740308,p740309,p740310,pmax type: index possible_keys: NULL key: when_observed key_len: 16 ref: NULL rows: 1 Extra: Using where; Using index MyRocks · 621865 / AdvisorPerformanceSchema / flat id: 1 select_type: SIMPLE table: layout_flat partitions: NULL type: range possible_keys: PRIMARY,level_neighbour,level_neighbour_epoch key: PRIMARY key_len: 32 ref: NULL rows: 7472 Extra: Using where; Using index MyRocks · 621865 / AdvisorPerformanceSchema / by_fp id: 1 select_type: SIMPLE table: layout_by_fp partitions: p15 type: range possible_keys: PRIMARY,level_neighbour,level_neighbour_epoch key: PRIMARY key_len: 32 ref: NULL rows: 8222 Extra: Using where; Using index MyRocks · 621865 / AdvisorTimeZoneAlignment / reference id: 1 select_type: SIMPLE table: pmc_alert_level_point partitions: plegacy,p20261013,p20261014,p20261015,p20261016,p20261017,p20261018,p20261019,p20261020,p20261021,p20261022,p20261023,p20261024,p20261025,p20261026,p20261027,p20261028,p20261029,p20261030,p740286,p740287,p740288,p740289,p740290,p740291,p740292,p740293,p740294,p740295,p740296,p740297,p740298,p740299,p740300,p740301,p740302,p740303,p740304,p740305,p740306,p740307,p740308,p740309,p740310,pmax type: range possible_keys: PRIMARY,level_neighbour,level_neighbour_epoch key: PRIMARY key_len: 32 ref: NULL rows: 57018 Extra: Using where; Using index MyRocks · 621865 / AdvisorTimeZoneAlignment / temporal_auto id: 1 select_type: SIMPLE table: time_candidate partitions: plegacy,p20261013,p20261014,p20261015,p20261016,p20261017,p20261018,p20261019,p20261020,p20261021,p20261022,p20261023,p20261024,p20261025,p20261026,p20261027,p20261028,p20261029,p20261030,p740286,p740287,p740288,p740289,p740290,p740291,p740292,p740293,p740294,p740295,p740296,p740297,p740298,p740299,p740300,p740301,p740302,p740303,p740304,p740305,p740306,p740307,p740308,p740309,p740310,pmax type: range possible_keys: PRIMARY,level_neighbour,level_neighbour_epoch key: PRIMARY key_len: 32 ref: NULL rows: 56712 Extra: Using where; Using index MyRocks · 621865 / AdvisorTimeZoneAlignment / temporal_force id: 1 select_type: SIMPLE table: time_candidate partitions: plegacy,p20261013,p20261014,p20261015,p20261016,p20261017,p20261018,p20261019,p20261020,p20261021,p20261022,p20261023,p20261024,p20261025,p20261026,p20261027,p20261028,p20261029,p20261030,p740286,p740287,p740288,p740289,p740290,p740291,p740292,p740293,p740294,p740295,p740296,p740297,p740298,p740299,p740300,p740301,p740302,p740303,p740304,p740305,p740306,p740307,p740308,p740309,p740310,pmax type: index possible_keys: NULL key: when_observed key_len: 16 ref: NULL rows: 1 Extra: Using where; Using index MyRocks · 621865 / AdvisorTimeZoneAlignment / flat id: 1 select_type: SIMPLE table: layout_flat partitions: NULL type: range possible_keys: PRIMARY,level_neighbour,level_neighbour_epoch key: PRIMARY key_len: 32 ref: NULL rows: 6452 Extra: Using where; Using index MyRocks · 621865 / AdvisorTimeZoneAlignment / by_fp id: 1 select_type: SIMPLE table: layout_by_fp partitions: p4 type: ref possible_keys: PRIMARY,level_neighbour,level_neighbour_epoch key: PRIMARY key_len: 32 ref: const rows: 7299 Extra: Using where; Using index MyRocks · 621865 / AdvisorWsrepSstMethod / reference id: 1 select_type: SIMPLE table: pmc_alert_level_point partitions: plegacy,p20261013,p20261014,p20261015,p20261016,p20261017,p20261018,p20261019,p20261020,p20261021,p20261022,p20261023,p20261024,p20261025,p20261026,p20261027,p20261028,p20261029,p20261030,p740286,p740287,p740288,p740289,p740290,p740291,p740292,p740293,p740294,p740295,p740296,p740297,p740298,p740299,p740300,p740301,p740302,p740303,p740304,p740305,p740306,p740307,p740308,p740309,p740310,pmax type: range possible_keys: PRIMARY,level_neighbour,level_neighbour_epoch key: PRIMARY key_len: 32 ref: NULL rows: 5820 Extra: Using where; Using index MyRocks · 621865 / AdvisorWsrepSstMethod / temporal_auto id: 1 select_type: SIMPLE table: time_candidate partitions: plegacy,p20261013,p20261014,p20261015,p20261016,p20261017,p20261018,p20261019,p20261020,p20261021,p20261022,p20261023,p20261024,p20261025,p20261026,p20261027,p20261028,p20261029,p20261030,p740286,p740287,p740288,p740289,p740290,p740291,p740292,p740293,p740294,p740295,p740296,p740297,p740298,p740299,p740300,p740301,p740302,p740303,p740304,p740305,p740306,p740307,p740308,p740309,p740310,pmax type: range possible_keys: PRIMARY,level_neighbour,level_neighbour_epoch key: PRIMARY key_len: 32 ref: NULL rows: 5894 Extra: Using where; Using index MyRocks · 621865 / AdvisorWsrepSstMethod / temporal_force id: 1 select_type: SIMPLE table: time_candidate partitions: plegacy,p20261013,p20261014,p20261015,p20261016,p20261017,p20261018,p20261019,p20261020,p20261021,p20261022,p20261023,p20261024,p20261025,p20261026,p20261027,p20261028,p20261029,p20261030,p740286,p740287,p740288,p740289,p740290,p740291,p740292,p740293,p740294,p740295,p740296,p740297,p740298,p740299,p740300,p740301,p740302,p740303,p740304,p740305,p740306,p740307,p740308,p740309,p740310,pmax type: index possible_keys: NULL key: when_observed key_len: 16 ref: NULL rows: 1 Extra: Using where; Using index MyRocks · 621865 / AdvisorWsrepSstMethod / flat id: 1 select_type: SIMPLE table: layout_flat partitions: NULL type: range possible_keys: PRIMARY,level_neighbour,level_neighbour_epoch key: PRIMARY key_len: 32 ref: NULL rows: 6042 Extra: Using where; Using index MyRocks · 621865 / AdvisorWsrepSstMethod / by_fp id: 1 select_type: SIMPLE table: layout_by_fp partitions: p5 type: ref possible_keys: PRIMARY,level_neighbour,level_neighbour_epoch key: PRIMARY key_len: 32 ref: const rows: 2532 Extra: Using where; Using index MyRocks · 621865 / AdvisorWsrepSlaveThreads / reference id: 1 select_type: SIMPLE table: pmc_alert_level_point partitions: plegacy,p20261013,p20261014,p20261015,p20261016,p20261017,p20261018,p20261019,p20261020,p20261021,p20261022,p20261023,p20261024,p20261025,p20261026,p20261027,p20261028,p20261029,p20261030,p740286,p740287,p740288,p740289,p740290,p740291,p740292,p740293,p740294,p740295,p740296,p740297,p740298,p740299,p740300,p740301,p740302,p740303,p740304,p740305,p740306,p740307,p740308,p740309,p740310,pmax type: range possible_keys: PRIMARY,level_neighbour,level_neighbour_epoch key: PRIMARY key_len: 32 ref: NULL rows: 5694 Extra: Using where; Using index MyRocks · 621865 / AdvisorWsrepSlaveThreads / temporal_auto id: 1 select_type: SIMPLE table: time_candidate partitions: plegacy,p20261013,p20261014,p20261015,p20261016,p20261017,p20261018,p20261019,p20261020,p20261021,p20261022,p20261023,p20261024,p20261025,p20261026,p20261027,p20261028,p20261029,p20261030,p740286,p740287,p740288,p740289,p740290,p740291,p740292,p740293,p740294,p740295,p740296,p740297,p740298,p740299,p740300,p740301,p740302,p740303,p740304,p740305,p740306,p740307,p740308,p740309,p740310,pmax type: range possible_keys: PRIMARY,level_neighbour,level_neighbour_epoch key: PRIMARY key_len: 32 ref: NULL rows: 5931 Extra: Using where; Using index MyRocks · 621865 / AdvisorWsrepSlaveThreads / temporal_force id: 1 select_type: SIMPLE table: time_candidate partitions: plegacy,p20261013,p20261014,p20261015,p20261016,p20261017,p20261018,p20261019,p20261020,p20261021,p20261022,p20261023,p20261024,p20261025,p20261026,p20261027,p20261028,p20261029,p20261030,p740286,p740287,p740288,p740289,p740290,p740291,p740292,p740293,p740294,p740295,p740296,p740297,p740298,p740299,p740300,p740301,p740302,p740303,p740304,p740305,p740306,p740307,p740308,p740309,p740310,pmax type: index possible_keys: NULL key: when_observed key_len: 16 ref: NULL rows: 1 Extra: Using where; Using index MyRocks · 621865 / AdvisorWsrepSlaveThreads / flat id: 1 select_type: SIMPLE table: layout_flat partitions: NULL type: range possible_keys: PRIMARY,level_neighbour,level_neighbour_epoch key: PRIMARY key_len: 32 ref: NULL rows: 17298 Extra: Using where; Using index MyRocks · 621865 / AdvisorWsrepSlaveThreads / by_fp id: 1 select_type: SIMPLE table: layout_by_fp partitions: p1 type: range possible_keys: PRIMARY,level_neighbour,level_neighbour_epoch key: PRIMARY key_len: 32 ref: NULL rows: 7498 Extra: Using where; Using index MyRocks · 621865 / AdvisorWsrepNodeName / reference id: 1 select_type: SIMPLE table: pmc_alert_level_point partitions: plegacy,p20261013,p20261014,p20261015,p20261016,p20261017,p20261018,p20261019,p20261020,p20261021,p20261022,p20261023,p20261024,p20261025,p20261026,p20261027,p20261028,p20261029,p20261030,p740286,p740287,p740288,p740289,p740290,p740291,p740292,p740293,p740294,p740295,p740296,p740297,p740298,p740299,p740300,p740301,p740302,p740303,p740304,p740305,p740306,p740307,p740308,p740309,p740310,pmax type: range possible_keys: PRIMARY,level_neighbour,level_neighbour_epoch key: PRIMARY key_len: 32 ref: NULL rows: 5787 Extra: Using where; Using index MyRocks · 621865 / AdvisorWsrepNodeName / temporal_auto id: 1 select_type: SIMPLE table: time_candidate partitions: plegacy,p20261013,p20261014,p20261015,p20261016,p20261017,p20261018,p20261019,p20261020,p20261021,p20261022,p20261023,p20261024,p20261025,p20261026,p20261027,p20261028,p20261029,p20261030,p740286,p740287,p740288,p740289,p740290,p740291,p740292,p740293,p740294,p740295,p740296,p740297,p740298,p740299,p740300,p740301,p740302,p740303,p740304,p740305,p740306,p740307,p740308,p740309,p740310,pmax type: range possible_keys: PRIMARY,level_neighbour,level_neighbour_epoch key: PRIMARY key_len: 32 ref: NULL rows: 5915 Extra: Using where; Using index MyRocks · 621865 / AdvisorWsrepNodeName / temporal_force id: 1 select_type: SIMPLE table: time_candidate partitions: plegacy,p20261013,p20261014,p20261015,p20261016,p20261017,p20261018,p20261019,p20261020,p20261021,p20261022,p20261023,p20261024,p20261025,p20261026,p20261027,p20261028,p20261029,p20261030,p740286,p740287,p740288,p740289,p740290,p740291,p740292,p740293,p740294,p740295,p740296,p740297,p740298,p740299,p740300,p740301,p740302,p740303,p740304,p740305,p740306,p740307,p740308,p740309,p740310,pmax type: index possible_keys: NULL key: when_observed key_len: 16 ref: NULL rows: 1 Extra: Using where; Using index MyRocks · 621865 / AdvisorWsrepNodeName / flat id: 1 select_type: SIMPLE table: layout_flat partitions: NULL type: range possible_keys: PRIMARY,level_neighbour,level_neighbour_epoch key: PRIMARY key_len: 32 ref: NULL rows: 7046 Extra: Using where; Using index MyRocks · 621865 / AdvisorWsrepNodeName / by_fp id: 1 select_type: SIMPLE table: layout_by_fp partitions: p5 type: range possible_keys: PRIMARY,level_neighbour,level_neighbour_epoch key: PRIMARY key_len: 32 ref: NULL rows: 8092 Extra: Using where; Using index