# What's up with these 1ms views?

**URL:** https://meta.discourse.org/t/whats-up-with-these-1ms-views/76881
**Category:** Support
**Created:** [12월 28, 2017, 3:24오후 UTC](https://meta.discourse.org/t/whats-up-with-these-1ms-views/76881 "2017-12-28T15:24:17Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![mcwumbly](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/mcwumbly/32/103861_2.png) [@mcwumbly](https://meta.discourse.org/u/mcwumbly)
#### Post date: [12월 28, 2017, 3:24오후 UTC](https://meta.discourse.org/t/whats-up-with-these-1ms-views/76881/1 "2017-12-28T15:24:17Z")

</div>

While working on [this query](https://meta.discourse.org/t/should-top-include-topics-older-topics-with-new-posts-in-the-selected-period/76670/4), I noticed that there were some posts that had a number of 1 millisecond views

```sql
  select count(1) as tiny_views
  from post_timings
  where msecs = 1
  # tiny_views: 3515

```

I first noticed about 30 of these views on an “auto close” post in an old topic. That post was created in the last week, and at least one of those views is from a user who has not logged in since June.

Any idea what may be causing those post timing entries?

If I change the query to show anything with less than 100ms, the count doesn’t go up too much:

```sql
  select count(1) as tiny_views
  from post_timings
  where msecs < 100
  # tiny_views: 3568

```

…so there seems to be something special about these 1msec entries:

---

<div class="post-metadata">

### Author: ![Mittineague](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/mittineague/32/114259_2.png) [@Mittineague](https://meta.discourse.org/u/Mittineague)
#### Post date: [12월 28, 2017, 7:33오후 UTC](https://meta.discourse.org/t/whats-up-with-these-1ms-views/76881/2 "2017-12-28T19:33:59Z")

</div>

I just ran this query on my localhost.

```plaintext
SELECT * 
FROM post_timings 
ORDER BY msecs 

```

There were quite a few msecs 1

They were all for the same “small action” autoclose post.

My guess is that “system” can post extremely fast.

---

<div class="post-metadata">

### Author: ![neil](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/neil/32/102150_2.png) [@neil](https://meta.discourse.org/u/neil)
#### Post date: [12월 28, 2017, 8:24오후 UTC](https://meta.discourse.org/t/whats-up-with-these-1ms-views/76881/3 "2017-12-28T20:24:13Z")

</div>

This is being done when a topic is being autoclosed ([here](https://github.com/discourse/discourse/blob/master/app/services/topic_status_updater.rb#L67-L73)). When a topic auto-closes, a new post is made to say that the post was automatically closed. Normally that post will be shown as unread, which can be annoying to everyone who has read all the other posts in the topic. So we mark the autoclose post as read by anyone who read all the real posts, and give it a 1 ms read time.

So if you have a lot of auto-closed topics, you’ll see those 1 ms post timing records.

---

<div class="post-metadata">

### Author: ![JammyDodger](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/jammydodger/32/254611_2.png) [@JammyDodger](https://meta.discourse.org/u/JammyDodger)
#### Post date: [6월 8, 2024, 12:43오후 UTC](https://meta.discourse.org/t/whats-up-with-these-1ms-views/76881/4 "2024-06-08T12:43:47Z")

</div>

이 주제는 2353일 후 자동으로 닫혔습니다. 새로운 답글은 더 이상 허용되지 않습니다.
