explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hcgs

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 0.781 ↑ 1.0 1 1

Result (cost=2.19..2.20 rows=1 width=4) (actual time=0.781..0.781 rows=1 loops=1)

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

Initplan (for Result)

3. 0.001 0.778 ↑ 1.0 1 1

Limit (cost=0.57..2.19 rows=1 width=4) (actual time=0.778..0.778 rows=1 loops=1)

  • Buffers: shared read=5
  • I/O Timings: read=0.628
4. 0.777 0.777 ↑ 438,616,054.0 1 1

Index Scan using index_ci_builds_on_user_id on public.ci_builds (cost=0.57..710,469,663.18 rows=438,616,054 width=4) (actual time=0.777..0.777 rows=1 loops=1)

  • Index Cond: (ci_builds.user_id IS NOT NULL)
  • Filter: ((ci_builds.type)::text = 'Ci::Build'::text)
  • Rows Removed by Filter: 0
  • Buffers: shared read=5
  • I/O Timings: read=0.628