API tools faq
paste
Advertisement
chrissharp123

Untitled

chrissharp123
Nov 8th, 2018
480
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 8.89 KB | None | 0 0
raw download clone embed print report
  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
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!