explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6smu

Settings
# exclusive inclusive rows x rows loops node
1. 0.007 7.385 ↑ 1.0 1 1

Result (cost=0.60..0.61 rows=1 width=4) (actual time=7.384..7.385 rows=1 loops=1)

  • Buffers: shared read=5
  • I/O Timings: read=7.302
2.          

Initplan (for Result)

3. 0.002 7.378 ↑ 1.0 1 1

Limit (cost=0.57..0.60 rows=1 width=4) (actual time=7.378..7.378 rows=1 loops=1)

  • Buffers: shared read=5
  • I/O Timings: read=7.302
4. 7.376 7.376 ↑ 159,656,704.0 1 1

Index Only Scan using ci_pipelines_pkey on public.ci_pipelines (cost=0.57..4,352,251.77 rows=159,656,704 width=4) (actual time=7.376..7.376 rows=1 loops=1)

  • Index Cond: (ci_pipelines.id IS NOT NULL)
  • Heap Fetches: 0
  • Buffers: shared read=5
  • I/O Timings: read=7.302