Pgsql DB User Function fix (find who's calling it)

Imekamilika Ilichapishwa wiki 2 zilizopita Kulipwa wakati wa kujifungua

€30-250 EUR

Kulipwa wakati wa kujifungua

Imekamilika Kulipwa wakati wa kujifungua

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/[login to view URL]

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 [login to view URL] 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!

p.s. max budget is 100.

Perl Linux PostgreSQL

Kitambulisho cha Mradi: #38046025

Kuhusu mradi

15 mapendekezo Mradi wa mbali Ipo mtandaoni %project.latestActivity_relativeTime|badilisha%

Unapania kutengeneza pesa?

Faida za kutoa zabuni kwenye Freelancer

Weka bajeti yako na muda
Lipwa kwa kazi yako
Onyesha ombi lako
Ni bure kujisajili na kuweka zabuni kwa kazi

Imetuzwa kwa:

Picha ya Profaili ya usuf001
usuf001

Hi there, i have experience in pgsql and Linux administration. I can check why stats are not being enabled in your new server for pgsql. Need root login details to troubleshoot the problem. Thank you

€48 EUR kwa siku 1
(Maoni 176)
6.7

15 wafanyakazi huru wanazabuni wastani wa €142 kwa kazi hii

Picha ya Profaili ya MRARIFAKRAM
MRARIFAKRAM

My name is Muhammad Abdullah, an experienced IT professional with a strong grasp on Linux, making me well-versed in PostgreSQL. Given your project's specific need of fixing a user function and rectifying statistics iss Zaidi

€100 EUR kwa siku 1
(Maoni 86)
6.0
Picha ya Profaili ya swamyvaditya
swamyvaditya

Dear sir, I'm knowledgeable in PostgreSql, and Perl programming language. I can help to fix the issue is related to the pg_stat_user_functions view not showing any calls for the _util_update_stat function on the new s Zaidi

€165 EUR kwa siku 7
(Maoni 9)
4.9
Picha ya Profaili ya gustavoguanilo
gustavoguanilo

As an expert in PostgreSQL and Linux, I am confident in my ability to address the issues you're experiencing with your Pgsql user function. With a strong background in database management and optimization, I am well-ve Zaidi

€100 EUR kwa siku 1
(Maoni 3)
4.8
Picha ya Profaili ya techplusintl
techplusintl

Hi there, ★★★ Database Design & Development Expert ★★★ 7+ Years of Experience ★★★ I've read requirements and ready to work on your project. I have completed multiple projects across various domains like Manufacturing, Zaidi

€100 EUR kwa siku 1
(Maoni 7)
5.0
Picha ya Profaili ya tanette
tanette

Hello, I have experience of developing management system of custom Linux using perl with PostgreSQL. I can help you to resolve your issue. With six years of experience in Linux and network engineering, I believe I will Zaidi

€100 EUR kwa siku 7
(Maoni 1)
1.4
Picha ya Profaili ya pivendev
pivendev

I have many years of experience on Perl, Linux, PostgreSQL

€120 EUR kwa siku 3
(Maoni 0)
0.0
Picha ya Profaili ya paul396
paul396

Hello, PostgreSQL Expert HERE~ I want to hear from you soon. Best Paul

€200 EUR kwa siku 7
(Maoni 0)
0.0
Picha ya Profaili ya nelson832
nelson832

★★★ Hi, there ★★★ I understand what exactly you need and I can start work on the spot. I'm a professional fullstack developer who has great experience in the PostgreSQL and MySQL fields. I can handle your task in no ti Zaidi

€100 EUR kwa siku 3
(Maoni 0)
0.0
Picha ya Profaili ya mannnupatel
mannnupatel

I have more than 14 years of IT experience with various database technologies. Working Knowledge of Oralce,postgres Databases. Strong experience in Oracle to postgres migration Strong Oralce Development Skills worki Zaidi

€277.78 EUR kwa siku 20
(Maoni 0)
0.0
Picha ya Profaili ya aseaudi
aseaudi

Experience in postgres and perl 15+ years experience in IT, Networks, and Software Development Cisco CCIE R&S, IP/MPLS, VOIP, IPTV, SDN/NFV, LTE/5G Core Networks Python, C/C++, Golang, Erlang, Java, DevOPs, GitlabCI, Zaidi

€100 EUR kwa siku 7
(Maoni 0)
0.0
Tuma Mradi Kama huu