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
