Pgsql DB User Function fix (find who's calling it)
Budget: €30 – €250 EUR
I'm having issues with a specific user function in my Pgsql ( postgresql 8.4) database that needs fixing.
After transferring server and DB from real PC to the VM, all works except new server doesn't show statistics.
We found the problem source (most possibly) is stats update function in DB.
Found by adding "track_functions = pl" to /etc/postgresql/8.4/main/postgresql.conf
So old server has:
datacenter_new=# SELECT * FROM pg_stat_user_functions;
funcid | schemaname | funcname | calls | total_time | self_time
----------+------------+-----------------------+-------+------------+----------- 32645236 | ADMIN | _get_news_url | 44 | 43244836 | ADMIN | _util_update_stat_new | 27 | 1365 | 1365
32645239 | ADMIN | _util_update_stat | 27 | 37511 | 37511
calls
And new doesn't have any calls of _util_update_stat at all which makes Stats table empty
You need to track why is this happening & fix it.
Server is a bunch of perl.pl scripts, but seems it doesn't matter cause all scripts just READ this stats table (i guess)
Pgsql expirience is a must Perl expirience is a plus.
Plz no "manager" bids, don't waste your time, will talk with developers only. (if you are a "manager" it will be seen after the 2nd tech question Plz don't waste OUR time!!!!)
Thank you!
After transferring server and DB from real PC to the VM, all works except new server doesn't show statistics.
We found the problem source (most possibly) is stats update function in DB.
Found by adding "track_functions = pl" to /etc/postgresql/8.4/main/postgresql.conf
So old server has:
datacenter_new=# SELECT * FROM pg_stat_user_functions;
funcid | schemaname | funcname | calls | total_time | self_time
----------+------------+-----------------------+-------+------------+----------- 32645236 | ADMIN | _get_news_url | 44 | 43244836 | ADMIN | _util_update_stat_new | 27 | 1365 | 1365
32645239 | ADMIN | _util_update_stat | 27 | 37511 | 37511
calls
And new doesn't have any calls of _util_update_stat at all which makes Stats table empty
You need to track why is this happening & fix it.
Server is a bunch of perl.pl scripts, but seems it doesn't matter cause all scripts just READ this stats table (i guess)
Pgsql expirience is a must Perl expirience is a plus.
Plz no "manager" bids, don't waste your time, will talk with developers only. (if you are a "manager" it will be seen after the 2nd tech question Plz don't waste OUR time!!!!)
Thank you!