explain.depesz.com

PostgreSQL's explain analyze made readable

Result: FrGy

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 124,854.691 ↓ 0.0 0 1

Update on wkdlv_profiles (cost=6,948,999.87..8,407,087.16 rows=2,460,003 width=385) (actual time=124,854.691..124,854.691 rows=0 loops=1)

2. 7,836.901 124,854.689 ↓ 0.0 0 1

Hash Join (cost=6,948,999.87..8,407,087.16 rows=2,460,003 width=385) (actual time=124,854.688..124,854.689 rows=0 loops=1)

  • Hash Cond: (wkdlv_profiles.iprofileid = "ANY_subquery".iprofileid)
3. 90,177.217 90,177.217 ↑ 1.0 8,888,888 1

Seq Scan on wkdlv_profiles (cost=0.00..559,234.38 rows=9,317,679 width=347) (actual time=0.035..90,177.217 rows=8,888,888 loops=1)

  • Filter: (ifailurereason = 0)
  • Rows Removed by Filter: 1111112
4. 150.883 26,840.571 ↑ 2.5 1,111,112 1

Hash (cost=6,895,087.73..6,895,087.73 rows=2,788,171 width=32) (actual time=26,840.571..26,840.571 rows=1,111,112 loops=1)

  • Buckets: 65536 Batches: 64 Memory Usage: 1596kB
5. 113.980 26,689.688 ↑ 2.5 1,111,112 1

Subquery Scan on ANY_subquery (cost=6,508,143.65..6,895,087.73 rows=2,788,171 width=32) (actual time=20,646.353..26,689.688 rows=1,111,112 loops=1)

6. 3,170.769 26,575.708 ↑ 2.5 1,111,112 1

GroupAggregate (cost=6,508,143.65..6,867,206.02 rows=2,788,171 width=4) (actual time=20,646.347..26,575.708 rows=1,111,112 loops=1)

  • Group Key: wkdlv_test.iprofileid
  • Filter: (count(*) > 4)
  • Rows Removed by Filter: 8888888
7. 11,955.577 23,404.939 ↑ 1.0 33,788,891 1

Sort (cost=6,508,143.65..6,592,978.97 rows=33,934,128 width=4) (actual time=20,646.339..23,404.939 rows=33,788,891 loops=1)

  • Sort Key: wkdlv_test.iprofileid
  • Sort Method: external merge Disk: 462488kB
8. 11,449.362 11,449.362 ↑ 1.0 33,788,891 1

Seq Scan on wkdlv_test (cost=0.00..871,785.28 rows=33,934,128 width=4) (actual time=82.586..11,449.362 rows=33,788,891 loops=1)

Planning time : 0.151 ms