explain.depesz.com

PostgreSQL's explain analyze made readable

Result: tbGY

Settings
# exclusive inclusive rows x rows loops node
1. 47.554 3,368.486 ↑ 1.0 1 1

Aggregate (cost=35,313.58..35,313.59 rows=1 width=8) (actual time=3,368.485..3,368.486 rows=1 loops=1)

  • Buffers: shared hit=45,617 read=10,786 dirtied=6,680
  • I/O Timings: read=3,178.921
2. 3,320.932 3,320.932 ↑ 1.3 213,632 1

Index Only Scan using index_ci_pipelines_on_user_id_and_created_at_and_config_source on public.ci_pipelines (cost=0.57..34,597.09 rows=286,598 width=4) (actual time=22.806..3,320.932 rows=213,632 loops=1)

  • Index Cond: ((ci_pipelines.user_id >= 0) AND (ci_pipelines.user_id <= 1,250) AND (ci_pipelines.config_source = 1))
  • Heap Fetches: 10,055
  • Buffers: shared hit=45,612 read=10,786 dirtied=6,680
  • I/O Timings: read=3,178.921