[PERFORM] Please help with a slow query: there are millions of records, whatcan we do?

Поиск

Список

Период

Сортировка

От	Pat Maddox
Тема	[PERFORM] Please help with a slow query: there are millions of records, whatcan we do?
Дата	8 марта 2017 г. 05:26:36
Msg-id	D3877097-C899-41C6-AAA3-F51D26C2BEBB@adorable.io обсуждение исходный текст
Ответы	Re: [PERFORM] Please help with a slow query: there are millions ofrecords, what can we do? Re: [PERFORM] Please help with a slow query: there are millions ofrecords, what can we do?
Список	pgsql-performance

Дерево обсуждения

Hi there,

I’ve been asked to help with a project dealing with slow queries. I’m brand new to the project, so I have very little context. I’ve gathered as much information as I can.

I’ve put the schema, query, and explain info in gists to maintain their formatting.

We are stumped with this slow query right now. I could really use some help looking for ways to speed it up.

If you need any more information, please let me know.

Thanks,

Pat

Full Table and Index Schema

tasks schema

permissions schema

Table Metadata

tasks count: 8.8 million

tasks count where assigned_to_user_id is null: 2.7 million

tasks table has lots of new records added, individual existing records updated (e.g. to mark them complete)