explain.depesz.com

PostgreSQL's explain analyze made readable

Result: sKLD

Settings
# exclusive inclusive rows x rows loops node
1. 0.010 2.234 ↑ 1.0 1 1

Nested Loop Left Join (cost=69.75..115.95 rows=1 width=2,990) (actual time=2.199..2.234 rows=1 loops=1)

2. 0.008 2.215 ↑ 1.0 1 1

Nested Loop Left Join (cost=69.62..115.79 rows=1 width=2,794) (actual time=2.181..2.215 rows=1 loops=1)

3. 0.008 2.166 ↑ 1.0 1 1

Nested Loop Left Join (cost=69.34..115.44 rows=1 width=2,778) (actual time=2.133..2.166 rows=1 loops=1)

4. 0.009 2.144 ↑ 1.0 1 1

Nested Loop Left Join (cost=69.20..113.91 rows=1 width=2,646) (actual time=2.111..2.144 rows=1 loops=1)

5. 0.008 2.116 ↑ 1.0 1 1

Nested Loop Left Join (cost=69.06..113.75 rows=1 width=2,506) (actual time=2.083..2.116 rows=1 loops=1)

6. 0.008 2.098 ↑ 1.0 1 1

Nested Loop Left Join (cost=68.93..113.59 rows=1 width=2,310) (actual time=2.065..2.098 rows=1 loops=1)

7. 0.007 2.067 ↑ 1.0 1 1

Nested Loop Left Join (cost=68.65..113.26 rows=1 width=2,183) (actual time=2.035..2.067 rows=1 loops=1)

8. 0.007 2.030 ↑ 1.0 1 1

Nested Loop Left Join (cost=68.37..112.89 rows=1 width=2,167) (actual time=1.998..2.030 rows=1 loops=1)

9. 0.032 1.996 ↑ 1.0 1 1

Nested Loop (cost=68.23..112.73 rows=1 width=2,055) (actual time=1.964..1.996 rows=1 loops=1)

10. 0.030 1.299 ↓ 2.9 35 1

Nested Loop (cost=67.94..108.53 rows=12 width=2,026) (actual time=1.021..1.299 rows=35 loops=1)

11. 0.007 1.012 ↑ 1.0 1 1

Nested Loop Left Join (cost=67.66..107.57 rows=1 width=2,022) (actual time=0.981..1.012 rows=1 loops=1)

12. 0.006 0.978 ↑ 1.0 1 1

Nested Loop Left Join (cost=67.52..107.41 rows=1 width=1,730) (actual time=0.947..0.978 rows=1 loops=1)

13. 0.007 0.951 ↑ 1.0 1 1

Nested Loop Left Join (cost=67.39..107.25 rows=1 width=1,534) (actual time=0.920..0.951 rows=1 loops=1)

14. 0.005 0.933 ↑ 1.0 1 1

Nested Loop Left Join (cost=67.11..106.75 rows=1 width=1,400) (actual time=0.903..0.933 rows=1 loops=1)

15. 0.005 0.900 ↑ 1.0 1 1

Nested Loop Left Join (cost=66.83..106.41 rows=1 width=1,383) (actual time=0.870..0.900 rows=1 loops=1)

16. 0.005 0.850 ↑ 1.0 1 1

Nested Loop Left Join (cost=66.55..98.11 rows=1 width=1,379) (actual time=0.821..0.850 rows=1 loops=1)

  • Join Filter: (cts.id = "ctsInsVers".cts_id)
17. 0.005 0.814 ↑ 1.0 1 1

Nested Loop Left Join (cost=66.27..89.80 rows=1 width=1,322) (actual time=0.785..0.814 rows=1 loops=1)

  • Join Filter: (partner.id = "ctsInsVers".partner_id)
  • Rows Removed by Join Filter: 6
18. 0.006 0.792 ↑ 1.0 1 1

Nested Loop Left Join (cost=66.27..88.62 rows=1 width=927) (actual time=0.763..0.792 rows=1 loops=1)

19. 0.000 0.760 ↑ 1.0 1 1

Nested Loop (cost=65.99..80.30 rows=1 width=378) (actual time=0.732..0.760 rows=1 loops=1)

20. 0.094 0.732 ↑ 1.0 1 1

Hash Right Join (cost=65.71..71.99 rows=1 width=234) (actual time=0.690..0.732 rows=1 loops=1)

  • Hash Cond: (branch.id = "ctsInsVers".branch_id)
21. 0.046 0.046 ↑ 1.0 165 1

Seq Scan on branches branch (cost=0.00..5.65 rows=165 width=135) (actual time=0.020..0.046 rows=165 loops=1)

22. 0.007 0.592 ↑ 1.0 1 1

Hash (cost=65.70..65.70 rows=1 width=99) (actual time=0.592..0.592 rows=1 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
23. 0.585 0.585 ↑ 1.0 1 1

Seq Scan on cts_ins_vers "ctsInsVers" (cost=0.00..65.70 rows=1 width=99) (actual time=0.373..0.585 rows=1 loops=1)

  • Filter: (cts_id = 1,857)
  • Rows Removed by Filter: 2,295
24. 0.033 0.033 ↑ 1.0 1 1

Index Scan using "PK_7ce3b31b41ab9aa536063837ece" on cts_ins "ctsIns" (cost=0.28..8.30 rows=1 width=144) (actual time=0.033..0.033 rows=1 loops=1)

  • Index Cond: (id = "ctsInsVers".cts_ins_id)
25. 0.026 0.026 ↑ 1.0 1 1

Index Scan using "PK_a3ffb1c0c8416b9fc6f907b7433" on users "user" (cost=0.27..8.29 rows=1 width=549) (actual time=0.026..0.026 rows=1 loops=1)

  • Index Cond: (id = "ctsInsVers".user_id)
26. 0.017 0.017 ↑ 1.1 7 1

Seq Scan on partners partner (cost=0.00..1.08 rows=8 width=395) (actual time=0.016..0.017 rows=7 loops=1)

27. 0.031 0.031 ↑ 1.0 1 1

Index Scan using "PK_0ff7107d0c5f0612536cfc918f7" on cts (cost=0.28..8.30 rows=1 width=57) (actual time=0.031..0.031 rows=1 loops=1)

  • Index Cond: (id = 1,857)
28. 0.045 0.045 ↑ 1.0 1 1

Index Only Scan using "PK_b4bd89487b9ad5b80a704a36247" on cts_signatories_vers "ctsInsVers_ctsSignatories" (cost=0.28..8.30 rows=1 width=8) (actual time=0.044..0.045 rows=1 loops=1)

  • Index Cond: (cts_ins_vers_id = "ctsInsVers".id)
  • Heap Fetches: 1
29. 0.028 0.028 ↑ 1.0 1 1

Index Scan using "PK_76aeea1697ffef17739eda72c99" on cts_signatories "ctsSignatories" (cost=0.28..0.34 rows=1 width=21) (actual time=0.028..0.028 rows=1 loops=1)

  • Index Cond: (id = "ctsInsVers_ctsSignatories".cts_signatories_id)
30. 0.011 0.011 ↑ 1.0 1 1

Index Scan using "PK_a02f237db367b27bf89a907d665" on ctgts_fl_vers "ctgtsFlVers" (cost=0.28..0.49 rows=1 width=134) (actual time=0.011..0.011 rows=1 loops=1)

  • Index Cond: (id = "ctsSignatories".ctgts_fl_vers_id)
31. 0.021 0.021 ↑ 1.0 1 1

Index Scan using "PK_f2b5e0264fcf0ef36a716546796" on ref_ins_date_units "refInsDateUnitCts" (cost=0.13..0.16 rows=1 width=196) (actual time=0.021..0.021 rows=1 loops=1)

  • Index Cond: (id = "ctsIns".ref_ins_date_unit_id)
32. 0.027 0.027 ↑ 1.0 1 1

Index Scan using "PK_c78bb3089545d582524e792be29" on ref_currencies "refCurrencies" (cost=0.14..0.16 rows=1 width=292) (actual time=0.027..0.027 rows=1 loops=1)

  • Index Cond: (id = "ctsIns".ref_currencies_id)
33. 0.257 0.257 ↓ 2.9 35 1

Index Only Scan using "PK_f98010849793b1aea1680448111" on cts_ins_statuses_vers "ctsIns_ctsInsStatuses" (cost=0.29..0.85 rows=12 width=8) (actual time=0.034..0.257 rows=35 loops=1)

  • Index Cond: (cts_ins_id = "ctsIns".id)
  • Heap Fetches: 35
34. 0.665 0.665 ↓ 0.0 0 35

Index Scan using "PK_d245bc1ad5b1ee18173ce95417e" on cts_ins_statuses "ctsInsStatuses" (cost=0.29..0.35 rows=1 width=33) (actual time=0.019..0.019 rows=0 loops=35)

  • Index Cond: (id = "ctsIns_ctsInsStatuses".cts_ins_statuses_id)
  • Filter: actuality
  • Rows Removed by Filter: 1
35. 0.027 0.027 ↑ 1.0 1 1

Index Scan using "PK_e77816b8b0eb11a98eebc1b2f66" on ref_ins_statuses "refInsStatuses" (cost=0.14..0.16 rows=1 width=112) (actual time=0.027..0.027 rows=1 loops=1)

  • Index Cond: (id = "ctsInsStatuses".ref_ins_statuses_id)
36. 0.030 0.030 ↑ 1.0 1 1

Index Scan using "PK_cfa8921e895d8eb3c71ad465687" on cts_ins_lines "ctsInsLine" (cost=0.28..0.37 rows=1 width=16) (actual time=0.030..0.030 rows=1 loops=1)

  • Index Cond: (id = "ctsIns".cts_ins_line_id)
37. 0.023 0.023 ↑ 1.0 1 1

Index Scan using "PK_6cd023171b0c0cf7cdd531a1a3c" on cts_ins_line_isz "ctsInsLineIsz" (cost=0.28..0.33 rows=1 width=127) (actual time=0.023..0.023 rows=1 loops=1)

  • Index Cond: (id = "ctsInsLine".cts_ins_line_isz_id)
38. 0.010 0.010 ↑ 1.0 1 1

Index Scan using "PK_f2b5e0264fcf0ef36a716546796" on ref_ins_date_units "couponPaymentFreq" (cost=0.13..0.16 rows=1 width=196) (actual time=0.010..0.010 rows=1 loops=1)

  • Index Cond: (id = "ctsInsLineIsz".coupon_payment_freq_id)
39. 0.019 0.019 ↑ 1.0 1 1

Index Scan using "PK_8126e91709c30e546f5429aa1f3" on ins_products "insProduct" (cost=0.14..0.16 rows=1 width=140) (actual time=0.019..0.019 rows=1 loops=1)

  • Index Cond: (id = "ctsIns".ins_product_id)
40. 0.014 0.014 ↑ 1.0 1 1

Index Scan using "PK_e1d5b54ed0f1dc6896affd3a45f" on ins_products_descr "insProductsDescr" (cost=0.14..1.44 rows=1 width=132) (actual time=0.014..0.014 rows=1 loops=1)

  • Index Cond: (id = "insProduct".ins_products_descr_id)
41. 0.041 0.041 ↑ 1.0 1 1

Index Scan using cts_ins_payments_cts_ins_id_index on cts_ins_payments "ctsInsPayment" (cost=0.28..0.34 rows=1 width=16) (actual time=0.040..0.041 rows=1 loops=1)

  • Index Cond: (cts_ins_id = "ctsIns".id)
42. 0.009 0.009 ↑ 1.0 1 1

Index Scan using "PK_f2b5e0264fcf0ef36a716546796" on ref_ins_date_units "refInsDateUnit" (cost=0.13..0.16 rows=1 width=196) (actual time=0.009..0.009 rows=1 loops=1)

  • Index Cond: (id = "ctsInsPayment".payment_freq)
Planning time : 14.307 ms
Execution time : 3.742 ms