Skip to content
Backend CI

feat(performance): query improvements for trends (load less people) #88371

Sign in to view logs

feat(performance): query improvements for trends (load less people)

feat(performance): query improvements for trends (load less people) #88371

Triggered via pull request June 23, 2024 00:48
@posthog-botposthog-bot
synchronize #23135
aspicer/group_pdi
Status Success
Total duration 11m 54s
Artifacts 12

ci-backend.yml

on: pull_request
Determine need to run backend checks
5s
Determine need to run backend checks
Matrix: async-migrations
Matrix: django
Python code quality checks
2m 8s
Python code quality checks
Validate Django and CH migrations
2m 8s
Validate Django and CH migrations
Calculate running time
3s
Calculate running time
Fit to window
Zoom out
Zoom in

Annotations

36 warnings
Determine need to run backend checks
Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/checkout@v3, dorny/paths-filter@v2. For more information see: https://github.blog/changelog/2023-09-22-github-actions-transitioning-from-node-16-to-node-20/.
Python code quality checks
Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/checkout@v3. For more information see: https://github.blog/changelog/2023-09-22-github-actions-transitioning-from-node-16-to-node-20/.
Validate Django and CH migrations
Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/checkout@v3. For more information see: https://github.blog/changelog/2023-09-22-github-actions-transitioning-from-node-16-to-node-20/.
Async migrations tests - clickhouse/clickhouse-server:23.12.5.81-alpine
Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/checkout@v3. For more information see: https://github.blog/changelog/2023-09-22-github-actions-transitioning-from-node-16-to-node-20/.
Django tests – Core (persons-on-events on), Py 3.11.9, clickhouse/clickhouse-server:23.12.5.81-alpine (7/10)
Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/checkout@v3, actions/setup-node@v3. For more information see: https://github.blog/changelog/2023-09-22-github-actions-transitioning-from-node-16-to-node-20/.
Django tests – Core (persons-on-events on), Py 3.11.9, clickhouse/clickhouse-server:23.12.5.81-alpine (2/10)
Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/checkout@v3, actions/setup-node@v3. For more information see: https://github.blog/changelog/2023-09-22-github-actions-transitioning-from-node-16-to-node-20/.
Django tests – Core (persons-on-events on), Py 3.11.9, clickhouse/clickhouse-server:23.12.5.81-alpine (4/10)
Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/checkout@v3, actions/setup-node@v3. For more information see: https://github.blog/changelog/2023-09-22-github-actions-transitioning-from-node-16-to-node-20/.
Django tests – Core (persons-on-events on), Py 3.11.9, clickhouse/clickhouse-server:23.12.5.81-alpine (1/10)
Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/checkout@v3, actions/setup-node@v3. For more information see: https://github.blog/changelog/2023-09-22-github-actions-transitioning-from-node-16-to-node-20/.
Django tests – Core (persons-on-events on), Py 3.11.9, clickhouse/clickhouse-server:23.12.5.81-alpine (10/10)
Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/checkout@v3, actions/setup-node@v3. For more information see: https://github.blog/changelog/2023-09-22-github-actions-transitioning-from-node-16-to-node-20/.
Django tests – Core (persons-on-events on), Py 3.11.9, clickhouse/clickhouse-server:23.12.5.81-alpine (3/10)
Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/checkout@v3, actions/setup-node@v3. For more information see: https://github.blog/changelog/2023-09-22-github-actions-transitioning-from-node-16-to-node-20/.
Django tests – Core (persons-on-events on), Py 3.11.9, clickhouse/clickhouse-server:23.12.5.81-alpine (5/10)
Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/checkout@v3, actions/setup-node@v3. For more information see: https://github.blog/changelog/2023-09-22-github-actions-transitioning-from-node-16-to-node-20/.
Django tests – Core (persons-on-events on), Py 3.11.9, clickhouse/clickhouse-server:23.12.5.81-alpine (8/10)
Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/checkout@v3, actions/setup-node@v3. For more information see: https://github.blog/changelog/2023-09-22-github-actions-transitioning-from-node-16-to-node-20/.
Django tests – Core (persons-on-events on), Py 3.11.9, clickhouse/clickhouse-server:23.12.5.81-alpine (9/10)
Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/checkout@v3, actions/setup-node@v3. For more information see: https://github.blog/changelog/2023-09-22-github-actions-transitioning-from-node-16-to-node-20/.
Django tests – Core (persons-on-events on), Py 3.11.9, clickhouse/clickhouse-server:23.12.5.81-alpine (6/10)
Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/checkout@v3, actions/setup-node@v3. For more information see: https://github.blog/changelog/2023-09-22-github-actions-transitioning-from-node-16-to-node-20/.
Django tests – Core (persons-on-events off), Py 3.11.9, clickhouse/clickhouse-server:23.12.5.81-alpine (8/10)
Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/checkout@v3, actions/setup-node@v3, actions/upload-artifact@v3. For more information see: https://github.blog/changelog/2023-09-22-github-actions-transitioning-from-node-16-to-node-20/.
Django tests – Core (persons-on-events off), Py 3.11.9, clickhouse/clickhouse-server:23.12.5.81-alpine (6/10)
Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/checkout@v3, actions/setup-node@v3, actions/upload-artifact@v3. For more information see: https://github.blog/changelog/2023-09-22-github-actions-transitioning-from-node-16-to-node-20/.
Django tests – Core (persons-on-events off), Py 3.11.9, clickhouse/clickhouse-server:23.12.5.81-alpine (6/10)
No files were found with the provided path: posthog/tasks/test/__emails__. No artifacts will be uploaded.
Django tests – Core (persons-on-events off), Py 3.11.9, clickhouse/clickhouse-server:23.12.5.81-alpine (7/10)
Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/checkout@v3, actions/setup-node@v3, actions/upload-artifact@v3. For more information see: https://github.blog/changelog/2023-09-22-github-actions-transitioning-from-node-16-to-node-20/.
Django tests – Core (persons-on-events off), Py 3.11.9, clickhouse/clickhouse-server:23.12.5.81-alpine (7/10)
No files were found with the provided path: posthog/tasks/test/__emails__. No artifacts will be uploaded.
Django tests – Core (persons-on-events off), Py 3.11.9, clickhouse/clickhouse-server:23.12.5.81-alpine (2/10)
Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/checkout@v3, actions/setup-node@v3, actions/upload-artifact@v3. For more information see: https://github.blog/changelog/2023-09-22-github-actions-transitioning-from-node-16-to-node-20/.
Django tests – Core (persons-on-events off), Py 3.11.9, clickhouse/clickhouse-server:23.12.5.81-alpine (2/10)
No files were found with the provided path: posthog/tasks/test/__emails__. No artifacts will be uploaded.
Django tests – Core (persons-on-events off), Py 3.11.9, clickhouse/clickhouse-server:23.12.5.81-alpine (9/10)
Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/checkout@v3, actions/setup-node@v3, actions/upload-artifact@v3. For more information see: https://github.blog/changelog/2023-09-22-github-actions-transitioning-from-node-16-to-node-20/.
Django tests – Core (persons-on-events off), Py 3.11.9, clickhouse/clickhouse-server:23.12.5.81-alpine (9/10)
No files were found with the provided path: posthog/tasks/test/__emails__. No artifacts will be uploaded.
Django tests – Core (persons-on-events off), Py 3.11.9, clickhouse/clickhouse-server:23.12.5.81-alpine (4/10)
Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/checkout@v3, actions/setup-node@v3, actions/upload-artifact@v3. For more information see: https://github.blog/changelog/2023-09-22-github-actions-transitioning-from-node-16-to-node-20/.
Django tests – Core (persons-on-events off), Py 3.11.9, clickhouse/clickhouse-server:23.12.5.81-alpine (4/10)
No files were found with the provided path: posthog/tasks/test/__emails__. No artifacts will be uploaded.
Django tests – Core (persons-on-events off), Py 3.11.9, clickhouse/clickhouse-server:23.12.5.81-alpine (3/10)
Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/checkout@v3, actions/setup-node@v3, actions/upload-artifact@v3. For more information see: https://github.blog/changelog/2023-09-22-github-actions-transitioning-from-node-16-to-node-20/.
Django tests – Core (persons-on-events off), Py 3.11.9, clickhouse/clickhouse-server:23.12.5.81-alpine (3/10)
No files were found with the provided path: posthog/tasks/test/__emails__. No artifacts will be uploaded.
Django tests – Temporal (persons-on-events off), Py 3.11.9, clickhouse/clickhouse-server:23.12.5.81-alpine (1/1)
Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/checkout@v3, actions/setup-node@v3. For more information see: https://github.blog/changelog/2023-09-22-github-actions-transitioning-from-node-16-to-node-20/.
Django tests – Core (persons-on-events off), Py 3.11.9, clickhouse/clickhouse-server:23.12.5.81-alpine (1/10)
Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/checkout@v3, actions/setup-node@v3, actions/upload-artifact@v3. For more information see: https://github.blog/changelog/2023-09-22-github-actions-transitioning-from-node-16-to-node-20/.
Django tests – Core (persons-on-events off), Py 3.11.9, clickhouse/clickhouse-server:23.12.5.81-alpine (1/10)
No files were found with the provided path: posthog/tasks/test/__emails__. No artifacts will be uploaded.
Django tests – Core (persons-on-events off), Py 3.11.9, clickhouse/clickhouse-server:23.12.5.81-alpine (5/10)
Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/checkout@v3, actions/setup-node@v3, actions/upload-artifact@v3. For more information see: https://github.blog/changelog/2023-09-22-github-actions-transitioning-from-node-16-to-node-20/.
Django tests – Core (persons-on-events off), Py 3.11.9, clickhouse/clickhouse-server:23.12.5.81-alpine (5/10)
No files were found with the provided path: posthog/tasks/test/__emails__. No artifacts will be uploaded.
Django tests – Core (persons-on-events off), Py 3.11.9, clickhouse/clickhouse-server:23.12.5.81-alpine (10/10)
Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/checkout@v3, actions/setup-node@v3, actions/upload-artifact@v3. For more information see: https://github.blog/changelog/2023-09-22-github-actions-transitioning-from-node-16-to-node-20/.
Django tests – Core (persons-on-events off), Py 3.11.9, clickhouse/clickhouse-server:23.12.5.81-alpine (10/10)
No files were found with the provided path: posthog/tasks/test/__emails__. No artifacts will be uploaded.
Calculate running time
Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: PostHog/[email protected]. For more information see: https://github.blog/changelog/2023-09-22-github-actions-transitioning-from-node-16-to-node-20/.
Deprecation notice: v1, v2, and v3 of the artifact actions
The following artifacts were uploaded using a version of actions/upload-artifact that is scheduled for deprecation: "email_renders". Please update your workflow to use v4 of the artifact actions. Learn more: https://github.blog/changelog/2024-04-16-deprecation-notice-v3-of-the-artifact-actions/

Artifacts

Produced during runtime
Name Size
email_renders Expired
49.4 KB
timing_data-Core-1 Expired
131 KB
timing_data-Core-10 Expired
136 KB
timing_data-Core-2 Expired
133 KB
timing_data-Core-3 Expired
129 KB
timing_data-Core-4 Expired
129 KB
timing_data-Core-5 Expired
130 KB
timing_data-Core-6 Expired
130 KB
timing_data-Core-7 Expired
129 KB
timing_data-Core-8 Expired
136 KB
timing_data-Core-9 Expired
142 KB
timing_data-Temporal-1 Expired
130 KB