Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Stats: email stats for individual posts are too slow #40758

Open
gibrown opened this issue Dec 28, 2024 · 1 comment
Open

Stats: email stats for individual posts are too slow #40758

gibrown opened this issue Dec 28, 2024 · 1 comment
Labels
[Feature] Stats Data Feature that enables users to track their site's traffic and gain insights on popular content. Needs triage Ticket needs to be triaged [Platform] Atomic [Platform] Simple [Plugin] Jetpack Issues about the Jetpack plugin. https://wordpress.org/plugins/jetpack/ [Pri] BLOCKER [Status] Auto-allocated [Status] Escalated to Product Ambassadors [Status] Priority Review Triggered The guild in charge of triage has been notified of this issue in Slack [Type] Bug When a feature is broken and / or not performing as intended

Comments

@gibrown
Copy link
Member

gibrown commented Dec 28, 2024

Impacted plugin

Jetpack

Quick summary

Our email stats for individual posts (and likely other cases) are way too slow for larger sites.

This may mean that we need to redesign the backend tables or change the way that queries are working.

Steps to reproduce

  1. Go to the email stats for an individual post. Example https://wordpress.com/stats/email/opens/day/54632/3584907 (this is en.blog)
  2. Most of the data will minutes to load and/or will timeout.
Image Image

A clear and concise description of what you expected to happen.

No response

What actually happened

No response

Impact

Some (< 50%)

Available workarounds?

No and the platform is unusable

If the above answer is "Yes...", outline the workaround.

No response

Platform (Simple and/or Atomic)

Simple, Atomic, Self-hosted

Logs or notes

No response
@gibrown gibrown added [Feature] Stats Data Feature that enables users to track their site's traffic and gain insights on popular content. [Type] Bug When a feature is broken and / or not performing as intended Needs triage Ticket needs to be triaged labels Dec 28, 2024
@matticbot matticbot added the [Status] Priority Review Triggered The guild in charge of triage has been notified of this issue in Slack label Dec 28, 2024
@github-actions GitHub Actions
Copy link
Contributor

This issue could use some more labels, to help prioritize and categorize our work. Could you please add at least a [Type], a [Feature], and a [Pri] label?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
[Feature] Stats Data Feature that enables users to track their site's traffic and gain insights on popular content. Needs triage Ticket needs to be triaged [Platform] Atomic [Platform] Simple [Plugin] Jetpack Issues about the Jetpack plugin. https://wordpress.org/plugins/jetpack/ [Pri] BLOCKER [Status] Auto-allocated [Status] Escalated to Product Ambassadors [Status] Priority Review Triggered The guild in charge of triage has been notified of this issue in Slack [Type] Bug When a feature is broken and / or not performing as intended
Projects
Automattic Prioritization: The One Board ™
Status: Needs Triage
Milestone
No milestone
Development

No branches or pull requests
2 participants
@gibrown @matticbot