explain.depesz.com

PostgreSQL's explain analyze made readable

Result: cvjv

Settings
# exclusive inclusive rows x rows loops node
1. 1.898 136.072 ↑ 1.0 1,838 1

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

2.          

SubPlan (forSeq Scan)

3. 9.190 80.872 ↑ 1.0 1 1,838

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

4. 71.682 71.682 ↑ 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.004..0.039 rows=91 loops=1,838)

  • Index Cond: (exportid = wowbillingexport.id)
  • Filter: (entitytypeid = 1)
  • Rows Removed by Filter: 31
5. 1.838 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. 51.464 51.464 ↑ 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.028 rows=31 loops=1,838)

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