explain.depesz.com

PostgreSQL's explain analyze made readable

Result: WM8d : css proddeev2

Settings
# exclusive inclusive rows x rows loops node
1. 7,978.233 162,966.540 ↓ 0.0 0 1

Update on aw_003_000002_000018 (cost=19,340,439.27..19,403,379.24 rows=1 width=39,904) (actual time=162,966.540..162,966.540 rows=0 loops=1)

  • Buffers: shared hit=4048000 read=126608 dirtied=126691, temp read=58641 written=58641
2. 6,793.439 154,988.307 ↓ 1,927,161.0 1,927,161 1

Merge Join (cost=19,340,439.27..19,403,379.24 rows=1 width=39,904) (actual time=136,201.364..154,988.307 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 = (subquery.dim2)::text) AND ((aw_003_000002_000018.dim3)::text = (subquery.dim3)::text) AND ((aw_003_000002_000018.dim4)::text = (subquery.dim4)::text) AND ((aw_003_000002_000018.dim5)::text = (subquery.dim5)::text) AND ((aw_003_000002_000018.dim6)::text = (subquery.dim6)::text) AND ((aw_003_000002_000018.dim7)::text = (subquery.dim7)::text) AND ((aw_003_000002_000018.dim8)::text = (subquery.dim8)::text) AND ((aw_003_000002_000018.dim9)::text = (subquery.dim9)::text) AND ((aw_003_000002_000018.dim10)::text = (subquery.dim10)::text) AND ((aw_003_000002_000018.dim12)::text = (subquery.dim12)::text))
  • Buffers: shared hit=63431 read=63367, temp read=58641 written=58641
3. 118,195.648 120,716.019 ↑ 1.0 1,927,161 1

Sort (cost=19,246,341.24..19,251,159.14 rows=1,927,161 width=39,292) (actual time=109,889.411..120,716.019 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, aw_003_000002_000018.dim6, aw_003_000002_000018.dim7, aw_003_000002_000018.dim8, aw_003_000002_000018.dim9, aw_003_000002_000018.dim10, aw_003_000002_000018.dim12
  • Sort Method: external merge Disk: 469080kB
  • Buffers: shared hit=32 read=63367, temp read=58641 written=58641
4. 2,520.371 2,520.371 ↑ 1.0 1,927,161 1

Seq Scan on aw_003_000002_000018 (cost=0.00..82,670.61 rows=1,927,161 width=39,292) (actual time=0.016..2,520.371 rows=1,927,161 loops=1)

  • Buffers: shared hit=32 read=63367
5. 12,894.890 27,478.849 ↓ 203.9 1,927,160 1

Sort (cost=94,098.04..94,121.67 rows=9,453 width=168) (actual time=26,311.926..27,478.849 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.dim10, subquery.dim12
  • Sort Method: quicksort Memory: 226046kB
  • Buffers: shared hit=63399
6. 1,564.009 14,583.959 ↓ 122.1 1,154,071 1

Subquery Scan on subquery (cost=92,946.39..93,473.83 rows=9,453 width=168) (actual time=10,513.060..14,583.959 rows=1,154,071 loops=1)

  • Buffers: shared hit=63399
7. 1,811.066 13,019.950 ↓ 122.1 1,154,071 1

GroupAggregate (cost=92,946.39..93,379.30 rows=9,453 width=72) (actual time=10,513.046..13,019.950 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_003_000002_000018_1.dim6, aw_003_000002_000018_1.dim7, aw_003_000002_000018_1.dim8, aw_003_000002_000018_1.dim9, aw_003_000002_000018_1.dim10, aw_003_000002_000018_1.dim12, aw_003_000002_000018_1.ent
  • Buffers: shared hit=63399
8. 9,544.334 11,208.884 ↓ 119.4 1,154,094 1

Sort (cost=92,946.39..92,970.56 rows=9,668 width=42) (actual time=10,513.030..11,208.884 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, aw_003_000002_000018_1.dim6, aw_003_000002_000018_1.dim7, aw_003_000002_000018_1.dim8, aw_003_000002_000018_1.dim9, aw_003_000002_000018_1.dim10, aw_003_000002_000018_1.dim12, aw_003_000002_000018_1.ent
  • Sort Method: quicksort Memory: 153666kB
  • Buffers: shared hit=63399
9. 1,664.550 1,664.550 ↓ 119.4 1,154,094 1

Seq Scan on aw_003_000002_000018 aw_003_000002_000018_1 (cost=0.00..92,306.41 rows=9,668 width=42) (actual time=0.025..1,664.550 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=63399
Planning time : 1.734 ms
Execution time : 163,036.710 ms