explain.depesz.com

PostgreSQL's explain analyze made readable

Result: usey

Settings
# exclusive inclusive rows x rows loops node
1. 47.597 1,174.555 ↑ 3.2 21,157 1

Gather (cost=276,104.74..927,618.65 rows=67,454 width=1,826) (actual time=774.688..1,174.555 rows=21,157 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 6.467 1,105.801 ↑ 4.0 7,052 3 / 3

Hash Left Join (cost=275,104.74..368,605.43 rows=28,106 width=1,639) (actual time=768.463..1,105.801 rows=7,052 loops=3)

  • Hash Cond: (ps_eps.earlypaymentmapping_id = bpt.mapping_id)
3. 6.313 1,099.330 ↑ 4.0 7,052 3 / 3

Hash Left Join (cost=275,094.51..368,489.80 rows=28,106 width=1,639) (actual time=768.444..1,099.330 rows=7,052 loops=3)

  • Hash Cond: (si.paymentadvice_id = ipa.id)
4. 6.292 1,093.012 ↑ 4.0 7,052 3 / 3

Hash Left Join (cost=275,084.29..368,405.80 rows=28,106 width=595) (actual time=768.420..1,093.012 rows=7,052 loops=3)

  • Hash Cond: (ps_eps.earlypaymentadvice_id = eps_epa.id)
5. 6.373 1,086.092 ↑ 4.0 7,052 3 / 3

Hash Left Join (cost=275,052.02..368,299.76 rows=28,106 width=581) (actual time=767.774..1,086.092 rows=7,052 loops=3)

  • Hash Cond: (si.currency_id = c.id)
6. 11.205 1,079.706 ↑ 4.0 7,052 3 / 3

Nested Loop Left Join (cost=275,050.89..368,172.74 rows=28,106 width=585) (actual time=767.747..1,079.706 rows=7,052 loops=3)

7. 6.502 1,054.396 ↑ 4.0 7,052 3 / 3

Hash Left Join (cost=275,050.46..354,189.36 rows=28,106 width=585) (actual time=767.728..1,054.396 rows=7,052 loops=3)

  • Hash Cond: (si.supplier_id = s_cb.id)
8. 6.144 1,046.517 ↑ 4.0 7,052 3 / 3

Hash Left Join (cost=274,839.33..353,904.27 rows=28,106 width=575) (actual time=766.336..1,046.517 rows=7,052 loops=3)

  • Hash Cond: (od_db.buyer_id = od_c_cb.id)
9. 6.349 1,038.987 ↑ 4.0 7,052 3 / 3

Hash Left Join (cost=274,628.21..353,619.17 rows=28,106 width=565) (actual time=764.936..1,038.987 rows=7,052 loops=3)

  • Hash Cond: (si.originatordivision_id = od_db.id)
10. 6.529 1,032.616 ↑ 4.0 7,052 3 / 3

Hash Left Join (cost=274,626.89..353,521.74 rows=28,106 width=553) (actual time=764.897..1,032.616 rows=7,052 loops=3)

  • Hash Cond: (ps_apfeps_t_apfda.bank_id = ps_eps_t_bc_cb.id)
11. 7.805 1,024.437 ↑ 4.0 7,052 3 / 3

Parallel Hash Left Join (cost=274,415.77..353,236.65 rows=28,106 width=543) (actual time=763.227..1,024.437 rows=7,052 loops=3)

  • Hash Cond: (ps_apffc_fc_fcb.id = ps_apffc_fc_afc.id)
12. 7.847 932.374 ↑ 4.0 7,052 3 / 3

Parallel Hash Left Join (cost=267,270.68..346,017.78 rows=28,106 width=427) (actual time=678.407..932.374 rows=7,052 loops=3)

  • Hash Cond: (ps_apfeps.financingcontext_id = ps_apffc_fc_fcb.id)
13. 6.478 830.060 ↑ 4.0 7,052 3 / 3

Hash Join (cost=258,098.49..336,771.81 rows=28,106 width=427) (actual time=583.125..830.060 rows=7,052 loops=3)

  • Hash Cond: (ps_apfeps.apfda_id = ps_apfeps_t_apfda.id)
14. 7.625 823.541 ↑ 4.0 7,052 3 / 3

Nested Loop (cost=258,097.04..336,680.95 rows=28,106 width=427) (actual time=583.061..823.541 rows=7,052 loops=3)

15. 140.452 794.587 ↑ 4.0 7,110 3 / 3

Parallel Hash Join (cost=258,096.61..267,764.64 rows=28,115 width=236) (actual time=583.024..794.587 rows=7,110 loops=3)

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

17. 162.675 582.351 ↓ 1.3 168,023 3 / 3

Parallel Hash (cost=256,479.83..256,479.83 rows=129,342 width=220) (actual time=582.350..582.351 rows=168,023 loops=3)

  • Buckets: 524288 Batches: 1 Memory Usage: 118624kB
18. 385.420 419.676 ↓ 1.3 168,023 3 / 3

Parallel Bitmap Heap Scan on earlypaymentsettlement ps_eps (cost=9,686.05..256,479.83 rows=129,342 width=220) (actual time=151.232..419.676 rows=168,023 loops=3)

  • Recheck Cond: (creationdate >= '2019-02-01'::date)
  • Heap Blocks: exact=61243
19. 34.256 34.256 ↑ 1.0 504,070 1 / 3

Bitmap Index Scan on earlypaymentsettlement_creationdate_idx (cost=0.00..9,556.71 rows=517,370 width=0) (actual time=102.767..102.768 rows=504,070 loops=1)

  • Index Cond: (creationdate >= '2019-02-01'::date)
20. 21.329 21.329 ↑ 1.0 1 21,329 / 3

Index Scan using supplierinvoice_pkey on supplierinvoice si (cost=0.43..2.45 rows=1 width=207) (actual time=0.003..0.003 rows=1 loops=21,329)

  • Index Cond: (id = ps_eps.invoice_id)
  • Filter: (nettingbundle_id IS NULL)
  • Rows Removed by Filter: 0
21. 0.012 0.041 ↑ 1.0 20 3 / 3

Hash (cost=1.20..1.20 rows=20 width=16) (actual time=0.040..0.041 rows=20 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
22. 0.029 0.029 ↑ 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.022..0.029 rows=20 loops=3)

23. 56.918 94.467 ↓ 1.0 131,499 3 / 3

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

  • Buckets: 524288 Batches: 1 Memory Usage: 19584kB
24. 37.549 37.549 ↓ 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.033..37.549 rows=131,499 loops=3)

  • Heap Fetches: 0
25. 44.415 84.258 ↑ 1.2 79,932 3 / 3

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

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

27. 0.635 1.650 ↑ 1.0 1,650 3 / 3

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

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

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

29. 0.008 0.022 ↑ 1.0 14 3 / 3

Hash (cost=1.14..1.14 rows=14 width=28) (actual time=0.022..0.022 rows=14 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
30. 0.014 0.014 ↑ 1.0 14 3 / 3

Seq Scan on divisionbase od_db (cost=0.00..1.14 rows=14 width=28) (actual time=0.007..0.014 rows=14 loops=3)

31. 0.612 1.386 ↑ 1.0 1,650 3 / 3

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

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

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

33. 0.601 1.377 ↑ 1.0 1,650 3 / 3

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

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

35. 14.105 14.105 ↑ 1.0 1 21,157 / 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=21,157)

  • Index Cond: (si.importbatch_id = id)
36. 0.005 0.013 ↑ 1.0 6 3 / 3

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

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

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

38. 0.325 0.628 ↑ 1.0 945 3 / 3

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

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

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

40. 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
41. 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)

42. 0.001 0.004 ↓ 0.0 0 3 / 3

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

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

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

44.          

SubPlan (for Gather)

45. 21.157 21.157 ↑ 1.0 1 21,157

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

46. 0.000 0.000 ↓ 0.0 0 21,157

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=21,157)

  • Index Cond: (mapping_id = ps_eps.maturitypaymentmapping_id)
Planning time : 8.748 ms
Execution time : 1,179.759 ms