Technologies/Trino/trino.input.bytes.one_minute
TrinoTrinoMetric

trino.input.bytes.one_minute

Input bytes last minute
Dimensions:None
Available on:DatadogDatadog (1)
Interface Metrics (1)
DatadogDatadog
Total input data size processed in the last minute
Dimensions:None
Sources
trino.input.data_size.one_minute.countdocs.datadoghq.com

Technical Annotations (23)

Configuration Parameters (15)
query.max-scan-physical-bytes
maximum bytes a query can scan before termination
hive.pushdown-filter-enabledrecommended: true
Enables filter pushdown to Hive connector to reduce data transfer
hive.projection-pushdown-enabledrecommended: true
Enables projection pushdown to Hive connector for column pruning
delta.projection-pushdown-enabledrecommended: true
Enables projection pushdown for Delta Lake tables
delta.predicate-pushdown-enabledrecommended: true
Enables predicate pushdown for Delta Lake tables
hive.orc.use-column-namesrecommended: true
Enables column name-based ORC reading for better column pruning
parquet.optimized-reader.enabledrecommended: true
Enables optimized Parquet reader for better columnar access
delta.parquet.optimized-reader.enabledrecommended: true
Enables optimized Parquet reader for Delta Lake tables
hive.parquet.optimized-reader.enabledrecommended: true
Session-level Parquet optimization
hive.parquet.predicate-pushdown.enabledrecommended: true
Pushes predicates to Parquet reader for early filtering
enable-dynamic-filteringrecommended: true
Enables dynamic filtering for partition pruning (Trino 330+)
enable_dynamic_filteringrecommended: true
Session-level dynamic filtering configuration
dynamic_filtering_max_per_driver_row_countrecommended: 2000
Maximum rows per driver for dynamic filtering
dynamic_filtering_max_per_driver_sizerecommended: 1MB
Maximum size per driver for dynamic filtering
query.max-write-physical-size
No default set; configure to prevent excessive writes
CLI Commands (1)
EXPLAIN ANALYZE <query>diagnostic
Technical References (7)
HASH partitioningconceptLocalExchangecomponentTableScancomponentORCcomponentParquetcomponentdynamic filteringconceptpartition pruningconcept
Related Insights (7)
High per-task input standard deviation indicates data skewwarning
▸
Physical input size exceeding logical input indicates storage format inefficiencyinfo
▸
Query exceeds scan byte limitwarning
▸
Connector pushdown disabled causes excessive network data transferwarning
▸
Wide table scans without columnar optimization cause I/O bottlenecksinfo
▸
Poor partitioning schemes create massive I/O overhead for analytical querieswarning
▸
Runaway queries terminated at scan or write limitswarning
▸