Understand PostgreSQL query plan in 10 minutes

  Рет қаралды 40,410

Lift And Shift Dev

Lift And Shift Dev

3 жыл бұрын

In this video, I share with you how i read Postgres query plan. This skill is super useful when you develop API to retrieve or mutate data in database. By understanding the query plan, you can optimise your query to run efficiently. It is a must have skill for any back-end software engineer, not just DBA
#postgres #queryplan #liftandshiftdev #postgresql #backend #database #sql
Medium blog: / how-to-read-postgresql...
Support the channel: paypal.me/liftandshiftdev

Пікірлер: 20
@Shubh22
@Shubh22 2 жыл бұрын
Nice explanation. But the voice quality could have been better.
@Antnix732
@Antnix732 2 жыл бұрын
much more clear now, great explanation, thank you!
@pjvm0
@pjvm0 Жыл бұрын
Thank you for sharing. Nice and straightforward explanation! 👏🏻
@ihateregistrating3494
@ihateregistrating3494 2 ай бұрын
thanks, much clear than most tutorials
@liftandshiftdev3222
@liftandshiftdev3222 2 ай бұрын
thank you. Im thinking about posting more videos this year with better audio quality. Stay tuned for more content
@Truncator
@Truncator 2 жыл бұрын
Great explanation. Thank you!
@jagadeeshdora5987
@jagadeeshdora5987 3 жыл бұрын
Thanks for the video. Please add more videos on PostgreSQL development advanced concepts as well.
@liftandshiftdev3222
@liftandshiftdev3222 3 жыл бұрын
Sure I will
@CodeCruncher8
@CodeCruncher8 9 ай бұрын
Great explanation. Thanks!
@newsnetworkz
@newsnetworkz 2 жыл бұрын
Very useful, thanks
@vivekkashyaps5926
@vivekkashyaps5926 3 жыл бұрын
well explained!
@nikhilbadyal
@nikhilbadyal 2 жыл бұрын
Great video. 😄
@acalabash
@acalabash Жыл бұрын
As postgres docs propose, nothing stops you from doing a live EXPLAIN (EXPLAIN ANALYZE, that is) even with mutational commands on a production DB as long as you rollback afterwards
@artisingh9165
@artisingh9165 8 ай бұрын
Nice explanation
@SimarMannSingh
@SimarMannSingh 8 ай бұрын
Good video with a terrible audio. Just a friendly comment, If you wish to increase your viewers, please invest in a decent microphone. Audio is absolutely essential, more than the video itself. Don't trust me blindly but please research yourself. I really wish this channel to grow...
@lejeczek
@lejeczek 6 ай бұрын
All that nice work ruined by horribly bad sound/voice quality.
@ryanribeiro1725
@ryanribeiro1725 3 ай бұрын
whut?! the audio is so good for a free class, and this content is so specific, you should ne grateful for this guy took a time to share his knowledges about it!!
@JaiRamJaiRamJaiRam108
@JaiRamJaiRamJaiRam108 2 ай бұрын
​@@ryanribeiro1725free bee customer spotted😅😅😂
@samadhanmhaske5900
@samadhanmhaske5900 2 ай бұрын
@deki90to
@deki90to Жыл бұрын
why analyze dont work?
Optimize Your SQL Queries | Postgres Edition
22:52
Code with Irtiza
Рет қаралды 12 М.
Slow motion boy #shorts by Tsuriki Show
00:14
Tsuriki Show
Рет қаралды 10 МЛН
Пранк пошел не по плану…🥲
00:59
Саша Квашеная
Рет қаралды 7 МЛН
A little girl was shy at her first ballet lesson #shorts
00:35
Fabiosa Animated
Рет қаралды 17 МЛН
Database Indexing Explained (with PostgreSQL)
18:19
Hussein Nasser
Рет қаралды 301 М.
Use MySQL EXPLAIN for Query Optimization
17:19
High-Performance Programming
Рет қаралды 55 М.
A beginners guide to EXPLAIN ANALYZE - Michael Christofides
30:05
51 - PostgreSQL : Slow long running and blocked queries in PostgreSQL
14:37
E-MultiSkills Database services
Рет қаралды 10 М.
What is Neon Serverless Postgres?
2:27
Neon
Рет қаралды 7 М.
Postgres Open 2016 - Identifying Slow Queries and Fixing Them!
54:37
📱магазин техники в 2014 vs 2024
0:41
djetics
Рет қаралды 667 М.
Better Than Smart Phones☠️🤯 | #trollface
0:11
Not Sanu Moments
Рет қаралды 18 МЛН
Новые iPhone 16 и 16 Pro Max
0:42
Romancev768
Рет қаралды 2,4 МЛН
8 Товаров с Алиэкспресс, о которых ты мог и не знать!
49:47
РасПаковка ДваПаковка
Рет қаралды 178 М.