MariaDB · EXPLAIN PARTITIONS · 2026-11-21 latest / exact: replay at 2026-11-21 22:29:19.000000 previous / next: append at 2026-11-22 22:29:19.000000 EXPLAIN PARTITIONS SELECT observed_at FROM pmc_alert_level_point WHERE fingerprint = UNHEX(?) ORDER BY observed_epoch DESC, observed_at DESC LIMIT 1; EXPLAIN PARTITIONS SELECT is_open FROM pmc_alert_level_point WHERE fingerprint = UNHEX(?) AND observed_epoch = 1795296559 AND observed_at = '2026-11-21 22:29:19.000000'; AdvisorPerformanceSchema / latest 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: 3058 Extra: Using where; Using index AdvisorPerformanceSchema / exact id: 1 select_type: SIMPLE table: pmc_alert_level_point partitions: p740307 type: const possible_keys: PRIMARY,level_neighbour,level_neighbour_epoch key: PRIMARY key_len: 48 ref: const,const,const rows: 1 Extra: AdvisorPerformanceSchema / previous 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: 48 ref: NULL rows: 3094 Extra: Using where AdvisorPerformanceSchema / next 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: 48 ref: NULL rows: 81 Extra: Using where AdvisorTimeZoneAlignment / latest 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: 8617 Extra: Using where; Using index AdvisorTimeZoneAlignment / exact id: 1 select_type: SIMPLE table: pmc_alert_level_point partitions: p740307 type: const possible_keys: PRIMARY,level_neighbour,level_neighbour_epoch key: PRIMARY key_len: 48 ref: const,const,const rows: 1 Extra: AdvisorTimeZoneAlignment / previous 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: 48 ref: NULL rows: 8653 Extra: Using where AdvisorTimeZoneAlignment / next 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: 48 ref: NULL rows: 81 Extra: Using where AdvisorWsrepSstMethod / latest 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: 3314 Extra: Using where; Using index AdvisorWsrepSstMethod / exact id: 1 select_type: SIMPLE table: pmc_alert_level_point partitions: p740307 type: const possible_keys: PRIMARY,level_neighbour,level_neighbour_epoch key: PRIMARY key_len: 48 ref: const,const,const rows: 1 Extra: AdvisorWsrepSstMethod / previous 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: 48 ref: NULL rows: 3350 Extra: Using where AdvisorWsrepSstMethod / next 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: 48 ref: NULL rows: 81 Extra: Using where AdvisorWsrepSlaveThreads / latest 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: 3539 Extra: Using where; Using index AdvisorWsrepSlaveThreads / exact id: 1 select_type: SIMPLE table: pmc_alert_level_point partitions: p740307 type: const possible_keys: PRIMARY,level_neighbour,level_neighbour_epoch key: PRIMARY key_len: 48 ref: const,const,const rows: 1 Extra: AdvisorWsrepSlaveThreads / previous 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: 48 ref: NULL rows: 3575 Extra: Using where AdvisorWsrepSlaveThreads / next 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: 48 ref: NULL rows: 81 Extra: Using where AdvisorWsrepNodeName / latest 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: 2998 Extra: Using where; Using index AdvisorWsrepNodeName / exact id: 1 select_type: SIMPLE table: pmc_alert_level_point partitions: p740307 type: const possible_keys: PRIMARY,level_neighbour,level_neighbour_epoch key: PRIMARY key_len: 48 ref: const,const,const rows: 1 Extra: AdvisorWsrepNodeName / previous 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: 48 ref: NULL rows: 3034 Extra: Using where AdvisorWsrepNodeName / next 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: 48 ref: NULL rows: 81 Extra: Using where