explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6lj8

Settings
# exclusive inclusive rows x rows loops node
1. 17.494 2,336.035 ↑ 4.9 10,261 1

Gather (cost=340,003.07..779,039.27 rows=50,461 width=1,810) (actual time=2,248.640..2,336.035 rows=10,261 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 3.105 2,308.280 ↑ 6.1 3,420 3 / 3

Hash Left Join (cost=339,003.07..360,600.65 rows=21,025 width=1,655) (actual time=2,242.512..2,308.280 rows=3,420 loops=3)

  • Hash Cond: (ps_eps.earlypaymentmapping_id = bpt.mapping_id)
3. 2.954 2,305.170 ↑ 6.1 3,420 3 / 3

Hash Left Join (cost=338,992.85..360,511.57 rows=21,025 width=1,655) (actual time=2,242.491..2,305.170 rows=3,420 loops=3)

  • Hash Cond: (si.paymentadvice_id = ipa.id)
4. 2.940 2,302.211 ↑ 6.1 3,420 3 / 3

Hash Left Join (cost=338,982.62..360,446.15 rows=21,025 width=611) (actual time=2,242.471..2,302.211 rows=3,420 loops=3)

  • Hash Cond: (ps_eps.earlypaymentadvice_id = eps_epa.id)
5. 3.151 2,298.532 ↑ 6.1 3,420 3 / 3

Hash Left Join (cost=338,950.36..360,358.70 rows=21,025 width=597) (actual time=2,241.719..2,298.532 rows=3,420 loops=3)

  • Hash Cond: (si.currency_id = c.id)
6. 5.148 2,295.365 ↑ 6.1 3,420 3 / 3

Nested Loop Left Join (cost=338,949.23..360,263.39 rows=21,025 width=601) (actual time=2,241.688..2,295.365 rows=3,420 loops=3)

7. 3.182 2,283.376 ↑ 6.1 3,420 3 / 3

Hash Left Join (cost=338,948.79..349,802.97 rows=21,025 width=601) (actual time=2,241.668..2,283.376 rows=3,420 loops=3)

  • Hash Cond: (si.supplier_id = s_cb.id)
8. 3.153 2,278.474 ↑ 6.1 3,420 3 / 3

Hash Left Join (cost=338,737.67..349,536.51 rows=21,025 width=591) (actual time=2,239.929..2,278.474 rows=3,420 loops=3)

  • Hash Cond: (od_db.buyer_id = od_c_cb.id)
9. 4.433 2,275.275 ↑ 6.1 3,420 3 / 3

Parallel Hash Left Join (cost=338,729.36..349,239.11 rows=21,025 width=581) (actual time=2,239.856..2,275.275 rows=3,420 loops=3)

  • Hash Cond: (ps_apffc_fc_fcb.id = ps_apffc_fc_afc.id)
10. 4.220 2,191.092 ↑ 6.1 3,420 3 / 3

Parallel Hash Left Join (cost=331,584.27..342,038.83 rows=21,025 width=465) (actual time=2,159.318..2,191.092 rows=3,420 loops=3)

  • Hash Cond: (ps_apfeps.financingcontext_id = ps_apffc_fc_fcb.id)
11. 3.201 2,060.347 ↑ 6.1 3,420 3 / 3

Hash Join (cost=321,740.86..332,140.23 rows=21,025 width=449) (actual time=2,032.047..2,060.347 rows=3,420 loops=3)

  • Hash Cond: (ps_apfeps.apfda_id = ps_apfeps_t_apfda.id)
12. 107.037 2,057.032 ↑ 6.1 3,420 3 / 3

Parallel Hash Join (cost=321,737.68..331,847.95 rows=21,025 width=439) (actual time=2,031.908..2,057.032 rows=3,420 loops=3)

  • Hash Cond: (ps_apfeps.id = ps_eps.id)
13. 82.768 82.768 ↑ 1.3 277,103 3 / 3

Parallel Seq Scan on apfearlypaymentsettlement ps_apfeps (cost=0.00..8,758.79 rows=346,379 width=24) (actual time=0.004..82.768 rows=277,103 loops=3)

14. 6.431 1,867.227 ↑ 28.3 3,420 3 / 3

Parallel Hash (cost=320,528.59..320,528.59 rows=96,727 width=423) (actual time=1,867.227..1,867.227 rows=3,420 loops=3)

  • Buckets: 524288 Batches: 1 Memory Usage: 8480kB
15. 884.033 1,860.796 ↑ 28.3 3,420 3 / 3

Hash Join (cost=49,385.50..320,528.59 rows=96,727 width=423) (actual time=1,847.712..1,860.796 rows=3,420 loops=3)

  • Hash Cond: (ps_eps.invoice_id = si.id)
16. 815.452 815.452 ↓ 1.3 1,808,270 3 / 3

Parallel Seq Scan on earlypaymentsettlement ps_eps (cost=0.00..265,095.99 rows=1,354,620 width=220) (actual time=0.007..815.452 rows=1,808,270 loops=3)

  • Filter: (creationdate >= '2019-01-01'::date)
  • Rows Removed by Filter: 316423
17. 58.381 161.311 ↑ 5.8 80,348 3 / 3

Hash (cost=43,521.49..43,521.49 rows=469,121 width=219) (actual time=161.311..161.311 rows=80,348 loops=3)

  • Buckets: 524288 Batches: 1 Memory Usage: 24137kB
18. 58.581 102.930 ↑ 5.8 80,348 3 / 3

Nested Loop (cost=0.43..43,521.49 rows=469,121 width=219) (actual time=0.037..102.930 rows=80,348 loops=3)

19. 0.016 0.016 ↑ 1.0 1 3 / 3

Seq Scan on divisionbase od_db (cost=0.00..1.18 rows=1 width=28) (actual time=0.015..0.016 rows=1 loops=3)

  • Filter: (buyer_id = 67002626)
  • Rows Removed by Filter: 13
20. 44.333 44.333 ↑ 5.8 80,348 3 / 3

Index Scan using supplierinvoice_originatordivision_idx on supplierinvoice si (cost=0.43..38,829.11 rows=469,121 width=207) (actual time=0.017..44.333 rows=80,348 loops=3)

  • Index Cond: (originatordivision_id = od_db.id)
  • Filter: (nettingbundle_id IS NULL)
  • Rows Removed by Filter: 402
21. 0.011 0.114 ↑ 1.0 20 3 / 3

Hash (cost=2.93..2.93 rows=20 width=26) (actual time=0.114..0.114 rows=20 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
22. 0.019 0.103 ↑ 1.0 20 3 / 3

Merge Right Join (cost=2.05..2.93 rows=20 width=26) (actual time=0.082..0.103 rows=20 loops=3)

  • Merge Cond: (ps_eps_t_bc_cb.id = ps_apfeps_t_apfda.bank_id)
23. 0.022 0.022 ↑ 275.0 6 3 / 3

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.019..0.022 rows=6 loops=3)

24. 0.040 0.062 ↑ 1.0 20 3 / 3

Sort (cost=1.63..1.68 rows=20 width=16) (actual time=0.057..0.062 rows=20 loops=3)

  • Sort Key: ps_apfeps_t_apfda.bank_id
  • Sort Method: quicksort Memory: 25kB
  • Worker 0: Sort Method: quicksort Memory: 25kB
  • Worker 1: Sort Method: quicksort Memory: 25kB
25. 0.022 0.022 ↑ 1.0 20 3 / 3

Seq Scan on apfdebtoragreement ps_apfeps_t_apfda (cost=0.00..1.20 rows=20 width=16) (actual time=0.015..0.022 rows=20 loops=3)

26. 67.462 126.525 ↑ 1.3 131,499 3 / 3

Parallel Hash (cost=7,788.74..7,788.74 rows=164,374 width=24) (actual time=126.525..126.525 rows=131,499 loops=3)

  • Buckets: 524288 Batches: 1 Memory Usage: 26656kB
27. 59.063 59.063 ↑ 1.3 131,499 3 / 3

Parallel Seq Scan on financingcontextbase ps_apffc_fc_fcb (cost=0.00..7,788.74 rows=164,374 width=24) (actual time=0.008..59.063 rows=131,499 loops=3)

28. 41.755 79.750 ↑ 1.2 79,932 3 / 3

Parallel Hash (cost=5,896.15..5,896.15 rows=99,915 width=132) (actual time=79.750..79.750 rows=79,932 loops=3)

  • Buckets: 262144 Batches: 1 Memory Usage: 20832kB
29. 37.995 37.995 ↑ 1.2 79,932 3 / 3

Parallel Seq Scan on apffinancingcontext ps_apffc_fc_afc (cost=0.00..5,896.15 rows=99,915 width=132) (actual time=0.006..37.995 rows=79,932 loops=3)

30. 0.007 0.046 ↑ 1.0 1 3 / 3

Hash (cost=8.29..8.29 rows=1 width=26) (actual time=0.046..0.046 rows=1 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
31. 0.039 0.039 ↑ 1.0 1 3 / 3

Index Scan using corporatebase_pkey on corporatebase od_c_cb (cost=0.28..8.29 rows=1 width=26) (actual time=0.038..0.039 rows=1 loops=3)

  • Index Cond: (id = 67002626)
32. 0.698 1.720 ↑ 1.0 1,650 3 / 3

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

  • Buckets: 2048 Batches: 1 Memory Usage: 119kB
33. 1.022 1.022 ↑ 1.0 1,650 3 / 3

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

34. 6.841 6.841 ↑ 1.0 1 10,261 / 3

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

  • Index Cond: (si.importbatch_id = id)
35. 0.006 0.016 ↑ 1.0 6 3 / 3

Hash (cost=1.06..1.06 rows=6 width=12) (actual time=0.015..0.016 rows=6 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
36. 0.010 0.010 ↑ 1.0 6 3 / 3

Seq Scan on crxcurrency c (cost=0.00..1.06 rows=6 width=12) (actual time=0.007..0.010 rows=6 loops=3)

37. 0.382 0.739 ↑ 1.0 945 3 / 3

Hash (cost=20.45..20.45 rows=945 width=30) (actual time=0.739..0.739 rows=945 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 68kB
38. 0.357 0.357 ↑ 1.0 945 3 / 3

Seq Scan on earlypaymentadvice eps_epa (cost=0.00..20.45 rows=945 width=30) (actual time=0.005..0.357 rows=945 loops=3)

39. 0.001 0.005 ↓ 0.0 0 3 / 3

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

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
40. 0.004 0.004 ↓ 0.0 0 3 / 3

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

41. 0.001 0.005 ↓ 0.0 0 3 / 3

Hash (cost=10.10..10.10 rows=10 width=16) (actual time=0.004..0.005 rows=0 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
42. 0.004 0.004 ↓ 0.0 0 3 / 3

Seq Scan on bankpaymenttransaction bpt (cost=0.00..10.10 rows=10 width=16) (actual time=0.003..0.004 rows=0 loops=3)

43.          

SubPlan (for Gather)

44. 10.261 10.261 ↑ 1.0 1 10,261

Aggregate (cost=8.15..8.16 rows=1 width=8) (actual time=0.001..0.001 rows=1 loops=10,261)

45. 0.000 0.000 ↓ 0.0 0 10,261

Index Scan using bankpaymenttransaction_mapping_idx on bankpaymenttransaction bpt_1 (cost=0.14..8.15 rows=1 width=8) (actual time=0.000..0.000 rows=0 loops=10,261)

  • Index Cond: (mapping_id = ps_eps.maturitypaymentmapping_id)
Planning time : 8.310 ms
Execution time : 2,339.054 ms