explain.depesz.com

PostgreSQL's explain analyze made readable

Result: cw2h : Optimization for: Optimization for: plan #aqh3; plan #nfhw

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 752.316 1,090.990 ↑ 7.5 81 1

Bitmap Heap Scan on runs (cost=50,956.84..107,064.08 rows=607 width=187) (actual time=1,056.485..1,090.990 rows=81 loops=1)

  • Recheck Cond: ((jenkins_node_id = ANY ('{9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108}'::integer[])) AND (queued > '2019-07-25 07:10:55.752288+00'::timestamp with time zone))
  • Rows Removed by Index Recheck: 795567
  • Filter: (completed IS NULL)
  • Rows Removed by Filter: 73612
  • Heap Blocks: exact=3728 lossy=23791
2. 26.003 338.674 ↓ 0.0 0 1

BitmapAnd (cost=50,956.84..50,956.84 rows=14,552 width=0) (actual time=338.674..338.674 rows=0 loops=1)

3. 114.211 114.211 ↑ 1.0 579,974 1

Bitmap Index Scan on ix_runs_jenkins_node_id (cost=0.00..11,355.75 rows=603,612 width=0) (actual time=114.211..114.211 rows=579,974 loops=1)

  • Index Cond: (jenkins_node_id = ANY ('{9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108}'::integer[]))
4. 198.460 198.460 ↑ 1.0 1,725,408 1

Bitmap Index Scan on ix_runs_queued_jenkins_node_id (cost=0.00..39,600.53 rows=1,730,662 width=0) (actual time=198.460..198.460 rows=1,725,408 loops=1)

  • Index Cond: (queued > '2019-07-25 07:10:55.752288+00'::timestamp with time zone)