I am using Risingwave version 0.1.16.
SELECT * FROM pg_stat_activity ; doesn't give any expected output even when a query is executed in another terminal.
Login into the machine using the below command:
psql "postgres://dev:[email protected]:4566/dev?options=--tenant%3Drwc-6-releasetenant"
After that, create the record:
CREATE TABLE testtable AS SELECT generate_series(1, 10000000,1);
Now to get the pid of the running query run the below query on the same machine from a different terminal (make sure you execute it before the execution of the above query is complete).
SELECT * FROM pg_stat_activity ;
pg_stat_activity should have returned the pid and other information of the running query
unsupported function: "pg_teminate_backend"
This is a typo
IIUC #7274 only provides a dummy implementation for
pg_stat_activity, and functions like
pg_terminate_backend (cc @yezizp2012 & it might be better if the behavior can be stated more clearly in the discription 😇). You could take a look at the code, which is very simple.
This is a typo
Thanks for supplying feat(binder): hint similar candidates when function is unknown. I think catching typos and minor issues early will be a great improvement 👍
Currently In order to integrate some other ecological tools and implement some psql commands, we have several dummy implementation of system tables/functions including
pg_terminate_backend. It's not that easy to fully support activity-related functions in the current architecture, especially under multi-frontend deployment. Need more design and let's keep it to record.