explain.depesz.com

PostgreSQL's explain analyze made readable

Result: IeQf : Optimization for: Mikes ct_sum plan; plan #xumT

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 1.685 121,303.687 ↓ 28.0 28 1

GroupAggregate (cost=70,918.53..70,918.56 rows=1 width=572) (actual time=121,301.170..121,303.687 rows=28 loops=1)

  • Group Key: container1_.name, compositio0_.starttime
2. 2.704 121,302.002 ↓ 1,470.0 1,470 1

Sort (cost=70,918.53..70,918.54 rows=1 width=572) (actual time=121,301.024..121,302.002 rows=1,470 loops=1)

  • Sort Key: container1_.name, compositio0_.starttime
  • Sort Method: quicksort Memory: 752kB
3. 17,759.554 121,299.298 ↓ 1,470.0 1,470 1

Nested Loop (cost=5,115.84..70,918.52 rows=1 width=572) (actual time=362.531..121,299.298 rows=1,470 loops=1)

  • Join Filter: (compositio0_.container_key = container1_.container_key)
  • Rows Removed by Join Filter: 25,839,960
4. 16.644 16.644 ↓ 1,830.0 1,830 1

Seq Scan on containerdimension41 container1_ (cost=0.00..4,746.95 rows=1 width=520) (actual time=0.058..16.644 rows=1,830 loops=1)

  • Filter: (((name)::text = ANY (‘{“HLS_025_VariantManifest (Audio)“,HLS_020_VariantManifest}’::text[])) AND (type = ‘22’::smallint))
  • Rows Removed by Filter: 28,672
5. 68,599.380 103,523.100 ↓ 1.5 14,121 1,830

Bitmap Heap Scan on compositionelementaggregatebyminute41 compositio0_ (cost=5,115.84..66,049.87 rows=9,736 width=60) (actual time=23.806..56.570 rows=14,121 loops=1,830)

  • Recheck Cond: (serialnumber <= 377,083)
  • Filter: ((starttime IS NOT NULL) AND (countstarted > 0) AND (completionstatus <> 1) AND (completionstatus <> 2) AND (compositionelementtype = ANY (‘{5,20,21,22,23,24,25,62,63,64,65,66,67,68,69}’::integer[])))
  • Rows Removed by Filter: 2,096
  • Heap Blocks: exact=53,855,070
6. 34,923.720 34,923.720 ↑ 1.0 377,083 1,830

Bitmap Index Scan on ixcmpaggminserno41 (cost=0.00..5,113.40 rows=395,330 width=0) (actual time=19.084..19.084 rows=377,083 loops=1,830)

  • Index Cond: (serialnumber <= 377,083)