explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2YS

Settings
# exclusive inclusive rows x rows loops node
1. 0.781 11,350.238 ↑ 1.0 1,001 1

Append (cost=1,862,508.42..1,863,096.38 rows=1,001 width=112) (actual time=11,334.079..11,350.238 rows=1,001 loops=1)

  • Buffers: shared hit=2547965 read=140538
2.          

CTE w

3. 3.876 11,342.196 ↑ 5.7 3,552 1

Subquery Scan on core_query (cost=1,862,153.36..1,862,508.42 rows=20,289 width=116) (actual time=11,334.057..11,342.196 rows=3,552 loops=1)

  • Buffers: shared hit=2547965 read=140538
4.          

CTE xde71d30_keyword_xq

5. 0.538 0.538 ↑ 1.0 1 1

Result (cost=0.00..0.03 rows=1 width=0) (actual time=0.537..0.538 rows=1 loops=1)

  • Buffers: shared hit=38
6.          

CTE lang_with

7. 0.122 0.222 ↑ 1.0 1 1

Bitmap Heap Scan on coded_value_map (cost=12.93..36.24 rows=1 width=4) (actual time=0.128..0.222 rows=1 loops=1)

  • Recheck Cond: (ctype = 'item_lang'::text)
  • Filter: (code = 'eng'::text)
  • Rows Removed by Filter: 487
  • Heap Blocks: exact=7
  • Buffers: shared hit=11
8. 0.100 0.100 ↓ 1.0 488 1

Bitmap Index Scan on config_coded_value_map_ctype_idx (cost=0.00..12.93 rows=487 width=0) (actual time=0.100..0.100 rows=488 loops=1)

  • Index Cond: (ctype = 'item_lang'::text)
  • Buffers: shared hit=4
9.          

CTE pop_with

10. 0.003 0.025 ↓ 0.0 0 1

HashAggregate (cost=13.27..13.43 rows=8 width=20) (actual time=0.025..0.025 rows=0 loops=1)

  • Group Key: s.record
  • Buffers: shared hit=2
11. 0.006 0.022 ↓ 0.0 0 1

Nested Loop (cost=3.21..13.11 rows=8 width=20) (actual time=0.022..0.022 rows=0 loops=1)

  • Buffers: shared hit=2
12. 0.007 0.007 ↑ 1.0 1 1

Seq Scan on badge b (cost=0.00..1.01 rows=1 width=8) (actual time=0.006..0.007 rows=1 loops=1)

  • Filter: (scope = ANY ('{1}'::integer[]))
  • Buffers: shared hit=1
13. 0.003 0.009 ↓ 0.0 0 1

Bitmap Heap Scan on record_badge_score s (cost=3.21..12.02 rows=8 width=16) (actual time=0.009..0.009 rows=0 loops=1)

  • Recheck Cond: (badge = b.id)
  • Buffers: shared hit=1
14. 0.006 0.006 ↓ 0.0 0 1

Bitmap Index Scan on record_badge_score_badge_idx (cost=0.00..3.21 rows=8 width=0) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: (badge = b.id)
  • Buffers: shared hit=1
15.          

CTE c_attr

16. 4.825 4.825 ↑ 1.0 1 1

Function Scan on patron_default_visibility_mask x (cost=0.25..0.27 rows=1 width=32) (actual time=4.822..4.825 rows=1 loops=1)

  • Buffers: shared hit=474
17.          

CTE b_attr

18. 0.932 0.932 ↑ 1.0 1 1

Function Scan on patron_default_visibility_mask x_1 (cost=0.25..0.27 rows=1 width=32) (actual time=0.931..0.932 rows=1 loops=1)

  • Buffers: shared hit=38
19. 2.639 11,338.320 ↑ 5.7 3,552 1

Limit (cost=1,862,103.12..1,862,153.84 rows=20,289 width=467) (actual time=11,334.047..11,338.320 rows=3,552 loops=1)

  • Buffers: shared hit=2547965 read=140538
20. 8.114 11,335.681 ↑ 5.7 3,552 1

Sort (cost=1,862,103.12..1,862,153.84 rows=20,289 width=467) (actual time=11,334.045..11,335.681 rows=3,552 loops=1)

  • Sort Key: ((1.0 / ((avg(COALESCE(((ts_rank_cd('{0.1,0.2,0.4,1}'::real[], "*SELECT* 1_1".index_vector, "*SELECT* 1_1".tsq_rank, 14) * ("*SELECT* 1_1".weight)::double precision) * '1000'::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_rank_cd('{0.1,0.2,0.4,1}'::real[], "*SELECT* 1_1".index_vector, "*SELECT* 1_1".tsq_rank, 14) * ("*SELECT* 1_1".weight)::double precision) * '1000'::double precision), '0'::double precision)) + ((1 * COALESCE(((NULLIF(first((mrv.vlist @> ARRAY[lang_with.id])), false))::integer * 5), 1)))::double precision))::numeric) DESC
  • Sort Method: quicksort Memory: 596kB
  • Buffers: shared hit=2547965 read=140538
21. 206.147 11,327.567 ↑ 5.7 3,552 1

HashAggregate (cost=1,859,434.27..1,860,651.61 rows=20,289 width=467) (actual time=11,313.734..11,327.567 rows=3,552 loops=1)

  • Group Key: m.source
  • Buffers: shared hit=2547959 read=140538
22. 30.820 11,121.420 ↑ 1.5 13,187 1

Nested Loop (cost=11,085.76..1,843,405.96 rows=20,289 width=467) (actual time=2,286.080..11,121.420 rows=13,187 loops=1)

  • Join Filter: ((SubPlan 6) OR (b_attr.vis_test IS NULL) OR (bre.vis_attr_vector @@ b_attr.vis_test))
  • Rows Removed by Join Filter: 2056
  • Buffers: shared hit=2529399 read=140538
23. 0.003 6.018 ↑ 1.0 1 1

Nested Loop (cost=0.00..0.08 rows=1 width=68) (actual time=5.912..6.018 rows=1 loops=1)

  • Buffers: shared hit=523
24. 0.006 5.077 ↑ 1.0 1 1

Nested Loop (cost=0.00..0.05 rows=1 width=36) (actual time=4.975..5.077 rows=1 loops=1)

  • Buffers: shared hit=485
25. 0.227 0.227 ↑ 1.0 1 1

CTE Scan on lang_with (cost=0.00..0.02 rows=1 width=4) (actual time=0.132..0.227 rows=1 loops=1)

  • Buffers: shared hit=11
26. 4.844 4.844 ↑ 1.0 1 1

CTE Scan on c_attr (cost=0.00..0.02 rows=1 width=32) (actual time=4.839..4.844 rows=1 loops=1)

  • Buffers: shared hit=474
27. 0.938 0.938 ↑ 1.0 1 1

CTE Scan on b_attr (cost=0.00..0.02 rows=1 width=32) (actual time=0.935..0.938 rows=1 loops=1)

  • Buffers: shared hit=38
28. 35.706 10,779.722 ↑ 2.6 15,243 1

Nested Loop Left Join (cost=11,085.76..1,099,482.52 rows=40,336 width=486) (actual time=2,280.059..10,779.722 rows=15,243 loops=1)

  • Buffers: shared hit=2468376 read=139244
29. 16.427 10,606.829 ↑ 2.4 15,243 1

Nested Loop Left Join (cost=11,085.32..1,071,543.13 rows=35,912 width=470) (actual time=2,280.025..10,606.829 rows=15,243 loops=1)

  • Join Filter: (m.source = pop_with.record)
  • Buffers: shared hit=2409816 read=136098
30. 32.353 10,575.159 ↑ 2.4 15,243 1

Nested Loop (cost=11,085.32..1,065,078.89 rows=35,912 width=406) (actual time=2,279.995..10,575.159 rows=15,243 loops=1)

  • Buffers: shared hit=2409814 read=136098
31. 42.303 10,404.179 ↑ 5.4 15,403 1

Nested Loop (cost=11,084.89..943,412.30 rows=83,005 width=399) (actual time=2,275.294..10,404.179 rows=15,403 loops=1)

  • Buffers: shared hit=2352473 read=131702
32. 45.344 10,224.130 ↑ 6.7 19,678 1

Nested Loop (cost=11,084.46..872,430.68 rows=131,397 width=272) (actual time=2,269.000..10,224.130 rows=19,678 loops=1)

  • Buffers: shared hit=2279830 read=129783
33. 21.838 9,978.458 ↑ 5.2 25,041 1

Append (cost=11,084.03..758,562.73 rows=131,154 width=264) (actual time=2,268.646..9,978.458 rows=25,041 loops=1)

  • Buffers: shared hit=2190794 read=128738
34. 11.412 4,356.651 ↑ 4.1 12,488 1

Subquery Scan on *SELECT* 1_1 (cost=11,084.03..147,749.40 rows=51,661 width=417) (actual time=2,268.645..4,356.651 rows=12,488 loops=1)

  • Buffers: shared hit=954369 read=60315
35. 18.188 4,345.239 ↑ 4.1 12,488 1

Hash Join (cost=11,084.03..147,232.79 rows=51,661 width=417) (actual time=2,268.643..4,345.239 rows=12,488 loops=1)

  • Hash Cond: (fe.field = fe_weight.id)
  • Buffers: shared hit=954369 read=60315
36. 12.756 4,326.983 ↑ 4.1 12,488 1

Nested Loop (cost=11,080.79..146,519.21 rows=51,661 width=417) (actual time=2,268.552..4,326.983 rows=12,488 loops=1)

  • Buffers: shared hit=954364 read=60315
37. 0.543 0.543 ↑ 1.0 1 1

CTE Scan on xde71d30_keyword_xq (cost=0.00..0.02 rows=1 width=64) (actual time=0.540..0.543 rows=1 loops=1)

  • Buffers: shared hit=38
38. 2,078.213 4,313.684 ↑ 4.1 12,488 1

Bitmap Heap Scan on keyword_field_entry fe (cost=11,080.79..146,002.58 rows=51,661 width=385) (actual time=2,268.004..4,313.684 rows=12,488 loops=1)

  • Recheck Cond: (index_vector @@ xde71d30_keyword_xq.tsq)
  • Rows Removed by Index Recheck: 101836
  • Filter: (id IS NOT NULL)
  • Heap Blocks: exact=107488
  • Buffers: shared hit=954326 read=60315
39. 2,235.471 2,235.471 ↓ 2.7 138,590 1

Bitmap Index Scan on metabib_keyword_field_entry_index_vector_idx (cost=0.00..11,067.88 rows=51,661 width=0) (actual time=2,235.471..2,235.471 rows=138,590 loops=1)

  • Index Cond: (index_vector @@ xde71d30_keyword_xq.tsq)
  • Buffers: shared hit=440911 read=372
40. 0.026 0.068 ↑ 1.0 55 1

Hash (cost=2.55..2.55 rows=55 width=8) (actual time=0.068..0.068 rows=55 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
  • Buffers: shared hit=2
41. 0.042 0.042 ↑ 1.0 55 1

Seq Scan on metabib_field fe_weight (cost=0.00..2.55 rows=55 width=8) (actual time=0.009..0.042 rows=55 loops=1)

  • Buffers: shared hit=2
42. 3.127 1,231.281 ↑ 5.6 3,590 1

Subquery Scan on *SELECT* 2 (cost=4,989.56..178,666.76 rows=20,221 width=161) (actual time=1,171.605..1,231.281 rows=3,590 loops=1)

  • Buffers: shared hit=75046 read=41280
43. 3.329 1,228.154 ↑ 5.6 3,590 1

Nested Loop (cost=4,989.56..178,464.55 rows=20,221 width=161) (actual time=1,171.603..1,228.154 rows=3,590 loops=1)

  • Buffers: shared hit=75046 read=41280
44. 0.020 0.020 ↑ 1.0 1 1

Seq Scan on metabib_field_virtual_map fe_weight_1 (cost=0.00..1.60 rows=1 width=8) (actual time=0.017..0.020 rows=1 loops=1)

  • Filter: ((virtual = 45) AND ("real" = 16))
  • Rows Removed by Filter: 39
  • Buffers: shared hit=1
45. 3.096 1,224.805 ↑ 5.6 3,590 1

Nested Loop (cost=4,989.56..178,260.74 rows=20,221 width=161) (actual time=1,171.581..1,224.805 rows=3,590 loops=1)

  • Buffers: shared hit=75045 read=41280
46. 0.003 0.003 ↑ 1.0 1 1

CTE Scan on xde71d30_keyword_xq xde71d30_keyword_xq_1 (cost=0.00..0.02 rows=1 width=64) (actual time=0.001..0.003 rows=1 loops=1)

47. 51.201 1,221.706 ↑ 5.6 3,590 1

Bitmap Heap Scan on subject_field_entry fe_1 (cost=4,989.56..178,058.51 rows=20,221 width=129) (actual time=1,171.574..1,221.706 rows=3,590 loops=1)

  • Recheck Cond: (index_vector @@ xde71d30_keyword_xq_1.tsq)
  • Rows Removed by Index Recheck: 27
  • Filter: ((id IS NOT NULL) AND (field = 16))
  • Rows Removed by Filter: 5559
  • Heap Blocks: exact=4998
  • Buffers: shared hit=75045 read=41280
48. 1,170.505 1,170.505 ↑ 8.7 9,226 1

Bitmap Index Scan on metabib_subject_field_entry_index_vector_idx (cost=0.00..4,984.50 rows=80,545 width=0) (actual time=1,170.505..1,170.505 rows=9,226 loops=1)

  • Index Cond: (index_vector @@ xde71d30_keyword_xq_1.tsq)
  • Buffers: shared hit=74916 read=36274
49. 0.073 753.431 ↑ 523.5 92 1

Subquery Scan on *SELECT* 3 (cost=6,122.04..192,432.26 rows=48,163 width=120) (actual time=750.534..753.431 rows=92 loops=1)

  • Buffers: shared hit=75146 read=8148
50. 0.105 753.358 ↑ 523.5 92 1

Nested Loop (cost=6,122.04..191,950.63 rows=48,163 width=120) (actual time=750.532..753.358 rows=92 loops=1)

  • Buffers: shared hit=75146 read=8148
51. 0.014 0.014 ↑ 1.0 1 1

Seq Scan on metabib_field_virtual_map fe_weight_2 (cost=0.00..1.60 rows=1 width=8) (actual time=0.010..0.014 rows=1 loops=1)

  • Filter: ((virtual = 45) AND ("real" = 8))
  • Rows Removed by Filter: 39
  • Buffers: shared hit=1
52. 0.077 753.239 ↑ 523.5 92 1

Nested Loop (cost=6,122.04..191,467.40 rows=48,163 width=120) (actual time=750.517..753.239 rows=92 loops=1)

  • Buffers: shared hit=75145 read=8148
53. 0.003 0.003 ↑ 1.0 1 1

CTE Scan on xde71d30_keyword_xq xde71d30_keyword_xq_2 (cost=0.00..0.02 rows=1 width=64) (actual time=0.001..0.003 rows=1 loops=1)

54. 2.750 753.159 ↑ 523.5 92 1

Bitmap Heap Scan on author_field_entry fe_2 (cost=6,122.04..190,985.75 rows=48,163 width=88) (actual time=750.509..753.159 rows=92 loops=1)

  • Recheck Cond: (index_vector @@ xde71d30_keyword_xq_2.tsq)
  • Rows Removed by Index Recheck: 59
  • Filter: ((id IS NOT NULL) AND (field = 8))
  • Rows Removed by Filter: 135
  • Heap Blocks: exact=230
  • Buffers: shared hit=75145 read=8148
55. 750.409 750.409 ↑ 234.6 388 1

Bitmap Index Scan on metabib_author_field_entry_index_vector_idx (cost=0.00..6,110.00 rows=91,011 width=0) (actual time=750.409..750.409 rows=388 loops=1)

  • Index Cond: (index_vector @@ xde71d30_keyword_xq_2.tsq)
  • Buffers: shared hit=74878 read=7969
56. 3.783 2,734.209 ↑ 2.3 3,957 1

Subquery Scan on *SELECT* 4 (cost=11,082.73..146,895.70 rows=9,041 width=417) (actual time=1,781.197..2,734.209 rows=3,957 loops=1)

  • Buffers: shared hit=1014623
57. 9.847 2,730.426 ↑ 2.3 3,957 1

Hash Join (cost=11,082.73..146,805.29 rows=9,041 width=417) (actual time=1,781.195..2,730.426 rows=3,957 loops=1)

  • Hash Cond: (fe_3.field = fe_weight_3."real")
  • Buffers: shared hit=1014623
58. 11.428 2,720.554 ↑ 4.1 12,488 1

Nested Loop (cost=11,080.79..146,519.21 rows=51,661 width=417) (actual time=1,776.343..2,720.554 rows=12,488 loops=1)

  • Buffers: shared hit=1014622
59. 0.003 0.003 ↑ 1.0 1 1

CTE Scan on xde71d30_keyword_xq xde71d30_keyword_xq_3 (cost=0.00..0.02 rows=1 width=64) (actual time=0.002..0.003 rows=1 loops=1)

60. 964.815 2,709.123 ↑ 4.1 12,488 1

Bitmap Heap Scan on keyword_field_entry fe_3 (cost=11,080.79..146,002.58 rows=51,661 width=385) (actual time=1,776.332..2,709.123 rows=12,488 loops=1)

  • Recheck Cond: (index_vector @@ xde71d30_keyword_xq_3.tsq)
  • Rows Removed by Index Recheck: 101836
  • Filter: (id IS NOT NULL)
  • Heap Blocks: exact=107488
  • Buffers: shared hit=1014622
61. 1,744.308 1,744.308 ↓ 2.7 138,590 1

Bitmap Index Scan on metabib_keyword_field_entry_index_vector_idx (cost=0.00..11,067.88 rows=51,661 width=0) (actual time=1,744.308..1,744.308 rows=138,590 loops=1)

  • Index Cond: (index_vector @@ xde71d30_keyword_xq_3.tsq)
  • Buffers: shared hit=441283
62. 0.006 0.025 ↑ 1.0 7 1

Hash (cost=1.85..1.85 rows=7 width=8) (actual time=0.025..0.025 rows=7 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=1
63. 0.019 0.019 ↑ 1.0 7 1

Seq Scan on metabib_field_virtual_map fe_weight_3 (cost=0.00..1.85 rows=7 width=8) (actual time=0.011..0.019 rows=7 loops=1)

  • Filter: ((virtual = 45) AND ("real" = ANY ('{39,41,42,46,47,48,50}'::integer[])))
  • Rows Removed by Filter: 33
  • Buffers: shared hit=1
64. 4.177 881.048 ↓ 2.4 4,914 1

Subquery Scan on *SELECT* 5 (cost=2,845.54..92,818.60 rows=2,068 width=151) (actual time=827.320..881.048 rows=4,914 loops=1)

  • Buffers: shared hit=71610 read=18995
65. 6.052 876.871 ↓ 2.4 4,914 1

Hash Join (cost=2,845.54..92,797.92 rows=2,068 width=151) (actual time=827.319..876.871 rows=4,914 loops=1)

  • Hash Cond: (fe_4.field = fe_weight_4."real")
  • Buffers: shared hit=71610 read=18995
66. 4.819 870.793 ↑ 7.5 5,522 1

Nested Loop (cost=2,843.92..92,620.54 rows=41,355 width=151) (actual time=827.274..870.793 rows=5,522 loops=1)

  • Buffers: shared hit=71609 read=18995
67. 0.002 0.002 ↑ 1.0 1 1

CTE Scan on xde71d30_keyword_xq xde71d30_keyword_xq_4 (cost=0.00..0.02 rows=1 width=64) (actual time=0.001..0.002 rows=1 loops=1)

68. 39.467 865.972 ↑ 7.5 5,522 1

Bitmap Heap Scan on title_field_entry fe_4 (cost=2,843.92..92,206.97 rows=41,355 width=119) (actual time=827.264..865.972 rows=5,522 loops=1)

  • Recheck Cond: (index_vector @@ xde71d30_keyword_xq_4.tsq)
  • Rows Removed by Index Recheck: 22
  • Filter: (id IS NOT NULL)
  • Heap Blocks: exact=3688
  • Buffers: shared hit=71609 read=18995
69. 826.505 826.505 ↑ 6.9 5,988 1

Bitmap Index Scan on metabib_title_field_entry_index_vector_idx (cost=0.00..2,833.58 rows=41,355 width=0) (actual time=826.505..826.505 rows=5,988 loops=1)

  • Index Cond: (index_vector @@ xde71d30_keyword_xq_4.tsq)
  • Buffers: shared hit=71399 read=15391
70. 0.009 0.026 ↑ 1.0 2 1

Hash (cost=1.60..1.60 rows=2 width=8) (actual time=0.026..0.026 rows=2 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=1
71. 0.017 0.017 ↑ 1.0 2 1

Seq Scan on metabib_field_virtual_map fe_weight_4 (cost=0.00..1.60 rows=2 width=8) (actual time=0.015..0.017 rows=2 loops=1)

  • Filter: (("real" = ANY ('{6,53}'::integer[])) AND (virtual = 45))
  • Rows Removed by Filter: 38
  • Buffers: shared hit=1
72. 200.328 200.328 ↑ 1.0 1 25,041

Index Only Scan using metabib_metarecord_source_map_source_record_idx on metarecord_source_map m (cost=0.43..0.86 rows=1 width=8) (actual time=0.007..0.008 rows=1 loops=25,041)

  • Index Cond: (source = "*SELECT* 1_1".source)
  • Heap Fetches: 14680
  • Buffers: shared hit=89036 read=1045
73. 137.746 137.746 ↑ 1.0 1 19,678

Index Scan using record_attr_vector_list_pkey on record_attr_vector_list mrv (cost=0.43..0.53 rows=1 width=127) (actual time=0.007..0.007 rows=1 loops=19,678)

  • Index Cond: (source = m.source)
  • Buffers: shared hit=72643 read=1919
74. 138.627 138.627 ↑ 1.0 1 15,403

Index Scan using record_entry_pkey on record_entry bre (cost=0.43..1.46 rows=1 width=31) (actual time=0.008..0.009 rows=1 loops=15,403)

  • Index Cond: (id = m.source)
  • Filter: (NOT deleted)
  • Rows Removed by Filter: 0
  • Buffers: shared hit=57341 read=4396
75. 15.243 15.243 ↓ 0.0 0 15,243

CTE Scan on pop_with (cost=0.00..0.16 rows=8 width=72) (actual time=0.001..0.001 rows=0 loops=15,243)

  • Buffers: shared hit=2
76. 137.187 137.187 ↑ 2.0 1 15,243

Index Scan using metabib_sorter_source_idx on record_sorter pubdate_t (cost=0.43..0.76 rows=2 width=24) (actual time=0.008..0.009 rows=1 loops=15,243)

  • Index Cond: (m.source = source)
  • Filter: (attr = 'pubdate'::text)
  • Rows Removed by Filter: 2
  • Buffers: shared hit=58560 read=3146
77.          

SubPlan (forNested Loop)

78. 304.860 304.860 ↑ 1.0 1 15,243

Index Scan using copy_vis_attr_cache_record_idx on copy_vis_attr_cache (cost=0.43..18.43 rows=1 width=0) (actual time=0.020..0.020 rows=1 loops=15,243)

  • Index Cond: (record = m.source)
  • Filter: (vis_attr_vector @@ c_attr.vis_test)
  • Rows Removed by Filter: 0
  • Buffers: shared hit=60500 read=1294
79. 0.964 11,339.114 ↑ 1.0 1,000 1

Subquery Scan on *SELECT* 1 (cost=0.00..30.00 rows=1,000 width=112) (actual time=11,334.079..11,339.114 rows=1,000 loops=1)

  • Buffers: shared hit=2547965 read=140538
80. 0.757 11,338.150 ↑ 1.0 1,000 1

Limit (cost=0.00..20.00 rows=1,000 width=112) (actual time=11,334.063..11,338.150 rows=1,000 loops=1)

  • Buffers: shared hit=2547965 read=140538
81. 11,337.393 11,337.393 ↑ 20.3 1,000 1

CTE Scan on w (cost=0.00..405.78 rows=20,289 width=112) (actual time=11,334.060..11,337.393 rows=1,000 loops=1)

  • Buffers: shared hit=2547965 read=140538
82. 1.446 10.343 ↑ 1.0 1 1

Aggregate (cost=557.95..557.96 rows=1 width=0) (actual time=10.343..10.343 rows=1 loops=1)

83. 8.897 8.897 ↑ 5.7 3,552 1

CTE Scan on w w_1 (cost=0.00..405.78 rows=20,289 width=0) (actual time=0.001..8.897 rows=3,552 loops=1)

Planning time : 111.227 ms
Execution time : 11,354.367 ms