Split query and show in table

Hi,

I’m using grafana for querying data into influxdb and show into a table.

I have a problem whit this because my query returns a lot of information and this does that mi filters and user interactions are bad.

I think that if I split my queries results or table I can to optimize my dashboard, but I’m not sure how i can do this…

thanks for the help

Hi,

I’m using grafana for querying data into influxdb and show into a table.

You’re using Grafana to query data into InfluxDB??

That sounds most strange - please give more details of how this is configured.

I have a problem whit this because my query returns a lot of information
and this does that mi filters and user interactions are bad.

I cannot understand what you are saying here.

Your query “returns a lot of information” - in what way is that a bad thing?

As for “this does that mi filters and user interactions are bad”, I’m afraid I
have no idea what this means - please try to express this some other way.

I think that if I split my queries results or table I can to optimize my
dashboard, but I’m not sure how i can do this…

Well, for a start:

  1. Tell us what your existing queries are.

  2. Tell us exactly what problems these are causing.

  3. Give us an idea regarding what the original data for these queries is (I’m
    guessing that this is in InfluxDB, but if not, please also tell us what the
    back-end data source is).

  4. You talk about “optimising your dashboard” - what do you mean by
    “optimise”? What problem are you trying to solve?

If you can give us enough information to understand and potentially
replicate your situation, then we might be able to help - otherwise we can
only guess at what’s going on and what you’re trying to do, and that helps
neither you nor us.

Regards,

Antony,

Sorry, I will try to explain me better.

I have a DB in influxdb stored with just one measure.
This measure has 10 millions of registers and 12 fields.
When running a query with simple select with the 12 fields and some filters, the dashboard break; I think that this happens because the query bright a lot of information, and the page is automatically stoped.

so I think that I can fix this splitting the information from influxdb.

for example:

if I running the query and the query bright 1 million of registers y want to show just 100.000 registers in a table and when I will click the next page, de dashboard run the query again and show the next 100.000 registers.

Sorry, I will try to explain me better.

Thank you.

I have a DB in influxdb stored with just one measure.
This measure has 10 millions of registers and 12 fields.
When running a query with simple select with the 12 fields and some
filters, the dashboard break; I think that this happens because the query
bright a lot of information, and the page is automatically stoped.

So:

  1. Tell us what your existing queries are.

  2. What filters are you applying?

  3. What do you mean by “the dashboard break”? What exactly do you see
    happening?

  4. You say “I think that this happens because the query bright a lot of
    information” - what does Grafana’s Query Inspector tell you is happening?

As I already said…

If you can give us enough information to understand and potentially
replicate your situation, then we might be able to help - otherwise we can
only guess at what’s going on and what you’re trying to do, and that helps
neither you nor us.

Regards,

Antony.