explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yJ4s

Settings
# exclusive inclusive rows x rows loops node
1. 0.178 40.789 ↑ 1.0 1 1

Aggregate (cost=7,000.19..7,000.20 rows=1 width=8) (actual time=40.788..40.789 rows=1 loops=1)

  • Buffers: shared hit=2,048 read=25 dirtied=18
  • I/O Timings: read=11.660
2. 40.611 40.611 ↑ 6.8 740 1

Index Only Scan using index_ci_pipelines_on_user_id_and_created_at_and_config_source on public.ci_pipelines (cost=0.57..6,987.57 rows=5,048 width=4) (actual time=0.860..40.611 rows=740 loops=1)

  • Index Cond: ((ci_pipelines.user_id >= 0) AND (ci_pipelines.user_id <= 1,250) AND (ci_pipelines.config_source = 2))
  • Heap Fetches: 25
  • Buffers: shared hit=2,048 read=25 dirtied=18
  • I/O Timings: read=11.660