explain.depesz.com

PostgreSQL's explain analyze made readable

Result: keSP

Settings
# exclusive inclusive rows x rows loops node
1. 100.283 427,679.208 ↑ 1.0 1 1

Aggregate (cost=196,936.35..196,936.36 rows=1 width=8) (actual time=427,679.207..427,679.208 rows=1 loops=1)

  • Buffers: shared hit=178 read=259,215 dirtied=212
  • I/O Timings: read=415,664.327
2. 386,068.637 427,578.925 ↑ 1.2 28,627 1

Bitmap Heap Scan on public.ci_builds (cost=141,163.21..196,848.20 rows=35,259 width=4) (actual time=41,635.425..427,578.925 rows=28,627 loops=1)

  • Buffers: shared hit=175 read=259,215 dirtied=212
  • I/O Timings: read=415,664.327
3. 879.006 41,510.288 ↓ 0.0 0 1

BitmapAnd (cost=141,163.21..141,163.21 rows=35,259 width=0) (actual time=41,510.288..41,510.288 rows=0 loops=1)

  • Buffers: shared hit=4 read=51,948
  • I/O Timings: read=35,218.722
4. 13,244.816 13,244.816 ↓ 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=13,244.816..13,244.816 rows=4,741,054 loops=1)

  • Buffers: shared read=28,471
  • I/O Timings: read=10,598.129
5. 27,386.466 27,386.466 ↑ 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=27,386.466..27,386.466 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=24,620.593