explain.depesz.com

PostgreSQL's explain analyze made readable

Result: NfAs

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 120,760.642 ↓ 0.0 0 1

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

2. 8,219.353 120,760.640 ↓ 0.0 0 1

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

  • Hash Cond: (w0.iprofileid = w1.iprofileid)
3. 86,069.261 86,069.261 ↑ 1.0 8,888,888 1

Seq Scan on wkdlv_profiles w0 (cost=0.00..559,234.38 rows=9,317,679 width=347) (actual time=0.034..86,069.261 rows=8,888,888 loops=1)

  • Filter: (ifailurereason = 0)
  • Rows Removed by Filter: 1111112
4. 162.714 26,472.026 ↑ 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,472.026..26,472.026 rows=1,111,112 loops=1)

  • Buckets: 65536 Batches: 64 Memory Usage: 1596kB
5. 112.533 26,309.312 ↑ 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=20,320.260..26,309.312 rows=1,111,112 loops=1)

6. 3,117.846 26,196.779 ↑ 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,320.254..26,196.779 rows=1,111,112 loops=1)

  • Group Key: wkdlv_test.iprofileid
  • Filter: (count(*) > 4)
  • Rows Removed by Filter: 8888888
7. 12,041.783 23,078.933 ↑ 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,320.245..23,078.933 rows=33,788,891 loops=1)

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

Planning time : 0.147 ms