explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8Wga

Settings
# exclusive inclusive rows x rows loops node
1. 0.368 104,572.881 ↑ 1.0 1 1

Aggregate (cost=94,657.24..94,657.25 rows=1 width=8) (actual time=104,572.880..104,572.881 rows=1 loops=1)

  • Buffers: shared hit=12 read=56,369 dirtied=37
  • I/O Timings: read=98,900.295
2. 71,854.149 104,572.513 ↑ 14.0 25 1

Bitmap Heap Scan on public.ci_builds (cost=86,133.82..94,656.37 rows=351 width=4) (actual time=54,365.454..104,572.513 rows=25 loops=1)

  • Filter: ((ci_builds.created_at >= '2020-05-26 05:25:26.510804'::timestamp without time zone) AND (ci_builds.created_at <= '2020-06-23 05:25:26.510907'::timestamp without time zone))
  • Rows Removed by Filter: 1,052
  • Buffers: shared hit=4 read=56,369 dirtied=37
  • I/O Timings: read=98,900.295
3. 234.924 32,718.364 ↓ 0.0 0 1

BitmapAnd (cost=86,133.82..86,133.82 rows=5,512 width=0) (actual time=32,718.364..32,718.364 rows=0 loops=1)

  • Buffers: shared hit=4 read=29,043
  • I/O Timings: read=27,751.519
4. 3,166.056 3,166.056 ↓ 1.1 800,707 1

Bitmap Index Scan using index_security_ci_builds_on_name_and_id (cost=0.00..12,341.84 rows=751,721 width=0) (actual time=3,166.056..3,166.056 rows=800,707 loops=1)

  • Index Cond: ((ci_builds.name)::text = 'container_scanning'::text)
  • Buffers: shared read=5,713
  • I/O Timings: read=2,711.811
5. 29,317.384 29,317.384 ↓ 1.0 4,321,457 1

Bitmap Index Scan using index_ci_builds_on_user_id (cost=0.00..73,791.56 rows=4,211,248 width=0) (actual time=29,317.384..29,317.384 rows=4,321,457 loops=1)

  • Index Cond: ((ci_builds.user_id >= 1) AND (ci_builds.user_id <= 10,000))
  • Buffers: shared hit=4 read=23,330
  • I/O Timings: read=25,039.707