explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Lqjc

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

Hash Left Join (cost=3,796.47..9,119.08 rows=82,046 width=4,101) (actual time=62.422..7,565.938 rows=375,502 loops=1)

  • Hash Cond: ("ctsInsStatuses".ref_ins_statuses_id = "refInsStatuses".id)
2. 736.412 6,877.142 ↓ 4.6 375,502 1

Hash Left Join (cost=3,794.89..8,867.01 rows=82,046 width=3,989) (actual time=62.380..6,877.142 rows=375,502 loops=1)

  • Hash Cond: ("ctgtsFlVers".ctgts_fl_data_name_id = "ctgtsFlDataName".id)
3. 766.952 6,138.946 ↓ 4.6 375,502 1

Hash Left Join (cost=3,574.04..8,430.62 rows=82,046 width=3,798) (actual time=60.548..6,138.946 rows=375,502 loops=1)

  • Hash Cond: ("ctsInsSide".ctgts_fl_vers_id = "ctgtsFlVers".id)
4. 592.465 5,344.854 ↓ 4.6 375,502 1

Hash Left Join (cost=2,765.99..6,494.44 rows=82,046 width=3,295) (actual time=33.366..5,344.854 rows=375,502 loops=1)

  • Hash Cond: ("ctsIns".id = "ctsIns_ctsInsSide".cts_ins_id)
5. 207.884 4,744.443 ↓ 4.3 135,786 1

Hash Left Join (cost=2,425.24..5,017.31 rows=31,592 width=3,171) (actual time=25.371..4,744.443 rows=135,786 loops=1)

  • Hash Cond: ("ctsIns_ctsInsStatuses".cts_ins_statuses_id = "ctsInsStatuses".id)
6. 200.579 4,527.896 ↓ 4.3 135,786 1

Hash Left Join (cost=1,453.53..3,897.52 rows=31,592 width=3,142) (actual time=16.677..4,527.896 rows=135,786 loops=1)

  • Hash Cond: ("ctsIns".id = "ctsIns_ctsInsStatuses".cts_ins_id)
7. 9.772 4,321.729 ↓ 2.0 5,619 1

Hash Left Join (cost=823.52..1,774.85 rows=2,827 width=3,138) (actual time=11.067..4,321.729 rows=5,619 loops=1)

  • Hash Cond: ("refCtsInsScanType".ref_cts_ins_scan_use_type_id = "refCtsInsScanUseType".id)
8. 9.261 4,311.954 ↓ 2.0 5,619 1

Hash Left Join (cost=822.48..1,764.30 rows=2,827 width=3,038) (actual time=11.058..4,311.954 rows=5,619 loops=1)

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

Hash Left Join (cost=821.30..1,753.60 rows=2,827 width=2,938) (actual time=11.047..4,302.689 rows=5,619 loops=1)

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

Hash Left Join (cost=820.21..1,744.96 rows=2,827 width=2,837) (actual time=11.033..4,294.050 rows=5,619 loops=1)

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

Hash Left Join (cost=819.12..1,728.58 rows=2,827 width=2,736) (actual time=11.017..4,284.177 rows=5,619 loops=1)

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

Hash Left Join (cost=817.17..1,718.47 rows=2,827 width=2,632) (actual time=10.998..4,274.304 rows=5,619 loops=1)

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

Hash Left Join (cost=815.83..1,707.62 rows=2,827 width=2,520) (actual time=10.977..4,265.242 rows=5,619 loops=1)

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

Hash Left Join (cost=788.14..1,672.46 rows=2,827 width=1,971) (actual time=10.573..4,255.737 rows=5,619 loops=1)

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

Hash Left Join (cost=348.53..1,225.43 rows=2,827 width=1,598) (actual time=6.215..4,241.854 rows=5,619 loops=1)

  • Hash Cond: ("ctsIns".ref_ins_scan_check_status_id = "ctsInsRefInsScanCheckStatus".id)
16. 8.987 4,234.648 ↓ 2.0 5,619 1

Hash Left Join (cost=347.44..1,212.39 rows=2,827 width=1,497) (actual time=6.206..4,234.648 rows=5,619 loops=1)

  • Hash Cond: ("ctsIns".user_id = "user".id)
17. 6.675 4,225.246 ↓ 2.0 5,619 1

Hash Left Join (cost=319.74..1,177.19 rows=2,827 width=948) (actual time=5.785..4,225.246 rows=5,619 loops=1)

  • Hash Cond: ("ctsIns".branch_id = branch.id)
18. 6.720 4,218.499 ↓ 2.0 5,619 1

Hash Left Join (cost=312.59..1,162.40 rows=2,827 width=810) (actual time=5.709..4,218.499 rows=5,619 loops=1)

  • Hash Cond: ("ctsIns".partner_id = partner.id)
19. 17.000 4,211.773 ↓ 2.0 5,619 1

Hash Left Join (cost=311.41..1,149.87 rows=2,827 width=415) (actual time=5.698..4,211.773 rows=5,619 loops=1)

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

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

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

22. 0.885 4.263 ↓ 1.0 2,092 1

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

  • Buckets: 4,096 Batches: 1 Memory Usage: 510kB
23. 1.608 3.378 ↓ 1.0 2,092 1

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

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

25. 0.591 1.517 ↑ 1.0 2,092 1

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

  • Buckets: 4,096 Batches: 1 Memory Usage: 318kB
26. 0.926 0.926 ↑ 1.0 2,092 1

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

27. 0.358 0.738 ↑ 1.0 2,092 1

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

  • Buckets: 4,096 Batches: 1 Memory Usage: 202kB
28. 0.380 0.380 ↑ 1.0 2,092 1

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

29.          

SubPlan (for Hash Left Join)

30. 7.094 4,178.366 ↑ 1.5 4 7,094

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

31. 35.470 4,171.272 ↑ 2.0 4 7,094

Sort (cost=189.97..189.99 rows=8 width=16) (actual time=0.587..0.588 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. 4,135.802 4,135.802 ↑ 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.275..0.583 rows=7 loops=7,094)

  • Filter: (cts_id = cts.id)
  • Rows Removed by Filter: 5,741
33. 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: 1,024 Batches: 1 Memory Usage: 10kB
34. 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)

35. 0.034 0.072 ↑ 1.0 140 1

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 33kB
36. 0.038 0.038 ↑ 1.0 140 1

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

37. 0.192 0.415 ↑ 1.0 431 1

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 146kB
38. 0.223 0.223 ↑ 1.0 431 1

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

39. 0.001 0.004 ↑ 1.0 4 1

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
40. 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)

41. 1.989 4.349 ↑ 1.0 6,407 1

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

  • Buckets: 8,192 Batches: 1 Memory Usage: 2,378kB
42. 2.360 2.360 ↑ 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.360 rows=6,407 loops=1)

43. 0.187 0.398 ↑ 1.0 431 1

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 146kB
44. 0.211 0.211 ↑ 1.0 431 1

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

45. 0.005 0.012 ↑ 1.0 15 1

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

  • Buckets: 1,024 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.007 0.014 ↑ 1.0 42 1

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

  • Buckets: 1,024 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.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: 1,024 Batches: 1 Memory Usage: 9kB
50. 0.007 0.007 ↑ 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.007..0.007 rows=4 loops=1)

51. 0.001 0.004 ↑ 1.0 4 1

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

  • Buckets: 1,024 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.003..0.003 rows=4 loops=1)

53. 0.001 0.004 ↑ 1.0 8 1

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

  • Buckets: 1,024 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. 0.001 0.003 ↑ 1.0 2 1

Hash (cost=1.02..1.02 rows=2 width=100) (actual time=0.003..0.003 rows=2 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
56. 0.002 0.002 ↑ 1.0 2 1

Seq Scan on ref_cts_ins_scan_use_types "refCtsInsScanUseType" (cost=0.00..1.02 rows=2 width=100) (actual time=0.002..0.002 rows=2 loops=1)

57. 3.425 5.588 ↑ 1.0 23,378 1

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

  • Buckets: 32,768 Batches: 1 Memory Usage: 1,170kB
58. 2.163 2.163 ↑ 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.005..2.163 rows=23,378 loops=1)

59. 0.622 8.663 ↓ 1.1 2,400 1

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

  • Buckets: 4,096 Batches: 1 Memory Usage: 193kB
60. 3.470 8.041 ↓ 1.1 2,400 1

Hash Join (cost=455.17..944.33 rows=2,191 width=33) (actual time=2.462..8.041 rows=2,400 loops=1)

  • Hash Cond: ("ctsInsStatuses".id = cis.id)
61. 2.142 2.142 ↑ 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.005..2.142 rows=23,378 loops=1)

62. 0.404 2.429 ↓ 1.1 2,400 1

Hash (cost=427.78..427.78 rows=2,191 width=4) (actual time=2.429..2.429 rows=2,400 loops=1)

  • Buckets: 4,096 Batches: 1 Memory Usage: 117kB
63. 2.025 2.025 ↓ 1.1 2,400 1

Seq Scan on cts_ins_statuses cis (cost=0.00..427.78 rows=2,191 width=4) (actual time=0.004..2.025 rows=2,400 loops=1)

  • Filter: actuality
  • Rows Removed by Filter: 20,978
64. 1.922 7.946 ↓ 1.0 5,535 1

Hash (cost=272.84..272.84 rows=5,433 width=128) (actual time=7.945..7.946 rows=5,535 loops=1)

  • Buckets: 8,192 Batches: 1 Memory Usage: 799kB
65. 1.965 6.024 ↓ 1.0 5,535 1

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

  • Hash Cond: ("ctsInsSide".ref_cts_ins_sides_type_id = "refCtsInsSidesType".id)
66. 2.022 4.045 ↓ 1.0 5,535 1

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

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

68. 0.921 1.494 ↓ 1.0 5,535 1

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

  • Buckets: 8,192 Batches: 1 Memory Usage: 340kB
69. 0.573 0.573 ↓ 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.004..0.573 rows=5,535 loops=1)

70. 0.010 0.014 ↑ 1.0 8 1

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
71. 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)

72. 3.925 27.140 ↑ 1.0 5,536 1

Hash (cost=738.42..738.42 rows=5,570 width=503) (actual time=27.140..27.140 rows=5,536 loops=1)

  • Buckets: 8,192 Batches: 1 Memory Usage: 1,560kB
73. 3.219 23.215 ↑ 1.0 5,536 1

Hash Left Join (cost=546.22..738.42 rows=5,570 width=503) (actual time=8.675..23.215 rows=5,536 loops=1)

  • Hash Cond: (ctgts.ref_glbl_ctgts_type_id = "refGlblCtgtsType".id)
74. 3.182 19.988 ↑ 1.0 5,536 1

Hash Left Join (cost=545.15..702.07 rows=5,570 width=371) (actual time=8.654..19.988 rows=5,536 loops=1)

  • Hash Cond: ("ctgtsFlVers".ctgts_id = ctgts.id)
75. 3.538 14.668 ↑ 1.0 5,536 1

Hash Right Join (cost=366.57..508.86 rows=5,570 width=314) (actual time=6.476..14.668 rows=5,536 loops=1)

  • Hash Cond: ("ctgtsFlVers_ctgtsFlTypes".ctgts_fl_vers_id = "ctgtsFlVers".id)
76. 1.954 6.215 ↓ 1.0 5,535 1

Hash Left Join (cost=159.25..287.26 rows=5,433 width=184) (actual time=1.526..6.215 rows=5,535 loops=1)

  • Hash Cond: ("ctgtsFlTypes".ref_ctgts_fl_types_id = "refCtgtsFlTypes".id)
77. 2.186 4.253 ↓ 1.0 5,535 1

Hash Left Join (cost=158.18..251.78 rows=5,433 width=52) (actual time=1.502..4.253 rows=5,535 loops=1)

  • Hash Cond: ("ctgtsFlVers_ctgtsFlTypes".ctgts_fl_types_id = "ctgtsFlTypes".id)
78. 0.611 0.611 ↓ 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.008..0.611 rows=5,535 loops=1)

79. 0.901 1.456 ↑ 1.0 5,535 1

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

  • Buckets: 8,192 Batches: 1 Memory Usage: 329kB
80. 0.555 0.555 ↑ 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.555 rows=5,535 loops=1)

81. 0.005 0.008 ↑ 1.0 3 1

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
82. 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.003..0.003 rows=3 loops=1)

83. 2.248 4.915 ↑ 1.0 5,536 1

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

  • Buckets: 8,192 Batches: 1 Memory Usage: 726kB
84. 2.667 2.667 ↑ 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.667 rows=5,536 loops=1)

85. 1.102 2.138 ↑ 1.0 5,536 1

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

  • Buckets: 8,192 Batches: 1 Memory Usage: 510kB
86. 1.036 1.036 ↑ 1.0 5,536 1

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

87. 0.004 0.008 ↑ 1.0 3 1

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
88. 0.004 0.004 ↑ 1.0 3 1

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

89. 1.158 1.784 ↑ 1.0 5,535 1

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

  • Buckets: 8,192 Batches: 1 Memory Usage: 819kB
90. 0.626 0.626 ↑ 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.006..0.626 rows=5,535 loops=1)

91. 0.011 0.021 ↑ 1.0 26 1

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 11kB
92. 0.010 0.010 ↑ 1.0 26 1

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

Planning time : 10.075 ms
Execution time : 7,584.840 ms