Тёмный
No video :(

EXPLAIN | Postgres.FM 079 |  

PostgresTV 💙💛
Подписаться 4,1 тыс.
Просмотров 356
50% 1

Опубликовано:

 

27 авг 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 5   
@sortof3337
@sortof3337 7 месяцев назад
Awesome podcast as always.
@michristofides
@michristofides 7 месяцев назад
Thank you 🙏
@DavidTuron1
@DavidTuron1 5 месяцев назад
Hi, thanks for the podcast and many useful links. I usually use depesz tool, but i will try yours as well:) I have one tip of maybe strange use explain verbose - sometimes i want to have insert with columns definition, so i use EXPLAIN VERBOSE SELECT * FROM table and just copy column names from output:) I now there are other ways to do that - like pg_dump with --column-inserts or use some GUI tool for generating insert o just get columns from some create table def. or \gdesc but with some painful editing:) Thanks again and have nice day and fast queries.
@RajeshKumar-fc9vk
@RajeshKumar-fc9vk 7 месяцев назад
How do i explain analyze dynamic queries?
@michristofides
@michristofides 7 месяцев назад
If I understand you correctly, one option is logging examples of the queries that are being executed, via log_min_duration_statement, or auto_explain
Далее
Microservices with Databases can be challenging...
20:52
How Sustainable Are Tech Companies, Really?
1:21:15
Просмотров 258 тыс.