explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Qrig : CodeCoverageSummary

Settings
# exclusive inclusive rows x rows loops node
1. 0.952 33,142.920 ↑ 157.3 3 1

Aggregate (cost=56,226.74..112,688.17 rows=472 width=28) (actual time=33,020.288..33,142.920 rows=3 loops=1)

  • Group Key: ci_daily_build_group_report_results.project_id
  • Buffers: shared hit=111,389 read=27,185 dirtied=384
  • I/O Timings: read=32,071.719
2.          

CTE latest_by_project

3. 76.519 32,931.725 ↑ 6,188.3 3 1

Aggregate (cost=0.55..54,538.60 rows=18,565 width=12) (actual time=21,837.711..32,931.725 rows=3 loops=1)

  • Group Key: ci_daily_build_group_report_results_1.project_id
  • Buffers: shared hit=42,117 read=27,183 dirtied=384
  • I/O Timings: read=32,064.136
4. 32,855.206 32,855.206 ↓ 1.0 140,824 1

Index Scan using index_daily_build_group_report_results_unique_columns on public.ci_daily_build_group_report_results ci_daily_build_group_report_results_1 (cost=0.55..53,654.35 rows=139,720 width=12) (actual time=0.057..32,855.206 rows=140,824 loops=1)

  • Index Cond: (ci_daily_build_group_report_results_1.project_id = ANY ('{10463077,278964,3310437}'::bigint[]))
  • Filter: ((ci_daily_build_group_report_results_1.data -> 'coverage'::text) IS NOT NULL)
  • Rows Removed by Filter: 0
  • Buffers: shared hit=42,117 read=27,183 dirtied=384
  • I/O Timings: read=32,064.136
5. 40.050 33,141.968 ↓ 1.5 691 1

Merge Join (cost=1,688.14..58,135.41 rows=472 width=42) (actual time=32,939.769..33,141.968 rows=691 loops=1)

  • Merge Cond: (ci_daily_build_group_report_results.project_id = latest_by_project.project_id)
  • Buffers: shared hit=111,389 read=27,185 dirtied=384
  • I/O Timings: read=32,071.719
6. 157.404 157.404 ↓ 1.0 140,824 1

Index Scan using index_daily_build_group_report_results_unique_columns on public.ci_daily_build_group_report_results (cost=0.55..53,654.35 rows=139,720 width=42) (actual time=7.804..157.404 rows=140,824 loops=1)

  • Index Cond: (ci_daily_build_group_report_results.project_id = ANY ('{10463077,278964,3310437}'::bigint[]))
  • Filter: ((ci_daily_build_group_report_results.data -> 'coverage'::text) IS NOT NULL)
  • Rows Removed by Filter: 0
  • Buffers: shared hit=69,272 read=2
  • I/O Timings: read=7.583
7. 12.764 32,944.514 ↓ 4.7 87,585 1

Sort (cost=1,687.59..1,734.00 rows=18,565 width=12) (actual time=32,931.789..32,944.514 rows=87,585 loops=1)

  • Sort Key: latest_by_project.project_id
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=42,117 read=27,183 dirtied=384
  • I/O Timings: read=32,064.136
8. 32,931.750 32,931.750 ↑ 6,188.3 3 1

CTE Scan on latest_by_project (cost=0.00..371.30 rows=18,565 width=12) (actual time=21,837.719..32,931.750 rows=3 loops=1)

  • Buffers: shared hit=42,117 read=27,183 dirtied=384
  • I/O Timings: read=32,064.136