explain.depesz.com

PostgreSQL's explain analyze made readable

Result: u6q6

Settings
# exclusive inclusive rows x rows loops node
1. 0.483 190,511.262 ↑ 1.0 1 1

Aggregate (cost=197,013.64..197,013.65 rows=1 width=8) (actual time=190,511.261..190,511.262 rows=1 loops=1)

  • Buffers: shared hit=146,663 read=112,730
  • I/O Timings: read=178,282.086
2. 143,234.503 190,510.779 ↑ 4.7 480 1

Bitmap Heap Scan on public.ci_builds (cost=141,146.71..197,008.00 rows=2,256 width=4) (actual time=47,392.114..190,510.779 rows=480 loops=1)

  • Filter: ((ci_builds.created_at >= '2020-05-27 17:51:53.319709'::timestamp without time zone) AND (ci_builds.created_at <= '2020-06-24 17:51:53.319881'::timestamp without time zone))
  • Rows Removed by Filter: 28,147
  • Buffers: shared hit=146,660 read=112,730
  • I/O Timings: read=178,282.086
3. 1,174.017 47,276.276 ↓ 0.0 0 1

BitmapAnd (cost=141,146.71..141,146.71 rows=35,259 width=0) (actual time=47,276.276..47,276.276 rows=0 loops=1)

  • Buffers: shared hit=4 read=51,948
  • I/O Timings: read=39,633.362
4. 14,889.519 14,889.519 ↓ 1.0 4,741,054 1

Bitmap Index Scan using index_security_ci_builds_on_name_and_id (cost=0.00..64,885.05 rows=4,685,823 width=0) (actual time=14,889.519..14,889.519 rows=4,741,054 loops=1)

  • Buffers: shared read=28,471
  • I/O Timings: read=11,665.481
5. 31,212.740 31,212.740 ↑ 1.0 4,322,793 1

Bitmap Index Scan using index_ci_builds_on_user_id (cost=0.00..76,260.28 rows=4,340,071 width=0) (actual time=31,212.739..31,212.740 rows=4,322,793 loops=1)

  • Index Cond: ((ci_builds.user_id >= 0) AND (ci_builds.user_id <= 9,999))
  • Buffers: shared hit=4 read=23,477
  • I/O Timings: read=27,967.881