explain.depesz.com

PostgreSQL's explain analyze made readable

Result: T07l : query on reports

Settings
# exclusive inclusive rows x rows loops node
1. 35,967.974 55,418.014 ↓ 1,249.1 18,737 1

Bitmap Heap Scan on ruddersysevents (cost=75,423.01..98,984.47 rows=15 width=59) (actual time=19,453.053..55,418.014 rows=18,737 loops=1)

  • Recheck Cond: ((id > 1428065585) AND (id <= 1437233953) AND (component = 'end'::text))
  • Rows Removed by Index Recheck: 368945
  • Filter: (eventtype = 'control'::text)
2. 207.934 19,450.040 ↓ 0.0 0 1

BitmapAnd (cost=75,423.01..75,423.01 rows=5,953 width=0) (actual time=19,450.040..19,450.040 rows=0 loops=1)

3. 3,974.182 3,974.182 ↓ 5.1 9,168,368 1

Bitmap Index Scan on ruddersysevents_pkey (cost=0.00..37,554.50 rows=1,789,207 width=0) (actual time=3,974.182..3,974.182 rows=9,168,368 loops=1)

  • Index Cond: ((id > 1428065585) AND (id <= 1437233953))
4. 15,267.924 15,267.924 ↑ 1.2 959,338 1

Bitmap Index Scan on component_idx (cost=0.00..37,868.25 rows=1,158,476 width=0) (actual time=15,267.924..15,267.924 rows=959,338 loops=1)

  • Index Cond: (component = 'end'::text)