explain.depesz.com

PostgreSQL's explain analyze made readable

Result: LKNJ

Settings
# exclusive inclusive rows x rows loops node
1. 2.798 144.324 ↑ 1.0 1,838 1

Seq Scan on wowbillingexport (cost=0.00..104,225.39 rows=1,838 width=16) (actual time=0.086..144.324 rows=1,838 loops=1)

2.          

SubPlan (forSeq Scan)

3. 9.190 88.224 ↑ 1.0 1 1,838

Aggregate (cost=28.43..28.44 rows=1 width=8) (actual time=0.048..0.048 rows=1 loops=1,838)

4. 79.034 79.034 ↑ 1.3 91 1,838

Index Scan using "ix_BillingLog_exportid" on billinglog (cost=0.42..28.13 rows=120 width=0) (actual time=0.006..0.043 rows=91 loops=1,838)

  • Index Cond: (exportid = wowbillingexport.id)
  • Filter: (entitytypeid = 1)
  • Rows Removed by Filter: 31
5. 3.676 53.302 ↑ 1.0 1 1,838

Aggregate (cost=28.23..28.24 rows=1 width=8) (actual time=0.029..0.029 rows=1 loops=1,838)

6. 49.626 49.626 ↑ 1.3 31 1,838

Index Scan using "ix_BillingLog_exportid" on billinglog billinglog_1 (cost=0.42..28.13 rows=41 width=0) (actual time=0.007..0.027 rows=31 loops=1,838)

  • Index Cond: (exportid = wowbillingexport.id)
  • Filter: (entitytypeid = 2)
  • Rows Removed by Filter: 91