explain.depesz.com

PostgreSQL's explain analyze made readable

Result: C3Pr

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 2.449 ↑ 1.0 1 1

Unique (cost=3.18..3.18 rows=1 width=8) (actual time=2.449..2.449 rows=1 loops=1)

  • Buffers: shared hit=39 read=27 dirtied=14
  • I/O Timings: read=2.153
2. 0.069 2.448 ↑ 1.0 1 1

Sort (cost=3.18..3.18 rows=1 width=8) (actual time=2.448..2.448 rows=1 loops=1)

  • Sort Key: (count(ci_pipelines.project_id))
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=39 read=27 dirtied=14
  • I/O Timings: read=2.153
3. 0.026 2.379 ↑ 1.0 1 1

Aggregate (cost=3.16..3.17 rows=1 width=8) (actual time=2.379..2.379 rows=1 loops=1)

  • Buffers: shared hit=36 read=27 dirtied=14
  • I/O Timings: read=2.153
4. 2.353 2.353 ↓ 62.0 62 1

Index Only Scan using index_ci_pipelines_for_ondemand_dast_scans on public.ci_pipelines (cost=0.14..3.15 rows=1 width=4) (actual time=0.024..2.353 rows=62 loops=1)

  • Heap Fetches: 27
  • Buffers: shared hit=36 read=27 dirtied=14
  • I/O Timings: read=2.153