explain.depesz.com

PostgreSQL's explain analyze made readable

Result: q3HY

Settings
# exclusive inclusive rows x rows loops node
1. 133.452 5,612.079 ↓ 106.9 72,793 1

Hash Left Join (cost=3,657.48..7,368.96 rows=681 width=3,869) (actual time=75.627..5,612.079 rows=72,793 loops=1)

  • Hash Cond: ("ctgtsFlVers_ctgtsFlTypes".ctgts_fl_types_id = "ctgtsFlTypes".id)
2. 123.299 5,474.345 ↓ 106.9 72,793 1

Hash Left Join (cost=3,468.76..7,170.87 rows=681 width=3,693) (actual time=71.301..5,474.345 rows=72,793 loops=1)

  • Hash Cond: ("ctgtsFlVers".ctgts_id = ctgts.id)
3. 120.682 5,349.081 ↓ 106.9 72,793 1

Hash Left Join (cost=3,293.49..6,993.82 rows=681 width=3,636) (actual time=69.292..5,349.081 rows=72,793 loops=1)

  • Hash Cond: ("ctsInsStatuses".ref_ins_statuses_id = "refInsStatuses".id)
4. 154.126 5,228.382 ↓ 106.9 72,793 1

Hash Join (cost=3,291.91..6,990.16 rows=681 width=3,524) (actual time=69.258..5,228.382 rows=72,793 loops=1)

  • Hash Cond: ("ctgtsFlVers".ctgts_fl_data_name_id = "ctgtsFlDataName".id)
5. 609.075 5,058.180 ↓ 4.4 375,502 1

Hash Join (cost=2,898.56..6,370.72 rows=86,062 width=3,333) (actual time=53.171..5,058.180 rows=375,502 loops=1)

  • Hash Cond: ("ctsIns".id = "ctsIns_ctsInsSide".cts_ins_id)
6. 204.159 4,429.900 ↓ 4.2 135,786 1

Hash Left Join (cost=2,119.33..4,404.87 rows=32,600 width=3,071) (actual time=33.951..4,429.900 rows=135,786 loops=1)

  • Hash Cond: ("ctsIns_ctsInsStatuses".cts_ins_statuses_id = "ctsInsStatuses".id)
7. 175.909 4,216.392 ↓ 4.2 135,786 1

Hash Left Join (cost=1,401.09..3,601.04 rows=32,600 width=3,042) (actual time=24.477..4,216.392 rows=135,786 loops=1)

  • Hash Cond: ("ctsIns".id = "ctsIns_ctsInsStatuses".cts_ins_id)
8. 7.999 4,034.757 ↓ 2.0 5,619 1

Hash Left Join (cost=771.85..1,449.50 rows=2,874 width=3,038) (actual time=18.619..4,034.757 rows=5,619 loops=1)

  • Hash Cond: ("refCtsInsScanType".ref_cts_ins_sides_type_id = "scanTypeRefCtsInsSidesType".id)
9. 7.428 4,026.752 ↓ 2.0 5,619 1

Hash Left Join (cost=770.67..1,438.64 rows=2,874 width=2,938) (actual time=18.597..4,026.752 rows=5,619 loops=1)

  • Hash Cond: ("ctsInsScanCheck".ref_ins_scan_check_error_id = "refInsScanCheckError".id)
10. 8.380 4,019.318 ↓ 2.0 5,619 1

Hash Left Join (cost=769.58..1,429.86 rows=2,874 width=2,837) (actual time=18.574..4,019.318 rows=5,619 loops=1)

  • Hash Cond: ("ctsInsScanCheck".ref_ins_scan_check_status_id = "refInsScanCheckStatus".id)
11. 8.133 4,010.933 ↓ 2.0 5,619 1

Hash Left Join (cost=768.49..1,413.24 rows=2,874 width=2,736) (actual time=18.552..4,010.933 rows=5,619 loops=1)

  • Hash Cond: ("ctsInsScanCheck".ref_cts_ins_doc_type_id = "refCtsInsDocType".id)
12. 8.329 4,002.783 ↓ 2.0 5,619 1

Hash Left Join (cost=766.54..1,402.99 rows=2,874 width=2,632) (actual time=18.520..4,002.783 rows=5,619 loops=1)

  • Hash Cond: ("ctsInsScanCheck".ref_cts_ins_scan_type_id = "refCtsInsScanType".id)
13. 8.062 3,994.434 ↓ 2.0 5,619 1

Hash Left Join (cost=765.21..1,391.98 rows=2,874 width=2,520) (actual time=18.476..3,994.434 rows=5,619 loops=1)

  • Hash Cond: ("ctsInsScanCheck".last_check_user_id = "lastCheckUser".id)
14. 8.990 3,985.893 ↓ 2.0 5,619 1

Hash Left Join (cost=737.51..1,356.69 rows=2,874 width=1,971) (actual time=17.987..3,985.893 rows=5,619 loops=1)

  • Hash Cond: ("ctsInsScanCheck".cts_ins_scan_id = "ctsInsScan".id)
15. 12.889 3,972.600 ↓ 2.0 5,619 1

Hash Left Join (cost=299.40..911.03 rows=2,874 width=1,598) (actual time=13.670..3,972.600 rows=5,619 loops=1)

  • Hash Cond: ("ctsInsVers".cts_id = cts.id)
  • Filter: (SubPlan 1)
  • Rows Removed by Filter: 1441
16. 13.368 26.586 ↓ 1.2 7,060 1

Hash Right Join (cost=233.09..430.61 rows=5,748 width=1,541) (actual time=12.332..26.586 rows=7,060 loops=1)

  • Hash Cond: ("ctsInsScanCheck".cts_ins_id = "ctsIns".id)
17. 0.902 0.902 ↑ 1.0 5,748 1

Seq Scan on cts_ins_scans_check "ctsInsScanCheck" (cost=0.00..118.48 rows=5,748 width=115) (actual time=0.006..0.902 rows=5,748 loops=1)

18. 2.082 12.316 ↑ 1.0 2,058 1

Hash (cost=207.37..207.37 rows=2,058 width=1,426) (actual time=12.316..12.316 rows=2,058 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 1773kB
19. 1.776 10.234 ↑ 1.0 2,058 1

Hash Left Join (cost=119.42..207.37 rows=2,058 width=1,426) (actual time=1.952..10.234 rows=2,058 loops=1)

  • Hash Cond: ("ctsIns".ref_ins_scan_check_status_id = "ctsInsRefInsScanCheckStatus".id)
20. 1.970 8.452 ↑ 1.0 2,058 1

Hash Left Join (cost=118.33..197.61 rows=2,058 width=1,325) (actual time=1.938..8.452 rows=2,058 loops=1)

  • Hash Cond: ("ctsIns".user_id = "user".id)
21. 1.423 6.064 ↑ 1.0 2,058 1

Hash Left Join (cost=90.64..164.46 rows=2,058 width=776) (actual time=1.515..6.064 rows=2,058 loops=1)

  • Hash Cond: ("ctsIns".branch_id = branch.id)
22. 1.347 4.570 ↑ 1.0 2,058 1

Hash Left Join (cost=83.48..151.74 rows=2,058 width=638) (actual time=1.439..4.570 rows=2,058 loops=1)

  • Hash Cond: ("ctsIns".partner_id = partner.id)
23. 1.552 3.217 ↑ 1.0 2,058 1

Hash Join (cost=82.31..142.30 rows=2,058 width=243) (actual time=1.427..3.217 rows=2,058 loops=1)

  • Hash Cond: ("ctsInsVers".cts_ins_id = "ctsIns".id)
24. 0.249 0.249 ↑ 1.0 2,058 1

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

25. 0.577 1.416 ↑ 1.0 2,058 1

Hash (cost=56.58..56.58 rows=2,058 width=144) (actual time=1.416..1.416 rows=2,058 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 313kB
26. 0.839 0.839 ↑ 1.0 2,058 1

Seq Scan on cts_ins "ctsIns" (cost=0.00..56.58 rows=2,058 width=144) (actual time=0.005..0.839 rows=2,058 loops=1)

27. 0.002 0.006 ↑ 1.0 8 1

Hash (cost=1.08..1.08 rows=8 width=395) (actual time=0.006..0.006 rows=8 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
28. 0.004 0.004 ↑ 1.0 8 1

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

29. 0.034 0.071 ↑ 1.0 140 1

Hash (cost=5.40..5.40 rows=140 width=138) (actual time=0.071..0.071 rows=140 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 33kB
30. 0.037 0.037 ↑ 1.0 140 1

Seq Scan on branches branch (cost=0.00..5.40 rows=140 width=138) (actual time=0.004..0.037 rows=140 loops=1)

31. 0.193 0.418 ↑ 1.0 431 1

Hash (cost=22.31..22.31 rows=431 width=549) (actual time=0.418..0.418 rows=431 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 146kB
32. 0.225 0.225 ↑ 1.0 431 1

Seq Scan on users "user" (cost=0.00..22.31 rows=431 width=549) (actual time=0.005..0.225 rows=431 loops=1)

33. 0.002 0.006 ↑ 1.0 4 1

Hash (cost=1.04..1.04 rows=4 width=101) (actual time=0.006..0.006 rows=4 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
34. 0.004 0.004 ↑ 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.004..0.004 rows=4 loops=1)

35. 0.328 0.705 ↑ 1.0 2,058 1

Hash (cost=40.58..40.58 rows=2,058 width=57) (actual time=0.705..0.705 rows=2,058 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 199kB
36. 0.377 0.377 ↑ 1.0 2,058 1

Seq Scan on cts (cost=0.00..40.58 rows=2,058 width=57) (actual time=0.005..0.377 rows=2,058 loops=1)

37.          

SubPlan (for Hash Left Join)

38. 14.120 3,932.420 ↑ 1.5 4 7,060

Unique (cost=132.97..133.01 rows=6 width=16) (actual time=0.556..0.557 rows=4 loops=7,060)

39. 21.180 3,918.300 ↑ 2.0 4 7,060

Sort (cost=132.97..132.99 rows=8 width=16) (actual time=0.555..0.555 rows=4 loops=7,060)

  • Sort Key: "ctsInsScanCheck_1".ref_cts_ins_doc_type_id, "ctsInsScanCheck_1".check_finish_date DESC
  • Sort Method: quicksort Memory: 25kB
40. 3,897.120 3,897.120 ↑ 1.1 7 7,060

Seq Scan on cts_ins_scans_check "ctsInsScanCheck_1" (cost=0.00..132.85 rows=8 width=16) (actual time=0.244..0.552 rows=7 loops=7,060)

  • Filter: (cts_id = cts.id)
  • Rows Removed by Filter: 5741
41. 1.916 4.303 ↑ 1.0 6,405 1

Hash (cost=358.05..358.05 rows=6,405 width=373) (actual time=4.303..4.303 rows=6,405 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 2377kB
42. 2.387 2.387 ↑ 1.0 6,405 1

Seq Scan on cts_ins_scans "ctsInsScan" (cost=0.00..358.05 rows=6,405 width=373) (actual time=0.005..2.387 rows=6,405 loops=1)

43. 0.246 0.479 ↑ 1.0 431 1

Hash (cost=22.31..22.31 rows=431 width=549) (actual time=0.478..0.479 rows=431 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 146kB
44. 0.233 0.233 ↑ 1.0 431 1

Seq Scan on users "lastCheckUser" (cost=0.00..22.31 rows=431 width=549) (actual time=0.009..0.233 rows=431 loops=1)

45. 0.012 0.020 ↑ 1.0 15 1

Hash (cost=1.15..1.15 rows=15 width=112) (actual time=0.020..0.020 rows=15 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
46. 0.008 0.008 ↑ 1.0 15 1

Seq Scan on ref_cts_ins_scan_types "refCtsInsScanType" (cost=0.00..1.15 rows=15 width=112) (actual time=0.005..0.008 rows=15 loops=1)

47. 0.010 0.017 ↑ 1.0 42 1

Hash (cost=1.42..1.42 rows=42 width=104) (actual time=0.017..0.017 rows=42 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 14kB
48. 0.007 0.007 ↑ 1.0 42 1

Seq Scan on ref_cts_ins_docs_types "refCtsInsDocType" (cost=0.00..1.42 rows=42 width=104) (actual time=0.004..0.007 rows=42 loops=1)

49. 0.002 0.005 ↑ 1.0 4 1

Hash (cost=1.04..1.04 rows=4 width=101) (actual time=0.005..0.005 rows=4 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
50. 0.003 0.003 ↑ 1.0 4 1

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

51. 0.003 0.006 ↑ 1.0 4 1

Hash (cost=1.04..1.04 rows=4 width=101) (actual time=0.006..0.006 rows=4 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
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.002..0.003 rows=4 loops=1)

53. 0.003 0.006 ↑ 1.0 8 1

Hash (cost=1.08..1.08 rows=8 width=100) (actual time=0.006..0.006 rows=8 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
54. 0.003 0.003 ↑ 1.0 8 1

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

55. 3.551 5.726 ↑ 1.0 23,344 1

Hash (cost=337.44..337.44 rows=23,344 width=8) (actual time=5.726..5.726 rows=23,344 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 1168kB
56. 2.175 2.175 ↑ 1.0 23,344 1

Seq Scan on cts_ins_statuses_vers "ctsIns_ctsInsStatuses" (cost=0.00..337.44 rows=23,344 width=8) (actual time=0.008..2.175 rows=23,344 loops=1)

57. 4.630 9.349 ↑ 1.0 23,344 1

Hash (cost=426.44..426.44 rows=23,344 width=33) (actual time=9.349..9.349 rows=23,344 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 1850kB
58. 4.719 4.719 ↑ 1.0 23,344 1

Seq Scan on cts_ins_statuses "ctsInsStatuses" (cost=0.00..426.44 rows=23,344 width=33) (actual time=0.006..4.719 rows=23,344 loops=1)

59. 2.573 19.205 ↑ 1.0 5,433 1

Hash (cost=711.31..711.31 rows=5,433 width=266) (actual time=19.205..19.205 rows=5,433 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 1247kB
60. 3.156 16.632 ↑ 1.0 5,433 1

Hash Left Join (cost=506.93..711.31 rows=5,433 width=266) (actual time=5.862..16.632 rows=5,433 loops=1)

  • Hash Cond: ("ctgtsFlVers".id = "ctgtsFlVers_ctgtsFlTypes".ctgts_fl_vers_id)
61. 3.146 12.237 ↑ 1.0 5,433 1

Hash Join (cost=359.69..489.38 rows=5,433 width=262) (actual time=4.613..12.237 rows=5,433 loops=1)

  • Hash Cond: ("ctsInsSide".ctgts_fl_vers_id = "ctgtsFlVers".id)
62. 1.854 5.805 ↑ 1.0 5,433 1

Hash Left Join (cost=157.42..272.84 rows=5,433 width=128) (actual time=1.321..5.805 rows=5,433 loops=1)

  • Hash Cond: ("ctsInsSide".ref_cts_ins_sides_type_id = "refCtsInsSidesType".id)
63. 2.092 3.944 ↑ 1.0 5,433 1

Hash Join (cost=156.24..249.85 rows=5,433 width=28) (actual time=1.310..3.944 rows=5,433 loops=1)

  • Hash Cond: ("ctsIns_ctsInsSide".cts_ins_sides_id = "ctsInsSide".id)
64. 0.556 0.556 ↑ 1.0 5,433 1

Seq Scan on cts_ins_sides_vers "ctsIns_ctsInsSide" (cost=0.00..79.33 rows=5,433 width=8) (actual time=0.006..0.556 rows=5,433 loops=1)

65. 0.744 1.296 ↑ 1.0 5,433 1

Hash (cost=88.33..88.33 rows=5,433 width=24) (actual time=1.295..1.296 rows=5,433 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 335kB
66. 0.552 0.552 ↑ 1.0 5,433 1

Seq Scan on cts_ins_sides "ctsInsSide" (cost=0.00..88.33 rows=5,433 width=24) (actual time=0.005..0.552 rows=5,433 loops=1)

67. 0.002 0.007 ↑ 1.0 8 1

Hash (cost=1.08..1.08 rows=8 width=100) (actual time=0.006..0.007 rows=8 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
68. 0.005 0.005 ↑ 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.004..0.005 rows=8 loops=1)

69. 1.301 3.286 ↑ 1.0 5,434 1

Hash (cost=134.34..134.34 rows=5,434 width=134) (actual time=3.285..3.286 rows=5,434 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 713kB
70. 1.985 1.985 ↑ 1.0 5,434 1

Seq Scan on ctgts_fl_vers "ctgtsFlVers" (cost=0.00..134.34 rows=5,434 width=134) (actual time=0.010..1.985 rows=5,434 loops=1)

71. 0.740 1.239 ↑ 1.0 5,433 1

Hash (cost=79.33..79.33 rows=5,433 width=8) (actual time=1.238..1.239 rows=5,433 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 277kB
72. 0.499 0.499 ↑ 1.0 5,433 1

Seq Scan on ctgts_fl_types_vers "ctgtsFlVers_ctgtsFlTypes" (cost=0.00..79.33 rows=5,433 width=8) (actual time=0.005..0.499 rows=5,433 loops=1)

73. 0.353 16.076 ↓ 41.7 1,792 1

Hash (cost=392.82..392.82 rows=43 width=191) (actual time=16.075..16.076 rows=1,792 loops=1)

  • Buckets: 2048 (originally 1024) Batches: 1 (originally 1) Memory Usage: 260kB
74. 15.723 15.723 ↓ 41.7 1,792 1

Seq Scan on ctgts_fl_data_names "ctgtsFlDataName" (cost=0.00..392.82 rows=43 width=191) (actual time=0.029..15.723 rows=1,792 loops=1)

  • Filter: ((((lower((last_name)::text) || lower((first_name)::text)) || lower((middle_name)::text)) ~~ '%п%'::text) AND (((lower((last_name)::text) || lower((first_name)::text)) || lower((middle_name)::text)) ~~ '%п%'::text) AND (((lower((last_name)::text) || lower((first_name)::text)) || lower((middle_name)::text)) ~~ '%п%'::text))
  • Rows Removed by Filter: 3641
75. 0.008 0.017 ↑ 1.0 26 1

Hash (cost=1.26..1.26 rows=26 width=112) (actual time=0.017..0.017 rows=26 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
76. 0.009 0.009 ↑ 1.0 26 1

Seq Scan on ref_ins_statuses "refInsStatuses" (cost=0.00..1.26 rows=26 width=112) (actual time=0.004..0.009 rows=26 loops=1)

77. 0.999 1.965 ↑ 1.0 5,434 1

Hash (cost=107.34..107.34 rows=5,434 width=57) (actual time=1.965..1.965 rows=5,434 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 500kB
78. 0.966 0.966 ↑ 1.0 5,434 1

Seq Scan on ctgts (cost=0.00..107.34 rows=5,434 width=57) (actual time=0.007..0.966 rows=5,434 loops=1)

79. 1.710 4.282 ↑ 1.0 5,433 1

Hash (cost=120.81..120.81 rows=5,433 width=180) (actual time=4.282..4.282 rows=5,433 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 642kB
80. 2.031 2.572 ↑ 1.0 5,433 1

Hash Left Join (cost=1.07..120.81 rows=5,433 width=180) (actual time=0.023..2.572 rows=5,433 loops=1)

  • Hash Cond: ("ctgtsFlTypes".ref_ctgts_fl_types_id = "refCtgtsFlTypes".id)
81. 0.535 0.535 ↑ 1.0 5,433 1

Seq Scan on ctgts_fl_types "ctgtsFlTypes" (cost=0.00..85.33 rows=5,433 width=48) (actual time=0.005..0.535 rows=5,433 loops=1)

82. 0.003 0.006 ↑ 1.0 3 1

Hash (cost=1.03..1.03 rows=3 width=132) (actual time=0.006..0.006 rows=3 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
83. 0.003 0.003 ↑ 1.0 3 1

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

Planning time : 11.118 ms
Execution time : 5,616.001 ms