Bug #6098
Updated by Ward Vandewege about 9 years ago
<pre>
explain analyze SELECT COUNT(DISTINCT "pipeline_instances"."id") FROM "pipeline_instances" WHERE (pipeline_instances.uuid in ('qr1hi-tpzed-w68kvgin92qp9gs','qr1hi-tpzed-anonymouspublic') OR pipeline_instances.owner_uuid in ('qr1hi-tpzed-w68kvgin92qp9gs','qr1hi-tpzed-anonymouspublic','qr1hi-j7d0g-xcq63k14iwywimi','qr1hi-j7d0g-fffffffffffffff','qr1hi-j7d0g-it30l961gq3t0oi','qr1hi-j7d0g-rluyd6zowuj1zre','qr1hi-j7d0g-anonymouspublic','qr1hi-j7d0g-662ij1pcw6bj8uj','qr1hi-j7d0g-ls7mn9ilxiwvep6','qr1hi-j7d0g-key0mqeqlvhz7v7','qr1hi-j7d0g-2hth2gzle63muo6','qr1hi-j7d0g-gytictj8fzr9jfh','qr1hi-j7d0g-25wprjygblp9z2f','qr1hi-j7d0g-ziejtm5kaik7ndl','qr1hi-j7d0g-a45rn6qhjszct1d','qr1hi-j7d0g-7o66z9uq8mkgqun','qr1hi-j7d0g-iodpr5gc65cp4t0','qr1hi-j7d0g-550ma2g4nlx5ri6','qr1hi-j7d0g-gsw7n4d2g3mx1dj','qr1hi-j7d0g-fpyx8sz1lkdvcaq','qr1hi-j7d0g-l1emsbyyx6wyjdh','qr1hi-j7d0g-45zjb0b4n6cpzxa','qr1hi-j7d0g-834hs5rnunpn6y6','qr1hi-j7d0g-up6qgpqz5ie2vfq','qr1hi-j7d0g-u7zg1qdaowykd8d','qr1hi-j7d0g-mm1t3d3mmkh7n2u','qr1hi-j7d0g-k40t93v1njk9gcz','qr1hi-j7d0g-anonymouspublic','qr1hi-j7d0g-2ak9yjmy5u0hw6z','qr1hi-j7d0g-jrzr18w1nqr5326','qr1hi-j7d0g-anonymouspublic','qr1hi-j7d0g-662ij1pcw6bj8uj','qr1hi-j7d0g-ls7mn9ilxiwvep6','qr1hi-j7d0g-key0mqeqlvhz7v7','qr1hi-j7d0g-2hth2gzle63muo6','qr1hi-j7d0g-gytictj8fzr9jfh','qr1hi-j7d0g-25wprjygblp9z2f','qr1hi-j7d0g-ziejtm5kaik7ndl','qr1hi-j7d0g-a45rn6qhjszct1d','qr1hi-j7d0g-7o66z9uq8mkgqun','qr1hi-j7d0g-iodpr5gc65cp4t0','qr1hi-j7d0g-550ma2g4nlx5ri6','qr1hi-j7d0g-gsw7n4d2g3mx1dj','qr1hi-j7d0g-fpyx8sz1lkdvcaq','qr1hi-j7d0g-l1emsbyyx6wyjdh','qr1hi-j7d0g-45zjb0b4n6cpzxa','qr1hi-j7d0g-anonymouspublic') OR pipeline_instances.uuid IN (SELECT head_uuid FROM links WHERE link_class='permission' AND tail_uuid IN ('qr1hi-tpzed-w68kvgin92qp9gs', 'qr1hi-tpzed-anonymouspublic', 'qr1hi-j7d0g-xcq63k14iwywimi', 'qr1hi-j7d0g-fffffffffffffff', 'qr1hi-j7d0g-it30l961gq3t0oi', 'qr1hi-j7d0g-rluyd6zowuj1zre', 'qr1hi-j7d0g-anonymouspublic', 'qr1hi-j7d0g-662ij1pcw6bj8uj', 'qr1hi-j7d0g-ls7mn9ilxiwvep6', 'qr1hi-j7d0g-key0mqeqlvhz7v7', 'qr1hi-j7d0g-2hth2gzle63muo6', 'qr1hi-j7d0g-gytictj8fzr9jfh', 'qr1hi-j7d0g-25wprjygblp9z2f', 'qr1hi-j7d0g-ziejtm5kaik7ndl', 'qr1hi-j7d0g-a45rn6qhjszct1d', 'qr1hi-j7d0g-7o66z9uq8mkgqun', 'qr1hi-j7d0g-iodpr5gc65cp4t0', 'qr1hi-j7d0g-550ma2g4nlx5ri6', 'qr1hi-j7d0g-gsw7n4d2g3mx1dj', 'qr1hi-j7d0g-fpyx8sz1lkdvcaq', 'qr1hi-j7d0g-l1emsbyyx6wyjdh', 'qr1hi-j7d0g-45zjb0b4n6cpzxa', 'qr1hi-j7d0g-834hs5rnunpn6y6', 'qr1hi-j7d0g-up6qgpqz5ie2vfq', 'qr1hi-j7d0g-u7zg1qdaowykd8d', 'qr1hi-j7d0g-mm1t3d3mmkh7n2u', 'qr1hi-j7d0g-k40t93v1njk9gcz', 'qr1hi-j7d0g-anonymouspublic', 'qr1hi-j7d0g-2ak9yjmy5u0hw6z', 'qr1hi-j7d0g-jrzr18w1nqr5326', 'qr1hi-j7d0g-anonymouspublic', 'qr1hi-j7d0g-662ij1pcw6bj8uj', 'qr1hi-j7d0g-ls7mn9ilxiwvep6', 'qr1hi-j7d0g-key0mqeqlvhz7v7', 'qr1hi-j7d0g-2hth2gzle63muo6', 'qr1hi-j7d0g-gytictj8fzr9jfh', 'qr1hi-j7d0g-25wprjygblp9z2f', 'qr1hi-j7d0g-ziejtm5kaik7ndl', 'qr1hi-j7d0g-a45rn6qhjszct1d', 'qr1hi-j7d0g-7o66z9uq8mkgqun', 'qr1hi-j7d0g-iodpr5gc65cp4t0', 'qr1hi-j7d0g-550ma2g4nlx5ri6', 'qr1hi-j7d0g-gsw7n4d2g3mx1dj', 'qr1hi-j7d0g-fpyx8sz1lkdvcaq', 'qr1hi-j7d0g-l1emsbyyx6wyjdh', 'qr1hi-j7d0g-45zjb0b4n6cpzxa', 'qr1hi-j7d0g-anonymouspublic'))) AND ((to_tsvector('english', coalesce(uuid,'') || ' ' || coalesce(owner_uuid,'') || ' ' || coalesce(modified_by_client_uuid,'') || ' ' || coalesce(modified_by_user_uuid,'') || ' ' || coalesce(pipeline_template_uuid,'') || ' ' || coalesce(name,'') || ' ' || coalesce(components,'') || ' ' || coalesce(properties,'') || ' ' || coalesce(state,'') || ' ' || coalesce(components_summary,'') || ' ' || coalesce(description,'')) @@ to_tsquery('hash:*')));
</pre>
Cold, that takes about 38 seconds; hot, 23 seconds.