explain.depesz.com

PostgreSQL's explain analyze made readable

Result: gWkM

Settings
# exclusive inclusive rows x rows loops node
1. 5,004.287 111,122.187 ↓ 0.0 0 1

Update on aw_003_000002_000018 (cost=19,661,660.47..19,724,593.12 rows=1 width=39,592) (actual time=111,122.187..111,122.187 rows=0 loops=1)

  • Buffers: shared hit=4700883 dirtied=52480, temp read=58641 written=58641
2. 3,007.936 106,117.900 ↓ 1,927,161.0 1,927,161 1

Merge Join (cost=19,661,660.47..19,724,593.12 rows=1 width=39,592) (actual time=95,149.506..106,117.900 rows=1,927,161 loops=1)

  • Merge Cond: (((aw_003_000002_000018.ent)::text = (subquery.ent)::text) AND ((aw_003_000002_000018.dim1)::text = (subquery.dim1)::text) AND ((aw_003_000002_000018.dim2)::text = (
  • Buffers: shared hit=600634 dirtied=1725, temp read=58641 written=58641
3. 85,897.010 87,130.579 ↓ 1.0 1,927,161 1

Sort (cost=19,330,649.30..19,335,466.66 rows=1,926,944 width=38,980) (actual time=79,336.205..87,130.579 rows=1,927,161 loops=1)

  • Sort Key: aw_003_000002_000018.ent, aw_003_000002_000018.dim1, aw_003_000002_000018.dim2, aw_003_000002_000018.dim3, aw_003_000002_000018.dim4, aw_003_000002_000018.dim5,
  • Sort Method: external merge Disk: 469080kB
  • Buffers: shared hit=300317 dirtied=1725, temp read=58641 written=58641
4. 1,233.569 1,233.569 ↓ 1.0 1,927,161 1

Seq Scan on aw_003_000002_000018 (cost=0.00..319,586.44 rows=1,926,944 width=38,980) (actual time=0.093..1,233.569 rows=1,927,161 loops=1)

  • Buffers: shared hit=300317 dirtied=1725
5. 8,015.798 15,979.385 ↓ 204.0 1,927,160 1

Sort (cost=331,011.17..331,034.78 rows=9,445 width=168) (actual time=15,813.277..15,979.385 rows=1,927,160 loops=1)

  • Sort Key: subquery.ent, subquery.dim1, subquery.dim2, subquery.dim3, subquery.dim4, subquery.dim5, subquery.dim6, subquery.dim7, subquery.dim8, subquery.dim9, subquery.dim
  • Sort Method: quicksort Memory: 226046kB
  • Buffers: shared hit=300317
6. 327.691 7,963.587 ↓ 122.2 1,154,071 1

Subquery Scan on subquery (cost=329,860.55..330,387.55 rows=9,445 width=168) (actual time=7,071.732..7,963.587 rows=1,154,071 loops=1)

  • Buffers: shared hit=300317
7. 490.489 7,635.896 ↓ 122.2 1,154,071 1

GroupAggregate (cost=329,860.55..330,293.10 rows=9,445 width=72) (actual time=7,071.723..7,635.896 rows=1,154,071 loops=1)

  • Group Key: aw_003_000002_000018_1.dim1, aw_003_000002_000018_1.dim2, aw_003_000002_000018_1.dim3, aw_003_000002_000018_1.dim4, aw_003_000002_000018_1.dim5, aw_
  • Buffers: shared hit=300317
8. 6,168.482 7,145.407 ↓ 119.5 1,154,094 1

Sort (cost=329,860.55..329,884.70 rows=9,660 width=42) (actual time=7,071.712..7,145.407 rows=1,154,094 loops=1)

  • Sort Key: aw_003_000002_000018_1.dim1, aw_003_000002_000018_1.dim2, aw_003_000002_000018_1.dim3, aw_003_000002_000018_1.dim4, aw_003_000002_000018_1.dim5
  • Sort Method: quicksort Memory: 153666kB
  • Buffers: shared hit=300317
9. 976.925 976.925 ↓ 119.5 1,154,094 1

Seq Scan on aw_003_000002_000018 aw_003_000002_000018_1 (cost=0.00..329,221.16 rows=9,660 width=42) (actual time=0.133..976.925 rows=1,154,094 loops=1)

  • Filter: (((dim11)::text ~~ '%101%'::text) OR ((COALESCE(dim11, ''::character varying))::text = ''::text))
  • Rows Removed by Filter: 773067
  • Buffers: shared hit=300317
Planning time : 0.433 ms