flakytest.dev anze3db flakytest
Docs Sign In
Tests / apps/projects/tests.py

AnalyticsTest::test_ci_vs_local

First seen 3 weeks ago in 78a4357
CI github-actions:test 12 runs
Average
14 ms
median 15 ms
max 20 ms
Phases
Setup 0.68 ms Call 13 ms Teardown 0.15 ms
Categories
Database 12 ms App code 1 ms Other (Unsampled, Libraries, pytest) 0.82 ms

13 database queries per run

Needs 2 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
call13 ms93.8%
AnalyticsTest.test_ci_vs_localapps/projects/tests.py:789 comparison = ci_vs_local(self.project)10 ms72.9%
ci_vs_localapps/projects/analytics.py:7388 ms62.5%
compareapps/projects/analytics.py:7113 ms20.8%
compare.<locals>.side_summaryapps/projects/analytics.py:695 summaries = list(3 ms20.8%
QuerySet.__iter__django/db/models/query.py:3903 ms20.8%
QuerySet._fetch_alldjango/db/models/query.py:20003 ms20.8%
ValuesListIterable.__iter__django/db/models/query.py:2383 ms20.8%
SQLCompiler.results_iterdjango/db/models/sql/compiler.py:15733 ms20.8%
SQLCompiler.execute_sqldjango/db/models/sql/compiler.py:16243 ms20.8%
CursorWrapper.executedjango/db/backends/utils.py:793 ms20.8%
CursorWrapper._execute_with_wrappersdjango/db/backends/utils.py:923 ms20.8%
CursorWrapper._executedjango/db/backends/utils.py:1053 ms20.8%
Cursor.executepsycopg/cursor.py:1133 ms20.8%
Connection.waitpsycopg/connection.py:4953 ms20.8%
compareapps/projects/analytics.py:6553 ms20.8%
averages_by_testapps/projects/analytics.py:631 for row in daily_totals(rows)3 ms20.8%
daily_totalsapps/projects/analytics.py:406 return rows.values("test_id", "test__name", "test__slug").annotate(1 ms10.4%
QuerySet.valuesdjango/db/models/query.py:14141 ms10.4%
QuerySet._valuesdjango/db/models/query.py:14091 ms10.4%
Query.set_valuesdjango/db/models/sql/query.py:25481 ms10.4%
Query.check_aliasdjango/db/models/sql/query.py:12291 ms10.4%
QuerySet.__iter__django/db/models/query.py:3901 ms10.4%
QuerySet._fetch_alldjango/db/models/query.py:20001 ms10.4%
ValuesIterable.__iter__django/db/models/query.py:2221 ms10.4%
SQLCompiler.results_iterdjango/db/models/sql/compiler.py:15731 ms10.4%
SQLCompiler.execute_sqldjango/db/models/sql/compiler.py:16241 ms10.4%
CursorWrapper.executedjango/db/backends/utils.py:791 ms10.4%
CursorWrapper._execute_with_wrappersdjango/db/backends/utils.py:921 ms10.4%
CursorWrapper._executedjango/db/backends/utils.py:1051 ms10.4%
Cursor.executepsycopg/cursor.py:1131 ms10.4%
Connection.waitpsycopg/connection.py:4951 ms10.4%
compareapps/projects/analytics.py:6541 ms10.4%
averages_by_testapps/projects/analytics.py:631 for row in daily_totals(rows)1 ms10.4%
QuerySet.__iter__django/db/models/query.py:3901 ms10.4%
QuerySet._fetch_alldjango/db/models/query.py:20001 ms10.4%
ValuesIterable.__iter__django/db/models/query.py:2221 ms10.4%
SQLCompiler.results_iterdjango/db/models/sql/compiler.py:15731 ms10.4%
SQLCompiler.execute_sqldjango/db/models/sql/compiler.py:16241 ms10.4%
CursorWrapper.executedjango/db/backends/utils.py:791 ms10.4%
CursorWrapper._execute_with_wrappersdjango/db/backends/utils.py:921 ms10.4%
CursorWrapper._executedjango/db/backends/utils.py:1051 ms10.4%
Cursor.executepsycopg/cursor.py:1131 ms10.4%
Connection.waitpsycopg/connection.py:4951 ms10.4%
compareapps/projects/analytics.py:6681 ms10.4%
categories_by_testapps/projects/analytics.py:424 for test_id, run_count, categories in rows.filter(test_id__in=test_ids).values_list(1 ms10.4%
QuerySet.__iter__django/db/models/query.py:3901 ms10.4%
QuerySet._fetch_alldjango/db/models/query.py:20001 ms10.4%
ValuesListIterable.__iter__django/db/models/query.py:2381 ms10.4%
SQLCompiler.results_iterdjango/db/models/sql/compiler.py:15731 ms10.4%
SQLCompiler.execute_sqldjango/db/models/sql/compiler.py:16111 ms10.4%
SQLCompiler.as_sqldjango/db/models/sql/compiler.py:7951 ms10.4%
SQLCompiler.compiledjango/db/models/sql/compiler.py:5781 ms10.4%
WhereNode.as_sqldjango/db/models/sql/where.py:1511 ms10.4%
SQLCompiler.compiledjango/db/models/sql/compiler.py:5781 ms10.4%
ci_vs_localapps/projects/analytics.py:735 local = list(Environment.objects.filter(project=project, kind=Environment.Kind.LOCAL))1 ms10.4%
QuerySet.__iter__django/db/models/query.py:3901 ms10.4%
QuerySet._fetch_alldjango/db/models/query.py:20001 ms10.4%
ModelIterable.__iter__django/db/models/query.py:951 ms10.4%
SQLCompiler.execute_sqldjango/db/models/sql/compiler.py:16111 ms10.4%
SQLCompiler.as_sqldjango/db/models/sql/compiler.py:7671 ms10.4%
SQLCompiler.pre_sql_setupdjango/db/models/sql/compiler.py:871 ms10.4%
SQLCompiler.get_order_bydjango/db/models/sql/compiler.py:4911 ms10.4%
SQLCompiler._order_by_pairsdjango/db/models/sql/compiler.py:4741 ms10.4%
SQLCompiler.find_ordering_namedjango/db/models/sql/compiler.py:10791 ms10.4%
TransactionTestCase._post_teardowndjango/test/testcases.py:1240 self._fixture_teardown()3 ms20.8%
TestCase._fixture_teardowndjango/test/testcases.py:14953 ms20.8%
DatabaseWrapper.check_constraintsdjango/db/backends/postgresql/base.py:4833 ms20.8%
CursorWrapper.executedjango/db/backends/utils.py:793 ms20.8%
CursorWrapper._execute_with_wrappersdjango/db/backends/utils.py:923 ms20.8%
CursorWrapper._executedjango/db/backends/utils.py:1033 ms20.8%
Cursor.executepsycopg/cursor.py:1133 ms20.8%
Connection.waitpsycopg/connection.py:4953 ms20.8%
Estimated from 9 samples; phase durations are exact. Frames from pytest and pluggy are hidden .

Hot lines in your code

apps/projects/analytics.py:695
summaries = list(
compare.<locals>.side_summary · Database
3 ms
apps/projects/analytics.py:631
for row in daily_totals(rows)
averages_by_test · Database
3 ms
apps/projects/analytics.py:735
local = list(Environment.objects.filter(project=project, kind=Environment.Kind.LOCAL))
ci_vs_local · Database
1 ms
apps/projects/analytics.py:406
return rows.values("test_id", "test__name", "test__slug").annotate(
daily_totals · Database
1 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
1 ms

Fixtures

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

Database

13 queries · 6 ms
No repeated queries.

Biggest pieces of work

call test body
apps/projects/tests.py:789
 10 ms
call _post_teardown
django/test/testcases.py:1240
 3 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 13 ms e141198 main Profile
1 week, 5 days ago CI github-actions:test passed 9 ms 46ec2aa main Profile
2 weeks, 1 day ago CI github-actions:test passed 15 ms afde85b main Profile
2 weeks, 1 day ago CI github-actions:test passed 13 ms fe29f9d main Profile
2 weeks, 1 day ago CI github-actions:test passed 15 ms 044719a main Profile
2 weeks, 2 days ago CI github-actions:test passed 10 ms b3fedae main Profile
2 weeks, 4 days ago CI github-actions:test passed 15 ms 43c4eda main Profile
2 weeks, 6 days ago CI github-actions:test passed 15 ms 9caa567 main Profile
2 weeks, 6 days ago CI github-actions:test passed 20 ms ec75501 main Profile
3 weeks ago CI github-actions:test passed 16 ms d2c12e5 main Profile
3 weeks ago CI github-actions:test passed 9 ms 0b902f6 main Profile
3 weeks ago CI github-actions:test passed 15 ms 78a4357 main Profile