flakytest.dev anze3db flakytest
Tests / apps/projects/tests.py

AnalyticsTest::test_slow_tests

First seen 3 weeks ago in 78a4357
CI github-actions:test 12 runs
Average
10 ms
median 10 ms
max 13 ms
Phases
Setup 0.65 ms Call 9 ms Teardown 0.15 ms
Categories
Database 6 ms App code 1 ms Other (Unsampled, Deep copies, pytest) 3 ms

10 database queries per run

Needs 1 KB of memory (max 4 KB)

Duration per run

Where the time goes

Latest run in ci:github-actions:test, 16 hours ago · open run
Show pytest frames
setup0.72 ms6.9%
call10 ms91.4%
AnalyticsTest.test_slow_testsapps/projects/tests.py:736 rows = slow_tests(resolve_scope(self.project))10 ms91.4%
slow_testsapps/projects/analytics.py:4432 ms22.9%
daily_totalsapps/projects/analytics.py:406 return rows.values("test_id", "test__name", "test__slug").annotate(2 ms22.9%
QuerySet.annotatedjango/db/models/query.py:16992 ms22.9%
QuerySet._annotatedjango/db/models/query.py:17512 ms22.9%
Query.add_annotationdjango/db/models/sql/query.py:12422 ms22.9%
Aggregate.resolve_expressiondjango/db/models/aggregates.py:1222 ms22.9%
BaseExpression.resolve_expressiondjango/db/models/expressions.py:3012 ms22.9%
slow_testsapps/projects/analytics.py:442 rows = list(2 ms22.9%
QuerySet.__iter__django/db/models/query.py:3902 ms22.9%
QuerySet._fetch_alldjango/db/models/query.py:20002 ms22.9%
ValuesIterable.__iter__django/db/models/query.py:2222 ms22.9%
SQLCompiler.results_iterdjango/db/models/sql/compiler.py:15732 ms22.9%
SQLCompiler.execute_sqldjango/db/models/sql/compiler.py:16242 ms22.9%
CursorWrapper.executedjango/db/backends/utils.py:792 ms22.9%
CursorWrapper._execute_with_wrappersdjango/db/backends/utils.py:922 ms22.9%
CursorWrapper._executedjango/db/backends/utils.py:1052 ms22.9%
Cursor.executepsycopg/cursor.py:1132 ms22.9%
Connection.waitpsycopg/connection.py:4952 ms22.9%
slow_testsapps/projects/analytics.py:4502 ms22.9%
categories_by_testapps/projects/analytics.py:424 for test_id, run_count, categories in rows.filter(test_id__in=test_ids).values_list(2 ms22.9%
QuerySet.values_listdjango/db/models/query.py:14582 ms22.9%
QuerySet._valuesdjango/db/models/query.py:14092 ms22.9%
Query.set_valuesdjango/db/models/sql/query.py:26052 ms22.9%
Query.add_fieldsdjango/db/models/sql/query.py:22662 ms22.9%
Query.setup_joinsdjango/db/models/sql/query.py:19272 ms22.9%
slow_testsapps/projects/analytics.py:453 TestSnapshot.objects.filter(scope.environment_q(), test_id__in=ids)2 ms22.9%
QuerySet.__iter__django/db/models/query.py:3902 ms22.9%
QuerySet._fetch_alldjango/db/models/query.py:20002 ms22.9%
ModelIterable.__iter__django/db/models/query.py:952 ms22.9%
SQLCompiler.execute_sqldjango/db/models/sql/compiler.py:16112 ms22.9%
SQLCompiler.as_sqldjango/db/models/sql/compiler.py:7672 ms22.9%
SQLCompiler.pre_sql_setupdjango/db/models/sql/compiler.py:862 ms22.9%
SQLCompiler.setup_querydjango/db/models/sql/compiler.py:752 ms22.9%
SQLCompiler.get_selectdjango/db/models/sql/compiler.py:3002 ms22.9%
SQLCompiler.get_related_selectionsdjango/db/models/sql/compiler.py:12592 ms22.9%
SQLCompiler.get_default_columnsdjango/db/models/sql/compiler.py:10302 ms22.9%
Estimated from 5 samples; phase durations are exact. Frames from pytest and pluggy are hidden .

Hot lines in your code

apps/projects/analytics.py:406
return rows.values("test_id", "test__name", "test__slug").annotate(
daily_totals · Database
2 ms
apps/projects/analytics.py:442
rows = list(
slow_tests · Database
2 ms
apps/projects/analytics.py:424
for test_id, run_count, categories in rows.filter(test_id__in=test_ids).values_list(
categories_by_test · Database
2 ms
apps/projects/analytics.py:453
TestSnapshot.objects.filter(scope.environment_q(), test_id__in=ids)
slow_tests · Database
2 ms

Fixtures

Exact setup time
_template_string_if_invalid_marker function 0.05 ms
_dj_autoclear_mailbox function 0.05 ms
_django_db_marker function 0.04 ms
_django_set_urlconf function 0.04 ms
_django_clear_site_cache function 0.03 ms
_live_server_helper function 0.03 ms
monkeypatch function 0.02 ms

Database

10 queries · 4 ms
No repeated queries.

Biggest pieces of work

call test body
apps/projects/tests.py:736
10 ms
setup pytest internals 0.72 ms

Reliability

12 results · 0 CI failures · 0 local failures

This test hasn't failed recently.

History

Latest 12 results, oldest first in the strip
When Environment Outcome Duration Commit
16 hours ago CI github-actions:test passed 10 ms e141198 main Profile
1 week, 5 days ago CI github-actions:test passed 6 ms 46ec2aa main Profile
2 weeks, 1 day ago CI github-actions:test passed 10 ms afde85b main Profile
2 weeks, 1 day ago CI github-actions:test passed 8 ms fe29f9d main Profile
2 weeks, 1 day ago CI github-actions:test passed 13 ms 044719a main Profile
2 weeks, 2 days ago CI github-actions:test passed 6 ms b3fedae main Profile
2 weeks, 4 days ago CI github-actions:test passed 12 ms 43c4eda main Profile
2 weeks, 6 days ago CI github-actions:test passed 11 ms 9caa567 main Profile
2 weeks, 6 days ago CI github-actions:test passed 11 ms ec75501 main Profile
3 weeks ago CI github-actions:test passed 11 ms d2c12e5 main Profile
3 weeks ago CI github-actions:test passed 6 ms 0b902f6 main Profile
3 weeks ago CI github-actions:test passed 10 ms 78a4357 main Profile