explain.depesz.com

PostgreSQL's explain analyze made readable

Result: KI3W

Settings
# exclusive inclusive rows x rows loops node
1. 0.121 4.215 ↓ 747.0 747 1

Limit (cost=324.94..324.94 rows=1 width=101) (actual time=4.009..4.215 rows=747 loops=1)

  • Buffers: shared hit=1,860
2. 1.071 4.094 ↓ 747.0 747 1

Sort (cost=324.94..324.94 rows=1 width=101) (actual time=4.007..4.094 rows=747 loops=1)

  • Sort Key: ci_daily_build_group_report_results.date DESC, ci_daily_build_group_report_results.group_name
  • Sort Method: quicksort Memory: 130kB
  • Buffers: shared hit=1,860
3. 0.422 3.023 ↓ 747.0 747 1

Nested Loop (cost=0.99..324.93 rows=1 width=101) (actual time=0.059..3.023 rows=747 loops=1)

  • Buffers: shared hit=1,860
4. 0.231 0.231 ↓ 13.9 237 1

Index Only Scan using index_projects_on_namespace_id_and_id on public.projects (cost=0.43..5.17 rows=17 width=4) (actual time=0.027..0.231 rows=237 loops=1)

  • Index Cond: (projects.namespace_id = 9,970)
  • Heap Fetches: 48
  • Buffers: shared hit=258
5. 2.370 2.370 ↑ 3.7 3 237

Index Scan using index_daily_build_group_report_results_unique_columns on public.ci_daily_build_group_report_results (cost=0.55..18.70 rows=11 width=101) (actual time=0.005..0.010 rows=3 loops=237)

  • Index Cond: ((ci_daily_build_group_report_results.project_id = projects.id) AND (ci_daily_build_group_report_results.ref_path = 'refs/heads/master'::text) AND (ci_daily_build_group_report_results.date >= '2020-05-02'::date) AND (ci_daily_build_group_report_results.date <= '2020-08-03'::date))
  • Buffers: shared hit=1,602