explain.depesz.com

PostgreSQL's explain analyze made readable

Result: KEhb

Settings
# exclusive inclusive rows x rows loops node
1. 0.013 1,271.211 ↑ 1.0 10 1

Limit (cost=73.56..131.86 rows=10 width=3,901) (actual time=1,270.890..1,271.211 rows=10 loops=1)

2. 0.025 1,271.198 ↑ 8,192.6 10 1

Nested Loop Left Join (cost=73.56..477,693.54 rows=81,926 width=3,901) (actual time=1,270.889..1,271.198 rows=10 loops=1)

3. 0.025 1,271.163 ↑ 8,192.6 10 1

Nested Loop Left Join (cost=73.42..465,003.33 rows=81,926 width=3,789) (actual time=1,270.881..1,271.163 rows=10 loops=1)

  • Join Filter: ("refCtgtsFlTypes".id = "ctgtsFlTypes".ref_ctgts_fl_types_id)
  • Rows Removed by Join Filter: 5
4. 0.024 1,271.138 ↑ 8,192.6 10 1

Nested Loop Left Join (cost=73.42..461,930.07 rows=81,926 width=3,657) (actual time=1,270.873..1,271.138 rows=10 loops=1)

  • Join Filter: ("refGlblCtgtsType".id = ctgts.ref_glbl_ctgts_type_id)
5. 0.027 1,271.114 ↑ 8,192.6 10 1

Nested Loop Left Join (cost=73.42..458,856.82 rows=81,926 width=3,525) (actual time=1,270.864..1,271.114 rows=10 loops=1)

6. 0.021 1,271.077 ↑ 8,192.6 10 1

Nested Loop Left Join (cost=73.14..427,573.46 rows=81,926 width=3,334) (actual time=1,270.856..1,271.077 rows=10 loops=1)

7. 0.036 1,271.036 ↑ 8,192.6 10 1

Nested Loop Left Join (cost=72.86..398,760.67 rows=81,926 width=3,277) (actual time=1,270.848..1,271.036 rows=10 loops=1)

8. 0.020 1,270.990 ↑ 8,192.6 10 1

Nested Loop Left Join (cost=72.57..371,167.81 rows=81,926 width=3,233) (actual time=1,270.840..1,270.990 rows=10 loops=1)

9. 0.019 1,270.950 ↑ 8,192.6 10 1

Nested Loop Left Join (cost=72.29..343,240.90 rows=81,926 width=3,229) (actual time=1,270.831..1,270.950 rows=10 loops=1)

10. 0.017 1,270.911 ↑ 8,192.6 10 1

Nested Loop Left Join (cost=72.01..312,632.74 rows=81,926 width=3,095) (actual time=1,270.821..1,270.911 rows=10 loops=1)

  • Join Filter: ("refCtsInsSidesType".id = "ctsInsSide".ref_cts_ins_sides_type_id)
  • Rows Removed by Join Filter: 35
11. 0.018 1,270.884 ↑ 8,192.6 10 1

Nested Loop Left Join (cost=72.01..303,756.34 rows=81,926 width=2,995) (actual time=1,270.814..1,270.884 rows=10 loops=1)

12. 0.015 1,270.846 ↑ 8,192.6 10 1

Nested Loop Left Join (cost=71.73..276,042.88 rows=81,926 width=2,975) (actual time=1,270.804..1,270.846 rows=10 loops=1)

13. 0.013 1,270.816 ↑ 6,309.2 5 1

Nested Loop Left Join (cost=71.44..261,934.94 rows=31,546 width=2,971) (actual time=1,270.795..1,270.816 rows=5 loops=1)

14. 0.008 1,270.793 ↑ 6,309.2 5 1

Nested Loop Left Join (cost=71.16..250,908.07 rows=31,546 width=2,942) (actual time=1,270.787..1,270.793 rows=5 loops=1)

15. 0.005 1,270.778 ↑ 2,827.0 1 1

Nested Loop Left Join (cost=70.87..248,321.23 rows=2,827 width=2,938) (actual time=1,270.778..1,270.778 rows=1 loops=1)

  • Join Filter: ("refInsScanCheckError".id = "ctsInsScanCheck".ref_ins_scan_check_error_id)
  • Rows Removed by Join Filter: 4
16. 0.004 1,270.767 ↑ 2,827.0 1 1

Nested Loop Left Join (cost=70.87..248,150.99 rows=2,827 width=2,837) (actual time=1,270.767..1,270.767 rows=1 loops=1)

  • Join Filter: ("refInsScanCheckStatus".id = "ctsInsScanCheck".ref_ins_scan_check_status_id)
17. 0.004 1,270.758 ↑ 2,827.0 1 1

Nested Loop Left Join (cost=70.87..248,005.77 rows=2,827 width=2,736) (actual time=1,270.758..1,270.758 rows=1 loops=1)

18. 0.004 1,270.752 ↑ 2,827.0 1 1

Nested Loop Left Join (cost=70.73..247,555.84 rows=2,827 width=2,632) (actual time=1,270.752..1,270.752 rows=1 loops=1)

19. 0.004 1,270.743 ↑ 2,827.0 1 1

Nested Loop Left Join (cost=70.59..247,121.80 rows=2,827 width=2,520) (actual time=1,270.743..1,270.743 rows=1 loops=1)

20. 0.006 1,270.739 ↑ 2,827.0 1 1

Nested Loop Left Join (cost=70.32..246,258.82 rows=2,827 width=1,971) (actual time=1,270.738..1,270.739 rows=1 loops=1)

21. 0.007 1,270.729 ↑ 2,827.0 1 1

Nested Loop Left Join (cost=70.04..244,791.03 rows=2,827 width=1,598) (actual time=1,270.729..1,270.729 rows=1 loops=1)

22. 0.006 1,270.718 ↑ 2,827.0 1 1

Nested Loop Left Join (cost=69.77..243,852.69 rows=2,827 width=1,049) (actual time=1,270.718..1,270.718 rows=1 loops=1)

23. 0.924 1,270.704 ↑ 2,827.0 1 1

Hash Left Join (cost=69.62..243,361.44 rows=2,827 width=911) (actual time=1,270.704..1,270.704 rows=1 loops=1)

  • Hash Cond: ("ctsInsVers".cts_id = cts.id)
  • Filter: (SubPlan 1)
  • Rows Removed by Filter: 886
24. 523.305 829.981 ↑ 6.4 887 1

Nested Loop Left Join (cost=0.00..242,706.94 rows=5,655 width=854) (actual time=3.730..829.981 rows=887 loops=1)

  • Join Filter: ("ctsInsScanCheck".cts_ins_id = "ctsIns".id)
  • Rows Removed by Join Filter: 5096288
25. 1.116 56.542 ↑ 2.3 887 1

Nested Loop Left Join (cost=0.00..65,076.33 rows=2,058 width=739) (actual time=0.031..56.542 rows=887 loops=1)

  • Join Filter: ("ctsInsRefInsScanCheckStatus".id = "ctsIns".ref_ins_scan_check_status_id)
  • Rows Removed by Join Filter: 3544
26. 1.344 55.426 ↑ 2.3 887 1

Nested Loop Left Join (cost=0.00..64,962.49 rows=2,058 width=638) (actual time=0.024..55.426 rows=887 loops=1)

  • Join Filter: (partner.id = "ctsIns".partner_id)
  • Rows Removed by Join Filter: 4368
27. 31.755 54.082 ↑ 2.3 887 1

Nested Loop Left Join (cost=0.00..64,738.42 rows=2,058 width=243) (actual time=0.018..54.082 rows=887 loops=1)

  • Join Filter: ("ctsIns".id = "ctsInsVers".cts_ins_id)
  • Rows Removed by Join Filter: 396293
28. 0.152 0.152 ↑ 2.3 887 1

Seq Scan on cts_ins_vers "ctsInsVers" (cost=0.00..54.58 rows=2,058 width=99) (actual time=0.008..0.152 rows=887 loops=1)

29. 21.426 22.175 ↑ 4.7 448 887

Materialize (cost=0.00..140.38 rows=2,092 width=144) (actual time=0.000..0.025 rows=448 loops=887)

30. 0.749 0.749 ↑ 1.1 1,887 1

Seq Scan on cts_ins "ctsIns" (cost=0.00..129.92 rows=2,092 width=144) (actual time=0.004..0.749 rows=1,887 loops=1)

31. 0.000 0.000 ↑ 1.3 6 887

Materialize (cost=0.00..1.12 rows=8 width=395) (actual time=0.000..0.000 rows=6 loops=887)

32. 0.003 0.003 ↑ 1.1 7 1

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

33. 0.000 0.000 ↑ 1.0 4 887

Materialize (cost=0.00..1.06 rows=4 width=101) (actual time=0.000..0.000 rows=4 loops=887)

34. 0.003 0.003 ↑ 1.0 4 1

Seq Scan on ref_ins_scans_check_status "ctsInsRefInsScanCheckStatus" (cost=0.00..1.04 rows=4 width=101) (actual time=0.002..0.003 rows=4 loops=1)

35. 248.273 250.134 ↑ 1.0 5,746 887

Materialize (cost=0.00..204.22 rows=5,748 width=115) (actual time=0.000..0.282 rows=5,746 loops=887)

36. 1.861 1.861 ↑ 1.0 5,748 1

Seq Scan on cts_ins_scans_check "ctsInsScanCheck" (cost=0.00..175.48 rows=5,748 width=115) (actual time=0.003..1.861 rows=5,748 loops=1)

37. 0.348 0.734 ↑ 1.0 2,092 1

Hash (cost=42.61..42.61 rows=2,161 width=57) (actual time=0.734..0.734 rows=2,092 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 202kB
38. 0.386 0.386 ↑ 1.0 2,092 1

Seq Scan on cts (cost=0.00..42.61 rows=2,161 width=57) (actual time=0.007..0.386 rows=2,092 loops=1)

39.          

SubPlan (for Hash Left Join)

40. 0.887 439.065 ↓ 0.0 0 887

Unique (cost=189.97..190.01 rows=6 width=16) (actual time=0.495..0.495 rows=0 loops=887)

41. 1.774 438.178 ↓ 0.0 0 887

Sort (cost=189.97..189.99 rows=8 width=16) (actual time=0.494..0.494 rows=0 loops=887)

  • Sort Key: "ctsInsScanCheck_1".ref_cts_ins_doc_type_id, "ctsInsScanCheck_1".check_finish_date DESC
  • Sort Method: quicksort Memory: 25kB
42. 436.404 436.404 ↓ 0.0 0 887

Seq Scan on cts_ins_scans_check "ctsInsScanCheck_1" (cost=0.00..189.85 rows=8 width=16) (actual time=0.492..0.492 rows=0 loops=887)

  • Filter: (cts_id = cts.id)
  • Rows Removed by Filter: 5748
43. 0.008 0.008 ↑ 1.0 1 1

Index Scan using "PK_7f37d3b42defea97f1df0d19535" on branches branch (cost=0.14..0.17 rows=1 width=138) (actual time=0.008..0.008 rows=1 loops=1)

  • Index Cond: (id = "ctsIns".branch_id)
44. 0.004 0.004 ↑ 1.0 1 1

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

  • Index Cond: (id = "ctsIns".user_id)
45. 0.004 0.004 ↑ 1.0 1 1

Index Scan using "PK_4a03375200654d139438508ede5" on cts_ins_scans "ctsInsScan" (cost=0.28..0.52 rows=1 width=373) (actual time=0.004..0.004 rows=1 loops=1)

  • Index Cond: (id = "ctsInsScanCheck".cts_ins_scan_id)
46. 0.000 0.000 ↓ 0.0 0 1

Index Scan using "PK_a3ffb1c0c8416b9fc6f907b7433" on users "lastCheckUser" (cost=0.27..0.31 rows=1 width=549) (actual time=0.000..0.000 rows=0 loops=1)

  • Index Cond: (id = "ctsInsScanCheck".last_check_user_id)
47. 0.005 0.005 ↑ 1.0 1 1

Index Scan using "PK_ae88ef275eb2d34ee9071ebab42" on ref_cts_ins_scan_types "refCtsInsScanType" (cost=0.14..0.15 rows=1 width=112) (actual time=0.004..0.005 rows=1 loops=1)

  • Index Cond: (id = "ctsInsScanCheck".ref_cts_ins_scan_type_id)
48. 0.002 0.002 ↑ 1.0 1 1

Index Scan using "PK_f371d0902fd20e097bb530af768" on ref_cts_ins_docs_types "refCtsInsDocType" (cost=0.14..0.16 rows=1 width=104) (actual time=0.002..0.002 rows=1 loops=1)

  • Index Cond: (id = "ctsInsScanCheck".ref_cts_ins_doc_type_id)
49. 0.001 0.005 ↑ 4.0 1 1

Materialize (cost=0.00..1.06 rows=4 width=101) (actual time=0.004..0.005 rows=1 loops=1)

50. 0.004 0.004 ↑ 4.0 1 1

Seq Scan on ref_ins_scans_check_status "refInsScanCheckStatus" (cost=0.00..1.04 rows=4 width=101) (actual time=0.004..0.004 rows=1 loops=1)

51. 0.003 0.006 ↑ 1.0 4 1

Materialize (cost=0.00..1.06 rows=4 width=101) (actual time=0.005..0.006 rows=4 loops=1)

52. 0.003 0.003 ↑ 1.0 4 1

Seq Scan on ref_ins_scans_check_errors "refInsScanCheckError" (cost=0.00..1.04 rows=4 width=101) (actual time=0.003..0.003 rows=4 loops=1)

53. 0.007 0.007 ↑ 2.2 5 1

Index Only Scan using "PK_f98010849793b1aea1680448111" on cts_ins_statuses_vers "ctsIns_ctsInsStatuses" (cost=0.29..0.81 rows=11 width=8) (actual time=0.005..0.007 rows=5 loops=1)

  • Index Cond: (cts_ins_id = "ctsIns".id)
  • Heap Fetches: 5
54. 0.010 0.010 ↑ 1.0 1 5

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

  • Index Cond: (id = "ctsIns_ctsInsStatuses".cts_ins_statuses_id)
55. 0.015 0.015 ↑ 1.5 2 5

Index Only Scan using "PK_254d1a736e45460d7d469c21628" on cts_ins_sides_vers "ctsIns_ctsInsSide" (cost=0.28..0.42 rows=3 width=8) (actual time=0.002..0.003 rows=2 loops=5)

  • Index Cond: (cts_ins_id = "ctsIns".id)
  • Heap Fetches: 10
56. 0.020 0.020 ↑ 1.0 1 10

Index Scan using "PK_15849ffa7565341c66ade4b2ddc" on cts_ins_sides "ctsInsSide" (cost=0.28..0.34 rows=1 width=24) (actual time=0.002..0.002 rows=1 loops=10)

  • Index Cond: (id = "ctsIns_ctsInsSide".cts_ins_sides_id)
57. 0.007 0.010 ↑ 2.0 4 10

Materialize (cost=0.00..1.12 rows=8 width=100) (actual time=0.000..0.001 rows=4 loops=10)

58. 0.003 0.003 ↑ 1.0 8 1

Seq Scan on ref_cts_ins_sides_types "refCtsInsSidesType" (cost=0.00..1.08 rows=8 width=100) (actual time=0.003..0.003 rows=8 loops=1)

59. 0.020 0.020 ↑ 1.0 1 10

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

  • Index Cond: (id = "ctsInsSide".ctgts_fl_vers_id)
60. 0.020 0.020 ↑ 1.0 1 10

Index Only Scan using "PK_770baa493d76ba3f90c7c7dfbf0" on ctgts_fl_types_vers "ctgtsFlVers_ctgtsFlTypes" (cost=0.28..0.33 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=10)

  • Index Cond: (ctgts_fl_vers_id = "ctgtsFlVers".id)
  • Heap Fetches: 10
61. 0.010 0.010 ↑ 1.0 1 10

Index Scan using "PK_39333148faecb7780dac67da0d2" on ctgts_fl_types "ctgtsFlTypes" (cost=0.28..0.34 rows=1 width=48) (actual time=0.001..0.001 rows=1 loops=10)

  • Index Cond: (id = "ctgtsFlVers_ctgtsFlTypes".ctgts_fl_types_id)
62. 0.020 0.020 ↑ 1.0 1 10

Index Scan using "PK_bc0006cfa6e0330bd5cfe4f5cb2" on ctgts (cost=0.28..0.35 rows=1 width=57) (actual time=0.002..0.002 rows=1 loops=10)

  • Index Cond: (id = "ctgtsFlVers".ctgts_id)
63. 0.010 0.010 ↑ 1.0 1 10

Index Scan using "PK_85ae76faeb0c540319ad60a1e90" on ctgts_fl_data_names "ctgtsFlDataName" (cost=0.28..0.38 rows=1 width=191) (actual time=0.001..0.001 rows=1 loops=10)

  • Index Cond: (id = "ctgtsFlVers".ctgts_fl_data_name_id)
64. 0.000 0.000 ↑ 3.0 1 10

Materialize (cost=0.00..1.04 rows=3 width=132) (actual time=0.000..0.000 rows=1 loops=10)

65. 0.002 0.002 ↑ 3.0 1 1

Seq Scan on ref_glbl_ctgts_types "refGlblCtgtsType" (cost=0.00..1.03 rows=3 width=132) (actual time=0.002..0.002 rows=1 loops=1)

66. 0.000 0.000 ↑ 1.5 2 10

Materialize (cost=0.00..1.04 rows=3 width=132) (actual time=0.000..0.000 rows=2 loops=10)

67. 0.002 0.002 ↑ 1.5 2 1

Seq Scan on ref_ctgts_fl_types "refCtgtsFlTypes" (cost=0.00..1.03 rows=3 width=132) (actual time=0.002..0.002 rows=2 loops=1)

68. 0.010 0.010 ↑ 1.0 1 10

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

  • Index Cond: (id = "ctsInsStatuses".ref_ins_statuses_id)
Planning time : 18.387 ms
Execution time : 1,272.046 ms