explain.depesz.com

PostgreSQL's explain analyze made readable

Result: PEOp

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 53.500 ↑ 1.0 1 1

Unique (cost=2,742.94..2,743.10 rows=1 width=968) (actual time=53.499..53.500 rows=1 loops=1)

2. 0.081 53.496 ↑ 1.0 1 1

Sort (cost=2,742.94..2,742.94 rows=1 width=968) (actual time=53.496..53.496 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.011 53.415 ↑ 1.0 1 1

Nested Loop (cost=3.72..2,742.93 rows=1 width=968) (actual time=53.409..53.415 rows=1 loops=1)

  • Join Filter: ((COALESCE(generalconfig.gridoperator, deliverypoint.gridoperator))::text = (gridoperator.gridoperator)::text)
  • Rows Removed by Join Filter: 1
4. 0.021 53.402 ↑ 1.0 1 1

Nested Loop Left Join (cost=3.72..2,741.88 rows=1 width=909) (actual time=53.398..53.402 rows=1 loops=1)

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

Nested Loop (cost=3.72..2,740.59 rows=1 width=905) (actual time=53.374..53.377 rows=1 loops=1)

6. 0.005 53.362 ↑ 1.0 1 1

Nested Loop (cost=3.30..2,738.14 rows=1 width=897) (actual time=53.360..53.362 rows=1 loops=1)

7. 36.485 53.336 ↑ 1.0 1 1

Hash Right Join (cost=2.88..2,735.69 rows=1 width=885) (actual time=53.335..53.336 rows=1 loops=1)

  • Hash Cond: (subscription.generalconfigid = generalconfig.generalconfigid)
  • Filter: (subscription.contractdeliveryid IS NULL)
8. 16.814 16.814 ↓ 1.0 103,550 1

Seq Scan on subscription (cost=0.00..2,344.49 rows=103,549 width=8) (actual time=0.007..16.814 rows=103,550 loops=1)

9. 0.007 0.037 ↑ 1.0 1 1

Hash (cost=2.87..2.87 rows=1 width=885) (actual time=0.037..0.037 rows=1 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 1kB
10. 0.030 0.030 ↑ 1.0 1 1

Index Scan using generalconfig_deliverypointcomponentid_idx on generalconfig (cost=0.42..2.87 rows=1 width=885) (actual time=0.029..0.030 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
11. 0.021 0.021 ↑ 1.0 1 1

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

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

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

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

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

14. 0.002 0.002 ↑ 1.0 2 1

Seq Scan on gridoperator (cost=0.00..1.02 rows=2 width=64) (actual time=0.001..0.002 rows=2 loops=1)

Planning time : 5.329 ms
Execution time : 53.914 ms