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
