Why is pg_stat_activity.query_start null for almost all queries? What is the meaning of a NULL query_start field?

closed as unclear what you're asking by Vérace, Max Vernon, Marco, John Eisbrener, Tom V Apr 17 at 19:14

Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.

  • If you can see results once, then you have permissions! We need more depth to this question - what problem are you having and trying to solve? – Vérace Apr 16 at 17:58
  • @Vérace I want to see the long running queries, but the query_start fields are almost all null. Do you know under which conditions they are null? – Josh Apr 16 at 19:23
  • So, show us what you are doing! You run SELECT * FROM pg_stat_activity.query_start; - yes? And you get results? Show them to us - in the form of text - not screenshots. I'm afraid that I can't answer your question about the conditions under which they are null - what does the documentation (normally very good) say? – Vérace Apr 16 at 19:27
  • I do select * from pg_stat_activity and I see query_start is almost always null... – Josh Apr 16 at 19:29
  • Yes, I understand, but as I said, what does the documentation say? – Vérace Apr 16 at 19:30

The only meaning I know of for a NULL query_start field is that no query has ever been started on that connection.

  • Thanks, that's a lot more helpful than Verace pretending it's confusing and putting it on hold because he doesn't know the answer. – Josh Apr 17 at 22:49

Not the answer you're looking for? Browse other questions tagged or ask your own question.