io.trino.connector.system.RuleStatsSystemTable Maven / Gradle / Ivy

Go to download
Show more of this group Show more artifacts with this name
Show all versions of trino-main Show documentation
Trino - Engine
There is a newer version: 465
/*
 * Licensed under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 *
 *     http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 */
package io.trino.connector.system;

import com.google.common.collect.ImmutableList;
import com.google.inject.Inject;
import io.trino.spi.Page;
import io.trino.spi.block.Block;
import io.trino.spi.block.BlockBuilder;
import io.trino.spi.block.MapBlockBuilder;
import io.trino.spi.connector.ColumnMetadata;
import io.trino.spi.connector.ConnectorPageSource;
import io.trino.spi.connector.ConnectorSession;
import io.trino.spi.connector.ConnectorTableMetadata;
import io.trino.spi.connector.ConnectorTransactionHandle;
import io.trino.spi.connector.FixedPageSource;
import io.trino.spi.connector.SchemaTableName;
import io.trino.spi.connector.SystemTable;
import io.trino.spi.predicate.TupleDomain;
import io.trino.spi.type.TypeManager;
import io.trino.sql.planner.RuleStatsRecorder;
import io.trino.sql.planner.iterative.RuleStats;

import java.util.Map;
import java.util.Optional;

import static com.google.common.base.Preconditions.checkState;
import static com.google.common.collect.ImmutableMap.toImmutableMap;
import static io.trino.metadata.MetadataUtil.TableMetadataBuilder.tableMetadataBuilder;
import static io.trino.spi.connector.SystemTable.Distribution.SINGLE_COORDINATOR;
import static io.trino.spi.type.BigintType.BIGINT;
import static io.trino.spi.type.DoubleType.DOUBLE;
import static io.trino.spi.type.TypeSignature.mapType;
import static io.trino.spi.type.VarcharType.VARCHAR;
import static java.util.Objects.requireNonNull;

public class RuleStatsSystemTable
        implements SystemTable
{
    private static final SchemaTableName TABLE_NAME = new SchemaTableName("runtime", "optimizer_rule_stats");
    private final ConnectorTableMetadata ruleStatsTable;
    private final Optional ruleStatsRecorder;

    @Inject
    public RuleStatsSystemTable(Optional ruleStatsRecorder, TypeManager typeManager)
    {
        this.ruleStatsRecorder = requireNonNull(ruleStatsRecorder, "ruleStatsRecorder is null");
        requireNonNull(typeManager, "typeManager is null");

        this.ruleStatsTable = tableMetadataBuilder(TABLE_NAME)
                .column("rule_name", VARCHAR)
                .column("invocations", BIGINT)
                .column("matches", BIGINT)
                .column("failures", BIGINT)
                .column("average_time", DOUBLE)
                .column("time_distribution_percentiles", typeManager.getType(mapType(DOUBLE.getTypeSignature(), DOUBLE.getTypeSignature())))
                .build();
    }

    @Override
    public Distribution getDistribution()
    {
        return SINGLE_COORDINATOR;
    }

    @Override
    public ConnectorTableMetadata getTableMetadata()
    {
        return ruleStatsTable;
    }

    @Override
    public ConnectorPageSource pageSource(ConnectorTransactionHandle transactionHandle, ConnectorSession session, TupleDomain constraint)
    {
        checkState(ruleStatsRecorder.isPresent(), "Rule stats system table can return results only on coordinator");
        Map, RuleStats> ruleStats = ruleStatsRecorder.get().getStats();

        int positionCount = ruleStats.size();
        Map blockBuilders = ruleStatsTable.getColumns().stream()
                .collect(toImmutableMap(ColumnMetadata::getName, column -> column.getType().createBlockBuilder(null, positionCount)));

        for (Map.Entry, RuleStats> entry : ruleStats.entrySet()) {
            RuleStats stats = entry.getValue();

            VARCHAR.writeString(blockBuilders.get("rule_name"), entry.getKey().getSimpleName());
            BIGINT.writeLong(blockBuilders.get("invocations"), stats.getInvocations());
            BIGINT.writeLong(blockBuilders.get("matches"), stats.getHits());
            BIGINT.writeLong(blockBuilders.get("failures"), stats.getFailures());
            DOUBLE.writeDouble(blockBuilders.get("average_time"), stats.getTime().getAvg());

            MapBlockBuilder blockBuilder = (MapBlockBuilder) blockBuilders.get("time_distribution_percentiles");
            blockBuilder.buildEntry((keyBuilder, valueBuilder) -> {
                stats.getTime().getPercentiles().forEach((key, value) -> {
                    DOUBLE.writeDouble(keyBuilder, key);
                    DOUBLE.writeDouble(valueBuilder, value);
                });
            });
        }

        Block[] blocks = ruleStatsTable.getColumns().stream()
                .map(column -> blockBuilders.get(column.getName()).build())
                .toArray(Block[]::new);

        return new FixedPageSource(ImmutableList.of(new Page(positionCount, blocks)));
    }
}