explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xhid

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

Index Scan using index_ci_pipelines_on_project_idandrefandiddesc on public.ci_pipelines (cost=0.57..4.59 rows=1 width=299) (actual time=11.663..11.663 rows=0 loops=1)

  • Index Cond: ((ci_pipelines.project_id = 19) AND ((ci_pipelines.ref)::text = 'master-2'::text))
  • Filter: (NOT ci_pipelines.tag)
  • Rows Removed by Filter: 0
  • Buffers: shared read=4
  • I/O Timings: read=11.625