search

NikolayS / postgres_dba

The missing set of useful tools for Postgres DBAs and all engineers
BSD 3-Clause "New" or "Revised" License
1.03k stars 113 forks source link

s1 problem, needs conditional for the order by #59

Closed KiriakosGeorgiou closed 2 years ago

KiriakosGeorgiou commented 2 years ago

s1 gives the following error on a v12 server:

LINE 31: order by sum(total_exec_time) desc

needs conditional to use total_time

NikolayS commented 2 years ago

@KiriakosGeorgiou thank you! fixed in https://github.com/NikolayS/postgres_dba/commit/a8654686a664a4f1fc1d5b09b9114eee465cfdc5. Please check.