debugging queries from psql
debugging queries from psql
От:
Rajesh Kumar Mallah <mallah@trade-india.com>
Дата:
Greeting, i have 2 identical queries. One of that finish faast another takes ages. there are couble of trigers that run on update. I want to know where exactly the sencond query takes time. is there any way to increase debug logging from the psql prompt so that i can see whats going behind? Regds Mallah. tradein_clients=# UPDATE users set last_visit=now() WHERE userid= 34866; UPDATE 1 Time: 436.591 ms tradein_clients=# UPDATE users set last_visit=now() WHERE userid= 72643; Time: Takes ages