explain.depesz.com

PostgreSQL's explain analyze made readable

Result: snKk

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 1.963 ↓ 12.0 12 1

Limit (cost=64.69..64.69 rows=1 width=101) (actual time=1.962..1.963 rows=12 loops=1)

2. 0.023 1.961 ↓ 12.0 12 1

Sort (cost=64.69..64.69 rows=1 width=101) (actual time=1.961..1.961 rows=12 loops=1)

  • Sort Key: ci_daily_build_group_report_results.date DESC, ci_daily_build_group_report_results.group_name
  • Sort Method: quicksort Memory: 26kB
3. 0.149 1.938 ↓ 12.0 12 1

Nested Loop (cost=0.99..64.68 rows=1 width=101) (actual time=0.098..1.938 rows=12 loops=1)

4. 0.367 0.367 ↓ 13.9 237 1

Index Only Scan using index_projects_on_namespace_id_and_id on projects (cost=0.43..3.73 rows=17 width=4) (actual time=0.057..0.367 rows=237 loops=1)

  • Index Cond: (namespace_id = 9,970)
  • Heap Fetches: 70
5. 1.422 1.422 ↓ 0.0 0 237

Index Scan using index_daily_build_group_report_results_unique_columns on ci_daily_build_group_report_results (cost=0.55..3.57 rows=1 width=101) (actual time=0.006..0.006 rows=0 loops=237)

  • Index Cond: ((project_id = projects.id) AND (ref_path = 'refs/heads/master'::text) AND (date >= '2020-08-02'::date) AND (date <= '2020-08-03'::date))
Planning time : 1.294 ms
Execution time : 2.024 ms