explain.depesz.com

PostgreSQL's explain analyze made readable

Result: l5rT

Settings
# exclusive inclusive rows x rows loops node
1. 621.732 7,701.988 ↓ 4.6 375,502 1

Hash Left Join (cost=3,531.06..8,891.40 rows=81,926 width=3,901) (actual time=68.867..7,701.988 rows=375,502 loops=1)

  • Hash Cond: ("ctsInsStatuses".ref_ins_statuses_id = "refInsStatuses".id)
2. 599.047 7,080.237 ↓ 4.6 375,502 1

Hash Left Join (cost=3,529.48..8,639.71 rows=81,926 width=3,789) (actual time=68.824..7,080.237 rows=375,502 loops=1)

  • Hash Cond: ("ctgtsFlTypes".ref_ctgts_fl_types_id = "refCtgtsFlTypes".id)
3. 594.344 6,481.185 ↓ 4.6 375,502 1

Hash Left Join (cost=3,528.41..8,119.77 rows=81,926 width=3,657) (actual time=68.803..6,481.185 rows=375,502 loops=1)

  • Hash Cond: (ctgts.ref_glbl_ctgts_type_id = "refGlblCtgtsType".id)
4. 591.976 5,886.835 ↓ 4.6 375,502 1

Hash Left Join (cost=3,527.34..7,599.83 rows=81,926 width=3,525) (actual time=68.773..5,886.835 rows=375,502 loops=1)

  • Hash Cond: ("ctgtsFlVers".ctgts_fl_data_name_id = "ctgtsFlDataName".id)
5. 551.851 5,293.080 ↓ 4.6 375,502 1

Hash Left Join (cost=3,306.49..7,163.76 rows=81,926 width=3,334) (actual time=66.947..5,293.080 rows=375,502 loops=1)

  • Hash Cond: ("ctgtsFlVers".ctgts_id = ctgts.id)
6. 582.926 4,739.102 ↓ 4.6 375,502 1

Hash Left Join (cost=3,127.91..6,769.95 rows=81,926 width=3,277) (actual time=64.771..4,739.102 rows=375,502 loops=1)

  • Hash Cond: ("ctsIns".id = "ctsIns_ctsInsSide".cts_ins_id)
7. 194.287 4,130.342 ↓ 4.3 135,786 1

Hash Left Join (cost=2,172.50..4,679.82 rows=31,546 width=2,971) (actual time=38.889..4,130.342 rows=135,786 loops=1)

  • Hash Cond: ("ctsIns_ctsInsStatuses".cts_ins_statuses_id = "ctsInsStatuses".id)
8. 165.465 3,925.071 ↓ 4.3 135,786 1

Hash Left Join (cost=1,450.54..3,875.04 rows=31,546 width=2,942) (actual time=27.747..3,925.071 rows=135,786 loops=1)

  • Hash Cond: ("ctsIns".id = "ctsIns_ctsInsStatuses".cts_ins_id)
9. 7.641 3,750.898 ↓ 2.0 5,619 1

Hash Left Join (cost=821.30..1,753.60 rows=2,827 width=2,938) (actual time=18.880..3,750.898 rows=5,619 loops=1)

  • Hash Cond: ("ctsInsScanCheck".ref_ins_scan_check_error_id = "refInsScanCheckError".id)
10. 8.081 3,743.248 ↓ 2.0 5,619 1

Hash Left Join (cost=820.21..1,744.96 rows=2,827 width=2,837) (actual time=18.849..3,743.248 rows=5,619 loops=1)

  • Hash Cond: ("ctsInsScanCheck".ref_ins_scan_check_status_id = "refInsScanCheckStatus".id)
11. 8.077 3,735.160 ↓ 2.0 5,619 1

Hash Left Join (cost=819.12..1,728.58 rows=2,827 width=2,736) (actual time=18.821..3,735.160 rows=5,619 loops=1)

  • Hash Cond: ("ctsInsScanCheck".ref_cts_ins_doc_type_id = "refCtsInsDocType".id)
12. 7.960 3,727.050 ↓ 2.0 5,619 1

Hash Left Join (cost=817.17..1,718.47 rows=2,827 width=2,632) (actual time=18.766..3,727.050 rows=5,619 loops=1)

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

Hash Left Join (cost=815.83..1,707.62 rows=2,827 width=2,520) (actual time=18.724..3,719.071 rows=5,619 loops=1)

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

Hash Left Join (cost=788.14..1,672.46 rows=2,827 width=1,971) (actual time=17.967..3,710.568 rows=5,619 loops=1)

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

Hash Left Join (cost=348.53..1,225.43 rows=2,827 width=1,598) (actual time=10.002..3,694.368 rows=5,619 loops=1)

  • Hash Cond: ("ctsIns".ref_ins_scan_check_status_id = "ctsInsRefInsScanCheckStatus".id)
16. 7.420 3,688.198 ↓ 2.0 5,619 1

Hash Left Join (cost=347.44..1,212.39 rows=2,827 width=1,497) (actual time=9.916..3,688.198 rows=5,619 loops=1)

  • Hash Cond: ("ctsIns".user_id = "user".id)
17. 5.736 3,679.906 ↓ 2.0 5,619 1

Hash Left Join (cost=319.74..1,177.19 rows=2,827 width=948) (actual time=9.005..3,679.906 rows=5,619 loops=1)

  • Hash Cond: ("ctsIns".branch_id = branch.id)
18. 5.879 3,674.039 ↓ 2.0 5,619 1

Hash Left Join (cost=312.59..1,162.40 rows=2,827 width=810) (actual time=8.853..3,674.039 rows=5,619 loops=1)

  • Hash Cond: ("ctsIns".partner_id = partner.id)
19. 11.646 3,668.149 ↓ 2.0 5,619 1

Hash Left Join (cost=311.41..1,149.87 rows=2,827 width=415) (actual time=8.822..3,668.149 rows=5,619 loops=1)

  • Hash Cond: ("ctsInsVers".cts_id = cts.id)
  • Filter: (SubPlan 1)
  • Rows Removed by Filter: 1475
20. 8.462 16.065 ↓ 1.3 7,094 1

Hash Right Join (cost=241.79..495.37 rows=5,655 width=358) (actual time=6.522..16.065 rows=7,094 loops=1)

  • Hash Cond: ("ctsInsScanCheck".cts_ins_id = "ctsIns".id)
21. 1.098 1.098 ↑ 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.006..1.098 rows=5,748 loops=1)

22. 1.453 6.505 ↓ 1.0 2,092 1

Hash (cost=216.06..216.06 rows=2,058 width=243) (actual time=6.505..6.505 rows=2,092 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 510kB
23. 2.336 5.052 ↓ 1.0 2,092 1

Hash Left Join (cost=156.07..216.06 rows=2,058 width=243) (actual time=2.384..5.052 rows=2,092 loops=1)

  • Hash Cond: ("ctsInsVers".cts_ins_id = "ctsIns".id)
24. 0.351 0.351 ↓ 1.0 2,092 1

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

25. 0.996 2.365 ↑ 1.0 2,092 1

Hash (cost=129.92..129.92 rows=2,092 width=144) (actual time=2.365..2.365 rows=2,092 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 318kB
26. 1.369 1.369 ↑ 1.0 2,092 1

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

27. 0.601 1.216 ↑ 1.0 2,092 1

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

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

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

29.          

SubPlan (for Hash Left Join)

30. 14.188 3,639.222 ↑ 1.5 4 7,094

Unique (cost=189.97..190.01 rows=6 width=16) (actual time=0.512..0.513 rows=4 loops=7,094)

31. 21.282 3,625.034 ↑ 2.0 4 7,094

Sort (cost=189.97..189.99 rows=8 width=16) (actual time=0.511..0.511 rows=4 loops=7,094)

  • Sort Key: "ctsInsScanCheck_1".ref_cts_ins_doc_type_id, "ctsInsScanCheck_1".check_finish_date DESC
  • Sort Method: quicksort Memory: 25kB
32. 3,603.752 3,603.752 ↑ 1.1 7 7,094

Seq Scan on cts_ins_scans_check "ctsInsScanCheck_1" (cost=0.00..189.85 rows=8 width=16) (actual time=0.246..0.508 rows=7 loops=7,094)

  • Filter: (cts_id = cts.id)
  • Rows Removed by Filter: 5741
33. 0.006 0.011 ↑ 1.0 8 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
34. 0.005 0.005 ↑ 1.0 8 1

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

35. 0.069 0.131 ↑ 1.0 140 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 33kB
36. 0.062 0.062 ↑ 1.0 140 1

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

37. 0.422 0.872 ↑ 1.0 431 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 146kB
38. 0.450 0.450 ↑ 1.0 431 1

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

39. 0.009 0.022 ↑ 1.0 4 1

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

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

41. 4.354 7.866 ↑ 1.0 6,407 1

Hash (cost=359.27..359.27 rows=6,427 width=373) (actual time=7.866..7.866 rows=6,407 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 2378kB
42. 3.512 3.512 ↑ 1.0 6,407 1

Seq Scan on cts_ins_scans "ctsInsScan" (cost=0.00..359.27 rows=6,427 width=373) (actual time=0.020..3.512 rows=6,407 loops=1)

43. 0.399 0.728 ↑ 1.0 431 1

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

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

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

45. 0.009 0.019 ↑ 1.0 15 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
46. 0.010 0.010 ↑ 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.010 rows=15 loops=1)

47. 0.017 0.033 ↑ 1.0 42 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 14kB
48. 0.016 0.016 ↑ 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.011..0.016 rows=42 loops=1)

49. 0.003 0.007 ↑ 1.0 4 1

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

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

51. 0.005 0.009 ↑ 1.0 4 1

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

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

53. 5.369 8.708 ↓ 1.0 23,378 1

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

  • Buckets: 32768 Batches: 1 Memory Usage: 1170kB
54. 3.339 3.339 ↓ 1.0 23,378 1

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

55. 5.461 10.984 ↑ 1.0 23,378 1

Hash (cost=428.65..428.65 rows=23,465 width=33) (actual time=10.983..10.984 rows=23,378 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 1852kB
56. 5.523 5.523 ↑ 1.0 23,378 1

Seq Scan on cts_ins_statuses "ctsInsStatuses" (cost=0.00..428.65 rows=23,465 width=33) (actual time=0.009..5.523 rows=23,378 loops=1)

57. 3.404 25.834 ↓ 1.0 5,535 1

Hash (cost=887.50..887.50 rows=5,433 width=310) (actual time=25.834..25.834 rows=5,535 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 1341kB
58. 3.204 22.430 ↓ 1.0 5,535 1

Hash Left Join (cost=670.17..887.50 rows=5,433 width=310) (actual time=7.994..22.430 rows=5,535 loops=1)

  • Hash Cond: ("ctgtsFlVers_ctgtsFlTypes".ctgts_fl_types_id = "ctgtsFlTypes".id)
59. 3.184 17.817 ↓ 1.0 5,535 1

Hash Left Join (cost=511.99..715.04 rows=5,433 width=266) (actual time=6.544..17.817 rows=5,535 loops=1)

  • Hash Cond: ("ctgtsFlVers".id = "ctgtsFlVers_ctgtsFlTypes".ctgts_fl_vers_id)
60. 3.403 13.241 ↓ 1.0 5,535 1

Hash Left Join (cost=364.75..494.44 rows=5,433 width=262) (actual time=5.117..13.241 rows=5,535 loops=1)

  • Hash Cond: ("ctsInsSide".ctgts_fl_vers_id = "ctgtsFlVers".id)
61. 1.951 6.222 ↓ 1.0 5,535 1

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

  • Hash Cond: ("ctsInsSide".ref_cts_ins_sides_type_id = "refCtsInsSidesType".id)
62. 2.287 4.261 ↓ 1.0 5,535 1

Hash Left Join (cost=156.24..249.85 rows=5,433 width=28) (actual time=1.443..4.261 rows=5,535 loops=1)

  • Hash Cond: ("ctsIns_ctsInsSide".cts_ins_sides_id = "ctsInsSide".id)
63. 0.571 0.571 ↓ 1.0 5,535 1

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

64. 0.874 1.403 ↓ 1.0 5,535 1

Hash (cost=88.33..88.33 rows=5,433 width=24) (actual time=1.402..1.403 rows=5,535 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 340kB
65. 0.529 0.529 ↓ 1.0 5,535 1

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

66. 0.006 0.010 ↑ 1.0 8 1

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

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

68. 1.595 3.616 ↑ 1.0 5,536 1

Hash (cost=137.70..137.70 rows=5,570 width=134) (actual time=3.616..3.616 rows=5,536 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 726kB
69. 2.021 2.021 ↑ 1.0 5,536 1

Seq Scan on ctgts_fl_vers "ctgtsFlVers" (cost=0.00..137.70 rows=5,570 width=134) (actual time=0.006..2.021 rows=5,536 loops=1)

70. 0.860 1.392 ↓ 1.0 5,535 1

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

  • Buckets: 8192 Batches: 1 Memory Usage: 281kB
71. 0.532 0.532 ↓ 1.0 5,535 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.532 rows=5,535 loops=1)

72. 0.874 1.409 ↑ 1.0 5,535 1

Hash (cost=88.08..88.08 rows=5,608 width=48) (actual time=1.409..1.409 rows=5,535 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 329kB
73. 0.535 0.535 ↑ 1.0 5,535 1

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

74. 1.100 2.127 ↑ 1.0 5,536 1

Hash (cost=109.37..109.37 rows=5,537 width=57) (actual time=2.127..2.127 rows=5,536 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 510kB
75. 1.027 1.027 ↑ 1.0 5,536 1

Seq Scan on ctgts (cost=0.00..109.37 rows=5,537 width=57) (actual time=0.008..1.027 rows=5,536 loops=1)

76. 1.141 1.779 ↑ 1.0 5,535 1

Hash (cost=151.49..151.49 rows=5,549 width=191) (actual time=1.779..1.779 rows=5,535 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 819kB
77. 0.638 0.638 ↑ 1.0 5,535 1

Seq Scan on ctgts_fl_data_names "ctgtsFlDataName" (cost=0.00..151.49 rows=5,549 width=191) (actual time=0.004..0.638 rows=5,535 loops=1)

78. 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
79. 0.003 0.003 ↑ 1.0 3 1

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

80. 0.003 0.005 ↑ 1.0 3 1

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

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

82. 0.010 0.019 ↑ 1.0 26 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
83. 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)

Planning time : 14.974 ms
Execution time : 7,720.402 ms