Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 2018-01-04 10:45:24.395 EST [21070] evergreen@evergreen LOG: duration: 12.228 ms statement: SELECT "acplg".id, oils_i18n_xlate('asset.copy_location_group', 'acplg', 'name', 'id', "acplg".id::TEXT, 'en-US') AS "name", "acplg".opac_visible, "acplg".owner, "acplg".pos, "acplg".top FROM asset.copy_location_group AS "acplg" WHERE "acplg".owner IN (SELECT (actor.org_unit_full_path("aou".id ))."id" AS "id" FROM actor.org_unit AS "aou" WHERE "aou".id IN (1)) AND "acplg".opac_visible = 't' ORDER BY pos;
- 2018-01-04 10:45:24.794 EST [21004] evergreen@evergreen LOG: duration: 51.813 ms statement: -- bib search: #CD_documentLength #CD_meanHarmonic #CD_uniqueWords core_limit(100000) badge_orgs(1) estimation_strategy(inclusion) skip_check(0) check_limit(1000) inside immigration depth(0)
- WITH w AS (
- WITH xe56d660_keyword_xq AS (SELECT
- (to_tsquery('english_nostop', COALESCE(NULLIF( '(' || btrim(regexp_replace(search_normalize(split_date_range($_21003$inside$_21003$)),E'(?:\\s+|:)','&','g'),'&|') || ')', '()'), '')) || to_tsquery('simple', COALESCE(NULLIF( '(' || btrim(regexp_replace(search_normalize(split_date_range($_21003$inside$_21003$)),E'(?:\\s+|:)','&','g'),'&|') || ')', '()'), '')))&&
- (to_tsquery('english_nostop', COALESCE(NULLIF( '(' || btrim(regexp_replace(search_normalize(split_date_range($_21003$immigration$_21003$)),E'(?:\\s+|:)','&','g'),'&|') || ')', '()'), '')) || to_tsquery('simple', COALESCE(NULLIF( '(' || btrim(regexp_replace(search_normalize(split_date_range($_21003$immigration$_21003$)),E'(?:\\s+|:)','&','g'),'&|') || ')', '()'), ''))) AS tsq,
- (to_tsquery('english_nostop', COALESCE(NULLIF( '(' || btrim(regexp_replace(search_normalize(split_date_range($_21003$inside$_21003$)),E'(?:\\s+|:)','&','g'),'&|') || ')', '()'), '')) || to_tsquery('simple', COALESCE(NULLIF( '(' || btrim(regexp_replace(search_normalize(split_date_range($_21003$inside$_21003$)),E'(?:\\s+|:)','&','g'),'&|') || ')', '()'), ''))) ||
- (to_tsquery('english_nostop', COALESCE(NULLIF( '(' || btrim(regexp_replace(search_normalize(split_date_range($_21003$immigration$_21003$)),E'(?:\\s+|:)','&','g'),'&|') || ')', '()'), '')) || to_tsquery('simple', COALESCE(NULLIF( '(' || btrim(regexp_replace(search_normalize(split_date_range($_21003$immigration$_21003$)),E'(?:\\s+|:)','&','g'),'&|') || ')', '()'), ''))) AS tsq_rank ),lang_with AS (SELECT id FROM config.coded_value_map WHERE ctype = 'item_lang' AND code = $_21003$eng$_21003$), pop_with AS (
- SELECT record,
- ARRAY_AGG(badge) AS badges,
- SUM(s.score::NUMERIC*b.weight::NUMERIC)/SUM(b.weight::NUMERIC) AS total_score
- FROM rating.record_badge_score s
- JOIN rating.badge b ON (
- b.id = s.badge
- AND b.scope = ANY ('{1}')) GROUP BY 1)
- ,c_attr AS (SELECT (ARRAY_TO_STRING(ARRAY[c_attrs],'&'))::query_int AS vis_test FROM asset.patron_default_visibility_mask() x)
- ,b_attr AS (SELECT (ARRAY_TO_STRING(ARRAY[b_attrs],'&'))::query_int AS vis_test FROM asset.patron_default_visibility_mask() x)
- SELECT id,
- rel,
- CASE WHEN cardinality(records) = 1 THEN records[1] ELSE NULL END AS record,
- NULL::INT AS total,
- NULL::INT AS checked,
- NULL::INT AS visible,
- NULL::INT AS deleted,
- NULL::INT AS excluded,
- badges,
- popularity
- FROM (SELECT m.source AS id,
- ARRAY[m.source] AS records,
- (AVG(
- (COALESCE(ts_rank_cd('{0.1, 0.2, 0.4, 1.0}', xe56d660_keyword.index_vector, xe56d660_keyword.tsq_rank, 14) * xe56d660_keyword.weight, 0.0)
- * evergreen.rel_bump(('{' || quote_literal(search_normalize($_21003$inside$_21003$)) || ',' || quote_literal(search_normalize($_21003$immigration$_21003$)) || '}')::TEXT[], xe56d660_keyword.value, '{word_order}'::TEXT[], '{10}'::NUMERIC[]))
- )+1 * COALESCE( NULLIF( FIRST(mrv.vlist @> ARRAY[lang_with.id]), FALSE )::INT * 5, 1))::NUMERIC AS rel,
- 1.0/((AVG(
- (COALESCE(ts_rank_cd('{0.1, 0.2, 0.4, 1.0}', xe56d660_keyword.index_vector, xe56d660_keyword.tsq_rank, 14) * xe56d660_keyword.weight, 0.0)
- * evergreen.rel_bump(('{' || quote_literal(search_normalize($_21003$inside$_21003$)) || ',' || quote_literal(search_normalize($_21003$immigration$_21003$)) || '}')::TEXT[], xe56d660_keyword.value, '{word_order}'::TEXT[], '{10}'::NUMERIC[]))
- )+1 * COALESCE( NULLIF( FIRST(mrv.vlist @> ARRAY[lang_with.id]), FALSE )::INT * 5, 1)))::NUMERIC AS rank,
- FIRST(pubdate_t.value) AS tie_break,
- STRING_AGG(ARRAY_TO_STRING(pop_with.badges,','),',') AS badges,
- AVG(COALESCE(pop_with.total_score::NUMERIC,0.0::NUMERIC))::NUMERIC(2,1) AS popularity
- FROM metabib.metarecord_source_map m
- LEFT JOIN (
- SELECT fe.*, fe_weight.weight, xe56d660_keyword_xq.tsq, xe56d660_keyword_xq.tsq_rank /* search */
- FROM metabib.keyword_field_entry AS fe
- JOIN config.metabib_field AS fe_weight ON (fe_weight.id = fe.field)
- JOIN xe56d660_keyword_xq ON (fe.index_vector @@ xe56d660_keyword_xq.tsq)
- ) AS xe56d660_keyword ON (m.source = xe56d660_keyword.source)
- INNER JOIN metabib.record_attr_vector_list mrv ON m.source = mrv.source
- INNER JOIN biblio.record_entry bre ON m.source = bre.id
- LEFT JOIN pop_with ON ( m.source = pop_with.record )
- LEFT JOIN metabib.record_sorter pubdate_t ON m.source = pubdate_t.source AND attr = 'pubdate'
- ,lang_with
- ,c_attr
- ,b_attr
- WHERE 1=1
- AND (
- (xe56d660_keyword.id IS NOT NULL)
- )
- AND (
- (EXISTS (SELECT 1 FROM asset.copy_vis_attr_cache WHERE record = m.source AND vis_attr_vector @@ c_attr.vis_test)) OR ((b_attr.vis_test IS NULL OR bre.vis_attr_vector @@ b_attr.vis_test))
- )
- GROUP BY 1
- ORDER BY 4 ASC NULLS LAST, 5 DESC NULLS LAST, 3 DESC
- ORDER BY 4 ASC NULLS LAST, 5 DESC NULLS LAST, 3 DESC
- LIMIT 100000
- ) AS core_query
- ) (SELECT * FROM w LIMIT 1000 OFFSET 0)
- UNION ALL
- SELECT NULL,NULL,NULL,COUNT(*),COUNT(*),COUNT(*),0,0,NULL,NULL FROM w;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement