Slow Planning Times
От | Saurabh Sehgal |
---|---|
Тема | Slow Planning Times |
Дата | |
Msg-id | CAB0Jq2KhM6guH6cPtV+upKQ=SSw6m3oXaQO=XnjqzTnyp+KEyw@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: Slow Planning Times
Re: Slow Planning Times |
Список | pgsql-performance |
explain (analyze, costs, timing) SELECT rr.* FROM rpc rpc
INNER JOIN rr rr
ON rr.uuid = rpc.rr_id
INNER JOIN rs rs
ON rs.r_id = rpc.r_id
INNER JOIN role r
ON r.uuid = rs.r_id
LEFT JOIN spc spc
ON spc.rr_id = rpc.rr_id
WHERE rs.s_id = 'caa767b8-8371-43a3-aa11-d1dba1893601'
and spc.s_id = 'caa767b8-8371-43a3-aa11-d1dba1893601'
and spc.rd_id = '9f33c45a-90c2-4e05-a42e-048ec1f2b2fa'
AND rpc.rd_id = '9f33c45a-90c2-4e05-a42e-048ec1f2b2fa'
AND rpc.c_id = '9fd29fdc-15fd-40bb-b85d-8cfe99734987'
and spc.c_id = '9fd29fdc-15fd-40bb-b85d-8cfe99734987'
AND rr.b_id = 'xyz'
AND (('GLOBAL' = ' NO_PROJECT_ID + "' ) OR (rr.p_id = 'GLOBAL'))
AND spc.permission_type IS null and spc.is_active = true
AND rpc.is_active = true AND rr.is_active = true AND rs.is_active = true AND r.is_active = true
Execution Time: 0.113 ms
В списке pgsql-performance по дате отправления: