SELECT COUNT(*) is Slow, Estimate it Instead (with Example in Node JS and Postgres)
Published April 24, 2021
At a glance
Views
80,210
Likes
2,282
Comments
163
Performance vs. channel
All-time outlier score
Engagement rate
More features coming
We're working on new analytics and tools. Stay tuned.
About
Get my database course https://database.husseinnasser.com In this video, I'll show how we can use the database query planner to estimate the count with the table statistics and gain enormous performance. I'm going to use Postgres as my database and express node js as my backend. Source Code https://github.com/hna…
- Published
- April 24, 2021
- Made for kids
- No
More features coming
We're working on new analytics and tools. Stay tuned.
How SELECT COUNT(*) is Slow, Estimate it Instead (with Example in Node JS and Postgres) is doing
It has 80.2K views in total. It ranks #9,965,368 among tracked YouTube videos by views.
Key facts about SELECT COUNT(*) is Slow, Estimate it Instead (with Example in Node JS and Postgres)
- Total views
- 80.2K
- Total likes
- 2.28K
- Total comments
- 163
- Published
- April 24, 2021
- Global rank by views
- #9,965,368
Frequently asked questions
How many views does SELECT COUNT(*) is Slow, Estimate it Instead (with Example in Node JS and Postgres) have?
SELECT COUNT(*) is Slow, Estimate it Instead (with Example in Node JS and Postgres) has 80,210 views, 2,282 likes and 163 comments, ranking #9,965,368 among tracked YouTube videos by views.
How accurate are these YouTube video analytics?
View, like, and comment counts come from YouTube's public API and refresh regularly. Growth and revenue figures are estimates built from tracked historical data, so they can differ slightly from what the creator sees privately in YouTube Studio.
What is the outlier score?
How this video's views compare to the channel's usual Shorts or long-form video. A 2x score means double the usual views for that channel, 0.5x means half.
What is engagement rate and how is it calculated?
Likes and comments per view, compared to this channel's typical engagement rate — shown as above or below what's usual for the channel.
How is the revenue estimate calculated?
It's a rough public estimate based on a $0.7–$2.0 CPM (revenue per 1,000 views) applied to view count — not actual creator earnings, which depend on ad rates, audience geography, and monetization settings YouTube doesn't expose publicly.
Is this YouTube video analytics checker free?
Yes. You get 10 free channel and video analytics lookups per 24 hours without an account — logging in, which is also free, removes that limit entirely.