explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ATDs

Settings
# exclusive inclusive rows x rows loops node
1. 0.026 10,035.650 ↑ 1.0 400 1

Limit (cost=2,530,829.66..2,530,830.66 rows=400 width=27) (actual time=10,035.599..10,035.650 rows=400 loops=1)

2.          

CTE docd_cte_0

3. 1.174 34.058 ↑ 2.1 616 1

Unique (cost=18,964.47..18,976.83 rows=1,278 width=4) (actual time=31.491..34.058 rows=616 loops=1)

4. 5.075 32.884 ↓ 8.3 20,437 1

Sort (cost=18,964.47..18,970.65 rows=2,472 width=4) (actual time=31.489..32.884 rows=20,437 loops=1)

  • Sort Key: t564_distinctcdo_opp_closedate_ownerid.c1890_ownerid
  • Sort Method: quicksort Memory: 1726kB
5. 3.252 27.809 ↓ 8.3 20,437 1

Nested Loop (cost=8,130.87..18,825.15 rows=2,472 width=4) (actual time=15.870..27.809 rows=20,437 loops=1)

6. 1.195 16.421 ↓ 1.1 2,712 1

HashAggregate (cost=8,130.45..8,154.58 rows=2,413 width=4) (actual time=15.855..16.421 rows=2,712 loops=1)

  • Group Key: t398_userrolehierarchy.sid
7. 0.226 15.226 ↓ 1.3 3,114 1

Append (cost=1,616.97..8,124.42 rows=2,413 width=4) (actual time=3.108..15.226 rows=3,114 loops=1)

8. 3.950 14.807 ↓ 1.3 3,005 1

Hash Semi Join (cost=1,616.97..7,842.89 rows=2,402 width=4) (actual time=3.108..14.807 rows=3,005 loops=1)

  • Hash Cond: (t398_userrolehierarchy.c1390_user_role_id = t629_userroledim.sid)
9. 8.124 10.539 ↓ 1.1 22,943 1

Bitmap Heap Scan on t398_userrolehierarchy (cost=1,092.36..7,223.21 rows=21,457 width=8) (actual time=2.759..10.539 rows=22,943 loops=1)

  • Recheck Cond: ((c1391_ancestor_role_id = 30) AND (end_stamp = '32503680000000'::bigint))
  • Heap Blocks: exact=2657
10. 2.415 2.415 ↓ 1.1 22,959 1

Bitmap Index Scan on idx_t398_userrolehierarchy_c1391_ancestor_role_id_end_s36986549 (cost=0.00..1,086.99 rows=21,457 width=0) (actual time=2.415..2.415 rows=22,959 loops=1)

  • Index Cond: ((c1391_ancestor_role_id = 30) AND (end_stamp = '32503680000000'::bigint))
11. 0.042 0.318 ↑ 2.5 331 1

Hash (cost=514.13..514.13 rows=839 width=4) (actual time=0.318..0.318 rows=331 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 20kB
12. 0.212 0.276 ↑ 2.5 331 1

Bitmap Heap Scan on t629_userroledim (cost=41.14..514.13 rows=839 width=4) (actual time=0.080..0.276 rows=331 loops=1)

  • Recheck Cond: ((end_stamp = '32503680000000'::bigint) AND ((c1972_portaltype IS NULL) OR (c1972_portaltype = 'None'::text)))
  • Filter: ((NOT deleted) AND (sid <> '-2'::integer))
  • Rows Removed by Filter: 190
  • Heap Blocks: exact=41
13. 0.064 0.064 ↑ 1.6 521 1

Bitmap Index Scan on idx_6_t629_userroledim_sid_timestamp_partial (cost=0.00..40.93 rows=852 width=0) (actual time=0.064..0.064 rows=521 loops=1)

  • Index Cond: (end_stamp = '32503680000000'::bigint)
14. 0.162 0.193 ↓ 9.9 109 1

Bitmap Heap Scan on t628_userdim (cost=5.12..257.40 rows=11 width=4) (actual time=0.053..0.193 rows=109 loops=1)

  • Recheck Cond: ((c1951_userroleid IS NULL) AND (end_stamp = '32503680000000'::bigint))
  • Filter: ((NOT deleted) AND (sid <> '-2'::integer) AND (c1954_usertype = 'Standard'::text))
  • Rows Removed by Filter: 12
  • Heap Blocks: exact=73
15. 0.031 0.031 ↓ 1.7 121 1

Bitmap Index Scan on idx_8_t628_userdim_c1951_userroleid_end_stamp_start_stamp_null (cost=0.00..5.12 rows=70 width=0) (actual time=0.031..0.031 rows=121 loops=1)

  • Index Cond: ((c1951_userroleid IS NULL) AND (end_stamp = '32503680000000'::bigint))
16. 8.136 8.136 ↓ 2.0 8 2,712

Index Only Scan using t564_distinctcdo_opp_closedate_ownerid__distinct_unique on t564_distinctcdo_opp_closedate_ownerid (cost=0.42..4.37 rows=4 width=4) (actual time=0.003..0.003 rows=8 loops=2,712)

  • Index Cond: ((c1890_ownerid = t398_userrolehierarchy.sid) AND (c1891_closedate >= 20191001) AND (c1891_closedate <= 20191231))
  • Heap Fetches: 834
17.          

CTE picklist_1

18. 0.021 0.021 ↑ 1.0 2 1

Seq Scan on t563_opportunitystagenamepicklistdim (cost=0.00..5.81 rows=2 width=4) (actual time=0.011..0.021 rows=2 loops=1)

  • Filter: (correlated_value = ANY ('{"Closed Won","Trial Won"}'::text[]))
  • Rows Removed by Filter: 63
19.          

CTE picklist_2

20. 0.032 0.032 ↑ 1.1 17 1

Seq Scan on t563_opportunitystagenamepicklistdim t563_opportunitystagenamepicklistdim_1 (cost=0.00..7.11 rows=18 width=4) (actual time=0.007..0.032 rows=17 loops=1)

  • Filter: (correlated_value = ANY ('{"10 - Disqualified","16 - Closed / Invalid or Duplicate Oppty","Closed - Dead","Closed - Call later","16 - Closed / Invalid or Duplicate Oppor","13 \\u2013 Closed / Lost to No Decision",Churn,"12 - Closed / Lost to Competition","14 - Closed / Mid Cycle Qualify Ou","Trial Lost","Closed Lost","15 - Closed / Lost to Churn","14 - Closed / Mid Cycle Qualify Out","13 - Closed / Lost to No Decision","Stage 16 - Closed / Invalid or Duplicate","Closed - Free","11 - Delayed or Deprioritized","Closed - No Decision"}'::text[]))
  • Rows Removed by Filter: 48
21.          

CTE picklist_4

22. 0.055 0.055 ↑ 1.1 19 1

Seq Scan on t563_opportunitystagenamepicklistdim t563_opportunitystagenamepicklistdim_2 (cost=0.00..7.28 rows=20 width=4) (actual time=0.015..0.055 rows=19 loops=1)

  • Filter: (correlated_value = ANY ('{"10 - Disqualified","16 - Closed / Invalid or Duplicate Oppty","Closed - Dead","Closed - Call later","16 - Closed / Invalid or Duplicate Oppor","13 \\u2013 Closed / Lost to No Decision",Churn,"12 - Closed / Lost to Competition","14 - Closed / Mid Cycle Qualify Ou","Trial Lost","Closed Lost","15 - Closed / Lost to Churn","Closed Won","14 - Closed / Mid Cycle Qualify Out","13 - Closed / Lost to No Decision","Stage 16 - Closed / Invalid or Duplicate","Trial Won","Closed - Free","11 - Delayed or Deprioritized","Closed - No Decision"}'::text[]))
  • Rows Removed by Filter: 46
23.          

CTE topsids

24. 0.035 10,030.220 ↑ 1.0 400 1

Limit (cost=2,499,077.10..2,499,084.98 rows=400 width=12) (actual time=10,030.065..10,030.220 rows=400 loops=1)

25.          

CTE bucketac

26. 328.642 3,275.273 ↓ 4.1 373,591 1

Nested Loop Left Join (cost=974,617.34..982,034.36 rows=90,922 width=116) (actual time=2,517.849..3,275.273 rows=373,591 loops=1)

27.          

CTE nullgroupbyvaluecte

28. 0.016 0.016 ↓ 0.0 0 1

Seq Scan on t563_opportunitystagenamepicklistdim t563_opportunitystagenamepicklistdim_3 (cost=0.00..5.81 rows=1 width=4) (actual time=0.016..0.016 rows=0 loops=1)

  • Filter: (value = 'Value Not Assigned'::text)
  • Rows Removed by Filter: 65
29. 82.644 2,946.507 ↓ 4.1 373,591 1

Hash Left Join (cost=974,582.32..977,907.84 rows=90,922 width=44) (actual time=2,517.819..2,946.507 rows=373,591 loops=1)

  • Hash Cond: (t531_oppfact_2.c1780_opp_stagename = t563_opportunitystagenamepicklistdim_5.sid)
30. 85.765 2,863.839 ↓ 4.1 373,591 1

Hash Left Join (cost=974,575.86..976,651.20 rows=90,922 width=40) (actual time=2,517.780..2,863.839 rows=373,591 loops=1)

  • Hash Cond: (t531_oppfact_1.c1780_opp_stagename = t563_opportunitystagenamepicklistdim_4.sid)
31. 121.890 2,778.032 ↓ 4.1 373,591 1

Merge Left Join (cost=974,569.39..975,394.56 rows=90,922 width=36) (actual time=2,517.712..2,778.032 rows=373,591 loops=1)

  • Merge Cond: ((t531_oppfact_2.c1782_opp_currency_code = t534_clari_conversion_rate.sid) AND (t531_oppfact_2.c1786_opp_close_date = t534_clari_conversion_rate.rate_date))
32. 325.252 2,608.775 ↓ 4.1 373,591 1

Sort (cost=973,047.86..973,275.16 rows=90,922 width=32) (actual time=2,505.186..2,608.775 rows=373,591 loops=1)

  • Sort Key: t531_oppfact_2.c1782_opp_currency_code, t531_oppfact_2.c1786_opp_close_date
  • Sort Method: external merge Disk: 15320kB
33. 278.161 2,283.523 ↓ 4.1 373,591 1

Nested Loop Left Join (cost=30.34..963,382.37 rows=90,922 width=32) (actual time=34.415..2,283.523 rows=373,591 loops=1)

34. 36.293 884.589 ↓ 4.1 373,591 1

Nested Loop (cost=29.77..287,354.59 rows=90,922 width=8) (actual time=34.396..884.589 rows=373,591 loops=1)

35. 0.411 34.560 ↓ 3.1 616 1

HashAggregate (cost=28.76..30.76 rows=200 width=4) (actual time=34.284..34.560 rows=616 loops=1)

  • Group Key: cte0_6.c1
36. 34.149 34.149 ↑ 2.1 616 1

CTE Scan on docd_cte_0 cte0_6 (cost=0.00..25.56 rows=1,278 width=4) (actual time=31.492..34.149 rows=616 loops=1)

37. 813.677 813.736 ↓ 2.9 606 616

Index Scan using ix_t531_oppfact_notnullowner_closedate_timestamp on t531_oppfact t531_oppfact_1 (cost=1.01..1,434.52 rows=210 width=12) (actual time=0.032..1.321 rows=606 loops=616)

  • Index Cond: ((c1791_opp_ownerid = cte0_6.c1) AND (c1786_opp_close_date >= 20191001) AND (c1786_opp_close_date <= 20191231) AND (end_stamp > '1574236800000'::bigint) AND (start_stamp <= '1574236800000'::bigint))
  • Filter: ((NOT deleted) AND (NOT (hashed SubPlan 9)))
  • Rows Removed by Filter: 787
38.          

SubPlan (for Index Scan)

39. 0.059 0.059 ↑ 1.1 19 1

CTE Scan on picklist_4 cte0_4 (cost=0.00..0.40 rows=20 width=4) (actual time=0.016..0.059 rows=19 loops=1)

40. 1,120.773 1,120.773 ↑ 1.0 1 373,591

Index Scan using t531_oppfact_sidendstampunique on t531_oppfact t531_oppfact_2 (cost=0.56..7.43 rows=1 width=28) (actual time=0.003..0.003 rows=1 loops=373,591)

  • Index Cond: ((t531_oppfact_1.sid = sid) AND (t531_oppfact_1.sid = sid) AND (end_stamp > '1574927999999'::bigint))
  • Filter: ((NOT deleted) AND (start_stamp <= '1574927999999'::bigint))
  • Rows Removed by Filter: 0
41. 42.880 47.367 ↓ 24.3 389,129 1

Sort (cost=1,521.53..1,561.51 rows=15,992 width=16) (actual time=12.251..47.367 rows=389,129 loops=1)

  • Sort Key: t534_clari_conversion_rate.sid, t534_clari_conversion_rate.rate_date
  • Sort Method: quicksort Memory: 1545kB
42. 0.938 4.487 ↓ 1.0 16,575 1

Append (cost=0.00..404.89 rows=15,992 width=16) (actual time=0.026..4.487 rows=16,575 loops=1)

43. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on t534_clari_conversion_rate (cost=0.00..0.00 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: (to_iso_code = 'USD'::text)
44. 3.546 3.546 ↓ 1.0 16,575 1

Seq Scan on t534_clari_conversion_rate_usd (cost=0.00..404.89 rows=15,991 width=16) (actual time=0.022..3.546 rows=16,575 loops=1)

  • Filter: (to_iso_code = 'USD'::text)
45. 0.015 0.042 ↑ 1.0 65 1

Hash (cost=5.65..5.65 rows=65 width=8) (actual time=0.042..0.042 rows=65 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
46. 0.027 0.027 ↑ 1.0 65 1

Seq Scan on t563_opportunitystagenamepicklistdim t563_opportunitystagenamepicklistdim_4 (cost=0.00..5.65 rows=65 width=8) (actual time=0.006..0.027 rows=65 loops=1)

47. 0.009 0.024 ↑ 1.0 65 1

Hash (cost=5.65..5.65 rows=65 width=8) (actual time=0.024..0.024 rows=65 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
48. 0.015 0.015 ↑ 1.0 65 1

Seq Scan on t563_opportunitystagenamepicklistdim t563_opportunitystagenamepicklistdim_5 (cost=0.00..5.65 rows=65 width=8) (actual time=0.002..0.015 rows=65 loops=1)

49. 0.000 0.000 ↓ 0.0 0 373,591

CTE Scan on nullgroupbyvaluecte cte0_5 (cost=0.00..0.02 rows=1 width=4) (actual time=0.000..0.000 rows=0 loops=373,591)

50.          

SubPlan (for Nested Loop Left Join)

51. 0.062 0.062 ↑ 2.1 616 1

CTE Scan on docd_cte_0 cte0_1 (cost=0.00..25.56 rows=1,278 width=4) (actual time=0.000..0.062 rows=616 loops=1)

52. 0.023 0.023 ↑ 1.0 2 1

CTE Scan on picklist_1 cte0_2 (cost=0.00..0.04 rows=2 width=4) (actual time=0.013..0.023 rows=2 loops=1)

53. 0.039 0.039 ↑ 1.1 17 1

CTE Scan on picklist_2 cte0_3 (cost=0.00..0.36 rows=18 width=4) (actual time=0.009..0.039 rows=17 loops=1)

54.          

CTE bucketec

55. 543.360 6,521.541 ↑ 1.8 99,299 1

Nested Loop Left Join (cost=306,610.39..1,510,964.09 rows=176,257 width=116) (actual time=1,718.075..6,521.541 rows=99,299 loops=1)

  • Filter: ((t531_oppfact_4.sid IS NULL) OR (t531_oppfact_4.c1786_opp_close_date < 20191001) OR (t531_oppfact_4.c1786_opp_close_date > 20191231) OR (NOT (hashed SubPlan 14)) OR (t531_oppfact_4.c1791_opp_ownerid IS NULL))
  • Rows Removed by Filter: 843642
56. 291.273 2,206.296 ↓ 5.2 942,941 1

Merge Left Join (cost=306,551.87..308,070.21 rows=180,291 width=24) (actual time=1,534.253..2,206.296 rows=942,941 loops=1)

  • Merge Cond: ((t531_oppfact_3.c1782_opp_currency_code = t534_clari_conversion_rate_1.sid) AND (t531_oppfact_3.c1786_opp_close_date = t534_clari_conversion_rate_1.rate_date))
57. 752.755 1,809.968 ↓ 5.2 942,941 1

Sort (cost=305,030.33..305,481.06 rows=180,291 width=24) (actual time=1,521.295..1,809.968 rows=942,941 loops=1)

  • Sort Key: t531_oppfact_3.c1782_opp_currency_code, t531_oppfact_3.c1786_opp_close_date
  • Sort Method: external merge Disk: 35032kB
58. 142.688 1,057.213 ↓ 5.2 942,941 1

Nested Loop (cost=29.32..285,591.46 rows=180,291 width=24) (actual time=0.216..1,057.213 rows=942,941 loops=1)

59. 0.323 0.381 ↓ 3.1 616 1

HashAggregate (cost=28.76..30.76 rows=200 width=4) (actual time=0.189..0.381 rows=616 loops=1)

  • Group Key: cte0_11.c1
60. 0.058 0.058 ↑ 2.1 616 1

CTE Scan on docd_cte_0 cte0_11 (cost=0.00..25.56 rows=1,278 width=4) (actual time=0.002..0.058 rows=616 loops=1)

61. 914.144 914.144 ↓ 3.7 1,531 616

Index Scan using ix_t531_oppfact_notnullowner_closedate_timestamp on t531_oppfact t531_oppfact_3 (cost=0.56..1,423.64 rows=416 width=28) (actual time=0.009..1.484 rows=1,531 loops=616)

  • Index Cond: ((c1791_opp_ownerid = cte0_11.c1) AND (c1786_opp_close_date >= 20191001) AND (c1786_opp_close_date <= 20191231) AND (end_stamp > '1574927999999'::bigint) AND (start_stamp <= '1574927999999'::bigint))
  • Filter: (NOT deleted)
  • Rows Removed by Filter: 24
62. 100.186 105.055 ↓ 59.9 958,316 1

Sort (cost=1,521.53..1,561.51 rows=15,992 width=16) (actual time=12.634..105.055 rows=958,316 loops=1)

  • Sort Key: t534_clari_conversion_rate_1.sid, t534_clari_conversion_rate_1.rate_date
  • Sort Method: quicksort Memory: 1545kB
63. 0.926 4.869 ↓ 1.0 16,575 1

Append (cost=0.00..404.89 rows=15,992 width=16) (actual time=0.021..4.869 rows=16,575 loops=1)

64. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on t534_clari_conversion_rate t534_clari_conversion_rate_1 (cost=0.00..0.00 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: (to_iso_code = 'USD'::text)
65. 3.940 3.940 ↓ 1.0 16,575 1

Seq Scan on t534_clari_conversion_rate_usd t534_clari_conversion_rate_usd_1 (cost=0.00..404.89 rows=15,991 width=16) (actual time=0.018..3.940 rows=16,575 loops=1)

  • Filter: (to_iso_code = 'USD'::text)
66. 3,771.764 3,771.764 ↑ 1.0 1 942,941

Index Scan using t531_oppfact_sidendstampunique on t531_oppfact t531_oppfact_4 (cost=0.56..6.63 rows=1 width=12) (actual time=0.004..0.004 rows=1 loops=942,941)

  • Index Cond: ((t531_oppfact_3.sid = sid) AND (t531_oppfact_3.sid = sid) AND (end_stamp > '1574236800000'::bigint))
  • Filter: ((NOT deleted) AND (start_stamp <= '1574236800000'::bigint))
  • Rows Removed by Filter: 0
67.          

SubPlan (for Nested Loop Left Join)

68. 0.058 0.058 ↑ 2.1 616 1

CTE Scan on docd_cte_0 cte0_7 (cost=0.00..25.56 rows=1,278 width=4) (actual time=0.002..0.058 rows=616 loops=1)

69. 0.001 0.001 ↑ 1.0 2 1

CTE Scan on picklist_1 cte0_8 (cost=0.00..0.04 rows=2 width=4) (actual time=0.001..0.001 rows=2 loops=1)

70. 0.006 0.006 ↑ 1.1 17 1

CTE Scan on picklist_2 cte0_9 (cost=0.00..0.36 rows=18 width=4) (actual time=0.001..0.006 rows=17 loops=1)

71. 0.056 0.056 ↑ 2.1 616 1

CTE Scan on docd_cte_0 cte0_10 (cost=0.00..25.56 rows=1,278 width=4) (actual time=0.001..0.056 rows=616 loops=1)

72. 0.059 10,030.185 ↑ 2.1 400 1

Merge Append (cost=6,078.66..6,095.48 rows=855 width=12) (actual time=10,030.065..10,030.185 rows=400 loops=1)

  • Sort Key: cte0_12.c4 DESC NULLS LAST
73. 7.219 3,453.547 ↑ 1.3 363 1

Sort (cost=2,070.38..2,071.52 rows=455 width=12) (actual time=3,453.494..3,453.547 rows=363 loops=1)

  • Sort Key: cte0_12.c4 DESC NULLS LAST
  • Sort Method: top-N heapsort Memory: 43kB
74. 3,446.328 3,446.328 ↓ 95.4 43,400 1

CTE Scan on bucketac cte0_12 (cost=0.00..2,045.74 rows=455 width=12) (actual time=2,518.253..3,446.328 rows=43,400 loops=1)

  • Filter: (c6 = 'won'::text)
  • Rows Removed by Filter: 330191
75. 0.008 6,576.579 ↑ 10.5 38 1

Limit (cost=4,008.26..4,009.26 rows=400 width=12) (actual time=6,576.568..6,576.579 rows=38 loops=1)

76. 2.509 6,576.571 ↑ 23.2 38 1

Sort (cost=4,008.26..4,010.47 rows=881 width=12) (actual time=6,576.566..6,576.571 rows=38 loops=1)

  • Sort Key: cte0_13.c4 DESC NULLS LAST
  • Sort Method: top-N heapsort Memory: 43kB
77. 6,574.062 6,574.062 ↓ 10.3 9,063 1

CTE Scan on bucketec cte0_13 (cost=0.00..3,965.78 rows=881 width=12) (actual time=1,732.552..6,574.062 rows=9,063 loops=1)

  • Filter: (c6 = 'won'::text)
  • Rows Removed by Filter: 90236
78. 0.122 10,035.624 ↑ 18.2 400 1

Sort (cost=12,747.65..12,765.90 rows=7,297 width=27) (actual time=10,035.597..10,035.624 rows=400 loops=1)

  • Sort Key: cte0.c2 DESC NULLS LAST
  • Sort Method: quicksort Memory: 56kB
79. 0.172 10,035.502 ↑ 18.2 400 1

Nested Loop (cost=1.13..12,395.80 rows=7,297 width=27) (actual time=10,030.103..10,035.502 rows=400 loops=1)

80. 0.241 10,033.330 ↑ 4.4 400 1

Nested Loop (cost=0.56..8,005.20 rows=1,756 width=16) (actual time=10,030.080..10,033.330 rows=400 loops=1)

81. 10,030.289 10,030.289 ↑ 1.0 400 1

CTE Scan on topsids cte0 (cost=0.00..8.00 rows=400 width=12) (actual time=10,030.067..10,030.289 rows=400 loops=1)

82. 2.800 2.800 ↑ 4.0 1 400

Index Scan using idx_t531_oppfact_sid_end_stamp_start_stamp on t531_oppfact (cost=0.56..19.95 rows=4 width=4) (actual time=0.006..0.007 rows=1 loops=400)

  • Index Cond: ((sid = cte0.c1) AND (end_stamp > '1574927999999'::bigint) AND (start_stamp <= '1574927999999'::bigint))
  • Filter: (NOT deleted)
83. 2.000 2.000 ↑ 22.0 1 400

Index Scan using t530_oppdim_sidendstampunique on t530_oppdim (cost=0.56..2.28 rows=22 width=23) (actual time=0.004..0.005 rows=1 loops=400)

  • Index Cond: ((sid = t531_oppfact.sid) AND (end_stamp > '1574927999999'::bigint))
  • Filter: ((NOT deleted) AND (start_stamp <= '1574927999999'::bigint))
  • Rows Removed by Filter: 0
Planning time : 9.283 ms
Execution time : 10,049.750 ms