Skip to content
Backend CI

fix(cohorts): optimized select from cohort_people #77474

Sign in to view logs

fix(cohorts): optimized select from cohort_people

fix(cohorts): optimized select from cohort_people #77474

Triggered via pull request April 16, 2024 11:51
@posthog-botposthog-bot
synchronize #21564
cohort-group
Status Success
Total duration 20m 21s
Artifacts 1

ci-backend.yml

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

Annotations

54 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.11.2.11-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 – EE (persons-on-events off), Py 3.10.10, clickhouse/clickhouse-server:23.11.2.11-alpine (1/5)
Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/checkout@v3, pnpm/action-setup@v2, actions/setup-node@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 – FOSS (persons-on-events on), Py 3.10.10, clickhouse/clickhouse-server:23.12.5.81-alpine (1/5)
Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/checkout@v3, pnpm/action-setup@v2, 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 – FOSS (persons-on-events on), Py 3.10.10, clickhouse/clickhouse-server:23.11.2.11-alpine (1/5)
Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/checkout@v3, pnpm/action-setup@v2, 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 – EE (persons-on-events on), Py 3.10.10, clickhouse/clickhouse-server:23.11.2.11-alpine (1/5)
Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/checkout@v3, pnpm/action-setup@v2, 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 – FOSS (persons-on-events on), Py 3.10.10, clickhouse/clickhouse-server:23.12.5.81-alpine (2/5)
Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/checkout@v3, pnpm/action-setup@v2, 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 – EE (persons-on-events off), Py 3.10.10, clickhouse/clickhouse-server:23.12.5.81-alpine (1/5)
Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/checkout@v3, pnpm/action-setup@v2, 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 – EE (persons-on-events on), Py 3.10.10, clickhouse/clickhouse-server:23.12.5.81-alpine (1/5)
Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/checkout@v3, pnpm/action-setup@v2, 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 – EE (persons-on-events on), Py 3.10.10, clickhouse/clickhouse-server:23.12.5.81-alpine (5/5)
Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/checkout@v3, pnpm/action-setup@v2, 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 – EE (persons-on-events on), Py 3.10.10, clickhouse/clickhouse-server:23.11.2.11-alpine (5/5)
Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/checkout@v3, pnpm/action-setup@v2, 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 – FOSS (persons-on-events on), Py 3.10.10, clickhouse/clickhouse-server:23.11.2.11-alpine (2/5)
Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/checkout@v3, pnpm/action-setup@v2, 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 – EE (persons-on-events on), Py 3.10.10, clickhouse/clickhouse-server:23.11.2.11-alpine (2/5)
Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/checkout@v3, pnpm/action-setup@v2, 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 – FOSS (persons-on-events on), Py 3.10.10, clickhouse/clickhouse-server:23.12.5.81-alpine (5/5)
Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/checkout@v3, pnpm/action-setup@v2, 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 – EE (persons-on-events off), Py 3.10.10, clickhouse/clickhouse-server:23.12.5.81-alpine (2/5)
Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/checkout@v3, pnpm/action-setup@v2, 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 – EE (persons-on-events on), Py 3.10.10, clickhouse/clickhouse-server:23.12.5.81-alpine (2/5)
Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/checkout@v3, pnpm/action-setup@v2, 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 – EE (persons-on-events off), Py 3.10.10, clickhouse/clickhouse-server:23.11.2.11-alpine (2/5)
Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/checkout@v3, pnpm/action-setup@v2, 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 – FOSS (persons-on-events on), Py 3.10.10, clickhouse/clickhouse-server:23.11.2.11-alpine (5/5)
Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/checkout@v3, pnpm/action-setup@v2, 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 – EE (persons-on-events off), Py 3.10.10, clickhouse/clickhouse-server:23.11.2.11-alpine (5/5)
Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/checkout@v3, pnpm/action-setup@v2, 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 – EE (persons-on-events on), Py 3.10.10, clickhouse/clickhouse-server:23.11.2.11-alpine (3/5)
Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/checkout@v3, pnpm/action-setup@v2, 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 – EE (persons-on-events off), Py 3.10.10, clickhouse/clickhouse-server:23.12.5.81-alpine (5/5)
Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/checkout@v3, pnpm/action-setup@v2, 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 – EE (persons-on-events on), Py 3.10.10, clickhouse/clickhouse-server:23.12.5.81-alpine (3/5)
Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/checkout@v3, pnpm/action-setup@v2, 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 – EE (persons-on-events on), Py 3.10.10, clickhouse/clickhouse-server:23.11.2.11-alpine (4/5)
Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/checkout@v3, pnpm/action-setup@v2, 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 – EE (persons-on-events on), Py 3.10.10, clickhouse/clickhouse-server:23.12.5.81-alpine (4/5)
Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/checkout@v3, pnpm/action-setup@v2, 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 – EE (persons-on-events off), Py 3.10.10, clickhouse/clickhouse-server:23.11.2.11-alpine (3/5)
Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/checkout@v3, pnpm/action-setup@v2, 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 – EE (persons-on-events off), Py 3.10.10, clickhouse/clickhouse-server:23.12.5.81-alpine (3/5)
Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/checkout@v3, pnpm/action-setup@v2, 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 – EE (persons-on-events off), Py 3.10.10, clickhouse/clickhouse-server:23.11.2.11-alpine (4/5)
Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/checkout@v3, pnpm/action-setup@v2, 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 – EE (persons-on-events off), Py 3.10.10, clickhouse/clickhouse-server:23.12.5.81-alpine (4/5)
Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/checkout@v3, pnpm/action-setup@v2, 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 – FOSS (persons-on-events on), Py 3.10.10, clickhouse/clickhouse-server:23.12.5.81-alpine (4/5)
Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/checkout@v3, pnpm/action-setup@v2, 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 – FOSS (persons-on-events on), Py 3.10.10, clickhouse/clickhouse-server:23.11.2.11-alpine (4/5)
Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/checkout@v3, pnpm/action-setup@v2, 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 – FOSS (persons-on-events off), Py 3.10.10, clickhouse/clickhouse-server:23.12.5.81-alpine (1/5)
Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/checkout@v3, pnpm/action-setup@v2, 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 – FOSS (persons-on-events off), Py 3.10.10, clickhouse/clickhouse-server:23.12.5.81-alpine (1/5)
No files were found with the provided path: posthog/tasks/test/__emails__. No artifacts will be uploaded.
Django tests – FOSS (persons-on-events off), Py 3.10.10, clickhouse/clickhouse-server:23.11.2.11-alpine (1/5)
Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/checkout@v3, pnpm/action-setup@v2, 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 – FOSS (persons-on-events off), Py 3.10.10, clickhouse/clickhouse-server:23.11.2.11-alpine (1/5)
No files were found with the provided path: posthog/tasks/test/__emails__. No artifacts will be uploaded.
Django tests – FOSS (persons-on-events on), Py 3.10.10, clickhouse/clickhouse-server:23.12.5.81-alpine (3/5)
Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/checkout@v3, pnpm/action-setup@v2, 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 – FOSS (persons-on-events on), Py 3.10.10, clickhouse/clickhouse-server:23.11.2.11-alpine (3/5)
Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/checkout@v3, pnpm/action-setup@v2, 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 – FOSS (persons-on-events off), Py 3.10.10, clickhouse/clickhouse-server:23.11.2.11-alpine (5/5)
Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/checkout@v3, pnpm/action-setup@v2, 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 – FOSS (persons-on-events off), Py 3.10.10, clickhouse/clickhouse-server:23.11.2.11-alpine (5/5)
No files were found with the provided path: posthog/tasks/test/__emails__. No artifacts will be uploaded.
Django tests – FOSS (persons-on-events off), Py 3.10.10, clickhouse/clickhouse-server:23.12.5.81-alpine (5/5)
Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/checkout@v3, pnpm/action-setup@v2, 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 – FOSS (persons-on-events off), Py 3.10.10, clickhouse/clickhouse-server:23.12.5.81-alpine (5/5)
No files were found with the provided path: posthog/tasks/test/__emails__. No artifacts will be uploaded.
Django tests – FOSS (persons-on-events off), Py 3.10.10, clickhouse/clickhouse-server:23.12.5.81-alpine (4/5)
Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/checkout@v3, pnpm/action-setup@v2, 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 – FOSS (persons-on-events off), Py 3.10.10, clickhouse/clickhouse-server:23.11.2.11-alpine (4/5)
Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/checkout@v3, pnpm/action-setup@v2, 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 – FOSS (persons-on-events off), Py 3.10.10, clickhouse/clickhouse-server:23.12.5.81-alpine (3/5)
Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/checkout@v3, pnpm/action-setup@v2, 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 – FOSS (persons-on-events off), Py 3.10.10, clickhouse/clickhouse-server:23.12.5.81-alpine (3/5)
No files were found with the provided path: posthog/tasks/test/__emails__. No artifacts will be uploaded.
Django tests – FOSS (persons-on-events off), Py 3.10.10, clickhouse/clickhouse-server:23.11.2.11-alpine (3/5)
Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/checkout@v3, pnpm/action-setup@v2, 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 – FOSS (persons-on-events off), Py 3.10.10, clickhouse/clickhouse-server:23.11.2.11-alpine (3/5)
No files were found with the provided path: posthog/tasks/test/__emails__. No artifacts will be uploaded.
Django tests – FOSS (persons-on-events off), Py 3.10.10, clickhouse/clickhouse-server:23.12.5.81-alpine (2/5)
Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/checkout@v3, pnpm/action-setup@v2, 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 – FOSS (persons-on-events off), Py 3.10.10, clickhouse/clickhouse-server:23.12.5.81-alpine (2/5)
No files were found with the provided path: posthog/tasks/test/__emails__. No artifacts will be uploaded.
Django tests – FOSS (persons-on-events off), Py 3.10.10, clickhouse/clickhouse-server:23.11.2.11-alpine (2/5)
Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/checkout@v3, pnpm/action-setup@v2, 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 – FOSS (persons-on-events off), Py 3.10.10, clickhouse/clickhouse-server:23.11.2.11-alpine (2/5)
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/.

Artifacts

Produced during runtime
Name Size
email_renders Expired
63.1 KB