Understand PostgreSQL query plan in 10 minutes

Поделиться
HTML-код
  • Опубликовано: 26 авг 2024
  • 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 года назад +18

    Nice explanation. But the voice quality could have been better.

  • @SimarMannSingh
    @SimarMannSingh 9 месяцев назад +5

    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...

  • @ihateregistrating3494
    @ihateregistrating3494 3 месяца назад

    thanks, much clear than most tutorials

    • @liftandshiftdev3222
      @liftandshiftdev3222  3 месяца назад

      thank you. Im thinking about posting more videos this year with better audio quality. Stay tuned for more content

  • @jagadeeshdora5987
    @jagadeeshdora5987 3 года назад +6

    Thanks for the video. Please add more videos on PostgreSQL development advanced concepts as well.

  • @pjvm0
    @pjvm0 Год назад

    Thank you for sharing. Nice and straightforward explanation! 👏🏻

  • @CodeCruncher8
    @CodeCruncher8 10 месяцев назад

    Great explanation. Thanks!

  • @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

  • @Antnix732
    @Antnix732 2 года назад

    much more clear now, great explanation, thank you!

  • @artisingh9165
    @artisingh9165 9 месяцев назад

    Nice explanation

  • @samadhanmhaske5900
    @samadhanmhaske5900 2 месяца назад

  • @Truncator
    @Truncator 2 года назад

    Great explanation. Thank you!

  • @vivekkashyaps5926
    @vivekkashyaps5926 3 года назад +2

    well explained!

  • @lejeczek
    @lejeczek 7 месяцев назад +4

    All that nice work ruined by horribly bad sound/voice quality.

    • @ryanribeiro1725
      @ryanribeiro1725 4 месяца назад +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 3 месяца назад

      ​@@ryanribeiro1725free bee customer spotted😅😅😂

  • @newsnetworkz
    @newsnetworkz 2 года назад

    Very useful, thanks

  • @nikhilbadyal
    @nikhilbadyal 2 года назад

    Great video. 😄

  • @deki90to
    @deki90to Год назад

    why analyze dont work?