CODEWITHSUNDEEP
sqldatabase-administrationvertica
James W.
James W.

Reputation: 3055

Vertica query performance tuning

Lets say you have a slow query, what is the chronological order of the steps you will take to solve the problem ?

vnetperf / vioperf / vcpuperf

EXPLAIN / EXPLAIN LOCAL VERBOSE / PROFILE

EXECUTION_ENGINE_PROFILES / QUERY_EVENTS / DC_QUERY_EXECUTIONS / EXECUTION_ENGINE_PROFILES / DC_SIPS_STATISTICS / QUERY_PLAN_PROFILES / RESOURCE_ALLOCATION / PROJECTION_USAGE / PROJECTIONS_COLUMN / PROJECTIONS_STORAGE

Upvotes: 0

Views: 731

Answers (2)

victtim
victtim

Reputation: 840

Try using Vertical Database Designer.

It may suggest a projection optimal for your query.

Upvotes: 0

IgorB
IgorB

Reputation: 126

as a 1 step look at the query and query plan see if you have stale statistics or unnecessary network resegments, check if your projections match your queries. also check recorded session from last year BDC it kinda helpfull : vertica query tuning

Upvotes: 1

Related Questions