explain.depesz.com

PostgreSQL's explain analyze made readable

Result: rrUk

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

Update on wkdlv_21913870t (cost=1,250,747.42..1,251,317.47 rows=67 width=386) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1,250,747.42..1,251,317.47 rows=67 width=386) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Subquery Scan on ANY_subquery (cost=1,250,746.98..1,250,750.15 rows=67 width=32) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

HashAggregate (cost=1,250,746.98..1,250,749.48 rows=67 width=4) (actual rows= loops=)

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

Seq Scan on wkdlv_21913870t_14c7a42 (cost=0.00..985,990.32 rows=52,951,332 width=4) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Index Scan using ndxr_21913870t on wkdlv_21913870t (cost=0.44..8.46 rows=1 width=348) (actual rows= loops=)

  • Index Cond: (iprofileid = "ANY_subquery".iprofileid)
  • Filter: (ifailurereason = 0)