explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xumT : Mikes ct_sum plan

Settings

Optimization(s) for this plan:

# 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. 121,282.654 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: 25839960
  • -> Bitmap Heap Scan on compositionelementaggregatebyminute41 compositio0_ (cost=5115.84..66049.87 rows=9736 width=60) (actual time=23.806..56.570 rows=14121 loops=1830
4. 0.000 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: 28672
  • Recheck Cond: (serialnumber <= 377083)
  • Filter: ((starttime IS NOT NULL) AND (countstarted > 0) AND (completionstatus <> 1) AND (completionstatus <> 2) AND (compositionelementtype = ANY (‘{5,20,21,22,23,
  • Rows Removed by Filter: 2096
  • Heap Blocks: exact=53855070
5. 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 <= 377083)