explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Vk1T

Settings
# exclusive inclusive rows x rows loops node
1. 0.009 2.443 ↑ 1.0 1 1

Nested Loop Left Join (cost=114.09..160.20 rows=1 width=2,990) (actual time=2.362..2.443 rows=1 loops=1)

2. 0.008 2.425 ↑ 1.0 1 1

Nested Loop Left Join (cost=113.96..160.03 rows=1 width=2,794) (actual time=2.345..2.425 rows=1 loops=1)

3. 0.011 2.398 ↑ 1.0 1 1

Nested Loop Left Join (cost=113.82..158.50 rows=1 width=2,662) (actual time=2.317..2.398 rows=1 loops=1)

4. 0.008 2.369 ↑ 1.0 1 1

Nested Loop Left Join (cost=113.68..158.34 rows=1 width=2,522) (actual time=2.288..2.369 rows=1 loops=1)

5. 0.009 2.353 ↑ 1.0 1 1

Nested Loop Left Join (cost=113.55..158.18 rows=1 width=2,326) (actual time=2.272..2.353 rows=1 loops=1)

6. 0.249 2.322 ↑ 1.0 1 1

Hash Right Join (cost=113.27..157.85 rows=1 width=2,199) (actual time=2.242..2.322 rows=1 loops=1)

  • Hash Cond: ("ctsInsPayment".cts_ins_id = "ctsIns".id)
7. 0.266 0.266 ↑ 1.0 2,296 1

Seq Scan on cts_ins_payments "ctsInsPayment" (cost=0.00..35.96 rows=2,296 width=16) (actual time=0.018..0.266 rows=2,296 loops=1)

8. 0.011 1.807 ↑ 1.0 1 1

Hash (cost=113.26..113.26 rows=1 width=2,183) (actual time=1.807..1.807 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
9. 0.007 1.796 ↑ 1.0 1 1

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

10. 0.007 1.763 ↑ 1.0 1 1

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

11. 0.021 1.740 ↑ 1.0 1 1

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

12. 0.029 1.159 ↓ 2.9 35 1

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

13. 0.007 0.918 ↑ 1.0 1 1

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

14. 0.006 0.892 ↑ 1.0 1 1

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

15. 0.007 0.865 ↑ 1.0 1 1

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

16. 0.005 0.840 ↑ 1.0 1 1

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

17. 0.005 0.804 ↑ 1.0 1 1

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

18. 0.006 0.773 ↑ 1.0 1 1

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

  • Join Filter: (cts.id = "ctsInsVers".cts_id)
19. 0.006 0.743 ↑ 1.0 1 1

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

  • Join Filter: (partner.id = "ctsInsVers".partner_id)
  • Rows Removed by Join Filter: 6
20. 0.005 0.726 ↑ 1.0 1 1

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

21. 0.005 0.700 ↑ 1.0 1 1

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

22. 0.038 0.671 ↑ 1.0 1 1

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

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

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

24. 0.007 0.602 ↑ 1.0 1 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
25. 0.595 0.595 ↑ 1.0 1 1

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

  • Filter: (cts_id = 1857)
  • Rows Removed by Filter: 2295
26. 0.024 0.024 ↑ 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.024..0.024 rows=1 loops=1)

  • Index Cond: (id = "ctsInsVers".cts_ins_id)
27. 0.021 0.021 ↑ 1.0 1 1

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

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

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

29. 0.024 0.024 ↑ 1.0 1 1

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

  • Index Cond: (id = 1857)
30. 0.026 0.026 ↑ 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.025..0.026 rows=1 loops=1)

  • Index Cond: (cts_ins_vers_id = "ctsInsVers".id)
  • Heap Fetches: 1
31. 0.031 0.031 ↑ 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.031..0.031 rows=1 loops=1)

  • Index Cond: (id = "ctsInsVers_ctsSignatories".cts_signatories_id)
32. 0.018 0.018 ↑ 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.018..0.018 rows=1 loops=1)

  • Index Cond: (id = "ctsSignatories".ctgts_fl_vers_id)
33. 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)
34. 0.019 0.019 ↑ 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.019..0.019 rows=1 loops=1)

  • Index Cond: (id = "ctsIns".ref_currencies_id)
35. 0.212 0.212 ↓ 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.033..0.212 rows=35 loops=1)

  • Index Cond: (cts_ins_id = "ctsIns".id)
  • Heap Fetches: 35
36. 0.560 0.560 ↓ 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.016..0.016 rows=0 loops=35)

  • Index Cond: (id = "ctsIns_ctsInsStatuses".cts_ins_statuses_id)
  • Filter: actuality
  • Rows Removed by Filter: 1
37. 0.016 0.016 ↑ 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.016..0.016 rows=1 loops=1)

  • Index Cond: (id = "ctsInsStatuses".ref_ins_statuses_id)
38. 0.026 0.026 ↑ 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.026..0.026 rows=1 loops=1)

  • Index Cond: (id = "ctsIns".cts_ins_line_id)
39. 0.022 0.022 ↑ 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.022..0.022 rows=1 loops=1)

  • Index Cond: (id = "ctsInsLine".cts_ins_line_isz_id)
40. 0.008 0.008 ↑ 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.008..0.008 rows=1 loops=1)

  • Index Cond: (id = "ctsInsLineIsz".coupon_payment_freq_id)
41. 0.018 0.018 ↑ 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.018..0.018 rows=1 loops=1)

  • Index Cond: (id = "ctsIns".ins_product_id)
42. 0.019 0.019 ↑ 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.019..0.019 rows=1 loops=1)

  • Index Cond: (id = "insProduct".ins_products_descr_id)
43. 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 : 10.859 ms
Execution time : 3.760 ms