explain.depesz.com

PostgreSQL's explain analyze made readable

Result: aM6H : Fast Plan

Settings
# exclusive inclusive rows x rows loops node
1. 0.557 17.973 ↑ 4.8 28 1

GroupAggregate (cost=7,226.04..7,229.42 rows=135 width=73) (actual time=17.386..17.973 rows=28 loops=1)

  • Group Key: container1_.name, compositio0_.starttime
2. 1.047 17.416 ↓ 10.9 1,470 1

Sort (cost=7,226.04..7,226.38 rows=135 width=363) (actual time=17.349..17.416 rows=1,470 loops=1)

  • Sort Key: container1_.name, compositio0_.starttime
  • Sort Method: quicksort Memory: 752kB
3. 1.472 16.369 ↓ 10.9 1,470 1

Hash Join (cost=4,794.92..7,221.27 rows=135 width=363) (actual time=8.319..16.369 rows=1,470 loops=1)

  • Hash Cond: (compositio0_.container_key = container1_.container_key)
4. 6.616 6.616 ↓ 1.1 14,121 1

Index Scan using ixcmpaggminserno41 on compositionelementaggregatebyminute41 compositio0_ (cost=0.29..2,393.59 rows=12,590 width=350) (actual time=0.019..6.616 rows=14,121 loops=1)

  • Index 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,24,25,62,63,64,65,66,67,68,6
  • Rows Removed by Filter: 2096
5. 0.356 8.281 ↓ 5.6 1,830 1

Hash (cost=4,790.53..4,790.53 rows=328 width=21) (actual time=8.281..8.281 rows=1,830 loops=1)

  • Buckets: 2048 (originally 1024) Batches: 1 (originally 1) Memory Usage: 128kB
6. 7.925 7.925 ↓ 5.6 1,830 1

Seq Scan on containerdimension41 container1_ (cost=0.00..4,790.53 rows=328 width=21) (actual time=0.029..7.925 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