-- 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
