explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4hli

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 0.117 ↓ 0.0 0 1

Limit (cost=4.41..4.41 rows=1 width=524) (actual time=0.117..0.117 rows=0 loops=1)

2. 0.035 0.115 ↓ 0.0 0 1

Sort (cost=4.41..4.41 rows=1 width=524) (actual time=0.115..0.115 rows=0 loops=1)

  • Sort Key: (sum(analytics_repository_file_commits.commit_count))
  • Sort Method: quicksort Memory: 25kB
3. 0.001 0.080 ↓ 0.0 0 1

GroupAggregate (cost=4.38..4.40 rows=1 width=524) (actual time=0.080..0.080 rows=0 loops=1)

  • Group Key: analytics_repository_files.file_path
4. 0.037 0.079 ↓ 0.0 0 1

Sort (cost=4.38..4.38 rows=1 width=518) (actual time=0.079..0.079 rows=0 loops=1)

  • Sort Key: analytics_repository_files.file_path
  • Sort Method: quicksort Memory: 25kB
5. 0.002 0.042 ↓ 0.0 0 1

Nested Loop (cost=0.30..4.37 rows=1 width=518) (actual time=0.041..0.042 rows=0 loops=1)

6. 0.040 0.040 ↓ 0.0 0 1

Index Scan using index_file_commits_on_committed_date_file_id_and_project_id on analytics_repository_file_commits (cost=0.15..2.17 rows=1 width=10) (actual time=0.040..0.040 rows=0 loops=1)

  • Index Cond: ((project_id = 5) AND (committed_date >= '2018-03-05'::date) AND (committed_date <= '2018-10-20'::date))
7. 0.000 0.000 ↓ 0.0 0

Index Scan using analytics_repository_files_pkey on analytics_repository_files (cost=0.14..2.16 rows=1 width=524) (never executed)

  • Index Cond: (id = analytics_repository_file_commits.analytics_repository_file_id)
Planning time : 1.477 ms
Execution time : 0.285 ms