Peeking into the Black Hole Called PL/PGSQL - the New PL Profiler / Jan Wieck (OpenSCG)
Приглашаем на конференцию HighLoad 2024, которая пройдет 2 и 3 декабря в Москве!
Программа, подробности и билеты по ссылке:
--------
Презентация и тезисы:
The new PL profiler allows you to easily get through the dark barrier, PL/pgSQL puts between tools like pgbadger and the queries, you are looking for. Query and schema tuning is tough enough by itself. But queries, buried many call levels deep in PL/pgSQL functions, make it torture. The reason is that the default monitoring tools like logs, pg_stat_activity and pg_stat_statements cannot penetrate into PL/pgSQL. All they report is that your query calling function X is slow. That is useful if function X has 20 lines of simple code. Not so useful if it calls other functions and the actual problem query is many call levels down in a dungeon of 100,000 lines of PL code. Learn from the original author of PL/pgSQL and current maintainer of the plprofiler extension how you can easily analyze, what is going on inside your PL code.
2 views
136
29
4 weeks ago 00:13:48 1
[Rotten Tomatoes] Jake Johnson Wanted to Get Weird with Nic Cage | ’Spider-Man: Into the Spider-Verse’ Interview
4 weeks ago 00:39:33 1
[Movieclips] ’Hacks’ Creators Lucia Aniello & Paul W. Downs Break Down Season 3
4 weeks ago 00:00:41 2
[Sports Illustrated Swimsuit] Watch This Brooks Nader Photo Shoot Montage
4 weeks ago 00:01:51 3
[CNBC Television] Gap plans to split into two independent public companies
4 weeks ago 00:03:09 5
[CNBC Television] Here’s how investing in home equity works
4 weeks ago 00:01:00 1
[Ghost Ship Games] DarkSwarm - Fall ’24 Teaser
1 month ago 00:02:43 2
[CG5] HENRY STICKMIN SONG ▶ “I’ma Walk Right In“ (Stealing the Diamond) | CG5
1 month ago 00:04:20 2
[CNBC Television] Wedbush’s Dan Ives on Apple’s iPhone demand issues
1 month ago 00:05:22 2
[CNBC Television] Stocks see some gains after sell-off
1 month ago 06:00:30 10
[SoundExpanse] 💧🌹🌿 Relaxing Rain on Ceramic Jars | No Midroll Ads | ASMR Raindrop Bliss | Fall Asleep Fast | 6 Hrs
1 month ago 00:02:48 3
[CNBC Television] Expect a strong close for retail season, industry veteran says
1 month ago 00:02:36 14
[Asmongold Clips] This is f**king insane..
1 month ago 00:01:30 7
[GameTrailers] Bye Sweet Carole - Official Midnight Trailer | The Indie Horror Showcase 2024
1 month ago 00:00:30 1.2K
[EverQuest 2] Sneak peek into Scars of Destruction
2 months ago 00:15:00 16
[JudeLow] OG traps vs new gen players
2 months ago 00:04:38 1
Starbomb - Kiss The Elden Ring (Official Music Video)
2 months ago 00:02:10 1
Based On A True Story Season 2 Trailer
2 months ago 00:16:41 1
We REVIEWED Every KNOCKOUT Luxury Car in Floyd Mayweather’s PRESTIGIOUS Collection
2 months ago 00:05:58 1
Inside Dove Cameron’s Balmain Shoulder Bag | In The Bag
2 months ago 00:02:29 1
Nobody Saves The World - Official Gameplay Overview Trailer
2 months ago 00:07:13 1
DIE ANTWOORD - BANANA BRAIN (Official Video)
2 months ago 00:30:54 1
The Shark - The Most META Zerg Base in 2022 - Rust Base Tutorial 4K
2 months ago 00:46:39 2
Peeking into the Black Hole Called PL/PGSQL - the New PL Profiler / Jan Wieck (OpenSCG)