How to know if PG_TIMETABLE is running ?

[msisolucoes]

How to know if PG_TIMETABLE is running ?

[pashagolub]

How about

ps -A | grep pg_timetable

[msisolucoes]

Hi,

Thank you very much for your answer, but I think I expressed myself, I will rephrase.
I wonder if there is a form by command SQL, example:
select timetable.isrunning;
Thank you.

[pashagolub]

Ah, you mean from the database point of view :) Sorry.

Well the most obvious would be to check the special table. You can read about this in my blog post.

SELECT * FROM timetable.active_session;

You can, of course, check special PostgreSQL view, in case you are using outdated pg_timetable (I hope you're not :-)

SELECT * FROM pg_stat_activity WHERE datname = 'mydatabasename';

Kind regards!