Was alerted to an old query lying around in the pg_stat_activity view on a little used server recently. It ha no values for wait_event_type or wait_event and had an idle state value. The query_start value was about two weeks old. Odd, but after verifying it had no pg_lock lookup, I canceled it.
Might there be an infrequent staleness of items that appear in the pg_stat_activity view that is just understood to be there from time to time?
