explain.depesz.com

PostgreSQL's explain analyze made readable

Result: U0d8

Settings
# exclusive inclusive rows x rows loops node
1. 654.869 4,450.673 ↓ 4.6 375,502 1

Hash Left Join (cost=3,120.97..7,976.16 rows=82,046 width=3,901) (actual time=57.349..4,450.673 rows=375,502 loops=1)

  • Hash Cond: ("ctsInsStatuses".ref_ins_statuses_id = "refInsStatuses".id)
2. 652.544 3,795.786 ↓ 4.6 375,502 1

Hash Left Join (cost=3,119.38..7,724.10 rows=82,046 width=3,789) (actual time=57.314..3,795.786 rows=375,502 loops=1)

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

Hash Left Join (cost=3,118.32..7,203.40 rows=82,046 width=3,657) (actual time=57.289..3,143.236 rows=375,502 loops=1)

  • Hash Cond: (ctgts.ref_glbl_ctgts_type_id = "refGlblCtgtsType".id)
4. 648.585 2,504.760 ↓ 4.6 375,502 1

Hash Left Join (cost=3,117.25..6,682.71 rows=82,046 width=3,525) (actual time=57.258..2,504.760 rows=375,502 loops=1)

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

Hash Left Join (cost=2,896.40..6,246.32 rows=82,046 width=3,334) (actual time=55.472..1,854.437 rows=375,502 loops=1)

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

Hash Left Join (cost=2,717.81..5,852.20 rows=82,046 width=3,277) (actual time=53.228..1,244.858 rows=375,502 loops=1)

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

Hash Left Join (cost=1,762.40..3,760.41 rows=31,592 width=2,971) (actual time=26.662..571.842 rows=135,786 loops=1)

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

Hash Left Join (cost=1,473.84..3,388.90 rows=31,592 width=2,942) (actual time=24.988..382.406 rows=135,786 loops=1)

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

Hash Left Join (cost=843.83..1,266.24 rows=2,827 width=2,938) (actual time=18.950..195.185 rows=5,619 loops=1)

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

Hash Left Join (cost=842.74..1,257.59 rows=2,827 width=2,837) (actual time=18.928..187.036 rows=5,619 loops=1)

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

Hash Left Join (cost=841.65..1,241.22 rows=2,827 width=2,736) (actual time=18.908..178.293 rows=5,619 loops=1)

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

Hash Left Join (cost=839.71..1,231.10 rows=2,827 width=2,632) (actual time=18.875..169.657 rows=5,619 loops=1)

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

Hash Left Join (cost=838.37..1,220.25 rows=2,827 width=2,520) (actual time=18.841..161.168 rows=5,619 loops=1)

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

Hash Left Join (cost=810.67..1,185.09 rows=2,827 width=1,971) (actual time=18.312..152.320 rows=5,619 loops=1)

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

Hash Left Join (cost=371.07..738.06 rows=2,827 width=1,598) (actual time=12.923..138.169 rows=5,619 loops=1)

  • Hash Cond: ("ctsIns".user_id = "user".id)
16. 11.552 129.301 ↓ 2.0 5,619 1

Hash Left Join (cost=343.37..702.87 rows=2,827 width=1,049) (actual time=12.372..129.301 rows=5,619 loops=1)

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

Hash Right Join (cost=273.75..527.33 rows=5,655 width=992) (actual time=11.450..24.693 rows=7,094 loops=1)

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

19. 2.275 11.414 ↓ 1.0 2,092 1

Hash (cost=248.02..248.02 rows=2,058 width=877) (actual time=11.414..11.414 rows=2,092 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 1221kB
20. 1.509 9.139 ↓ 1.0 2,092 1

Hash Left Join (cost=165.49..248.02 rows=2,058 width=877) (actual time=2.634..9.139 rows=2,092 loops=1)

  • Hash Cond: ("ctsIns".ref_ins_scan_check_status_id = "ctsInsRefInsScanCheckStatus".id)
21. 1.585 7.623 ↓ 1.0 2,092 1

Hash Left Join (cost=164.40..238.22 rows=2,058 width=776) (actual time=2.605..7.623 rows=2,092 loops=1)

  • Hash Cond: ("ctsIns".branch_id = branch.id)
22. 1.494 5.925 ↓ 1.0 2,092 1

Hash Left Join (cost=157.25..225.50 rows=2,058 width=638) (actual time=2.470..5.925 rows=2,092 loops=1)

  • Hash Cond: ("ctsIns".partner_id = partner.id)
23. 1.729 4.416 ↓ 1.0 2,092 1

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

  • Hash Cond: ("ctsInsVers".cts_ins_id = "ctsIns".id)
24. 0.286 0.286 ↓ 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.008..0.286 rows=2,092 loops=1)

25. 1.100 2.401 ↑ 1.0 2,092 1

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

  • Buckets: 4096 Batches: 1 Memory Usage: 318kB
26. 1.301 1.301 ↑ 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.301 rows=2,092 loops=1)

27. 0.009 0.015 ↑ 1.0 8 1

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

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

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

29. 0.056 0.113 ↑ 1.0 140 1

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

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

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

31. 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
32. 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)

33. 0.442 0.834 ↑ 1.0 2,092 1

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

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

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

35.          

SubPlan (for Hash Left Join)

36. 14.188 92.222 ↑ 1.5 4 7,094

Unique (cost=30.32..30.36 rows=6 width=16) (actual time=0.012..0.013 rows=4 loops=7,094)

37. 28.376 78.034 ↑ 2.0 4 7,094

Sort (cost=30.32..30.34 rows=8 width=16) (actual time=0.011..0.011 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
38. 28.376 49.658 ↑ 1.1 7 7,094

Bitmap Heap Scan on cts_ins_scans_check "ctsInsScanCheck_1" (cost=4.34..30.20 rows=8 width=16) (actual time=0.004..0.007 rows=7 loops=7,094)

  • Recheck Cond: (cts_id = cts.id)
  • Heap Blocks: exact=23210
39. 21.282 21.282 ↑ 1.1 7 7,094

Bitmap Index Scan on "IDX_98447750d13acac627ac3caedd" (cost=0.00..4.34 rows=8 width=0) (actual time=0.003..0.003 rows=7 loops=7,094)

  • Index Cond: (cts_id = cts.id)
40. 0.282 0.529 ↑ 1.0 431 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 146kB
41. 0.247 0.247 ↑ 1.0 431 1

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

42. 2.945 5.350 ↑ 1.0 6,407 1

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

  • Buckets: 8192 Batches: 1 Memory Usage: 2378kB
43. 2.405 2.405 ↑ 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.005..2.405 rows=6,407 loops=1)

44. 0.277 0.509 ↑ 1.0 431 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 146kB
45. 0.232 0.232 ↑ 1.0 431 1

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

46. 0.005 0.013 ↑ 1.0 15 1

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

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

48. 0.009 0.016 ↑ 1.0 42 1

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

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

50. 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
51. 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)

52. 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
53. 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)

54. 3.633 5.895 ↑ 1.0 23,378 1

Hash (cost=337.78..337.78 rows=23,378 width=8) (actual time=5.895..5.895 rows=23,378 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 1170kB
55. 2.262 2.262 ↑ 1.0 23,378 1

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

56. 0.598 1.640 ↓ 1.1 2,400 1

Hash (cost=261.18..261.18 rows=2,191 width=33) (actual time=1.640..1.640 rows=2,400 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 193kB
57. 0.872 1.042 ↓ 1.1 2,400 1

Bitmap Heap Scan on cts_ins_statuses "ctsInsStatuses" (cost=45.27..261.18 rows=2,191 width=33) (actual time=0.191..1.042 rows=2,400 loops=1)

  • Filter: (actuality IS TRUE)
  • Heap Blocks: exact=112
58. 0.170 0.170 ↓ 1.1 2,400 1

Bitmap Index Scan on cts_ins_statuses_actuality_index (cost=0.00..44.72 rows=2,191 width=0) (actual time=0.170..0.170 rows=2,400 loops=1)

  • Index Cond: (actuality = true)
59. 3.671 26.519 ↓ 1.0 5,535 1

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

  • Buckets: 8192 Batches: 1 Memory Usage: 1341kB
60. 3.146 22.848 ↓ 1.0 5,535 1

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

  • Hash Cond: ("ctgtsFlVers_ctgtsFlTypes".ctgts_fl_types_id = "ctgtsFlTypes".id)
61. 3.233 18.206 ↓ 1.0 5,535 1

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

  • Hash Cond: ("ctgtsFlVers".id = "ctgtsFlVers_ctgtsFlTypes".ctgts_fl_vers_id)
62. 3.417 13.584 ↓ 1.0 5,535 1

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

  • Hash Cond: ("ctsInsSide".ctgts_fl_vers_id = "ctgtsFlVers".id)
63. 2.082 6.557 ↓ 1.0 5,535 1

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

  • Hash Cond: ("ctsInsSide".ref_cts_ins_sides_type_id = "refCtsInsSidesType".id)
64. 2.509 4.467 ↓ 1.0 5,535 1

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

  • Hash Cond: ("ctsIns_ctsInsSide".cts_ins_sides_id = "ctsInsSide".id)
65. 0.585 0.585 ↓ 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.585 rows=5,535 loops=1)

66. 0.852 1.373 ↓ 1.0 5,535 1

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

  • Buckets: 8192 Batches: 1 Memory Usage: 340kB
67. 0.521 0.521 ↓ 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.521 rows=5,535 loops=1)

68. 0.004 0.008 ↑ 1.0 8 1

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

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

70. 1.580 3.610 ↑ 1.0 5,536 1

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

  • Buckets: 8192 Batches: 1 Memory Usage: 726kB
71. 2.030 2.030 ↑ 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.005..2.030 rows=5,536 loops=1)

72. 0.850 1.389 ↓ 1.0 5,535 1

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

  • Buckets: 8192 Batches: 1 Memory Usage: 281kB
73. 0.539 0.539 ↓ 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.007..0.539 rows=5,535 loops=1)

74. 0.972 1.496 ↑ 1.0 5,535 1

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

  • Buckets: 8192 Batches: 1 Memory Usage: 329kB
75. 0.524 0.524 ↑ 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.524 rows=5,535 loops=1)

76. 1.124 2.188 ↑ 1.0 5,536 1

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

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

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

78. 1.131 1.738 ↑ 1.0 5,535 1

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

  • Buckets: 8192 Batches: 1 Memory Usage: 819kB
79. 0.607 0.607 ↑ 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.607 rows=5,535 loops=1)

80. 0.003 0.012 ↑ 1.0 3 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
81. 0.009 0.009 ↑ 1.0 3 1

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

82. 0.004 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.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)

84. 0.009 0.018 ↑ 1.0 26 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
85. 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.489 ms
Execution time : 4,470.734 ms