explain.depesz.com

PostgreSQL's explain analyze made readable

Result: KeOF

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

Gather (cost=339,331.92..778,368.11 rows=50,461 width=1,826) (actual time=2,234.326..2,325.640 rows=10,261 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 3.359 2,293.849 ↑ 6.1 3,420 3 / 3

Hash Left Join (cost=338,331.92..359,929.49 rows=21,025 width=1,639) (actual time=2,224.189..2,293.849 rows=3,420 loops=3)

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

Hash Left Join (cost=338,321.69..359,840.41 rows=21,025 width=1,639) (actual time=2,224.169..2,290.485 rows=3,420 loops=3)

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

Hash Left Join (cost=338,311.47..359,774.99 rows=21,025 width=595) (actual time=2,224.147..2,287.477 rows=3,420 loops=3)

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

Hash Left Join (cost=338,279.21..359,687.54 rows=21,025 width=581) (actual time=2,223.383..2,283.643 rows=3,420 loops=3)

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

Nested Loop Left Join (cost=338,278.07..359,592.23 rows=21,025 width=585) (actual time=2,223.352..2,280.182 rows=3,420 loops=3)

7. 3.276 2,267.355 ↑ 6.1 3,420 3 / 3

Hash Left Join (cost=338,277.64..349,131.82 rows=21,025 width=585) (actual time=2,223.332..2,267.355 rows=3,420 loops=3)

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

Hash Left Join (cost=338,066.51..348,865.35 rows=21,025 width=575) (actual time=2,221.544..2,262.306 rows=3,420 loops=3)

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

Parallel Hash Left Join (cost=338,058.21..348,567.95 rows=21,025 width=565) (actual time=2,221.467..2,258.949 rows=3,420 loops=3)

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

Parallel Hash Left Join (cost=330,913.12..341,367.68 rows=21,025 width=449) (actual time=2,128.702..2,162.332 rows=3,420 loops=3)

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

Hash Join (cost=321,740.93..332,140.29 rows=21,025 width=449) (actual time=2,030.090..2,060.224 rows=3,420 loops=3)

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

Parallel Hash Join (cost=321,737.75..331,848.02 rows=21,025 width=439) (actual time=2,029.945..2,056.776 rows=3,420 loops=3)

  • Hash Cond: (ps_apfeps.id = ps_eps.id)
13. 88.777 88.777 ↑ 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.006..88.777 rows=277,103 loops=3)

14. 6.706 1,854.510 ↑ 28.3 3,420 3 / 3

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

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

Hash Join (cost=49,385.50..320,528.66 rows=96,727 width=423) (actual time=1,833.872..1,847.804 rows=3,420 loops=3)

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

Parallel Seq Scan on earlypaymentsettlement ps_eps (cost=0.00..265,096.04 rows=1,354,624 width=220) (actual time=0.005..795.866 rows=1,808,270 loops=3)

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

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

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

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

19. 0.014 0.014 ↑ 1.0 1 3 / 3

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

  • Filter: (buyer_id = 67002626)
  • Rows Removed by Filter: 13
20. 48.522 48.522 ↑ 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.333..48.522 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.116 ↑ 1.0 20 3 / 3

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

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

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

  • Merge Cond: (ps_eps_t_bc_cb.id = ps_apfeps_t_apfda.bank_id)
23. 0.020 0.020 ↑ 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.017..0.020 rows=6 loops=3)

24. 0.043 0.067 ↑ 1.0 20 3 / 3

Sort (cost=1.63..1.68 rows=20 width=16) (actual time=0.061..0.067 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.024 0.024 ↑ 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.018..0.024 rows=20 loops=3)

26. 55.822 97.776 ↓ 1.0 131,499 3 / 3

Parallel Hash (cost=7,581.48..7,581.48 rows=127,257 width=8) (actual time=97.776..97.776 rows=131,499 loops=3)

  • Buckets: 524288 Batches: 1 Memory Usage: 19584kB
27. 41.954 41.954 ↓ 1.0 131,499 3 / 3

Parallel Index Only Scan using financingcontextbase_pkey on financingcontextbase ps_apffc_fc_fcb (cost=0.42..7,581.48 rows=127,257 width=8) (actual time=0.028..41.954 rows=131,499 loops=3)

  • Heap Fetches: 0
28. 45.886 92.216 ↑ 1.2 79,932 3 / 3

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

  • Buckets: 262144 Batches: 1 Memory Usage: 20832kB
29. 46.330 46.330 ↑ 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.005..46.330 rows=79,932 loops=3)

30. 0.006 0.048 ↑ 1.0 1 3 / 3

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
31. 0.042 0.042 ↑ 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.041..0.042 rows=1 loops=3)

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

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

  • Buckets: 2048 Batches: 1 Memory Usage: 119kB
33. 1.053 1.053 ↑ 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.017..1.053 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.005 0.015 ↑ 1.0 6 3 / 3

Hash (cost=1.06..1.06 rows=6 width=12) (actual time=0.015..0.015 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.396 0.751 ↑ 1.0 945 3 / 3

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

  • Buckets: 1024 Batches: 1 Memory Usage: 68kB
38. 0.355 0.355 ↑ 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.355 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.336 ms
Execution time : 2,328.857 ms