PostgresOpen 2019 Explain Plans And You

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

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 М.
Doing This Instead Of Studying.. 😳
00:12
Jojo Sim
Рет қаралды 19 МЛН
Sigma girl and soap bubbles by Secret Vlog
00:37
Secret Vlog
Рет қаралды 15 МЛН
PostgresOpen 2019 Look It Up Practical PostgreSQL Indexing
45:36
Postgres Open
Рет қаралды 4,3 М.
Postgres, MVCC, and you or, Why COUNT(*) is slow (David Wolever)
29:39
PostgresOpen 2019 PostgreSQL Partitioning
49:21
Postgres Open
Рет қаралды 10 М.
PostgresOpen 2019 The Art Of PostgreSQL
50:37
Postgres Open
Рет қаралды 10 М.
Webinar: Explaining the Postgres Query Optimizer
57:35
PostgresOpen 2019 A Look At The Elephants Trunk
49:21
Postgres Open
Рет қаралды 943
PostgresOpen 2019 Improve Your SQL Workload With Observability
40:01
Это - iPhone 16!
16:29
Rozetked
Рет қаралды 399 М.
ноутбуки от 7.900 в тг laptopshoptop
0:14
Ноутбуковая лавка
Рет қаралды 3,5 МЛН
Ускоряем ваш TV🚀
0:44
ARTEM_CHIBA
Рет қаралды 196 М.
Опасность фирменной зарядки Apple
0:57
SuperCrastan
Рет қаралды 12 МЛН
Сколько реально стоит ПК Величайшего?
0:37