explain.depesz.com

PostgreSQL's explain analyze made readable

Result: a1U3

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 134,068.783 ↓ 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=134,068.783..134,068.783 rows=0 loops=1)

2. 7,557.168 134,068.781 ↓ 0.0 0 1

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

  • Hash Cond: (w0.iprofileid = w1.iprofileid)
3. 99,741.306 99,741.306 ↑ 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.035..99,741.306 rows=8,888,888 loops=1)

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

  • Buckets: 65,536 Batches: 64 Memory Usage: 1,596kB
5. 112.750 26,602.772 ↑ 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,667.793..26,602.772 rows=1,111,112 loops=1)

6. 3,085.224 26,490.022 ↑ 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,667.788..26,490.022 rows=1,111,112 loops=1)

  • Group Key: wkdlv_test.iprofileid
  • Filter: (count(*) > 4)
  • Rows Removed by Filter: 8,888,888
7. 11,927.446 23,404.798 ↑ 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,667.781..23,404.798 rows=33,788,891 loops=1)

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