explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jbBJ

Settings
# exclusive inclusive rows x rows loops node
1. 30.110 441.289 ↓ 2.0 15,389 1

Hash Left Join (cost=3,597.85..4,528.63 rows=7,690 width=4,101) (actual time=57.025..441.289 rows=15,389 loops=1)

  • Hash Cond: ("ctsInsStatuses".ref_ins_statuses_id = "refInsStatuses".id)
2. 28.835 411.163 ↓ 2.0 15,389 1

Hash Left Join (cost=3,596.27..4,503.57 rows=7,690 width=3,989) (actual time=56.992..411.163 rows=15,389 loops=1)

  • Hash Cond: (ctgts.ref_glbl_ctgts_type_id = "refGlblCtgtsType".id)
3. 31.149 382.319 ↓ 2.0 15,389 1

Hash Left Join (cost=3,595.20..4,453.80 rows=7,690 width=3,857) (actual time=56.966..382.319 rows=15,389 loops=1)

  • Hash Cond: ("ctgtsFlVers".id = "ctgtsFlVers_ctgtsFlTypes".ctgts_fl_vers_id)
4. 29.015 343.533 ↓ 2.0 15,389 1

Hash Left Join (cost=3,240.03..3,994.78 rows=7,690 width=3,677) (actual time=49.289..343.533 rows=15,389 loops=1)

  • Hash Cond: ("ctgtsFlVers".ctgts_fl_data_name_id = "ctgtsFlDataName".id)
5. 27.290 312.814 ↓ 2.0 15,389 1

Hash Left Join (cost=3,019.18..3,753.73 rows=7,690 width=3,486) (actual time=47.545..312.814 rows=15,389 loops=1)

  • Hash Cond: ("ctgtsFlVers".ctgts_id = ctgts.id)
6. 27.832 283.383 ↓ 2.0 15,389 1

Hash Left Join (cost=2,840.59..3,554.95 rows=7,690 width=3,429) (actual time=45.360..283.383 rows=15,389 loops=1)

  • Hash Cond: ("ctsInsSide".ctgts_fl_vers_id = "ctgtsFlVers".id)
7. 24.815 252.079 ↓ 2.0 15,389 1

Hash Left Join (cost=2,633.27..3,327.43 rows=7,690 width=3,295) (actual time=41.847..252.079 rows=15,389 loops=1)

  • Hash Cond: ("ctsIns".id = "ctsIns_ctsInsSide".cts_ins_id)
8. 9.657 219.587 ↓ 1.9 5,633 1

Hash Left Join (cost=2,292.52..2,880.17 rows=2,961 width=3,171) (actual time=34.126..219.587 rows=5,633 loops=1)

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

Hash Left Join (cost=846.06..1,287.49 rows=2,827 width=3,138) (actual time=19.854..195.681 rows=5,619 loops=1)

  • Hash Cond: ("refCtsInsScanType".ref_cts_ins_scan_use_type_id = "refCtsInsScanUseType".id)
10. 7.829 187.184 ↓ 2.0 5,619 1

Hash Left Join (cost=845.01..1,276.93 rows=2,827 width=3,038) (actual time=19.833..187.184 rows=5,619 loops=1)

  • Hash Cond: ("refCtsInsScanType".ref_cts_ins_sides_type_id = "scanTypeRefCtsInsSidesType".id)
11. 7.723 179.344 ↓ 2.0 5,619 1

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

  • Hash Cond: ("ctsInsScanCheck".ref_ins_scan_check_error_id = "refInsScanCheckError".id)
12. 8.172 171.613 ↓ 2.0 5,619 1

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

  • Hash Cond: ("ctsInsScanCheck".ref_ins_scan_check_status_id = "refInsScanCheckStatus".id)
13. 8.044 163.436 ↓ 2.0 5,619 1

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

  • Hash Cond: ("ctsInsScanCheck".ref_cts_ins_doc_type_id = "refCtsInsDocType".id)
14. 7.791 155.373 ↓ 2.0 5,619 1

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

  • Hash Cond: ("ctsInsScanCheck".ref_cts_ins_scan_type_id = "refCtsInsScanType".id)
15. 7.704 147.567 ↓ 2.0 5,619 1

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

  • Hash Cond: ("ctsInsScanCheck".last_check_user_id = "lastCheckUser".id)
16. 8.169 139.398 ↓ 2.0 5,619 1

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

  • Hash Cond: ("ctsInsScanCheck".cts_ins_scan_id = "ctsInsScan".id)
17. 7.617 125.885 ↓ 2.0 5,619 1

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

  • Hash Cond: ("ctsIns".user_id = "user".id)
18. 14.976 117.770 ↓ 2.0 5,619 1

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

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

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

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

21. 2.787 12.322 ↓ 1.0 2,092 1

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

  • Buckets: 4,096 Batches: 1 Memory Usage: 1,221kB
22. 1.737 9.535 ↓ 1.0 2,092 1

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

  • Hash Cond: ("ctsIns".ref_ins_scan_check_status_id = "ctsInsRefInsScanCheckStatus".id)
23. 1.792 7.792 ↓ 1.0 2,092 1

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

  • Hash Cond: ("ctsIns".branch_id = branch.id)
24. 1.709 5.914 ↓ 1.0 2,092 1

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

  • Hash Cond: ("ctsIns".partner_id = partner.id)
25. 2.142 4.195 ↓ 1.0 2,092 1

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

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

27. 0.744 1.718 ↑ 1.0 2,092 1

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

  • Buckets: 4,096 Batches: 1 Memory Usage: 318kB
28. 0.974 0.974 ↑ 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.974 rows=2,092 loops=1)

29. 0.005 0.010 ↑ 1.0 8 1

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

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

31. 0.047 0.086 ↑ 1.0 140 1

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

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

33. 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: 1,024 Batches: 1 Memory Usage: 9kB
34. 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)

35. 0.453 0.871 ↑ 1.0 2,092 1

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

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

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

37.          

SubPlan (for Hash Left Join)

38. 7.094 78.034 ↑ 1.5 4 7,094

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

39. 28.376 70.940 ↑ 2.0 4 7,094

Sort (cost=30.32..30.34 rows=8 width=16) (actual time=0.010..0.010 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
40. 28.376 42.564 ↑ 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.006 rows=7 loops=7,094)

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

Bitmap Index Scan on cts_ins_scans_check_cts_id_index (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)
42. 0.260 0.498 ↑ 1.0 431 1

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 146kB
43. 0.238 0.238 ↑ 1.0 431 1

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

44. 2.929 5.344 ↑ 1.0 6,407 1

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

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

46. 0.244 0.465 ↑ 1.0 431 1

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 146kB
47. 0.221 0.221 ↑ 1.0 431 1

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

48. 0.007 0.015 ↑ 1.0 15 1

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

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

50. 0.012 0.019 ↑ 1.0 42 1

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

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

52. 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: 1,024 Batches: 1 Memory Usage: 9kB
53. 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)

54. 0.005 0.008 ↑ 1.0 4 1

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

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

56. 0.003 0.011 ↑ 1.0 8 1

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

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

58. 0.003 0.005 ↑ 1.0 2 1

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

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

60. 0.632 14.249 ↓ 1.1 2,400 1

Hash (cost=1,419.07..1,419.07 rows=2,191 width=37) (actual time=14.249..14.249 rows=2,400 loops=1)

  • Buckets: 4,096 Batches: 1 Memory Usage: 207kB
61. 3.570 13.617 ↓ 1.1 2,400 1

Hash Right Join (cost=881.71..1,419.07 rows=2,191 width=37) (actual time=7.973..13.617 rows=2,400 loops=1)

  • Hash Cond: ("ctsInsStatuses".id = "ctsIns_ctsInsStatuses".cts_ins_statuses_id)
62. 2.100 2.100 ↑ 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.006..2.100 rows=23,378 loops=1)

63. 0.419 7.947 ↓ 1.1 2,400 1

Hash (cost=854.33..854.33 rows=2,191 width=8) (actual time=7.947..7.947 rows=2,400 loops=1)

  • Buckets: 4,096 Batches: 1 Memory Usage: 126kB
64. 3.239 7.528 ↓ 1.1 2,400 1

Hash Join (cost=455.17..854.33 rows=2,191 width=8) (actual time=2.417..7.528 rows=2,400 loops=1)

  • Hash Cond: ("ctsIns_ctsInsStatuses".cts_ins_statuses_id = cis.id)
65. 1.901 1.901 ↑ 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.007..1.901 rows=23,378 loops=1)

66. 0.404 2.388 ↓ 1.1 2,400 1

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

  • Buckets: 4,096 Batches: 1 Memory Usage: 117kB
67. 1.984 1.984 ↓ 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.006..1.984 rows=2,400 loops=1)

  • Filter: actuality
  • Rows Removed by Filter: 20,978
68. 1.824 7.677 ↓ 1.0 5,535 1

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

  • Buckets: 8,192 Batches: 1 Memory Usage: 799kB
69. 1.962 5.853 ↓ 1.0 5,535 1

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

  • Hash Cond: ("ctsInsSide".ref_cts_ins_sides_type_id = "refCtsInsSidesType".id)
70. 1.967 3.884 ↓ 1.0 5,535 1

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

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

72. 0.863 1.389 ↓ 1.0 5,535 1

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

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

74. 0.003 0.007 ↑ 1.0 8 1

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

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

76. 1.533 3.472 ↑ 1.0 5,536 1

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

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

78. 1.109 2.141 ↑ 1.0 5,536 1

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

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

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

80. 1.107 1.704 ↑ 1.0 5,535 1

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

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

82. 1.866 7.637 ↓ 1.0 5,535 1

Hash (cost=287.26..287.26 rows=5,433 width=184) (actual time=7.637..7.637 rows=5,535 loops=1)

  • Buckets: 8,192 Batches: 1 Memory Usage: 675kB
83. 1.960 5.771 ↓ 1.0 5,535 1

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

  • Hash Cond: ("ctgtsFlTypes".ref_ctgts_fl_types_id = "refCtgtsFlTypes".id)
84. 1.885 3.806 ↓ 1.0 5,535 1

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

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

86. 0.855 1.395 ↑ 1.0 5,535 1

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

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

88. 0.002 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: 1,024 Batches: 1 Memory Usage: 9kB
89. 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)

90. 0.005 0.009 ↑ 1.0 3 1

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

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

92. 0.008 0.016 ↑ 1.0 26 1

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 11kB
93. 0.008 0.008 ↑ 1.0 26 1

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

Planning time : 10.073 ms
Execution time : 443.160 ms