explain.depesz.com

PostgreSQL's explain analyze made readable

Result: kXZf

Settings
# exclusive inclusive rows x rows loops node
1. 31.273 400.665 ↓ 1.1 12,760 1

Hash Left Join (cost=3,691.76..272,882.37 rows=11,943 width=1,770) (actual time=109.296..400.665 rows=12,760 loops=1)

  • Hash Cond: (ps_eps.earlypaymentmapping_id = bpt.mapping_id)
2. 12.424 249.413 ↓ 1.1 12,760 1

Hash Left Join (cost=1,812.49..171,472.86 rows=11,943 width=1,793) (actual time=40.175..249.413 rows=12,760 loops=1)

  • Hash Cond: ((ps_abseps_t_absda.id = ifca.absda_id) AND (si.currency_id = ifca.currency_id))
3. 29.888 236.000 ↓ 1.1 12,760 1

Nested Loop (cost=1,810.77..171,330.38 rows=11,943 width=1,685) (actual time=39.165..236.000 rows=12,760 loops=1)

  • Join Filter: (si.currency_id = c.id)
  • Rows Removed by Join Filter: 63800
4. 0.408 0.408 ↑ 1.0 6 1

Index Scan using crxcurrency_pkey on crxcurrency c (cost=0.13..12.22 rows=6 width=12) (actual time=0.400..0.408 rows=6 loops=1)

5. 30.430 205.704 ↓ 1.1 12,760 6

Materialize (cost=1,810.64..170,273.15 rows=11,943 width=1,681) (actual time=6.460..34.284 rows=12,760 loops=6)

6. 10.167 175.274 ↓ 1.1 12,760 1

Hash Left Join (cost=1,810.64..170,213.43 rows=11,943 width=1,681) (actual time=38.751..175.274 rows=12,760 loops=1)

  • Hash Cond: (si.paymentadvice_id = ipa.id)
7. 9.613 165.103 ↓ 1.1 12,760 1

Hash Left Join (cost=1,800.41..170,171.86 rows=11,943 width=637) (actual time=38.728..165.103 rows=12,760 loops=1)

  • Hash Cond: (ps_eps.earlypaymentadvice_id = eps_epa.id)
8. 11.914 155.113 ↓ 1.1 12,760 1

Nested Loop (cost=1,798.51..170,138.61 rows=11,943 width=623) (actual time=38.329..155.113 rows=12,760 loops=1)

9. 11.180 104.919 ↓ 1.1 12,760 1

Hash Join (cost=1,798.08..88,541.12 rows=11,943 width=623) (actual time=35.136..104.919 rows=12,760 loops=1)

  • Hash Cond: (ps_abseps_t_absda.bank_id = ps_eps_t_bc_cb.id)
10. 10.537 83.891 ↓ 1.1 12,760 1

Hash Join (cost=1,586.95..88,298.57 rows=11,943 width=613) (actual time=25.258..83.891 rows=12,760 loops=1)

  • Hash Cond: (si.supplier_id = s_cb.id)
11. 9.135 72.017 ↓ 1.1 12,760 1

Nested Loop (cost=1,375.83..88,056.01 rows=11,943 width=603) (actual time=23.901..72.017 rows=12,760 loops=1)

12. 0.045 0.045 ↑ 1.0 1 1

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

  • Index Cond: (id = 64608300)
13. 10.952 62.837 ↓ 1.1 12,760 1

Hash Join (cost=1,375.55..87,928.29 rows=11,943 width=593) (actual time=23.851..62.837 rows=12,760 loops=1)

  • Hash Cond: (ps_abseps.absda_id = ps_abseps_t_absda.id)
14. 14.132 51.312 ↓ 1.1 12,760 1

Nested Loop (cost=1,374.24..87,886.13 rows=11,943 width=585) (actual time=23.261..51.312 rows=12,760 loops=1)

15. 0.405 0.405 ↑ 1.0 1 1

Seq Scan on capfloorauction cfa (cost=0.00..1.31 rows=1 width=21) (actual time=0.401..0.405 rows=1 loops=1)

  • Filter: (id = 6656)
  • Rows Removed by Filter: 24
16. 0.000 36.775 ↓ 1.1 12,760 1

Gather (cost=1,374.24..87,765.39 rows=11,943 width=580) (actual time=22.854..36.775 rows=12,760 loops=1)

  • Workers Planned: 3
  • Workers Launched: 3
17. 3.068 69.820 ↑ 1.2 3,190 4 / 4

Hash Left Join (cost=374.24..85,571.09 rows=3,853 width=580) (actual time=17.679..69.820 rows=3,190 loops=4)

  • Hash Cond: (ps_absfc_fc_fcb.id = ps_absfc_fc_afc.id)
18. 4.153 62.406 ↑ 1.2 3,190 4 / 4

Nested Loop Left Join (cost=282.99..85,469.73 rows=3,853 width=463) (actual time=13.304..62.406 rows=3,190 loops=4)

19. 2.836 51.873 ↑ 1.2 3,190 4 / 4

Hash Join (cost=282.56..83,753.32 rows=3,853 width=447) (actual time=12.059..51.873 rows=3,190 loops=4)

  • Hash Cond: (si.originatordivision_id = od_db.id)
20. 2.536 48.899 ↑ 1.2 3,190 4 / 4

Nested Loop (cost=280.21..83,737.80 rows=3,853 width=435) (actual time=11.868..48.899 rows=3,190 loops=4)

21. 6.652 36.793 ↑ 1.5 3,190 4 / 4

Nested Loop (cost=279.78..81,498.28 rows=4,631 width=419) (actual time=10.635..36.793 rows=3,190 loops=4)

22. 8.694 11.001 ↑ 1.5 3,190 4 / 4

Parallel Bitmap Heap Scan on supplierinvoice si (cost=279.35..47,334.75 rows=4,782 width=215) (actual time=7.693..11.001 rows=3,190 loops=4)

  • Recheck Cond: (lastauction_id = 6656)
  • Filter: (nettingbundle_id IS NULL)
  • Rows Removed by Filter: 500
  • Heap Blocks: exact=1
23. 2.307 2.307 ↑ 1.0 14,760 1 / 4

Bitmap Index Scan on supplierinvoice_lastauction_idx (cost=0.00..275.64 rows=14,828 width=0) (actual time=9.228..9.228 rows=14,760 loops=1)

  • Index Cond: (lastauction_id = 6656)
24. 19.140 19.140 ↑ 1.0 1 12,760 / 4

Index Scan using earlypaymentsettlement_invoice_uq on earlypaymentsettlement ps_eps (cost=0.43..7.14 rows=1 width=220) (actual time=0.006..0.006 rows=1 loops=12,760)

  • Index Cond: (invoice_id = si.id)
25. 9.570 9.570 ↑ 1.0 1 12,760 / 4

Index Scan using absearlypaymentsettlement_pkey on absearlypaymentsettlement ps_abseps (cost=0.43..0.48 rows=1 width=24) (actual time=0.003..0.003 rows=1 loops=12,760)

  • Index Cond: (id = ps_eps.id)
26. 0.011 0.138 ↑ 1.0 14 4 / 4

Hash (cost=2.17..2.17 rows=14 width=28) (actual time=0.137..0.138 rows=14 loops=4)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
27. 0.127 0.127 ↑ 1.0 14 4 / 4

Seq Scan on divisionbase od_db (cost=0.00..2.17 rows=14 width=28) (actual time=0.118..0.127 rows=14 loops=4)

  • Filter: (buyer_id = 64608300)
28. 6.380 6.380 ↑ 1.0 1 12,760 / 4

Index Scan using financingcontextbase_pkey on financingcontextbase ps_absfc_fc_fcb (cost=0.42..0.45 rows=1 width=24) (actual time=0.002..0.002 rows=1 loops=12,760)

  • Index Cond: (id = ps_abseps.financingcontext_id)
29. 0.918 4.346 ↑ 1.0 2,100 4 / 4

Hash (cost=65.00..65.00 rows=2,100 width=133) (actual time=4.346..4.346 rows=2,100 loops=4)

  • Buckets: 4096 Batches: 1 Memory Usage: 197kB
30. 3.428 3.428 ↑ 1.0 2,100 4 / 4

Seq Scan on absfinancingcontext ps_absfc_fc_afc (cost=0.00..65.00 rows=2,100 width=133) (actual time=0.569..3.428 rows=2,100 loops=4)

31. 0.010 0.573 ↑ 1.0 14 1

Hash (cost=1.14..1.14 rows=14 width=16) (actual time=0.573..0.573 rows=14 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
32. 0.563 0.563 ↑ 1.0 14 1

Seq Scan on absdebtoragreement ps_abseps_t_absda (cost=0.00..1.14 rows=14 width=16) (actual time=0.559..0.563 rows=14 loops=1)

33. 0.551 1.337 ↑ 1.0 1,650 1

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

  • Buckets: 2048 Batches: 1 Memory Usage: 119kB
34. 0.786 0.786 ↑ 1.0 1,650 1

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

35. 0.596 9.848 ↑ 1.0 1,650 1

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

  • Buckets: 2048 Batches: 1 Memory Usage: 119kB
36. 9.252 9.252 ↑ 1.0 1,650 1

Seq Scan on corporatebase ps_eps_t_bc_cb (cost=0.00..190.50 rows=1,650 width=26) (actual time=0.529..9.252 rows=1,650 loops=1)

37. 38.280 38.280 ↑ 1.0 1 12,760

Index Scan using arpimportbatch_pkey on arpimportbatch ib (cost=0.43..6.83 rows=1 width=16) (actual time=0.003..0.003 rows=1 loops=12,760)

  • Index Cond: (id = si.importbatch_id)
38. 0.019 0.377 ↑ 1.0 40 1

Hash (cost=1.40..1.40 rows=40 width=30) (actual time=0.377..0.377 rows=40 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
39. 0.358 0.358 ↑ 1.0 40 1

Seq Scan on earlypaymentadvice eps_epa (cost=0.00..1.40 rows=40 width=30) (actual time=0.347..0.358 rows=40 loops=1)

40. 0.000 0.004 ↓ 0.0 0 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
41. 0.004 0.004 ↓ 0.0 0 1

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

42. 0.007 0.989 ↑ 1.0 6 1

Hash (cost=1.63..1.63 rows=6 width=140) (actual time=0.988..0.989 rows=6 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
43. 0.010 0.982 ↑ 1.0 6 1

Merge Right Join (cost=1.42..1.63 rows=6 width=140) (actual time=0.974..0.982 rows=6 loops=1)

  • Merge Cond: (cba.id = ifca.maturitypaymentsaccount_id)
44. 0.537 0.537 ↑ 544.3 3 1

Index Scan using corporatebankaccount_pkey on corporatebankaccount cba (cost=0.28..99.78 rows=1,633 width=132) (actual time=0.536..0.537 rows=3 loops=1)

45. 0.035 0.435 ↑ 1.0 6 1

Sort (cost=1.14..1.15 rows=6 width=24) (actual time=0.433..0.435 rows=6 loops=1)

  • Sort Key: ifca.maturitypaymentsaccount_id
  • Sort Method: quicksort Memory: 25kB
46. 0.400 0.400 ↑ 1.0 6 1

Seq Scan on fiduciarycashaccount ifca (cost=0.00..1.06 rows=6 width=24) (actual time=0.398..0.400 rows=6 loops=1)

47. 9.811 68.939 ↑ 1.0 30,234 1

Hash (cost=1,501.34..1,501.34 rows=30,234 width=16) (actual time=68.938..68.939 rows=30,234 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 1674kB
48. 59.128 59.128 ↑ 1.0 30,234 1

Seq Scan on bankpaymenttransaction bpt (cost=0.00..1,501.34 rows=30,234 width=16) (actual time=29.009..59.128 rows=30,234 loops=1)

49.          

SubPlan (for Hash Left Join)

50. 12.760 51.040 ↑ 1.0 1 12,760

Aggregate (cost=8.31..8.32 rows=1 width=8) (actual time=0.004..0.004 rows=1 loops=12,760)

51. 38.280 38.280 ↑ 1.0 1 12,760

Index Scan using bankpaymenttransaction_mapping_idx on bankpaymenttransaction bpt_1 (cost=0.29..8.30 rows=1 width=8) (actual time=0.002..0.003 rows=1 loops=12,760)

  • Index Cond: (mapping_id = ps_eps.maturitypaymentmapping_id)
Planning time : 166.416 ms
Execution time : 406.083 ms