SHOW TAG VALUES Performance vs Select

I want to create variables in grafana and I am querying influxdb to get the values the issue so, I would like to know which stresses the servers less when ran on a big data set:

  • SHOW TAG VALUES FROM ‘measurement’ WITH KEY=tag WHERE ‘condition’
  • SELECT ‘tag’ FROM(SELECT ‘tag’, ‘metric’ FROM measurement WHERE ‘condition’)

Currently I am using SHOW TAG VALUES, but the tick stack admin advised me against it saying that it consumes much more resources than the SELECT query. I would like to have more insight into this.

Thank you.

1 Like

can anyone help me with this?