explain.depesz.com

PostgreSQL's explain analyze made readable

Result: tyYW

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Update on wkdlv_21913870t (cost=10,291,789.44..12,121,832.19 rows=4,197,756 width=386) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Merge Join (cost=10,291,789.44..12,121,832.19 rows=4,197,756 width=386) (actual rows= loops=)

  • Merge Cond: (wkdlv_21913870t.iprofileid = "ANY_subquery".iprofileid)
3. 0.000 0.000 ↓ 0.0

Index Scan using ndxr_21913870t on wkdlv_21913870t (cost=0.44..1,110,496.52 rows=22,740,805 width=348) (actual rows= loops=)

  • Filter: (ifailurereason = 0)
4. 0.000 0.000 ↓ 0.0

Subquery Scan on ANY_subquery (cost=10,291,789.00..10,902,011.70 rows=4,197,756 width=32) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=10,291,789.00..10,860,034.14 rows=4,197,756 width=4) (actual rows= loops=)

  • Group Key: wkdlv_21913870t_14c7a42.iprofileid
  • Filter: (count(*) > 5)
6. 0.000 0.000 ↓ 0.0

Sort (cost=10,291,789.00..10,428,732.10 rows=54,777,240 width=4) (actual rows= loops=)

  • Sort Key: wkdlv_21913870t_14c7a42.iprofileid
7. 0.000 0.000 ↓ 0.0

Seq Scan on wkdlv_21913870t_14c7a42 (cost=0.00..1,004,249.40 rows=54,777,240 width=4) (actual rows= loops=)