explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ZCJi

Settings
# exclusive inclusive rows x rows loops node
1. 0.021 34,494.539 ↑ 200.0 1 1

Hash Left Join (cost=6,556,133.37..6,556,642.13 rows=200 width=120) (actual time=34,494.537..34,494.539 rows=1 loops=1)

  • Hash Cond: (f.multi_series = f_1.multi_series)
2.          

CTE step_0

3. 93.006 4,821.651 ↓ 115.6 115,058 1

Subquery Scan on innerq (cost=1,014,039.61..1,020,504.12 rows=995 width=86) (actual time=4,360.688..4,821.651 rows=115,058 loops=1)

  • Filter: (innerq.rn = 1)
  • Rows Removed by Filter: 172804
4. 283.038 4,728.645 ↓ 1.4 287,862 1

WindowAgg (cost=1,014,039.61..1,018,017.77 rows=198,908 width=86) (actual time=4,360.686..4,728.645 rows=287,862 loops=1)

5. 362.380 4,445.607 ↓ 1.4 287,862 1

Sort (cost=1,014,039.61..1,014,536.88 rows=198,908 width=46) (actual time=4,360.659..4,445.607 rows=287,862 loops=1)

  • Sort Key: o.person_id, o.timestamp_
  • Sort Method: quicksort Memory: 34778kB
6. 140.280 4,083.227 ↓ 1.4 287,862 1

Result (cost=0.00..996,533.97 rows=198,908 width=46) (actual time=0.734..4,083.227 rows=287,862 loops=1)

7. 124.848 3,942.947 ↓ 1.4 287,862 1

Append (cost=0.00..994,544.89 rows=198,908 width=46) (actual time=0.733..3,942.947 rows=287,862 loops=1)

8. 0.006 0.006 ↓ 0.0 0 1

Seq Scan on event_page_ace8b421_634f_4060_9118_ffc36db704dc o (cost=0.00..0.00 rows=1 width=90) (actual time=0.005..0.006 rows=0 loops=1)

  • Filter: ((timestamp_ >= '2018-01-01 07:00:00'::timestamp without time zone) AND (timestamp_ <= '2018-03-12 05:59:59.999'::timestamp without time zone) AND ((location_host)::text ~~ '2017.hrblockonline.ca'::text) AND ((location_path)::text ~~ '/'::text) AND ((location_fragment)::text ~~ '/quick-entry/section'::text))
9. 153.396 153.396 ↓ 2.2 11,988 1

Index Only Scan using ep_ace8b421_634f_4060_9118_ffc36db704dc_2018_1_location on event_page_ace8b421_634f_4060_9118_ffc36db704dc_2018_1 o_1 (cost=0.55..19,250.52 rows=5,513 width=46) (actual time=0.726..153.396 rows=11,988 loops=1)

  • Index Cond: ((location_host = '2017.hrblockonline.ca'::text) AND (location_path = '/'::text) AND (location_fragment = '/quick-entry/section'::text) AND (timestamp_ >= '2018-01-01 07:00:00'::timestamp without time zone) AND (timestamp_ <= '2018-03-12 05:59:59.999'::timestamp without time zone))
  • Filter: (((location_host)::text ~~ '2017.hrblockonline.ca'::text) AND ((location_path)::text ~~ '/'::text) AND ((location_fragment)::text ~~ '/quick-entry/section'::text))
  • Heap Fetches: 0
10. 1,239.153 1,239.153 ↓ 1.5 134,494 1

Index Only Scan using ep_ace8b421_634f_4060_9118_ffc36db704dc_2018_2_location on event_page_ace8b421_634f_4060_9118_ffc36db704dc_2018_2 o_2 (cost=0.68..273,061.28 rows=89,014 width=46) (actual time=4.462..1,239.153 rows=134,494 loops=1)

  • Index Cond: ((location_host = '2017.hrblockonline.ca'::text) AND (location_path = '/'::text) AND (location_fragment = '/quick-entry/section'::text) AND (timestamp_ >= '2018-01-01 07:00:00'::timestamp without time zone) AND (timestamp_ <= '2018-03-12 05:59:59.999'::timestamp without time zone))
  • Filter: (((location_host)::text ~~ '2017.hrblockonline.ca'::text) AND ((location_path)::text ~~ '/'::text) AND ((location_fragment)::text ~~ '/quick-entry/section'::text))
  • Heap Fetches: 0
11. 2,425.544 2,425.544 ↓ 1.4 141,380 1

Index Only Scan using ep_ace8b421_634f_4060_9118_ffc36db704dc_2018_3_location on event_page_ace8b421_634f_4060_9118_ffc36db704dc_2018_3 o_3 (cost=0.81..702,233.10 rows=104,380 width=46) (actual time=16.529..2,425.544 rows=141,380 loops=1)

  • Index Cond: ((location_host = '2017.hrblockonline.ca'::text) AND (location_path = '/'::text) AND (location_fragment = '/quick-entry/section'::text) AND (timestamp_ >= '2018-01-01 07:00:00'::timestamp without time zone) AND (timestamp_ <= '2018-03-12 05:59:59.999'::timestamp without time zone))
  • Filter: (((location_host)::text ~~ '2017.hrblockonline.ca'::text) AND ((location_path)::text ~~ '/'::text) AND ((location_fragment)::text ~~ '/quick-entry/section'::text))
  • Heap Fetches: 20
12.          

CTE step_1

13. 116.956 3,663.151 ↓ 1.5 294,640 1

Append (cost=0.00..994,556.55 rows=199,574 width=46) (actual time=0.438..3,663.151 rows=294,640 loops=1)

14. 0.006 0.006 ↓ 0.0 0 1

Seq Scan on event_page_ace8b421_634f_4060_9118_ffc36db704dc o_4 (cost=0.00..0.00 rows=1 width=90) (actual time=0.005..0.006 rows=0 loops=1)

  • Filter: ((timestamp_ >= '2018-01-01 07:00:00'::timestamp without time zone) AND (timestamp_ <= '2018-03-12 05:59:59.999'::timestamp without time zone) AND ((location_host)::text ~~ '2017.hrblockonline.ca'::text) AND ((location_path)::text ~~ '/'::text) AND ((location_fragment)::text ~~ '/quick-entry/import/afr-choice'::text))
15. 93.592 93.592 ↓ 2.3 11,351 1

Index Only Scan using ep_ace8b421_634f_4060_9118_ffc36db704dc_2018_1_location on event_page_ace8b421_634f_4060_9118_ffc36db704dc_2018_1 o_5 (cost=0.55..19,240.56 rows=4,944 width=46) (actual time=0.431..93.592 rows=11,351 loops=1)

  • Index Cond: ((location_host = '2017.hrblockonline.ca'::text) AND (location_path = '/'::text) AND (location_fragment = '/quick-entry/import/afr-choice'::text) AND (timestamp_ >= '2018-01-01 07:00:00'::timestamp without time zone) AND (timestamp_ <= '2018-03-12 05:59:59.999'::timestamp without time zone))
  • Filter: (((location_host)::text ~~ '2017.hrblockonline.ca'::text) AND ((location_path)::text ~~ '/'::text) AND ((location_fragment)::text ~~ '/quick-entry/import/afr-choice'::text))
  • Heap Fetches: 0
16. 1,075.054 1,075.054 ↓ 1.5 139,245 1

Index Only Scan using ep_ace8b421_634f_4060_9118_ffc36db704dc_2018_2_location on event_page_ace8b421_634f_4060_9118_ffc36db704dc_2018_2 o_6 (cost=0.68..273,083.29 rows=90,272 width=46) (actual time=2.630..1,075.054 rows=139,245 loops=1)

  • Index Cond: ((location_host = '2017.hrblockonline.ca'::text) AND (location_path = '/'::text) AND (location_fragment = '/quick-entry/import/afr-choice'::text) AND (timestamp_ >= '2018-01-01 07:00:00'::timestamp without time zone) AND (timestamp_ <= '2018-03-12 05:59:59.999'::timestamp without time zone))
  • Filter: (((location_host)::text ~~ '2017.hrblockonline.ca'::text) AND ((location_path)::text ~~ '/'::text) AND ((location_fragment)::text ~~ '/quick-entry/import/afr-choice'::text))
  • Heap Fetches: 0
17. 2,377.543 2,377.543 ↓ 1.4 144,044 1

Index Only Scan using ep_ace8b421_634f_4060_9118_ffc36db704dc_2018_3_location on event_page_ace8b421_634f_4060_9118_ffc36db704dc_2018_3 o_7 (cost=0.81..702,232.70 rows=104,357 width=46) (actual time=14.923..2,377.543 rows=144,044 loops=1)

  • Index Cond: ((location_host = '2017.hrblockonline.ca'::text) AND (location_path = '/'::text) AND (location_fragment = '/quick-entry/import/afr-choice'::text) AND (timestamp_ >= '2018-01-01 07:00:00'::timestamp without time zone) AND (timestamp_ <= '2018-03-12 05:59:59.999'::timestamp without time zone))
  • Filter: (((location_host)::text ~~ '2017.hrblockonline.ca'::text) AND ((location_path)::text ~~ '/'::text) AND ((location_fragment)::text ~~ '/quick-entry/import/afr-choice'::text))
  • Heap Fetches: 28
18.          

CTE step_2

19. 687.184 6,607.145 ↓ 1.5 1,785,092 1

Append (cost=0.00..1,053,669.28 rows=1,209,602 width=46) (actual time=0.476..6,607.145 rows=1,785,092 loops=1)

20. 0.006 0.006 ↓ 0.0 0 1

Seq Scan on event_page_ace8b421_634f_4060_9118_ffc36db704dc o_8 (cost=0.00..0.00 rows=1 width=90) (actual time=0.006..0.006 rows=0 loops=1)

  • Filter: ((timestamp_ >= '2018-01-01 07:00:00'::timestamp without time zone) AND (timestamp_ <= '2018-03-12 05:59:59.999'::timestamp without time zone) AND ((location_host)::text ~~ '2017.hrblockonline.ca'::text) AND ((location_path)::text ~~ '/'::text) AND ((location_fragment)::text ~~ '/quick-entry/add%'::text))
21. 156.386 156.386 ↓ 2.2 55,921 1

Index Only Scan using ep_ace8b421_634f_4060_9118_ffc36db704dc_2018_1_location on event_page_ace8b421_634f_4060_9118_ffc36db704dc_2018_1 o_9 (cost=0.55..20,507.42 rows=25,022 width=46) (actual time=0.469..156.386 rows=55,921 loops=1)

  • Index Cond: ((location_host = '2017.hrblockonline.ca'::text) AND (location_path = '/'::text) AND (location_fragment ~>=~ '/quick-entry/add'::text) AND (location_fragment ~<~ '/quick-entry/ade'::text) AND (timestamp_ >= '2018-01-01 07:00:00'::timestamp without time zone) AND (timestamp_ <= '2018-03-12 05:59:59.999'::timestamp without time zone))
  • Filter: (((location_host)::text ~~ '2017.hrblockonline.ca'::text) AND ((location_path)::text ~~ '/'::text) AND ((location_fragment)::text ~~ '/quick-entry/add%'::text))
  • Heap Fetches: 3
22. 1,955.732 1,955.732 ↓ 1.6 821,006 1

Index Only Scan using ep_ace8b421_634f_4060_9118_ffc36db704dc_2018_2_location on event_page_ace8b421_634f_4060_9118_ffc36db704dc_2018_2 o_10 (cost=0.68..292,161.90 rows=529,095 width=46) (actual time=2.637..1,955.732 rows=821,006 loops=1)

  • Index Cond: ((location_host = '2017.hrblockonline.ca'::text) AND (location_path = '/'::text) AND (location_fragment ~>=~ '/quick-entry/add'::text) AND (location_fragment ~<~ '/quick-entry/ade'::text) AND (timestamp_ >= '2018-01-01 07:00:00'::timestamp without time zone) AND (timestamp_ <= '2018-03-12 05:59:59.999'::timestamp without time zone))
  • Filter: (((location_host)::text ~~ '2017.hrblockonline.ca'::text) AND ((location_path)::text ~~ '/'::text) AND ((location_fragment)::text ~~ '/quick-entry/add%'::text))
  • Heap Fetches: 0
23. 3,807.837 3,807.837 ↓ 1.4 908,165 1

Index Only Scan using ep_ace8b421_634f_4060_9118_ffc36db704dc_2018_3_location on event_page_ace8b421_634f_4060_9118_ffc36db704dc_2018_3 o_11 (cost=0.81..740,999.97 rows=655,484 width=46) (actual time=14.599..3,807.837 rows=908,165 loops=1)

  • Index Cond: ((location_host = '2017.hrblockonline.ca'::text) AND (location_path = '/'::text) AND (location_fragment ~>=~ '/quick-entry/add'::text) AND (location_fragment ~<~ '/quick-entry/ade'::text) AND (timestamp_ >= '2018-01-01 07:00:00'::timestamp without time zone) AND (timestamp_ <= '2018-03-12 05:59:59.999'::timestamp without time zone))
  • Filter: (((location_host)::text ~~ '2017.hrblockonline.ca'::text) AND ((location_path)::text ~~ '/'::text) AND ((location_fragment)::text ~~ '/quick-entry/add%'::text))
  • Heap Fetches: 143
24.          

CTE step_3

25. 148.636 3,780.541 ↓ 1.5 366,279 1

Append (cost=0.00..995,295.56 rows=241,803 width=46) (actual time=0.384..3,780.541 rows=366,279 loops=1)

26. 0.008 0.008 ↓ 0.0 0 1

Seq Scan on event_page_ace8b421_634f_4060_9118_ffc36db704dc o_12 (cost=0.00..0.00 rows=1 width=90) (actual time=0.008..0.008 rows=0 loops=1)

  • Filter: ((timestamp_ >= '2018-01-01 07:00:00'::timestamp without time zone) AND (timestamp_ <= '2018-03-12 05:59:59.999'::timestamp without time zone) AND ((location_host)::text ~~ '2017.hrblockonline.ca'::text) AND ((location_path)::text ~~ '/'::text) AND ((location_fragment)::text ~~ '/prepare/your-year'::text))
27. 92.863 92.863 ↓ 3.0 12,203 1

Index Only Scan using ep_ace8b421_634f_4060_9118_ffc36db704dc_2018_1_location on event_page_ace8b421_634f_4060_9118_ffc36db704dc_2018_1 o_13 (cost=0.55..19,224.30 rows=4,015 width=46) (actual time=0.374..92.863 rows=12,203 loops=1)

  • Index Cond: ((location_host = '2017.hrblockonline.ca'::text) AND (location_path = '/'::text) AND (location_fragment = '/prepare/your-year'::text) AND (timestamp_ >= '2018-01-01 07:00:00'::timestamp without time zone) AND (timestamp_ <= '2018-03-12 05:59:59.999'::timestamp without time zone))
  • Filter: (((location_host)::text ~~ '2017.hrblockonline.ca'::text) AND ((location_path)::text ~~ '/'::text) AND ((location_fragment)::text ~~ '/prepare/your-year'::text))
  • Heap Fetches: 1
28. 1,105.692 1,105.692 ↓ 1.6 168,852 1

Index Only Scan using ep_ace8b421_634f_4060_9118_ffc36db704dc_2018_2_location on event_page_ace8b421_634f_4060_9118_ffc36db704dc_2018_2 o_14 (cost=0.68..273,360.37 rows=106,105 width=46) (actual time=2.056..1,105.692 rows=168,852 loops=1)

  • Index Cond: ((location_host = '2017.hrblockonline.ca'::text) AND (location_path = '/'::text) AND (location_fragment = '/prepare/your-year'::text) AND (timestamp_ >= '2018-01-01 07:00:00'::timestamp without time zone) AND (timestamp_ <= '2018-03-12 05:59:59.999'::timestamp without time zone))
  • Filter: (((location_host)::text ~~ '2017.hrblockonline.ca'::text) AND ((location_path)::text ~~ '/'::text) AND ((location_fragment)::text ~~ '/prepare/your-year'::text))
  • Heap Fetches: 0
29. 2,433.342 2,433.342 ↓ 1.4 185,224 1

Index Only Scan using ep_ace8b421_634f_4060_9118_ffc36db704dc_2018_3_location on event_page_ace8b421_634f_4060_9118_ffc36db704dc_2018_3 o_15 (cost=0.81..702,710.89 rows=131,682 width=46) (actual time=11.208..2,433.342 rows=185,224 loops=1)

  • Index Cond: ((location_host = '2017.hrblockonline.ca'::text) AND (location_path = '/'::text) AND (location_fragment = '/prepare/your-year'::text) AND (timestamp_ >= '2018-01-01 07:00:00'::timestamp without time zone) AND (timestamp_ <= '2018-03-12 05:59:59.999'::timestamp without time zone))
  • Filter: (((location_host)::text ~~ '2017.hrblockonline.ca'::text) AND ((location_path)::text ~~ '/'::text) AND ((location_fragment)::text ~~ '/prepare/your-year'::text))
  • Heap Fetches: 36
30.          

CTE join1

31. 319.168 10,134.216 ↑ 1.1 294,860 1

WindowAgg (cost=69,353.28..75,972.48 rows=330,960 width=220) (actual time=9,746.216..10,134.216 rows=294,860 loops=1)

32. 333.845 9,815.048 ↑ 1.1 294,860 1

Sort (cost=69,353.28..70,180.68 rows=330,960 width=212) (actual time=9,746.191..9,815.048 rows=294,860 loops=1)

  • Sort Key: s1.person_id, s1.step_ts_min
  • Sort Method: quicksort Memory: 53753kB
33. 264.434 9,481.203 ↑ 1.1 294,860 1

Merge Left Join (cost=21,629.99..39,010.38 rows=330,960 width=212) (actual time=9,090.982..9,481.203 rows=294,860 loops=1)

  • Merge Cond: (s0.person_id = s1.person_id)
  • Join Filter: (s0.step_ts_min < s1.step_ts_min)
  • Rows Removed by Join Filter: 340
34. 89.502 5,008.901 ↓ 115.6 115,058 1

Sort (cost=69.44..71.93 rows=995 width=122) (actual time=4,977.993..5,008.901 rows=115,058 loops=1)

  • Sort Key: s0.person_id
  • Sort Method: quicksort Memory: 19253kB
35. 4,919.399 4,919.399 ↓ 115.6 115,058 1

CTE Scan on step_0 s0 (cost=0.00..19.90 rows=995 width=122) (actual time=4,360.691..4,919.399 rows=115,058 loops=1)

36. 320.643 4,207.868 ↓ 1.5 294,657 1

Sort (cost=21,560.54..22,059.48 rows=199,574 width=90) (actual time=4,112.978..4,207.868 rows=294,657 loops=1)

  • Sort Key: s1.person_id
  • Sort Method: quicksort Memory: 35307kB
37. 3,887.225 3,887.225 ↓ 1.5 294,640 1

CTE Scan on step_1 s1 (cost=0.00..3,991.48 rows=199,574 width=90) (actual time=0.442..3,887.225 rows=294,640 loops=1)

38.          

CTE join2

39. 2,292.811 25,998.311 ↑ 1.9 1,764,272 1

WindowAgg (cost=690,614.15..757,343.87 rows=3,336,486 width=318) (actual time=23,197.066..25,998.311 rows=1,764,272 loops=1)

40. 2,407.850 23,705.500 ↑ 1.9 1,764,272 1

Sort (cost=690,614.15..698,955.37 rows=3,336,486 width=310) (actual time=23,197.039..23,705.500 rows=1,764,272 loops=1)

  • Sort Key: s2.person_id, s2.step_ts_min
  • Sort Method: quicksort Memory: 517688kB
41. 1,232.468 21,297.650 ↑ 1.9 1,764,272 1

Merge Left Join (cost=153,933.82..329,107.59 rows=3,336,486 width=310) (actual time=19,535.238..21,297.650 rows=1,764,272 loops=1)

  • Merge Cond: (s1_1.p1 = s2.person_id)
  • Join Filter: (s1_1.t1 < s2.step_ts_min)
  • Rows Removed by Join Filter: 9982
42. 83.475 10,448.879 ↓ 69.5 115,067 1

Sort (cost=7,535.08..7,539.22 rows=1,655 width=220) (actual time=10,421.977..10,448.879 rows=115,067 loops=1)

  • Sort Key: s1_1.p1
  • Sort Method: quicksort Memory: 19254kB
43. 10,365.404 10,365.404 ↓ 69.5 115,067 1

CTE Scan on join1 s1_1 (cost=0.00..7,446.60 rows=1,655 width=220) (actual time=9,746.221..10,365.404 rows=115,067 loops=1)

  • Filter: (rank1 = 1)
  • Rows Removed by Filter: 179793
44. 1,737.487 9,616.303 ↓ 1.5 1,785,532 1

Sort (cost=146,398.74..149,422.75 rows=1,209,602 width=90) (actual time=9,113.248..9,616.303 rows=1,785,532 loops=1)

  • Sort Key: s2.person_id
  • Sort Method: quicksort Memory: 188613kB
45. 7,878.816 7,878.816 ↓ 1.5 1,785,092 1

CTE Scan on step_2 s2 (cost=0.00..24,192.04 rows=1,209,602 width=90) (actual time=0.481..7,878.816 rows=1,785,092 loops=1)

46.          

CTE join3

47. 408.234 33,369.740 ↑ 18.2 368,509 1

WindowAgg (cost=1,218,137.77..1,352,596.35 rows=6,722,929 width=506) (actual time=32,870.592..33,369.740 rows=368,509 loops=1)

48. 455.333 32,961.506 ↑ 18.2 368,509 1

Sort (cost=1,218,137.77..1,234,945.10 rows=6,722,929 width=408) (actual time=32,870.563..32,961.506 rows=368,509 loops=1)

  • Sort Key: s3.person_id, s3.step_ts_min
  • Sort Method: quicksort Memory: 110075kB
49. 288.343 32,506.173 ↑ 18.2 368,509 1

Merge Left Join (cost=102,698.29..455,735.49 rows=6,722,929 width=408) (actual time=32,087.259..32,506.173 rows=368,509 loops=1)

  • Merge Cond: (s2_1.p2 = s3.person_id)
  • Join Filter: (s2_1.t2 < s3.step_ts_min)
  • Rows Removed by Join Filter: 3243
50. 115.686 27,779.856 ↓ 6.9 115,081 1

Sort (cost=76,240.84..76,282.55 rows=16,682 width=318) (actual time=27,753.015..27,779.856 rows=115,081 loops=1)

  • Sort Key: s2_1.p2
  • Sort Method: quicksort Memory: 33542kB
51. 27,664.170 27,664.170 ↓ 6.9 115,081 1

CTE Scan on join2 s2_1 (cost=0.00..75,070.93 rows=16,682 width=318) (actual time=23,197.072..27,664.170 rows=115,081 loops=1)

  • Filter: (rank2 = 1)
  • Rows Removed by Filter: 1649191
52. 376.701 4,437.974 ↓ 1.5 366,617 1

Sort (cost=26,457.45..27,061.95 rows=241,803 width=90) (actual time=4,334.232..4,437.974 rows=366,617 loops=1)

  • Sort Key: s3.person_id
  • Sort Method: quicksort Memory: 40904kB
53. 4,061.273 4,061.273 ↓ 1.5 366,279 1

CTE Scan on step_3 s3 (cost=0.00..4,836.06 rows=241,803 width=90) (actual time=0.387..4,061.273 rows=366,279 loops=1)

54. 203.196 34,175.598 ↑ 200.0 1 1

GroupAggregate (cost=153,793.22..154,299.44 rows=200 width=64) (actual time=34,175.597..34,175.598 rows=1 loops=1)

  • Group Key: f.multi_series
55. 85.578 33,972.402 ↓ 3.4 115,097 1

Sort (cost=153,793.22..153,877.25 rows=33,615 width=96) (actual time=33,947.217..33,972.402 rows=115,097 loops=1)

  • Sort Key: f.multi_series
  • Sort Method: quicksort Memory: 19134kB
56. 33,886.824 33,886.824 ↓ 3.4 115,097 1

CTE Scan on join3 f (cost=0.00..151,265.90 rows=33,615 width=96) (actual time=32,870.600..33,886.824 rows=115,097 loops=1)

  • Filter: (rank3 = 1)
  • Rows Removed by Filter: 253412
57. 0.016 318.920 ↑ 200.0 1 1

Hash (cost=152,399.44..152,399.44 rows=200 width=56) (actual time=318.920..318.920 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
58. 62.657 318.904 ↑ 200.0 1 1

HashAggregate (cost=152,394.94..152,397.44 rows=200 width=56) (actual time=318.903..318.904 rows=1 loops=1)

  • Group Key: f_1.multi_series
59. 142.090 256.247 ↓ 4.7 107,492 1

HashAggregate (cost=151,600.37..151,940.90 rows=22,702 width=56) (actual time=183.081..256.247 rows=107,492 loops=1)

  • Group Key: f_1.multi_series, f_1.p0
60. 114.157 114.157 ↓ 3.2 107,534 1

CTE Scan on join3 f_1 (cost=0.00..151,265.90 rows=33,447 width=64) (actual time=0.004..114.157 rows=107,534 loops=1)

  • Filter: ((p3 IS NOT NULL) AND (rank3 = 1))
  • Rows Removed by Filter: 260975