Have anyone taken the “Terminating a Long Query” part of the SQL for Data Analysis course?
I’m having a trouble with this part with the 2 last questions especially.
I’m trying to identify the process ID of the sleep query with the following code:
select pid, query from pg_stat_activity where state = 'active'; but it’s doesn’t look it’s working out.
Do you have any ideas?
Also, I tried the 3rd questions which is ask us to force the sleep command using the pg_terminate_background, but I can not make it neither:
It said that there is no functions matches the giver and name argument…
I hope you could give me a clue!!
Thanks a lot!!