[PERFORM] how to know slowly query in lock postgre

hai friend i have problem with performance database in postgre, how to know slowly query in postgre, i want kill or stop query to make postgre slowly, on the server status on the admin pg, sometimes the query and how long the query runs do not appear Thanks for solution

[PERFORM] i want to ask monitory peformance memory postgresql with automatically

Hi friend I Want to ask, is there any solutions or tools for monitoring memory performance in postgre automatically, for example, will send allert if Peformance memory has exceeded 90% thank you for your help

[PERFORM] partition query on multiple cores

I have 8-core server, I wanted to ask whether a query can be divided for multiple processors or cores, if it could be what to do in postgresql Thanks

[PERFORM] ask the database engine tuning on the server

I had a problem with performance engine database, I use the server with the following specifications 1. its storage configuration? Storage SCSI 15K RAID 5 2. how his network? 2 gigabit bonding. 3. type / behavior of applications that connect to the db? Direct connects one s