explain.depesz.com

PostgreSQL's explain analyze made readable

Result: FOj

Settings
# exclusive inclusive rows x rows loops node
1. 4.790 399.970 ↑ 1.4 878 1

Gather (cost=10,271.22..35,164.13 rows=1,234 width=274) (actual time=364.328..399.970 rows=878 loops=1)

  • Workers Planned: 3
  • Workers Launched: 3
2. 0.245 395.180 ↑ 1.8 220 4 / 4

Nested Loop (cost=9,271.22..34,040.73 rows=398 width=274) (actual time=385.832..395.180 rows=220 loops=4)

3. 3.880 394.496 ↑ 1.8 220 4 / 4

Nested Loop (cost=9,270.79..33,031.56 rows=398 width=8) (actual time=385.820..394.496 rows=220 loops=4)

4. 28.616 380.472 ↑ 1.0 5,072 4 / 4

Merge Join (cost=9,270.36..15,939.82 rows=5,104 width=16) (actual time=361.611..380.472 rows=5,072 loops=4)

  • Merge Cond: (ddeps.id = ddsceps.id)
5. 28.326 28.326 ↑ 1.3 64,200 4 / 4

Parallel Index Only Scan using ddearlypaymentsettlement_pkey on ddearlypaymentsettlement ddeps (cost=0.42..6,332.80 rows=82,838 width=8) (actual time=0.019..28.326 rows=64,200 loops=4)

  • Heap Fetches: 256799
6. 13.813 323.530 ↓ 1.3 19,909 4 / 4

Sort (cost=9,269.94..9,309.49 rows=15,822 width=8) (actual time=317.699..323.530 rows=19,909 loops=4)

  • Sort Key: ddsceps.id
  • Sort Method: quicksort Memory: 1720kB
  • Worker 0: Sort Method: quicksort Memory: 1720kB
  • Worker 1: Sort Method: quicksort Memory: 1720kB
  • Worker 2: Sort Method: quicksort Memory: 1720kB
7. 104.470 309.717 ↓ 1.3 20,289 4 / 4

Hash Join (cost=3,088.17..8,166.38 rows=15,822 width=8) (actual time=283.404..309.717 rows=20,289 loops=4)

  • Hash Cond: (ddsceps.financingcontext_id = ddscfc.id)
8. 84.182 84.182 ↑ 1.0 256,798 4 / 4

Seq Scan on ddsuppliercentricearlypaymentsettlement ddsceps (cost=0.00..3,956.99 rows=256,799 width=16) (actual time=0.008..84.182 rows=256,798 loops=4)

9. 6.242 121.065 ↓ 1.6 15,179 4 / 4

Hash (cost=2,968.71..2,968.71 rows=9,557 width=8) (actual time=121.065..121.065 rows=15,179 loops=4)

  • Buckets: 16384 Batches: 1 Memory Usage: 721kB
10. 63.160 114.823 ↓ 1.6 15,179 4 / 4

Hash Join (cost=21.36..2,968.71 rows=9,557 width=8) (actual time=97.497..114.823 rows=15,179 loops=4)

  • Hash Cond: (ddscfc.paa_id = paa.id)
11. 51.559 51.559 ↑ 1.0 155,112 4 / 4

Seq Scan on ddsuppliercentricfinancingcontext ddscfc (cost=0.00..2,539.12 rows=155,112 width=16) (actual time=0.006..51.559 rows=155,112 loops=4)

12. 0.039 0.104 ↑ 1.0 100 4 / 4

Hash (cost=20.11..20.11 rows=100 width=8) (actual time=0.104..0.104 rows=100 loops=4)

  • Buckets: 1024 Batches: 1 Memory Usage: 12kB
13. 0.065 0.065 ↑ 1.0 100 4 / 4

Index Scan using paa_buyer_idx on payablesapprovalagreement paa (cost=0.28..20.11 rows=100 width=8) (actual time=0.018..0.065 rows=100 loops=4)

  • Index Cond: (buyer_id = 66895525)
14. 10.145 10.145 ↓ 0.0 0 20,289 / 4

Index Scan using earlypaymentsettlement_pkey on earlypaymentsettlement eps (cost=0.43..3.35 rows=1 width=16) (actual time=0.002..0.002 rows=0 loops=20,289)

  • Index Cond: (id = ddeps.id)
  • Filter: (creationdate >= '2019-02-01'::date)
  • Rows Removed by Filter: 1
15. 0.439 0.439 ↑ 1.0 1 878 / 4

Index Scan using supplierinvoice_pkey on supplierinvoice si (cost=0.43..2.54 rows=1 width=274) (actual time=0.002..0.002 rows=1 loops=878)

  • Index Cond: (id = eps.invoice_id)
Planning time : 1.533 ms
Execution time : 400.280 ms