Sergey_Cherepan_1
✭✭✭
Sergey_Cherepan_1 ✭✭✭
Reactions
-
Re: What's the meaning of LOCAL ROUND ROBIN in the execution plan?
When you need more than one thread per node, after global resegment optimiser can do local resegment or local round robin. Local round robin is used when optimiser decided that local resegment will w… (View Post)1 -
Re: What's the meaning of LOCAL ROUND ROBIN in the execution plan?
Without local resegment, it will be single threaded per node. You can look in execution_engine_profiles. Each instance of operator will publish set of counters. For example "execution time (us)&… (View Post)2 -
Re: Query to find slowest node
That is a great idea! Vertica already have a bunch of stats on all queries in dc_query_executions, we can go against all queries: with /*+ ENABLE_WITH_CLAUSE_MATERIALIZATION*/ node_steps as (select e… (View Post)1 -
Re: System table table_statistics is missing column "table_schema"
For reference, this is SQL to show tables with invalidated and not collected statistics: select t.table_schema, t.table_name, ps.row_cnt as table_row_count, case when ls.row_count = 1 then 'Invalidat… (View Post)1 -
Re: Can I remove some data from immutable table without leaving a trace
You can stop advancing AHM in several ways - shutdown node, special database parameters, or using undocumented functions. Though rollback to AHM it is not needed, immutable table really prevent only … (View Post)-4