explain.depesz.com

PostgreSQL's explain analyze made readable

Result: XqiM

Settings
# exclusive inclusive rows x rows loops node
1. 36.638 268.295 ↓ 2.5 12,760 1

Nested Loop Left Join (cost=1,813.78..214,728.56 rows=5,118 width=1,770) (actual time=8.175..268.295 rows=12,760 loops=1)

2. 13.402 167.857 ↓ 2.5 12,760 1

Hash Join (cost=1,813.49..170,478.78 rows=5,118 width=1,793) (actual time=8.142..167.857 rows=12,760 loops=1)

  • Hash Cond: ((ps_abseps.absda_id = ifca.absda_id) AND (si.currency_id = ifca.currency_id))
3. 10.355 154.414 ↓ 1.1 12,760 1

Hash Left Join (cost=1,811.77..170,268.06 rows=11,943 width=1,693) (actual time=8.082..154.414 rows=12,760 loops=1)

  • Hash Cond: (si.paymentadvice_id = ipa.id)
4. 11.047 144.057 ↓ 1.1 12,760 1

Hash Left Join (cost=1,801.55..170,226.48 rows=11,943 width=649) (actual time=8.068..144.057 rows=12,760 loops=1)

  • Hash Cond: (ps_eps.earlypaymentadvice_id = eps_epa.id)
5. 10.607 132.976 ↓ 1.1 12,760 1

Hash Left Join (cost=1,799.65..170,193.23 rows=11,943 width=635) (actual time=8.020..132.976 rows=12,760 loops=1)

  • Hash Cond: (si.currency_id = c.id)
6. 18.488 122.356 ↓ 1.1 12,760 1

Nested Loop (cost=1,798.51..170,138.61 rows=11,943 width=631) (actual time=7.993..122.356 rows=12,760 loops=1)

7. 11.534 78.348 ↓ 1.1 12,760 1

Hash Join (cost=1,798.08..88,541.12 rows=11,943 width=631) (actual time=7.973..78.348 rows=12,760 loops=1)

  • Hash Cond: (ps_abseps_t_absda.bank_id = ps_eps_t_bc_cb.id)
8. 10.999 65.348 ↓ 1.1 12,760 1

Hash Join (cost=1,586.95..88,298.57 rows=11,943 width=621) (actual time=6.499..65.348 rows=12,760 loops=1)

  • Hash Cond: (si.supplier_id = s_cb.id)
9. 9.307 53.106 ↓ 1.1 12,760 1

Nested Loop (cost=1,375.83..88,056.01 rows=11,943 width=611) (actual time=5.249..53.106 rows=12,760 loops=1)

10. 0.010 0.010 ↑ 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.009..0.010 rows=1 loops=1)

  • Index Cond: (id = 64608300)
11. 11.545 43.789 ↓ 1.1 12,760 1

Hash Join (cost=1,375.55..87,928.29 rows=11,943 width=601) (actual time=5.234..43.789 rows=12,760 loops=1)

  • Hash Cond: (ps_abseps.absda_id = ps_abseps_t_absda.id)
12. 17.810 32.230 ↓ 1.1 12,760 1

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

13. 0.009 0.009 ↑ 1.0 1 1

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

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

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

  • Workers Planned: 3
  • Workers Launched: 3
15. 3.009 38.549 ↑ 1.2 3,190 4 / 4

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

  • Hash Cond: (ps_absfc_fc_fcb.id = ps_absfc_fc_afc.id)
16. 5.706 33.537 ↑ 1.2 3,190 4 / 4

Nested Loop (cost=282.99..85,469.73 rows=3,853 width=463) (actual time=0.368..33.537 rows=3,190 loops=4)

17. 2.743 24.641 ↑ 1.2 3,190 4 / 4

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

  • Hash Cond: (si.originatordivision_id = od_db.id)
18. 2.581 21.871 ↑ 1.2 3,190 4 / 4

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

19. 4.419 12.910 ↑ 1.5 3,190 4 / 4

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

20. 1.898 2.111 ↑ 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=0.249..2.111 rows=3,190 loops=4)

  • Recheck Cond: (lastauction_id = 6656)
  • Filter: (nettingbundle_id IS NULL)
  • Rows Removed by Filter: 500
  • Heap Blocks: exact=65
21. 0.213 0.213 ↑ 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=0.852..0.852 rows=14,760 loops=1)

  • Index Cond: (lastauction_id = 6656)
22. 6.380 6.380 ↑ 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.002..0.002 rows=1 loops=12,760)

  • Index Cond: (invoice_id = si.id)
23. 6.380 6.380 ↑ 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.002..0.002 rows=1 loops=12,760)

  • Index Cond: (id = ps_eps.id)
24. 0.009 0.027 ↑ 1.0 14 4 / 4

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

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

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

  • Filter: (buyer_id = 64608300)
26. 3.190 3.190 ↑ 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.001..0.001 rows=1 loops=12,760)

  • Index Cond: (id = ps_abseps.financingcontext_id)
27. 0.891 2.003 ↑ 1.0 2,100 4 / 4

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

  • Buckets: 4096 Batches: 1 Memory Usage: 197kB
28. 1.112 1.112 ↑ 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.005..1.112 rows=2,100 loops=4)

29. 0.007 0.014 ↑ 1.0 14 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
30. 0.007 0.007 ↑ 1.0 14 1

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

31. 0.562 1.243 ↑ 1.0 1,650 1

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

  • Buckets: 2048 Batches: 1 Memory Usage: 119kB
32. 0.681 0.681 ↑ 1.0 1,650 1

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

33. 0.512 1.466 ↑ 1.0 1,650 1

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

  • Buckets: 2048 Batches: 1 Memory Usage: 119kB
34. 0.954 0.954 ↑ 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.003..0.954 rows=1,650 loops=1)

35. 25.520 25.520 ↑ 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.002..0.002 rows=1 loops=12,760)

  • Index Cond: (id = si.importbatch_id)
36. 0.006 0.013 ↑ 1.0 6 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
37. 0.007 0.007 ↑ 1.0 6 1

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

38. 0.019 0.034 ↑ 1.0 40 1

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

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

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

40. 0.000 0.002 ↓ 0.0 0 1

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

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

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

42. 0.005 0.041 ↑ 1.0 6 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
43. 0.009 0.036 ↑ 1.0 6 1

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

  • Merge Cond: (cba.id = ifca.maturitypaymentsaccount_id)
44. 0.011 0.011 ↑ 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.010..0.011 rows=3 loops=1)

45. 0.009 0.016 ↑ 1.0 6 1

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

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

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

47. 25.520 25.520 ↑ 1.0 1 12,760

Index Scan using bankpaymenttransaction_mapping_idx on bankpaymenttransaction bpt (cost=0.29..0.31 rows=1 width=16) (actual time=0.002..0.002 rows=1 loops=12,760)

  • Index Cond: (mapping_id = ps_eps.earlypaymentmapping_id)
48.          

SubPlan (for Nested Loop Left Join)

49. 12.760 38.280 ↑ 1.0 1 12,760

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

50. 25.520 25.520 ↑ 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.001..0.002 rows=1 loops=12,760)

  • Index Cond: (mapping_id = ps_eps.maturitypaymentmapping_id)
Planning time : 10.113 ms
Execution time : 271.953 ms