Hi,
I haven’t caught the issue yet with this debug etc. in place, but auto_explain
(and some pg_stat_statements poking about) has helped me find something
interesting that might(?) be related.
My data ingest is in 2 functions, depending on the type of data:
- RADIUS data with usage info
-
On Wed, Jul 13, 2022 at 03:13:46AM +1200, Nathan Ward wrote:
> I have been stepping through the various statements which are different
> between the two functions, and note that when I do math on a timestamp in a
> SELECT statement (i.e. _event_timestamp - INTERVAL ‘1 hour’),
> the planner takes