explain.depesz.com

PostgreSQL's explain analyze made readable

Result: VOvf

Settings
# exclusive inclusive rows x rows loops node
1. 0.096 3.778 ↓ 747.0 747 1

Limit (cost=324.94..324.94 rows=1 width=101) (actual time=3.622..3.778 rows=747 loops=1)

  • Buffers: shared hit=1,851
2. 0.904 3.682 ↓ 747.0 747 1

Sort (cost=324.94..324.94 rows=1 width=101) (actual time=3.621..3.682 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,851
3. 0.440 2.778 ↓ 747.0 747 1

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

  • Buffers: shared hit=1,851
4. 0.205 0.205 ↓ 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.018..0.205 rows=237 loops=1)

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

Index Scan using i2 on public.ci_daily_build_group_report_results (cost=0.55..18.70 rows=11 width=101) (actual time=0.005..0.009 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,593