evergreen=# SELECT  f.record, sum(f.sum), count(DISTINCT cp.id), sum(f.sum)                         FROM    (SELECT x.record, sum(x.sum) FROM ((SELECT record, AVG(ts_rank(index_vector, to_tsquery('default','9780764200540'))) as sum FROM metabib.full_rec WHERE ( tag = '020' AND subfield LIKE 'a' AND index_vector @@ to_tsquery('default','9780764200540') ) GROUP BY record)) x GROUP BY 1 HAVING COUNT(x.record) = 1 ORDER BY 2 DESC ) f,
                             asset.call_number cn,
                             asset.copy cp,
                             config.copy_status cs,
                             asset.copy_location cl,
                             biblio.record_entry br,
                             metabib.rec_descriptor rd,
                             actor.org_unit_descendants(17) d
                         WHERE   br.id = f.record
                             AND cn.record = f.record
                             AND rd.record = f.record
                             AND cp.status = cs.id
                             AND cp.location = cl.id
                             AND br.deleted IS FALSE
                             AND cn.deleted IS FALSE
                             AND cp.deleted IS FALSE
                             AND cn.owning_lib = d.id
                             AND cp.call_number = cn.id
                             AND d.opac_visible IS TRUE AND cp.opac_visible IS TRUE AND cs.opac_visible IS TRUE AND cl.opac_visible IS TRUE
                         GROUP BY f.record HAVING count(DISTINCT cp.id) > 0
                         ORDER BY 4 DESC,3 DESC;
 record | sum | count | sum
--------+-----+-------+-----
(0 rows)

Time: 381711.448 ms
evergreen=# \e
CREATE VIEW
Time: 56.002 ms
evergreen=#  SELECT  f.record, sum(f.sum), count(DISTINCT cp.id), sum(f.sum)
                         FROM    (SELECT x.record, sum(x.sum) FROM ((SELECT record, AVG(ts_rank(index_vector, to_tsquery('default','9780764200540'))) as sum FROM metabib.full_rec WHERE ( tag = '020' AND
subfield LIKE 'a' AND index_vector @@ to_tsquery('default','9780764200540') ) GROUP BY record)) x GROUP BY 1 HAVING COUNT(x.record) = 1 ORDER BY 2 DESC ) f,
                             asset.call_number cn,
                             asset.copy cp,
                             config.copy_status cs,
                             asset.copy_location cl,
                             biblio.record_entry br,
                             metabib.rec_descriptor rd,
                             actor.org_unit_descendants(17) d
                         WHERE   br.id = f.record
                             AND cn.record = f.record
                             AND rd.record = f.record
                             AND cp.status = cs.id
                             AND cp.location = cl.id
                             AND br.deleted IS FALSE
                             AND cn.deleted IS FALSE
                             AND cp.deleted IS FALSE
                             AND cn.owning_lib = d.id
                             AND cp.call_number = cn.id
                             AND d.opac_visible IS TRUE AND cp.opac_visible IS TRUE AND cs.opac_visible IS TRUE AND cl.opac_visible IS TRUE
                         GROUP BY f.record HAVING count(DISTINCT cp.id) > 0
                         ORDER BY 4 DESC,3 DESC; record | sum | count | sum
--------+-----+-------+-----
(0 rows)

Time: 542740.000 ms
evergreen=#