Large negative interval in query_plan_profiles
I am looking at query_plan_profile - finding place where query spent most time.
It appears, there are quite a few rather large values for runtime_interval column, slightly bigger than -10957 days. You can see them right here:
where running_time is not null
and running_time < '-10000'::interval;
Rest of values looks OK, either NULL or small interval like it should be.
Can you ask around, what is wrong with runtime_interval in query_plan_profiles. I am on v 12.0.4.
I resorted to
case when running_time < '-100'::interval then running_time + '10957'::interval else running_time end running_time,
that seems to be working.