Về trang chủ

Hiểu biết cơ bản về EXPLAIN ANALYZE

vie v3
Tác giả: PostgresConf South Africa
Ngày xuất bản: 2019-11-21T00:00:00
Length: 36:07

Tóm tắt nội dung

Mô tả

Justin Harvey

PostgresConf South Africa 2019

https://postgresconf.org/conferences/SouthAfrica2019/program/proposals/basic-understanding-of-explain-analyze

My talk is a beginners guide to using and understanding EXPLAIN ANALYZE.

This will include understanding: -INDEX SCAN VS. BITMAP SCAN VS. SEQUENTIAL SCAN (BASICS) -B-tree vs GIN vs GiST vs SP-GiST vs BRIN vs HASH -Costs and actual times

This is for unskilled and new PostgreSQL users.

Justin Harvey

PostgresConf South Africa 2019

https://postgresconf.org/conferences/SouthAfrica2019/program/proposals/basic-understanding-of-explain-analyze

My talk is a beginners guide to using and understanding EXPLAIN ANALYZE.

This will include understanding: -INDEX SCAN VS. BITMAP SCAN VS. SEQUENTIAL SCAN (BASICS) -B-tree vs GIN vs GiST vs SP-GiST vs BRIN vs HASH -Costs and actual times

This is for unskilled and new PostgreSQL users.

Dịch Vào Lúc: 2025-08-08T00:16:59Z

Yêu cầu dịch (Một bản dịch khoảng 5 phút)

Phiên bản 3 (ổn định)

Tối ưu hóa cho một người nói. Phù hợp cho video chia sẻ kiến thức hoặc giảng dạy.

Video Đề Xuất