explain.depesz.com

PostgreSQL's explain analyze made readable

Result: rWmt

Settings
# exclusive inclusive rows x rows loops node
1. 0.068 8.100 ↓ 19.0 19 1

Nested Loop Left Join (cost=1,037.21..15,010.27 rows=1 width=1,826) (actual time=1.538..8.100 rows=19 loops=1)

2. 0.032 8.013 ↓ 19.0 19 1

Nested Loop Left Join (cost=1,037.08..15,001.91 rows=1 width=1,639) (actual time=1.523..8.013 rows=19 loops=1)

3. 0.030 7.981 ↓ 19.0 19 1

Nested Loop Left Join (cost=1,036.94..15,001.73 rows=1 width=595) (actual time=1.518..7.981 rows=19 loops=1)

4. 0.035 7.951 ↓ 19.0 19 1

Nested Loop Left Join (cost=1,036.67..15,001.40 rows=1 width=581) (actual time=1.514..7.951 rows=19 loops=1)

5. 0.026 7.897 ↓ 19.0 19 1

Nested Loop Left Join (cost=1,036.53..15,001.25 rows=1 width=585) (actual time=1.508..7.897 rows=19 loops=1)

6. 0.037 7.814 ↓ 19.0 19 1

Nested Loop Left Join (cost=1,036.10..14,994.27 rows=1 width=585) (actual time=1.499..7.814 rows=19 loops=1)

7. 0.023 7.720 ↓ 19.0 19 1

Nested Loop Left Join (cost=1,035.82..14,993.91 rows=1 width=575) (actual time=1.465..7.720 rows=19 loops=1)

8. 0.037 7.659 ↓ 19.0 19 1

Nested Loop Left Join (cost=1,035.55..14,987.61 rows=1 width=565) (actual time=1.458..7.659 rows=19 loops=1)

9. 0.029 7.603 ↓ 19.0 19 1

Nested Loop Left Join (cost=1,035.41..14,987.45 rows=1 width=553) (actual time=1.451..7.603 rows=19 loops=1)

10. 0.040 7.536 ↓ 19.0 19 1

Nested Loop Left Join (cost=1,035.13..14,981.95 rows=1 width=543) (actual time=1.445..7.536 rows=19 loops=1)

11. 0.025 7.458 ↓ 19.0 19 1

Nested Loop Left Join (cost=1,034.71..14,981.46 rows=1 width=427) (actual time=1.436..7.458 rows=19 loops=1)

12. 0.000 7.376 ↓ 19.0 19 1

Nested Loop Left Join (cost=1,034.29..14,981.01 rows=1 width=427) (actual time=1.427..7.376 rows=19 loops=1)

13. 3.327 8.027 ↓ 19.0 19 1

Gather (cost=1,034.15..14,980.86 rows=1 width=427) (actual time=1.421..8.027 rows=19 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
14. 0.644 4.700 ↓ 10.0 10 2 / 2

Nested Loop (cost=34.15..13,980.76 rows=1 width=427) (actual time=1.763..4.700 rows=10 loops=2)

15. 0.895 2.921 ↓ 4.5 568 2 / 2

Nested Loop (cost=33.72..12,931.16 rows=127 width=236) (actual time=0.159..2.921 rows=568 loops=2)

16. 0.318 0.441 ↑ 1.2 792 2 / 2

Parallel Bitmap Heap Scan on earlypaymentsettlement ps_eps (cost=33.30..6,257.58 rows=976 width=220) (actual time=0.144..0.441 rows=792 loops=2)

  • Recheck Cond: (creationdate = '2019-01-01'::date)
  • Heap Blocks: exact=39
17. 0.123 0.123 ↑ 1.0 1,585 1 / 2

Bitmap Index Scan on earlypaymentsettlement_creationdate_idx (cost=0.00..32.88 rows=1,660 width=0) (actual time=0.247..0.247 rows=1,585 loops=1)

  • Index Cond: (creationdate = '2019-01-01'::date)
18. 1.585 1.585 ↑ 1.0 1 1,585 / 2

Index Scan using apfearlypaymentsettlement_pkey on apfearlypaymentsettlement ps_apfeps (cost=0.42..6.84 rows=1 width=24) (actual time=0.002..0.002 rows=1 loops=1,585)

  • Index Cond: (id = ps_eps.id)
19. 1.135 1.135 ↓ 0.0 0 1,135 / 2

Index Scan using supplierinvoice_pkey on supplierinvoice si (cost=0.43..8.26 rows=1 width=207) (actual time=0.002..0.002 rows=0 loops=1,135)

  • Index Cond: (id = ps_eps.invoice_id)
  • Filter: ((nettingbundle_id IS NULL) AND (supplier_id = 6,167))
  • Rows Removed by Filter: 1
20. 0.038 0.038 ↑ 1.0 1 19

Index Scan using apfdebtoragreement_pkey on apfdebtoragreement ps_apfeps_t_apfda (cost=0.14..0.16 rows=1 width=16) (actual time=0.002..0.002 rows=1 loops=19)

  • Index Cond: (ps_apfeps.apfda_id = id)
21. 0.057 0.057 ↑ 1.0 1 19

Index Only Scan using financingcontextbase_pkey on financingcontextbase ps_apffc_fc_fcb (cost=0.42..0.45 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=19)

  • Index Cond: (id = ps_apfeps.financingcontext_id)
  • Heap Fetches: 0
22. 0.038 0.038 ↑ 1.0 1 19

Index Scan using apffinancingcontext_pkey on apffinancingcontext ps_apffc_fc_afc (cost=0.42..0.49 rows=1 width=140) (actual time=0.002..0.002 rows=1 loops=19)

  • Index Cond: (ps_apffc_fc_fcb.id = id)
23. 0.038 0.038 ↑ 1.0 1 19

Index Scan using corporatebase_pkey on corporatebase ps_eps_t_bc_cb (cost=0.28..5.49 rows=1 width=26) (actual time=0.002..0.002 rows=1 loops=19)

  • Index Cond: (id = ps_apfeps_t_apfda.bank_id)
24. 0.019 0.019 ↑ 1.0 1 19

Index Scan using divisionbase_pkey on divisionbase od_db (cost=0.14..0.15 rows=1 width=28) (actual time=0.001..0.001 rows=1 loops=19)

  • Index Cond: (si.originatordivision_id = id)
25. 0.038 0.038 ↑ 1.0 1 19

Index Scan using corporatebase_pkey on corporatebase od_c_cb (cost=0.28..6.29 rows=1 width=26) (actual time=0.002..0.002 rows=1 loops=19)

  • Index Cond: (id = od_db.buyer_id)
26. 0.057 0.057 ↑ 1.0 1 19

Index Scan using corporatebase_pkey on corporatebase s_cb (cost=0.28..0.35 rows=1 width=26) (actual time=0.003..0.003 rows=1 loops=19)

  • Index Cond: ((id = si.supplier_id) AND (id = 6,167))
27. 0.057 0.057 ↑ 1.0 1 19

Index Scan using arpimportbatch_pkey on arpimportbatch ib (cost=0.43..6.97 rows=1 width=16) (actual time=0.003..0.003 rows=1 loops=19)

  • Index Cond: (si.importbatch_id = id)
28. 0.019 0.019 ↑ 1.0 1 19

Index Scan using crxcurrency_pkey on crxcurrency c (cost=0.13..0.15 rows=1 width=12) (actual time=0.001..0.001 rows=1 loops=19)

  • Index Cond: (si.currency_id = id)
29. 0.000 0.000 ↓ 0.0 0 19

Index Scan using earlypaymentadvice_pkey on earlypaymentadvice eps_epa (cost=0.28..0.33 rows=1 width=30) (actual time=0.000..0.000 rows=0 loops=19)

  • Index Cond: (id = ps_eps.earlypaymentadvice_id)
30. 0.000 0.000 ↓ 0.0 0 19

Index Scan using invoicepaymentadvice_pkey on invoicepaymentadvice ipa (cost=0.14..0.16 rows=1 width=1,052) (actual time=0.000..0.000 rows=0 loops=19)

  • Index Cond: (si.paymentadvice_id = id)
31. 0.000 0.000 ↓ 0.0 0 19

Index Scan using bankpaymenttransaction_mapping_idx on bankpaymenttransaction bpt (cost=0.14..0.18 rows=1 width=16) (actual time=0.000..0.000 rows=0 loops=19)

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

SubPlan (for Nested Loop Left Join)

33. 0.019 0.019 ↑ 1.0 1 19

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

34. 0.000 0.000 ↓ 0.0 0 19

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=19)

  • Index Cond: (mapping_id = ps_eps.maturitypaymentmapping_id)
Planning time : 6.681 ms
Execution time : 9.104 ms