chrissharp123

Untitled

Nov 8th, 2018
209
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. Subquery Scan on core_query (cost=870656.89..870750.29 rows=5337 width=116) (actual time=951.264..954.837 rows=3814 loops=1)
  2. CTE xf3ebf08_keyword_xq
  3. -> Result (cost=0.00..1.02 rows=1 width=0) (actual time=0.835..0.847 rows=1 loops=1)
  4. CTE lang_with
  5. -> Bitmap Heap Scan on coded_value_map (cost=12.93..52.24 rows=1 width=4) (actual time=0.232..0.251 rows=1 loops=1)
  6. Recheck Cond: (ctype = 'item_lang'::text)
  7. Filter: (code = 'eng'::text)
  8. Rows Removed by Filter: 486
  9. Heap Blocks: exact=5
  10. -> Bitmap Index Scan on config_coded_value_map_ctype_idx (cost=0.00..12.93 rows=487 width=0) (actual time=0.089..0.089 rows=487 loops=1)
  11. Index Cond: (ctype = 'item_lang'::text)
  12. CTE pop_with
  13. -> HashAggregate (cost=26.52..27.00 rows=24 width=20) (actual time=0.032..0.032 rows=0 loops=1)
  14. Group Key: s.record
  15. -> Nested Loop (cost=1.21..26.04 rows=24 width=20) (actual time=0.030..0.030 rows=0 loops=1)
  16. -> Seq Scan on badge b (cost=0.00..1.03 rows=3 width=8) (actual time=0.007..0.010 rows=3 loops=1)
  17. Filter: (scope = ANY ('{1}'::integer[]))
  18. -> Bitmap Heap Scan on record_badge_score s (cost=1.21..8.25 rows=8 width=16) (actual time=0.004..0.004 rows=0 loops=3)
  19. Recheck Cond: (badge = b.id)
  20. -> Bitmap Index Scan on record_badge_score_badge_idx (cost=0.00..1.21 rows=8 width=0) (actual time=0.002..0.002 rows=0 loops=3)
  21. Index Cond: (badge = b.id)
  22. CTE c_attr
  23. -> Function Scan on patron_default_visibility_mask x (cost=0.25..0.27 rows=1 width=32) (actual time=8.769..8.789 rows=1 loops=1)
  24. CTE b_attr
  25. -> Function Scan on patron_default_visibility_mask x_1 (cost=0.25..0.27 rows=1 width=32) (actual time=2.903..2.906 rows=1 loops=1)
  26. -> Limit (cost=870576.09..870589.44 rows=5337 width=740) (actual time=951.237..952.237 rows=3814 loops=1)
  27. -> Sort (cost=870576.09..870589.44 rows=5337 width=740) (actual time=951.236..951.698 rows=3814 loops=1)
  28. Sort Key: ((1.0 / ((avg(COALESCE((ts_rank_cd('{0.1,0.2,0.4,1}'::real[], fe.index_vector, xf3ebf08_keyword_xq.tsq_rank, 14) * (fe_weight.weight)::double precision), '0'::double precision)) + ((1 * COALESCE(((NULLIF(first((mrv.vlist @> ARRAY[lang_with.id])), false))::integer * 5), 1)))::double precision))::numeric)), (first(pubdate_t.value)) DESC NULLS LAST, (((avg(COALESCE((ts_ra
  29. nk_cd('{0.1,0.2,0.4,1}'::real[], fe.index_vector, xf3ebf08_keyword_xq.tsq_rank, 14) * (fe_weight.weight)::double precision), '0'::double precision)) + ((1 * COALESCE(((NULLIF(first((mrv.vlist @> ARRAY[lang_with.id])), false))::integer * 5), 1)))::double precision))::numeric) DESC
  30. Sort Method: quicksort Memory: 633kB
  31. -> HashAggregate (cost=869925.46..870245.68 rows=5337 width=740) (actual time=922.995..943.128 rows=3814 loops=1)
  32. Group Key: m.source
  33. -> Nested Loop (cost=1551.35..865735.92 rows=5337 width=740) (actual time=27.159..777.039 rows=3814 loops=1)
  34. Join Filter: ((SubPlan 6) OR (b_attr.vis_test IS NULL) OR (bre.vis_attr_vector @@ b_attr.vis_test))
  35. Rows Removed by Join Filter: 189
  36. -> Nested Loop (cost=0.00..0.08 rows=1 width=68) (actual time=11.946..12.002 rows=1 loops=1)
  37. -> Nested Loop (cost=0.00..0.05 rows=1 width=36) (actual time=9.040..9.084 rows=1 loops=1)
  38. -> CTE Scan on lang_with (cost=0.00..0.02 rows=1 width=4) (actual time=0.234..0.255 rows=1 loops=1)
  39. -> CTE Scan on c_attr (cost=0.00..0.02 rows=1 width=32) (actual time=8.804..8.825 rows=1 loops=1)
  40. -> CTE Scan on b_attr (cost=0.00..0.02 rows=1 width=32) (actual time=2.905..2.916 rows=1 loops=1)
  41. -> Nested Loop Left Join (cost=1551.35..60630.49 rows=10610 width=760) (actual time=14.979..409.482 rows=4003 loops=1)
  42. -> Hash Left Join (cost=1550.92..53198.75 rows=10610 width=745) (actual time=14.910..312.639 rows=4003 loops=1)
  43. Hash Cond: (m.source = pop_with.record)
  44. -> Nested Loop (cost=1550.14..53158.18 rows=10610 width=681) (actual time=14.849..309.930 rows=4003 loops=1)
  45. -> Nested Loop (cost=1549.71..48528.79 rows=9252 width=697) (actual time=14.780..257.310 rows=4006 loops=1)
  46. -> Hash Join (cost=1549.28..38476.82 rows=9252 width=665) (actual time=14.729..165.433 rows=4006 loops=1)
  47. Hash Cond: (fe.field = fe_weight.id)
  48. -> Nested Loop (cost=1546.09..38346.41 rows=9252 width=665) (actual time=14.643..161.677 rows=4006 loops=1)
  49. -> Nested Loop (cost=1545.66..32451.54 rows=11698 width=555) (actual time=14.573..70.651 rows=4979 loops=1)
  50. -> CTE Scan on xf3ebf08_keyword_xq (cost=0.00..0.02 rows=1 width=64) (actual time=0.836..0.851 rows=1 loo
  51. ps=1)
  52. -> Bitmap Heap Scan on keyword_field_entry fe (cost=1545.66..32334.54 rows=11698 width=523) (actual time=13.728..66.698 rows=4979 loops=1)
  53. Recheck Cond: (index_vector @@ xf3ebf08_keyword_xq.tsq)
  54. Filter: (id IS NOT NULL)
  55. Heap Blocks: exact=4841
  56. -> Bitmap Index Scan on metabib_keyword_field_entry_index_vector_idx (cost=0.00..1542.74 rows=11698 width=0) (actual time=12.764..12.764 rows=4988 loops=1)
  57. Index Cond: (index_vector @@ xf3ebf08_keyword_xq.tsq)
  58. -> Index Scan using record_attr_vector_list_pkey on record_attr_vector_list mrv (cost=0.43..0.49 rows=1 width=110) (actual time=0.017..0.017 rows=1 loops=4979)
  59. Index Cond: (source = fe.source)
  60. -> Hash (cost=2.53..2.53 rows=53 width=8) (actual time=0.048..0.048 rows=53 loops=1)
  61. Buckets: 1024 Batches: 1 Memory Usage: 11kB
  62. -> Seq Scan on metabib_field fe_weight (cost=0.00..2.53 rows=53 width=8) (actual time=0.018..0.033 rows=53 loops=1)
  63. -> Index Scan using record_entry_pkey on record_entry bre (cost=0.43..1.08 rows=1 width=32) (actual time=0.021..0.021 rows=1 loops=4006)
  64. Index Cond: (id = fe.source)
  65. -> Index Only Scan using metabib_metarecord_source_map_source_record_idx on metarecord_source_map m (cost=0.43..0.48 rows=2 width=8) (actual time=0.012..0.012 rows=1 loops=4006)
  66. Index Cond: (source = fe.source)
  67. Heap Fetches: 321
  68. -> Hash (cost=0.48..0.48 rows=24 width=72) (actual time=0.034..0.034 rows=0 loops=1)
  69. Buckets: 1024 Batches: 1 Memory Usage: 8kB
  70. -> CTE Scan on pop_with (cost=0.00..0.48 rows=24 width=72) (actual time=0.034..0.034 rows=0 loops=1)
  71. -> Index Scan using metabib_sorter_source_idx on record_sorter pubdate_t (cost=0.43..0.69 rows=1 width=23) (actual time=0.022..0.023 rows=1 loops=4003)
  72. Index Cond: (m.source = source)
  73. Filter: (attr = 'pubdate'::text)
  74. Rows Removed by Filter: 2
  75. SubPlan 6
  76. -> Index Scan using copy_vis_attr_cache_record_idx on copy_vis_attr_cache (cost=0.43..75.87 rows=1 width=0) (actual time=0.087..0.087 rows=1 loops=4003)
  77. Index Cond: (record = m.source)
  78. Filter: (vis_attr_vector @@ c_attr.vis_test)
  79. Rows Removed by Filter: 0
  80. Planning time: 27.744 ms
  81. Execution time: 955.939 ms
RAW Paste Data