explain.depesz.com

PostgreSQL's explain analyze made readable

Result: b1eE : CodeCoverageSummary

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

HashAggregate (cost=2.33..2.34 rows=1 width=28) (actual rows= loops=)

  • Group Key: ci_daily_build_group_report_results.project_id
2.          

CTE latest_by_project

3. 0.000 0.000 ↓ 0.0

HashAggregate (cost=1.08..1.11 rows=3 width=12) (actual rows= loops=)

  • Group Key: ci_daily_build_group_report_results_1.project_id
4. 0.000 0.000 ↓ 0.0

Seq Scan on ci_daily_build_group_report_results ci_daily_build_group_report_results_1 (cost=0.00..1.06 rows=3 width=12) (actual rows= loops=)

  • Filter: (((data -> 'coverage'::text) IS NOT NULL) AND (project_id = ANY ('{21,22,23}'::bigint[])))
5. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.10..1.20 rows=1 width=44) (actual rows= loops=)

  • Hash Cond: ((ci_daily_build_group_report_results.date = latest_by_project.date) AND (ci_daily_build_group_report_results.project_id = latest_by_project.project_id))
6. 0.000 0.000 ↓ 0.0

Seq Scan on ci_daily_build_group_report_results (cost=0.00..1.06 rows=3 width=44) (actual rows= loops=)

  • Filter: (((data -> 'coverage'::text) IS NOT NULL) AND (project_id = ANY ('{21,22,23}'::bigint[])))
7. 0.000 0.000 ↓ 0.0

Hash (cost=0.06..0.06 rows=3 width=12) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

CTE Scan on latest_by_project (cost=0.00..0.06 rows=3 width=12) (actual rows= loops=)