explain.depesz.com

PostgreSQL's explain analyze made readable

Result: C4Ua

Settings
# exclusive inclusive rows x rows loops node
1. 13.242 14.793 ↑ 4,833.0 1 1

Gather (cost=2,948.42..49,429.23 rows=4,833 width=1,810) (actual time=8.623..14.793 rows=1 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
2. 0.003 1.545 ↓ 0.0 0 5 / 5

Hash Left Join (cost=1,948.42..8,448.24 rows=1,208 width=1,655) (actual time=1.520..1.545 rows=0 loops=5)

  • Hash Cond: (fi_eps.earlypaymentmapping_id = fi_bpt.mapping_id)
3. 0.001 1.542 ↓ 0.0 0 5 / 5

Hash Left Join (cost=1,938.20..8,433.47 rows=1,208 width=1,655) (actual time=1.518..1.542 rows=0 loops=5)

  • Hash Cond: (fi_si.paymentadvice_id = fi_ipa.id)
4. 0.003 1.540 ↓ 0.0 0 5 / 5

Hash Left Join (cost=1,927.97..8,420.08 rows=1,208 width=611) (actual time=1.515..1.540 rows=0 loops=5)

  • Hash Cond: (fi_eps.earlypaymentadvice_id = fi_eps_epa.id)
5. 0.002 1.422 ↓ 0.0 0 5 / 5

Nested Loop Left Join (cost=1,895.71..8,384.64 rows=1,208 width=597) (actual time=1.398..1.422 rows=0 loops=5)

6. 0.002 1.419 ↓ 0.0 0 5 / 5

Hash Left Join (cost=1,895.28..7,783.65 rows=1,208 width=597) (actual time=1.395..1.419 rows=0 loops=5)

  • Hash Cond: (si.currency_id = c.id)
7. 0.002 1.415 ↓ 0.0 0 5 / 5

Hash Left Join (cost=1,894.14..7,777.11 rows=1,208 width=601) (actual time=1.391..1.415 rows=0 loops=5)

  • Hash Cond: (si.supplier_id = s_cb.id)
8. 0.002 1.169 ↓ 0.0 0 5 / 5

Hash Left Join (cost=1,683.02..7,562.81 rows=1,208 width=591) (actual time=1.145..1.169 rows=0 loops=5)

  • Hash Cond: (od_db.buyer_id = od_c_cb.id)
9. 0.002 0.842 ↓ 0.0 0 5 / 5

Nested Loop Left Join (cost=1,471.89..7,348.50 rows=1,208 width=581) (actual time=0.818..0.842 rows=0 loops=5)

10. 0.000 0.839 ↓ 0.0 0 5 / 5

Nested Loop Left Join (cost=1,471.47..6,787.69 rows=1,208 width=465) (actual time=0.815..0.839 rows=0 loops=5)

11. 0.003 0.837 ↓ 0.0 0 5 / 5

Hash Left Join (cost=1,471.05..6,214.15 rows=1,208 width=457) (actual time=0.812..0.837 rows=0 loops=5)

  • Hash Cond: (ps_apfeps.apfda_id = ps_apfeps_t_apfda.id)
12. 0.001 0.820 ↓ 0.0 0 5 / 5

Nested Loop (cost=1,467.87..6,194.36 rows=1,208 width=447) (actual time=0.797..0.820 rows=0 loops=5)

13. 0.004 0.818 ↓ 0.0 0 5 / 5

Merge Join (cost=1,467.44..2,050.55 rows=9,265 width=431) (actual time=0.795..0.818 rows=0 loops=5)

  • Merge Cond: (si.nettingbundle_id = nb.id)
14. 0.014 0.143 ↑ 1,593,520.0 1 5 / 5

Nested Loop (cost=0.86..1,786,202.47 rows=1,593,520 width=371) (actual time=0.120..0.143 rows=1 loops=5)

15. 0.034 0.034 ↑ 34,217.9 48 5 / 5

Parallel Index Scan using supplierinvoice_nettingbundle_idx on supplierinvoice si (cost=0.43..784,438.39 rows=1,642,460 width=191) (actual time=0.014..0.034 rows=48 loops=5)

16. 0.095 0.095 ↓ 0.0 0 238 / 5

Index Scan using earlypaymentsettlement_invoice_idx on earlypaymentsettlement ps_eps (cost=0.43..0.61 rows=1 width=196) (actual time=0.002..0.002 rows=0 loops=238)

  • Index Cond: (invoice_id = si.id)
17. 0.004 0.671 ↑ 1.0 1 5 / 5

Materialize (cost=1,466.58..1,466.59 rows=1 width=68) (actual time=0.670..0.671 rows=1 loops=5)

18. 0.018 0.667 ↑ 1.0 1 5 / 5

Sort (cost=1,466.58..1,466.58 rows=1 width=68) (actual time=0.667..0.667 rows=1 loops=5)

  • Sort Key: nb.id
  • Sort Method: quicksort Memory: 25kB
  • Worker 0: Sort Method: quicksort Memory: 25kB
  • Worker 1: Sort Method: quicksort Memory: 25kB
  • Worker 2: Sort Method: quicksort Memory: 25kB
  • Worker 3: Sort Method: quicksort Memory: 25kB
19. 0.003 0.649 ↑ 1.0 1 5 / 5

Nested Loop Left Join (cost=1.29..1,466.57 rows=1 width=68) (actual time=0.044..0.649 rows=1 loops=5)

  • Join Filter: (fi_si.originatordivision_id = od_db.id)
  • Rows Removed by Join Filter: 1
20. 0.002 0.642 ↑ 1.0 1 5 / 5

Nested Loop (cost=1.29..1,465.25 rows=1 width=56) (actual time=0.036..0.642 rows=1 loops=5)

21. 0.002 0.632 ↑ 1.0 1 5 / 5

Nested Loop (cost=0.86..1,464.80 rows=1 width=56) (actual time=0.027..0.632 rows=1 loops=5)

22. 0.054 0.623 ↑ 1.0 1 5 / 5

Nested Loop (cost=0.43..1,457.55 rows=1 width=40) (actual time=0.019..0.623 rows=1 loops=5)

23. 0.053 0.053 ↑ 1.0 172 5 / 5

Seq Scan on nettingbundle nb (cost=0.00..3.72 rows=172 width=16) (actual time=0.008..0.053 rows=172 loops=5)

24. 0.516 0.516 ↓ 0.0 0 860 / 5

Index Scan using supplierinvoice_pkey on supplierinvoice fi_si (cost=0.43..8.45 rows=1 width=24) (actual time=0.003..0.003 rows=0 loops=860)

  • Index Cond: (id = nb.surplus_id)
  • Filter: (supplier_id = 6167)
  • Rows Removed by Filter: 1
25. 0.007 0.007 ↑ 1.0 1 5 / 5

Index Scan using earlypaymentsettlement_invoice_idx on earlypaymentsettlement fi_eps (cost=0.43..7.25 rows=1 width=40) (actual time=0.006..0.007 rows=1 loops=5)

  • Index Cond: (invoice_id = fi_si.id)
  • Filter: (creationdate >= '2019-01-01'::date)
26. 0.008 0.008 ↑ 1.0 1 5 / 5

Index Scan using apfearlypaymentsettlement_pkey on apfearlypaymentsettlement fi_ps_apfeps (cost=0.42..0.45 rows=1 width=24) (actual time=0.007..0.008 rows=1 loops=5)

  • Index Cond: (id = fi_eps.id)
27. 0.004 0.004 ↑ 7.0 2 5 / 5

Seq Scan on divisionbase od_db (cost=0.00..1.14 rows=14 width=28) (actual time=0.004..0.004 rows=2 loops=5)

28. 0.001 0.001 ↑ 1.0 1 1 / 5

Index Scan using apfearlypaymentsettlement_pkey on apfearlypaymentsettlement ps_apfeps (cost=0.42..0.45 rows=1 width=24) (actual time=0.004..0.004 rows=1 loops=1)

  • Index Cond: (id = ps_eps.id)
29. 0.003 0.014 ↑ 1.0 20 1 / 5

Hash (cost=2.93..2.93 rows=20 width=26) (actual time=0.067..0.068 rows=20 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
30. 0.004 0.010 ↑ 1.0 20 1 / 5

Merge Right Join (cost=2.05..2.93 rows=20 width=26) (actual time=0.030..0.051 rows=20 loops=1)

  • Merge Cond: (ps_eps_t_bc_cb.id = ps_apfeps_t_apfda.bank_id)
31. 0.002 0.002 ↑ 275.0 6 1 / 5

Index Scan using corporatebase_pkey on corporatebase ps_eps_t_bc_cb (cost=0.28..234.48 rows=1,650 width=26) (actual time=0.008..0.010 rows=6 loops=1)

32. 0.003 0.005 ↑ 1.0 20 1 / 5

Sort (cost=1.63..1.68 rows=20 width=16) (actual time=0.019..0.023 rows=20 loops=1)

  • Sort Key: ps_apfeps_t_apfda.bank_id
  • Sort Method: quicksort Memory: 25kB
33. 0.002 0.002 ↑ 1.0 20 1 / 5

Seq Scan on apfdebtoragreement ps_apfeps_t_apfda (cost=0.00..1.20 rows=20 width=16) (actual time=0.003..0.009 rows=20 loops=1)

34. 0.002 0.002 ↑ 1.0 1 1 / 5

Index Scan using financingcontextbase_pkey on financingcontextbase ps_apffc_fc_fcb (cost=0.42..0.47 rows=1 width=24) (actual time=0.007..0.008 rows=1 loops=1)

  • Index Cond: (id = ps_apfeps.financingcontext_id)
35. 0.001 0.001 ↑ 1.0 1 1 / 5

Index Scan using apffinancingcontext_pkey on apffinancingcontext fi_ps_apffc_fc_afc (cost=0.42..0.46 rows=1 width=132) (actual time=0.007..0.007 rows=1 loops=1)

  • Index Cond: (fi_ps_apfeps.financingcontext_id = id)
36. 0.111 0.325 ↑ 1.0 1,650 1 / 5

Hash (cost=190.50..190.50 rows=1,650 width=26) (actual time=1.624..1.625 rows=1,650 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 119kB
37. 0.214 0.214 ↑ 1.0 1,650 1 / 5

Seq Scan on corporatebase od_c_cb (cost=0.00..190.50 rows=1,650 width=26) (actual time=0.003..1.071 rows=1,650 loops=1)

38. 0.103 0.244 ↑ 1.0 1,650 1 / 5

Hash (cost=190.50..190.50 rows=1,650 width=26) (actual time=1.219..1.219 rows=1,650 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 119kB
39. 0.140 0.140 ↑ 1.0 1,650 1 / 5

Seq Scan on corporatebase s_cb (cost=0.00..190.50 rows=1,650 width=26) (actual time=0.003..0.702 rows=1,650 loops=1)

40. 0.001 0.002 ↑ 1.0 6 1 / 5

Hash (cost=1.06..1.06 rows=6 width=12) (actual time=0.009..0.009 rows=6 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
41. 0.001 0.001 ↑ 1.0 6 1 / 5

Seq Scan on crxcurrency c (cost=0.00..1.06 rows=6 width=12) (actual time=0.003..0.006 rows=6 loops=1)

42. 0.001 0.001 ↑ 1.0 1 1 / 5

Index Scan using arpimportbatch_pkey on arpimportbatch ib (cost=0.43..0.50 rows=1 width=16) (actual time=0.007..0.007 rows=1 loops=1)

  • Index Cond: (si.importbatch_id = id)
43. 0.057 0.115 ↑ 1.0 945 1 / 5

Hash (cost=20.45..20.45 rows=945 width=30) (actual time=0.574..0.575 rows=945 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 68kB
44. 0.058 0.058 ↑ 1.0 945 1 / 5

Seq Scan on earlypaymentadvice fi_eps_epa (cost=0.00..20.45 rows=945 width=30) (actual time=0.003..0.289 rows=945 loops=1)

45. 0.000 0.001 ↓ 0.0 0 1 / 5

Hash (cost=10.10..10.10 rows=10 width=1,052) (actual time=0.002..0.003 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
46. 0.000 0.000 ↓ 0.0 0 1 / 5

Seq Scan on invoicepaymentadvice fi_ipa (cost=0.00..10.10 rows=10 width=1,052) (actual time=0.002..0.002 rows=0 loops=1)

47. 0.000 0.000 ↓ 0.0 0 1 / 5

Hash (cost=10.10..10.10 rows=10 width=16) (actual time=0.002..0.002 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
48. 0.000 0.000 ↓ 0.0 0 1 / 5

Seq Scan on bankpaymenttransaction fi_bpt (cost=0.00..10.10 rows=10 width=16) (actual time=0.001..0.002 rows=0 loops=1)

49.          

SubPlan (for Gather)

50. 0.004 0.006 ↑ 1.0 1 1

Aggregate (cost=8.15..8.16 rows=1 width=8) (actual time=0.005..0.006 rows=1 loops=1)

51. 0.002 0.002 ↓ 0.0 0 1

Index Scan using bankpaymenttransaction_mapping_idx on bankpaymenttransaction bpt (cost=0.14..8.15 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (mapping_id = fi_eps.maturitypaymentmapping_id)
Planning time : 8.679 ms
Execution time : 15.153 ms