explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9WpH

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 160,885.988 ↓ 0.0 0 1

Update on wkdlv_profiles w0 (cost=6,948,999.87..8,335,163.84 rows=2,460,003 width=385) (actual time=160,885.988..160,885.988 rows=0 loops=1)

2. 7,240.182 160,885.986 ↓ 0.0 0 1

Hash Join (cost=6,948,999.87..8,335,163.84 rows=2,460,003 width=385) (actual time=160,885.986..160,885.986 rows=0 loops=1)

  • Hash Cond: (w0.iprofileid = w1.iprofileid)
3. 101,126.367 101,126.367 ↓ 1.0 8,888,888 1

Seq Scan on wkdlv_profiles w0 (cost=0.00..531,283.53 rows=8,851,977 width=347) (actual time=0.036..101,126.367 rows=8,888,888 loops=1)

  • Filter: (ifailurereason = 0)
  • Rows Removed by Filter: 1111112
4. 201.700 52,519.437 ↑ 2.5 1,111,112 1

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

  • Buckets: 65536 Batches: 64 Memory Usage: 1596kB
5. 113.999 52,317.737 ↑ 2.5 1,111,112 1

Subquery Scan on w1 (cost=6,508,143.65..6,895,087.73 rows=2,788,171 width=32) (actual time=46,349.408..52,317.737 rows=1,111,112 loops=1)

6. 3,104.143 52,203.738 ↑ 2.5 1,111,112 1

GroupAggregate (cost=6,508,143.65..6,867,206.02 rows=2,788,171 width=4) (actual time=46,349.353..52,203.738 rows=1,111,112 loops=1)

  • Group Key: wkdlv_test.iprofileid
  • Filter: (count(*) > 4)
  • Rows Removed by Filter: 8888888
7. 12,140.784 49,099.595 ↑ 1.0 33,788,891 1

Sort (cost=6,508,143.65..6,592,978.97 rows=33,934,128 width=4) (actual time=46,349.343..49,099.595 rows=33,788,891 loops=1)

  • Sort Key: wkdlv_test.iprofileid
  • Sort Method: external merge Disk: 462488kB
8. 36,958.811 36,958.811 ↑ 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=112.886..36,958.811 rows=33,788,891 loops=1)

Planning time : 0.138 ms