explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Exfw

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.031 ↓ 0.0 0 1

Limit (cost=18.49..18.51 rows=1 width=524) (actual time=0.031..0.031 rows=0 loops=1)

  • Buffers: shared hit=7
2. 0.000 0.030 ↓ 0.0 0 1

Aggregate (cost=18.49..18.51 rows=1 width=524) (actual time=0.030..0.030 rows=0 loops=1)

  • Group Key: analytics_repository_files.file_path
  • Buffers: shared hit=7
3. 0.022 0.030 ↓ 0.0 0 1

Sort (cost=18.49..18.50 rows=1 width=520) (actual time=0.030..0.030 rows=0 loops=1)

  • Sort Key: analytics_repository_files.file_path
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=7
4. 0.001 0.008 ↓ 0.0 0 1

Nested Loop (cost=0.30..18.48 rows=1 width=520) (actual time=0.008..0.008 rows=0 loops=1)

  • Buffers: shared hit=4
5. 0.007 0.007 ↓ 0.0 0 1

Index Scan using index_analytics_repository_file_edits_on_project_id on public.analytics_repository_file_edits (cost=0.15..14.31 rows=1 width=12) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: (analytics_repository_file_edits.project_id = 1)
  • Filter: ((analytics_repository_file_edits.committed_date >= '2019-09-15'::date) AND (analytics_repository_file_edits.committed_date <= '2019-09-25'::date))
  • Rows Removed by Filter: 0
  • Buffers: shared hit=4
6. 0.000 0.000 ↓ 0.0 0 0

Index Scan using analytics_repository_files_pkey on public.analytics_repository_files (cost=0.14..4.16 rows=1 width=524) (actual time=0.000..0.000 rows=0 loops=0)

  • Index Cond: (analytics_repository_files.id = analytics_repository_file_edits.analytics_repository_file_id)