I have the following query:
*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*
I don't think it is super complex. But when I run explain analyze on this I
get the following:
Planning Time: 578.068 ms
Execution Time: 0.113 ms
This is a huge deviation in planning vs. execution times. The explain plan
looks good since the execution time is < 1ms. It doesn't matter though
since the planning time is high. I don't see anything in the explain
analyze output that tells me why the planning time is high. On average, the
tables being joined have 3 indexes/table. How can I debug this?
Been stuck on this for weeks. Any help is appreciated. Thank you!
Saurabh
