From: Justin Pryzby <pryzby@telsasoft.com>
To: Clemens Eisserer <linuxhippy@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: speeding up grafana sensor-data query on raspberry pi 3
Date: Sun, 16 Apr 2023 12:15:11 -0500
Message-ID: <ZDwtHyMicQ3+6AxE@telsasoft.com> (raw)
In-Reply-To: <CAFvQSYR_kaOm8xQjzXUWiUSvYmEXiShvDBimVNZTUtN-3W3TLg@mail.gmail.com>
References: <CAFvQSYR_kaOm8xQjzXUWiUSvYmEXiShvDBimVNZTUtN-3W3TLg@mail.gmail.com>
On Sun, Apr 16, 2023 at 07:00:33PM +0200, Clemens Eisserer wrote:
> Hi,
>
> I am currently trying to migrate an influxdb 1.7 smarthome database to
> postgresql (13.9) running on my raspberry 3.
> It works quite well, but for the queries executed by grafana I get a
> bit highter execution times than I'd hoped for.
Suggestions:
- enable track_io_timing and show explain (analyze,buffers,settings)
- or otherwise show your non-default settings;
- show \d of your table(s)
- show the query plan for the 6 months query . The query plan may be
different, or (if you can run it with "analyze") it may be
illuminating to see how the query "scales".
- consider trying postgres 15 (btw, v16 will have a beta release next
month)
https://wiki.postgresql.org/wiki/Slow_Query_Questions
--
Justin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: pryzby@telsasoft.com, linuxhippy@gmail.com
Subject: Re: speeding up grafana sensor-data query on raspberry pi 3
In-Reply-To: <ZDwtHyMicQ3+6AxE@telsasoft.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox