explain.depesz.com

PostgreSQL's explain analyze made readable

Result: sBkT

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 0.189 ↑ 1.0 1 1

Unique (cost=11.55..11.71 rows=1 width=968) (actual time=0.188..0.189 rows=1 loops=1)

2. 0.085 0.187 ↑ 1.0 1 1

Sort (cost=11.55..11.55 rows=1 width=968) (actual time=0.187..0.187 rows=1 loops=1)

  • Sort Key: generalconfig.todate, generalconfig.fromdate, generalconfig.sourceid, generalconfig.deliverypointid, generalconfig.generalconfignbr, generalconfig.gridrate, generalconfig.slpid, generalconfig.readingfrequency, generalconfig.readingmonth, generalconfig.netarea, generalconfig.pressurelevel, generalconfig.voltagelevel, generalconfig.copperloss, generalconfig.ironloss, generalconfig.powerlimiter, generalconfig.decprod, generalconfig.messageid, generalconfig.creator, generalconfig.creationdate, generalconfig.latestmodifier, generalconfig.latestmodifdate, generalconfig.version, generalconfig.category, generalconfig.state, generalconfig.physicalcapacity, generalconfig.premisescategory, generalconfig.deliverystatus, generalconfig.deleted, generalconfig.settlementmethod, generalconfig.meteringresponsible, generalconfig.occupied, generalconfig.transactioncostrate, generalconfig.psorate, generalconfig.prepaymentstatus, generalconfig.meteringregime, generalconfig.informativereadingfrequency, generalconfig.gridreadingfrequency, generalconfig.readingday, generalconfig.maxmeteringday, generalconfig.ironlossunit, generalconfig.reactiveironloss, generalconfig.reactiveironlossunit, generalconfig.reactivecopperloss, generalconfig.energyusage, generalconfig.settlementcalculation, generalconfig.billingtimeframe, generalconfig.gridfeetimeframe, generalconfig.functionalgroup, generalconfig.configurationcode, generalconfig.status, generalconfig.direction, generalconfig.generalconfigid, generalconfig.gridoperatorconfigid, generalconfig.supplierconfigid, generalconfig.gridfeepayer, generalconfig.minmeteringday, generalconfig.readingyear, generalconfig.gridoperator, rf.months, gridoperator.gln, gridoperator.gridoperator, deliverypoint.market, deliverypoint.regulator, deliverypointcomponent.componentnature
  • Sort Method: quicksort Memory: 25kB
3. 0.005 0.102 ↑ 1.0 1 1

Nested Loop (cost=1.68..11.54 rows=1 width=968) (actual time=0.095..0.102 rows=1 loops=1)

4. 0.012 0.085 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.55..11.38 rows=1 width=909) (actual time=0.081..0.085 rows=1 loops=1)

  • Join Filter: ((rf.readingfrequency)::text = (generalconfig.readingfrequency)::text)
  • Rows Removed by Join Filter: 12
5. 0.002 0.068 ↑ 1.0 1 1

Nested Loop (cost=1.55..10.09 rows=1 width=905) (actual time=0.066..0.068 rows=1 loops=1)

6. 0.003 0.056 ↑ 1.0 1 1

Nested Loop (cost=1.14..7.64 rows=1 width=897) (actual time=0.055..0.056 rows=1 loops=1)

7. 0.005 0.040 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.71..5.19 rows=1 width=885) (actual time=0.039..0.040 rows=1 loops=1)

  • Filter: (subscription.contractdeliveryid IS NULL)
8. 0.024 0.024 ↑ 1.0 1 1

Index Scan using generalconfig_deliverypointcomponentid_idx on generalconfig (cost=0.42..2.87 rows=1 width=885) (actual time=0.024..0.024 rows=1 loops=1)

  • Index Cond: (deliverypointcomponentid = 15,798)
  • Filter: ((deleted IS FALSE) AND (NOT deleted) AND (fromdate < '2020-01-01'::date) AND ((todate IS NULL) OR (todate > '2020-01-01'::date)) AND ((todate IS NULL) OR (todate > fromdate)))
  • Rows Removed by Filter: 1
9. 0.011 0.011 ↓ 0.0 0 1

Index Scan using subscription_generalconfigid_idx on subscription (cost=0.29..2.31 rows=1 width=8) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: (generalconfigid = generalconfig.generalconfigid)
10. 0.013 0.013 ↑ 1.0 1 1

Index Scan using deliverypointcomponent_pk on deliverypointcomponent (cost=0.42..2.44 rows=1 width=16) (actual time=0.013..0.013 rows=1 loops=1)

  • Index Cond: (deliverypointcomponentid = 15,798)
  • Filter: (deleted IS FALSE)
11. 0.010 0.010 ↑ 1.0 1 1

Index Scan using deliverypoint_pkey on deliverypoint (cost=0.42..2.44 rows=1 width=16) (actual time=0.009..0.010 rows=1 loops=1)

  • Index Cond: (deliverypointid = deliverypointcomponent.deliverypointid)
  • Filter: (deleted IS FALSE)
12. 0.005 0.005 ↑ 1.0 13 1

Seq Scan on readingfrequency rf (cost=0.00..1.13 rows=13 width=36) (actual time=0.004..0.005 rows=13 loops=1)

13. 0.012 0.012 ↑ 1.0 1 1

Index Scan using gridoperator_primary_key on gridoperator (cost=0.13..0.15 rows=1 width=64) (actual time=0.011..0.012 rows=1 loops=1)

  • Index Cond: ((gridoperator)::text = (COALESCE(generalconfig.gridoperator, deliverypoint.gridoperator))::text)
Planning time : 5.423 ms
Execution time : 0.543 ms