explain.depesz.com

PostgreSQL's explain analyze made readable

Result: QX3q

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

Update on wowbillingexport (cost=0.00..104,234.58 rows=1,838 width=58) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Seq Scan on wowbillingexport (cost=0.00..104,234.58 rows=1,838 width=58) (actual rows= loops=)

3.          

SubPlan (forSeq Scan)

4. 0.000 0.000 ↓ 0.0

Aggregate (cost=28.43..28.44 rows=1 width=8) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Index Scan using "ix_BillingLog_exportid" on billinglog (cost=0.42..28.13 rows=120 width=0) (actual rows= loops=)

  • Index Cond: (exportid = wowbillingexport.id)
  • Filter: (entitytypeid = 1)
6. 0.000 0.000 ↓ 0.0

Aggregate (cost=28.23..28.24 rows=1 width=8) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Index Scan using "ix_BillingLog_exportid" on billinglog billinglog_1 (cost=0.42..28.13 rows=41 width=0) (actual rows= loops=)

  • Index Cond: (exportid = wowbillingexport.id)