explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5lv3S

Settings
# exclusive inclusive rows x rows loops node
1. 590.584 3,390.043 ↓ 4.6 375,502 1

Hash Left Join (cost=3,550.06..8,150.38 rows=81,926 width=3,789) (actual time=66.192..3,390.043 rows=375,502 loops=1)

  • Hash Cond: ("ctgtsFlTypes".ref_ctgts_fl_types_id = "refCtgtsFlTypes".id)
2. 579.322 2,799.453 ↓ 4.6 375,502 1

Hash Left Join (cost=3,548.99..7,630.45 rows=81,926 width=3,657) (actual time=66.166..2,799.453 rows=375,502 loops=1)

  • Hash Cond: (ctgts.ref_glbl_ctgts_type_id = "refGlblCtgtsType".id)
3. 571.173 2,220.125 ↓ 4.6 375,502 1

Hash Left Join (cost=3,547.92..7,110.51 rows=81,926 width=3,525) (actual time=66.143..2,220.125 rows=375,502 loops=1)

  • Hash Cond: ("ctgtsFlVers".ctgts_fl_data_name_id = "ctgtsFlDataName".id)
4. 531.722 1,647.183 ↓ 4.6 375,502 1

Hash Left Join (cost=3,327.07..6,674.43 rows=81,926 width=3,334) (actual time=64.329..1,647.183 rows=375,502 loops=1)

  • Hash Cond: ("ctgtsFlVers".ctgts_id = ctgts.id)
5. 568.146 1,113.114 ↓ 4.6 375,502 1

Hash Left Join (cost=3,148.49..6,280.63 rows=81,926 width=3,277) (actual time=61.931..1,113.114 rows=375,502 loops=1)

  • Hash Cond: ("ctsIns".id = "ctsIns_ctsInsSide".cts_ins_id)
6. 184.497 518.785 ↓ 4.3 135,786 1

Hash Left Join (cost=2,193.08..4,190.50 rows=31,546 width=2,971) (actual time=35.696..518.785 rows=135,786 loops=1)

  • Hash Cond: ("ctsIns_ctsInsStatuses".cts_ins_statuses_id = "ctsInsStatuses".id)
7. 159.126 324.053 ↓ 4.3 135,786 1

Hash Left Join (cost=1,473.07..3,387.67 rows=31,546 width=2,942) (actual time=25.324..324.053 rows=135,786 loops=1)

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

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

  • Hash Cond: ("ctsInsScanCheck".ref_ins_scan_check_error_id = "refInsScanCheckError".id)
9. 7.178 152.020 ↓ 2.0 5,619 1

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

  • Hash Cond: ("ctsInsScanCheck".ref_ins_scan_check_status_id = "refInsScanCheckStatus".id)
10. 7.094 144.835 ↓ 2.0 5,619 1

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

  • Hash Cond: ("ctsInsScanCheck".ref_cts_ins_doc_type_id = "refCtsInsDocType".id)
11. 6.928 137.720 ↓ 2.0 5,619 1

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

  • Hash Cond: ("ctsInsScanCheck".ref_cts_ins_scan_type_id = "refCtsInsScanType".id)
12. 6.882 130.775 ↓ 2.0 5,619 1

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

  • Hash Cond: ("ctsInsScanCheck".last_check_user_id = "lastCheckUser".id)
13. 7.382 123.405 ↓ 2.0 5,619 1

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

  • Hash Cond: ("ctsInsScanCheck".cts_ins_scan_id = "ctsInsScan".id)
14. 6.743 110.253 ↓ 2.0 5,619 1

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

  • Hash Cond: ("ctsIns".user_id = "user".id)
15. 9.603 103.024 ↓ 2.0 5,619 1

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

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

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

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

18. 2.277 11.284 ↓ 1.0 2,092 1

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

  • Buckets: 4096 Batches: 1 Memory Usage: 1221kB
19. 1.531 9.007 ↓ 1.0 2,092 1

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

  • Hash Cond: ("ctsIns".ref_ins_scan_check_status_id = "ctsInsRefInsScanCheckStatus".id)
20. 1.560 7.470 ↓ 1.0 2,092 1

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

  • Hash Cond: ("ctsIns".branch_id = branch.id)
21. 1.473 5.818 ↓ 1.0 2,092 1

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

  • Hash Cond: ("ctsIns".partner_id = partner.id)
22. 1.699 4.323 ↓ 1.0 2,092 1

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

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

24. 1.059 2.342 ↑ 1.0 2,092 1

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

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

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

26. 0.009 0.022 ↑ 1.0 8 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
27. 0.013 0.013 ↑ 1.0 8 1

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

28. 0.053 0.092 ↑ 1.0 140 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 33kB
29. 0.039 0.039 ↑ 1.0 140 1

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

30. 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
31. 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.003..0.003 rows=4 loops=1)

32. 0.427 0.824 ↑ 1.0 2,092 1

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

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

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

34.          

SubPlan (for Hash Left Join)

35. 7.094 70.940 ↑ 1.5 4 7,094

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

36. 28.376 63.846 ↑ 2.0 4 7,094

Sort (cost=30.32..30.34 rows=8 width=16) (actual time=0.008..0.009 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
37. 21.282 35.470 ↑ 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.003..0.005 rows=7 loops=7,094)

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

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

  • Index Cond: (cts_id = cts.id)
39. 0.259 0.486 ↑ 1.0 431 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 146kB
40. 0.227 0.227 ↑ 1.0 431 1

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

41. 3.198 5.770 ↑ 1.0 6,407 1

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

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

43. 0.256 0.488 ↑ 1.0 431 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 146kB
44. 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.014..0.232 rows=431 loops=1)

45. 0.010 0.017 ↑ 1.0 15 1

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

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

47. 0.014 0.021 ↑ 1.0 42 1

Hash (cost=1.42..1.42 rows=42 width=104) (actual time=0.021..0.021 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.003..0.007 rows=42 loops=1)

49. 0.004 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.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.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
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. 3.719 6.012 ↓ 1.0 23,378 1

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

  • Buckets: 32768 Batches: 1 Memory Usage: 1170kB
54. 2.293 2.293 ↓ 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.006..2.293 rows=23,378 loops=1)

55. 5.088 10.235 ↑ 1.0 23,378 1

Hash (cost=427.78..427.78 rows=23,378 width=33) (actual time=10.235..10.235 rows=23,378 loops=1)

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

Seq Scan on cts_ins_statuses "ctsInsStatuses" (cost=0.00..427.78 rows=23,378 width=33) (actual time=0.007..5.147 rows=23,378 loops=1)

57. 3.530 26.183 ↓ 1.0 5,535 1

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

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

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

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

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

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

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

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

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

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

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

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

64. 0.878 1.407 ↓ 1.0 5,535 1

Hash (cost=88.33..88.33 rows=5,433 width=24) (actual time=1.407..1.407 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.007..0.529 rows=5,535 loops=1)

66. 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
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.605 3.633 ↑ 1.0 5,536 1

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

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

70. 0.871 1.388 ↓ 1.0 5,535 1

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

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

72. 0.876 1.429 ↑ 1.0 5,535 1

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

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

74. 1.217 2.347 ↑ 1.0 5,536 1

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

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

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

76. 1.148 1.769 ↑ 1.0 5,535 1

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

  • Buckets: 8192 Batches: 1 Memory Usage: 819kB
77. 0.621 0.621 ↑ 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.005..0.621 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.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
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)

Planning time : 8.806 ms
Execution time : 3,406.148 ms