#	rows x	node
1.	↓ 0.0	→ Subquery Scan on idl (cost=20,989,540.59..22,308,949.73 rows=17,024,634 width=1,274) (actual rows= loops=)
2.	↓ 0.0	→ WindowAgg (cost=20,989,540.59..21,287,471.69 rows=17,024,634 width=194) (actual rows= loops=)
3.	↓ 0.0	→ Sort (cost=20,989,540.59..21,032,102.18 rows=17,024,634 width=194) (actual rows= loops=) Sort Key: id.invoiceid
4.	↓ 0.0	→ GroupAggregate (cost=13,101,876.76..17,315,473.67 rows=17,024,634 width=194) (actual rows= loops=) Group Key: id.invdocid, id.invdocref, id.invoiceid, id.amount, id.vatamount, id.totalamount, id.invoicedate, id.duedate, cu.customernbr, c.supplierref, i.rundate, i.periodstart, i.periodend, i.billingrunid, pv.valuecode, i.final, i.cancellation, i.rectification, ic.invoiceid, ic.consumptionid
5.	↓ 0.0	→ Sort (cost=13,101,876.76..13,144,438.34 rows=17,024,634 width=194) (actual rows= loops=) Sort Key: id.invdocid, id.invdocref, id.invoiceid, id.amount, id.vatamount, id.totalamount, id.invoicedate, id.duedate, cu.customernbr, c.supplierref, i.rundate, i.periodstart, i.periodend, i.billingrunid, pv.valuecode, i.final, i.cancellation, i.rectification, ic.invoiceid, ic.consumptionid
6.	↓ 0.0	→ Hash Left Join (cost=7,599,637.28..9,427,809.84 rows=17,024,634 width=194) (actual rows= loops=) Hash Cond: (ir.finalinvoiceid = idr.invoiceid)
7.	↓ 0.0	→ Hash Right Join (cost=7,530,992.92..8,051,566.42 rows=17,024,634 width=186) (actual rows= loops=) Hash Cond: (ic.invoiceid = i.invoiceid)
8.	↓ 0.0	→ Seq Scan on invoicedconsumption ic (cost=0.00..26,622.60 rows=969,360 width=8) (actual rows= loops=)
9.	↓ 0.0	→ Hash (cost=6,885,917.99..6,885,917.99 rows=17,024,634 width=182) (actual rows= loops=)
10.	↓ 0.0	→ Hash Join (cost=417,362.71..6,885,917.99 rows=17,024,634 width=182) (actual rows= loops=) Hash Cond: (idl_1.invdocid = id.invdocid)
11.	↓ 0.0	→ Seq Scan on invdocline idl_1 (cost=0.00..5,824,024.71 rows=13,989,177 width=72) (actual rows= loops=) Filter: (((detail)::text = ANY ('{customer.category,customer.individual,customer.dataStatus,customer.title,customer.firstName,customer.name,customer.companyName,customer.legalForm,customer.tvaApplication,customer.vatNumber,customer.address,customer.languageCode,customer.mail,contract.marketCode,contract.productCode,contract.categoryCode,contract.deliveryCategory,contract.duration,contract.invoiceDeliveryMode,contract.paymentMode,contract.domiciliationDescription,contract.bankAccountDescription,external.newInstalmentAmount,invoicee.individual,invoicee.title,invoicee.firstName,invoicee.name,invoicee.companyName,invoicee.legalForm,invoicee.languageCode,invoicee.email}'::text[])) OR ((resultset)::text = 'invoice.vcs'::text))
12.	↓ 0.0	→ Hash (cost=376,284.53..376,284.53 rows=1,365,694 width=114) (actual rows= loops=)
13.	↓ 0.0	→ Hash Right Join (cost=271,450.63..376,284.53 rows=1,365,694 width=114) (actual rows= loops=) Hash Cond: (ir.originalinvoiceid = i.invoiceid)
14.	↓ 0.0	→ Seq Scan on invoicerelation ir (cost=0.00..41,047.69 rows=1,732,169 width=20) (actual rows= loops=)
15.	↓ 0.0	→ Hash (cost=241,142.56..241,142.56 rows=1,077,606 width=98) (actual rows= loops=)
16.	↓ 0.0	→ Hash Join (cost=104,815.74..241,142.56 rows=1,077,606 width=98) (actual rows= loops=) Hash Cond: (i.invoicenatureparamid = pv.parametervalueid)
17.	↓ 0.0	→ Hash Join (cost=104,762.96..226,272.70 rows=1,077,606 width=89) (actual rows= loops=) Hash Cond: (i.contractid = c.contractid)
18.	↓ 0.0	→ Hash Join (cost=94,927.95..193,538.56 rows=1,077,606 width=76) (actual rows= loops=) Hash Cond: (i.invoiceid = id.invoiceid)
19.	↓ 0.0	→ Seq Scan on invoice i (cost=0.00..49,423.74 rows=1,366,774 width=31) (actual rows= loops=)
20.	↓ 0.0	→ Hash (cost=71,985.88..71,985.88 rows=1,077,606 width=45) (actual rows= loops=)
21.	↓ 0.0	→ Hash Join (cost=850.94..71,985.88 rows=1,077,606 width=45) (actual rows= loops=) Hash Cond: (id.invdocrunid = br.billingrunid)
22.	↓ 0.0	→ Seq Scan on invdoc id (cost=0.00..49,136.94 rows=1,122,194 width=49) (actual rows= loops=)
23.	↓ 0.0	→ Hash (cost=689.31..689.31 rows=12,930 width=4) (actual rows= loops=)
24.	↓ 0.0	→ Seq Scan on billingrun br (cost=0.00..689.31 rows=12,930 width=4) (actual rows= loops=) Filter: ((accountingstate)::text = 'terminated'::text)
25.	↓ 0.0	→ Hash (cost=8,325.02..8,325.02 rows=120,799 width=21) (actual rows= loops=)
26.	↓ 0.0	→ Hash Join (cost=2,495.05..8,325.02 rows=120,799 width=21) (actual rows= loops=) Hash Cond: (c.customerid = cu.customerid)
27.	↓ 0.0	→ Seq Scan on contract c (cost=0.00..3,413.99 rows=120,799 width=19) (actual rows= loops=)
28.	↓ 0.0	→ Hash (cost=1,880.58..1,880.58 rows=49,158 width=10) (actual rows= loops=)
29.	↓ 0.0	→ Seq Scan on customer cu (cost=0.00..1,880.58 rows=49,158 width=10) (actual rows= loops=)
30.	↓ 0.0	→ Hash (cost=41.79..41.79 rows=879 width=17) (actual rows= loops=)
31.	↓ 0.0	→ Seq Scan on parametervalue pv (cost=0.00..41.79 rows=879 width=17) (actual rows= loops=)
32.	↓ 0.0	→ Hash (cost=49,136.94..49,136.94 rows=1,122,194 width=16) (actual rows= loops=)
33.	↓ 0.0	→ Seq Scan on invdoc idr (cost=0.00..49,136.94 rows=1,122,194 width=16) (actual rows= loops=)

"Subquery Scan on idl  (cost=20989540.59..22308949.73 rows=17024634 width=1274)"
"  ->  WindowAgg  (cost=20989540.59..21287471.69 rows=17024634 width=194)"
"        ->  Sort  (cost=20989540.59..21032102.18 rows=17024634 width=194)"
"              Sort Key: id.invoiceid"
"              ->  GroupAggregate  (cost=13101876.76..17315473.67 rows=17024634 width=194)"
"                    Group Key: id.invdocid, id.invdocref, id.invoiceid, id.amount, id.vatamount, id.totalamount, id.invoicedate, id.duedate, cu.customernbr, c.supplierref, i.rundate, i.periodstart, i.periodend, i.billingrunid, pv.valuecode, i.final, i.cancellation, i.rectification, ic.invoiceid, ic.consumptionid"
"                    ->  Sort  (cost=13101876.76..13144438.34 rows=17024634 width=194)"
"                          Sort Key: id.invdocid, id.invdocref, id.invoiceid, id.amount, id.vatamount, id.totalamount, id.invoicedate, id.duedate, cu.customernbr, c.supplierref, i.rundate, i.periodstart, i.periodend, i.billingrunid, pv.valuecode, i.final, i.cancellation, i.rectification, ic.invoiceid, ic.consumptionid"
"                          ->  Hash Left Join  (cost=7599637.28..9427809.84 rows=17024634 width=194)"
"                                Hash Cond: (ir.finalinvoiceid = idr.invoiceid)"
"                                ->  Hash Right Join  (cost=7530992.92..8051566.42 rows=17024634 width=186)"
"                                      Hash Cond: (ic.invoiceid = i.invoiceid)"
"                                      ->  Seq Scan on invoicedconsumption ic  (cost=0.00..26622.60 rows=969360 width=8)"
"                                      ->  Hash  (cost=6885917.99..6885917.99 rows=17024634 width=182)"
"                                            ->  Hash Join  (cost=417362.71..6885917.99 rows=17024634 width=182)"
"                                                  Hash Cond: (idl_1.invdocid = id.invdocid)"
"                                                  ->  Seq Scan on invdocline idl_1  (cost=0.00..5824024.71 rows=13989177 width=72)"
"                                                        Filter: (((detail)::text = ANY ('{customer.category,customer.individual,customer.dataStatus,customer.title,customer.firstName,customer.name,customer.companyName,customer.legalForm,customer.tvaApplication,customer.vatNumber,customer.address,customer.languageCode,customer.mail,contract.marketCode,contract.productCode,contract.categoryCode,contract.deliveryCategory,contract.duration,contract.invoiceDeliveryMode,contract.paymentMode,contract.domiciliationDescription,contract.bankAccountDescription,external.newInstalmentAmount,invoicee.individual,invoicee.title,invoicee.firstName,invoicee.name,invoicee.companyName,invoicee.legalForm,invoicee.languageCode,invoicee.email}'::text[])) OR ((resultset)::text = 'invoice.vcs'::text))"
"                                                  ->  Hash  (cost=376284.53..376284.53 rows=1365694 width=114)"
"                                                        ->  Hash Right Join  (cost=271450.63..376284.53 rows=1365694 width=114)"
"                                                              Hash Cond: (ir.originalinvoiceid = i.invoiceid)"
"                                                              ->  Seq Scan on invoicerelation ir  (cost=0.00..41047.69 rows=1732169 width=20)"
"                                                              ->  Hash  (cost=241142.56..241142.56 rows=1077606 width=98)"
"                                                                    ->  Hash Join  (cost=104815.74..241142.56 rows=1077606 width=98)"
"                                                                          Hash Cond: (i.invoicenatureparamid = pv.parametervalueid)"
"                                                                          ->  Hash Join  (cost=104762.96..226272.70 rows=1077606 width=89)"
"                                                                                Hash Cond: (i.contractid = c.contractid)"
"                                                                                ->  Hash Join  (cost=94927.95..193538.56 rows=1077606 width=76)"
"                                                                                      Hash Cond: (i.invoiceid = id.invoiceid)"
"                                                                                      ->  Seq Scan on invoice i  (cost=0.00..49423.74 rows=1366774 width=31)"
"                                                                                      ->  Hash  (cost=71985.88..71985.88 rows=1077606 width=45)"
"                                                                                            ->  Hash Join  (cost=850.94..71985.88 rows=1077606 width=45)"
"                                                                                                  Hash Cond: (id.invdocrunid = br.billingrunid)"
"                                                                                                  ->  Seq Scan on invdoc id  (cost=0.00..49136.94 rows=1122194 width=49)"
"                                                                                                  ->  Hash  (cost=689.31..689.31 rows=12930 width=4)"
"                                                                                                        ->  Seq Scan on billingrun br  (cost=0.00..689.31 rows=12930 width=4)"
"                                                                                                              Filter: ((accountingstate)::text = 'terminated'::text)"
"                                                                                ->  Hash  (cost=8325.02..8325.02 rows=120799 width=21)"
"                                                                                      ->  Hash Join  (cost=2495.05..8325.02 rows=120799 width=21)"
"                                                                                            Hash Cond: (c.customerid = cu.customerid)"
"                                                                                            ->  Seq Scan on contract c  (cost=0.00..3413.99 rows=120799 width=19)"
"                                                                                            ->  Hash  (cost=1880.58..1880.58 rows=49158 width=10)"
"                                                                                                  ->  Seq Scan on customer cu  (cost=0.00..1880.58 rows=49158 width=10)"
"                                                                          ->  Hash  (cost=41.79..41.79 rows=879 width=17)"
"                                                                                ->  Seq Scan on parametervalue pv  (cost=0.00..41.79 rows=879 width=17)"
"                                ->  Hash  (cost=49136.94..49136.94 rows=1122194 width=16)"
"                                      ->  Seq Scan on invdoc idr  (cost=0.00..49136.94 rows=1122194 width=16)"

Per node type stats

node type	count	sum of times	% of query
GroupAggregate	1	0.000 ms	0.0 %
Hash	9	0.000 ms	0.0 %
Hash Join	6	0.000 ms	0.0 %
Hash Left Join	1	0.000 ms	0.0 %
Hash Right Join	2	0.000 ms	0.0 %
Seq Scan	10	0.000 ms	0.0 %
Sort	2	0.000 ms	0.0 %
Subquery Scan	1	0.000 ms	0.0 %
WindowAgg	1	0.000 ms	0.0 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
billingrun	1	0.000 ms	0.0 %
Seq Scan	1	0.000 ms	0.0 %
contract	1	0.000 ms	0.0 %
Seq Scan	1	0.000 ms	0.0 %
customer	1	0.000 ms	0.0 %
Seq Scan	1	0.000 ms	0.0 %
invdoc	2	0.000 ms	0.0 %
Seq Scan	2	0.000 ms	0.0 %
invdocline	1	0.000 ms	0.0 %
Seq Scan	1	0.000 ms	0.0 %
invoice	1	0.000 ms	0.0 %
Seq Scan	1	0.000 ms	0.0 %
invoicedconsumption	1	0.000 ms	0.0 %
Seq Scan	1	0.000 ms	0.0 %
invoicerelation	1	0.000 ms	0.0 %
Seq Scan	1	0.000 ms	0.0 %
parametervalue	1	0.000 ms	0.0 %
Seq Scan	1	0.000 ms	0.0 %

explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7qkB

Color mode:

Visible columns:

Per node type stats

Per table stats