PostgresOpen 2019 Explain Plans And You

  Рет қаралды 7,602

Postgres Open

Postgres Open

Күн бұрын

Пікірлер: 8
@kunalmandalia1165
@kunalmandalia1165 3 жыл бұрын
Excellent talk. The speaker is keen for the audience to learn as opposed to appearing clever and that shines through.
@kundan621
@kundan621 4 жыл бұрын
Thanks for sharing. Excellent presentation and great content.
@india_is_greatest
@india_is_greatest 2 жыл бұрын
by far the best talk I listened so far about Postgres
@deryckhenson4353
@deryckhenson4353 3 жыл бұрын
Very good talk. Wish resolution was higher couldn't read much on the screen :\
@YogeshJadhav96
@YogeshJadhav96 3 жыл бұрын
Great Talk.
@SARANSASIDHARAN1
@SARANSASIDHARAN1 Жыл бұрын
Excellent talk!
@user-fr2fd4vj4p
@user-fr2fd4vj4p Жыл бұрын
Thanks. It was very helpful
@mourinhoalex1992
@mourinhoalex1992 4 жыл бұрын
What is the execution order of this plan: Sort (cost=87.71..88.75 rows=418 width=40) Sort Key: language.name DESC -> Hash Join (cost=1.14..69.51 rows=418 width=40) Hash Cond: (film.language_id = language.language_id) -> Seq Scan on film (cost=0.00..66.50 rows=418 width=21) Filter: (rating = ANY ('{R,PG-13}'::mpaa_rating[])) -> Hash (cost=1.06..1.06 rows=6 width=25) -> Seq Scan on language (cost=0.00..1.06 rows=6 width=25) As I understand from the talk, it should be: 1. The nodes that have the startup cost equals to 0 will be the nodes that gets run first, so these 2 nodes runs in parallel: Seq Scan on film, Seq Scan on language 2. Then this node gets run: Hash (cost=1.06..1.06 rows=6 width=25) 3. Then this node: Hash Join 4. Finally: Sort Do I understand it correctly ? If not, then what is the correct execution order of the nodes in this plan ?
PostgresOpen 2019 Fascinating Reporting With Postgres psql
50:00
Postgres Open
Рет қаралды 3,3 М.
PostgresOpen 2019 Optimizing Query Performance
41:35
Postgres Open
Рет қаралды 4,9 М.
Alex hid in the closet #shorts
00:14
Mihdens
Рет қаралды 18 МЛН
PostgresOpen 2019 Look It Up Practical PostgreSQL Indexing
45:36
Postgres Open
Рет қаралды 4,3 М.
PostgresOpen 2019 PostgreSQL Partitioning
49:21
Postgres Open
Рет қаралды 10 М.
Postgres, MVCC, and you or, Why COUNT(*) is slow (David Wolever)
29:39
PostgreSQL Locking Issues: a talk for devs and DBAs
39:42
Postgres Open
Рет қаралды 10 М.
PostgresOpen 2019 The Art Of PostgreSQL
50:37
Postgres Open
Рет қаралды 10 М.
Explaining the Postgres Query Optimizer - Bruce Momjian
51:26
Postgres Open
Рет қаралды 7 М.
PostgresOpen 2019 I Didn't Know Postgres Could Do That
47:21
Postgres Open
Рет қаралды 9 М.
Частая ошибка геймеров? 😐 Dareu A710X
1:00
Вэйми
Рет қаралды 5 МЛН
Better Than Smart Phones☠️🤯 | #trollface
0:11
Not Sanu Moments
Рет қаралды 18 МЛН
Todos os modelos de smartphone
0:20
Spider Slack
Рет қаралды 65 МЛН
Tag him😳💕 #miniphone #iphone #samsung #smartphone #fy
0:11
Pockify™
Рет қаралды 4,3 МЛН