grants files - Search results

Mailing lists  >>  pgsql-sql  >>  Thread

2010-01-31 21:03:09 | Re: Fwd: Help required on query performance (Dave Clements)

granted" = '1'::bpchar)))) -> Bitmap Heap Scan on sq_ast_perm p (cost=7.87..1521.54 rows=820 width=297) (actual time=0.019..0.023 rows=2 loops=586) Recheck Cond: (($0)::text = (assetid)::text) -> Bitmap Index Scan

Mailing lists  >>  pgsql-sql  >>  Thread

2010-01-31 20:50:55 | Fwd: Help required on query performance (Dave Clements)

file', 'page_rss_feed')      )      AND a.aid IN      (        SELECT          p.aid        FROM          perm p LEFT JOIN s_ast_role r ON (p.userid = r.roleid)        WHERE          (            p.userid IN ('7') OR r.userid