explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Lr95

Settings
# exclusive inclusive rows x rows loops node
1. 168.694 3,813.419 ↓ 1.0 21,475 1

Nested Loop Left Join (cost=5,661.42..538,434.10 rows=21,430 width=2,354) (actual time=277.446..3,813.419 rows=21,475 loops=1)

  • Buffers: shared hit=529414
2. 129.477 3,344.075 ↓ 1.0 21,475 1

Nested Loop Left Join (cost=5,661.42..479,501.60 rows=21,430 width=1,805) (actual time=277.370..3,344.075 rows=21,475 loops=1)

  • Join Filter: (fil.id = sf.filial_id)
  • Rows Removed by Join Filter: 90956
  • Buffers: shared hit=507882
3. 62.847 3,128.698 ↓ 1.0 21,475 1

Hash Left Join (cost=5,660.84..477,814.41 rows=21,430 width=1,706) (actual time=277.101..3,128.698 rows=21,475 loops=1)

  • Hash Cond: (shm.id = sf.ship_main_id)
  • Buffers: shared hit=507833
4. 86.765 3,054.194 ↓ 1.0 21,475 1

Nested Loop Left Join (cost=5,441.82..477,329.45 rows=21,430 width=1,706) (actual time=265.310..3,054.194 rows=21,475 loops=1)

  • Buffers: shared hit=507788
5. 49.533 1,227.954 ↓ 1.0 21,475 1

Hash Left Join (cost=5,420.10..11,387.67 rows=21,430 width=1,706) (actual time=265.099..1,227.954 rows=21,475 loops=1)

  • Hash Cond: (sr.csms_branch_id = csms.id)
  • Buffers: shared hit=3492
6. 44.965 1,078.901 ↓ 1.0 21,475 1

Hash Left Join (cost=3,394.02..9,119.11 rows=21,430 width=1,623) (actual time=165.174..1,078.901 rows=21,475 loops=1)

  • Hash Cond: (sh.ship_change_reason_id = cr.id)
  • Buffers: shared hit=2410
7. 52.799 1,033.854 ↓ 1.0 21,475 1

Hash Join (cost=3,391.72..9,036.34 rows=21,430 width=1,595) (actual time=165.072..1,033.854 rows=21,475 loops=1)

  • Hash Cond: (shm.ship_status_id = sst.ship_status_id)
  • Buffers: shared hit=2408
8. 53.692 980.972 ↓ 1.0 25,724 1

Hash Left Join (cost=3,389.30..8,691.03 rows=25,716 width=1,565) (actual time=164.968..980.972 rows=25,724 loops=1)

  • Hash Cond: (ssp.id = sspt.ship_purpose_id)
  • Buffers: shared hit=2406
9. 53.873 927.235 ↓ 1.0 25,724 1

Hash Left Join (cost=3,388.04..8,304.03 rows=25,716 width=1,539) (actual time=164.895..927.235 rows=25,724 loops=1)

  • Hash Cond: (sh.ship_registration_type_id = srt.id)
  • Buffers: shared hit=2405
10. 51.906 873.262 ↓ 1.0 25,724 1

Hash Left Join (cost=3,385.74..8,204.94 rows=25,716 width=1,486) (actual time=164.770..873.262 rows=25,724 loops=1)

  • Hash Cond: (sra.srvreq_answer_type_id = at.id)
  • Buffers: shared hit=2403
11. 66.115 821.245 ↓ 1.0 25,724 1

Hash Left Join (cost=3,383.63..7,977.81 rows=25,716 width=1,494) (actual time=164.610..821.245 rows=25,724 loops=1)

  • Hash Cond: (sr.id = sra.service_request_id)
  • Buffers: shared hit=2401
12. 73.924 694.054 ↓ 1.0 25,724 1

Hash Left Join (cost=2,470.26..6,717.53 rows=25,716 width=1,486) (actual time=103.302..694.054 rows=25,724 loops=1)

  • Hash Cond: (sh.id = sr.id)
  • Buffers: shared hit=2110
13. 52.373 572.214 ↓ 1.0 25,724 1

Hash Left Join (cost=1,216.26..5,109.94 rows=25,716 width=1,462) (actual time=55.236..572.214 rows=25,724 loops=1)

  • Hash Cond: (sh.ship_purpose_id = ssp.id)
  • Buffers: shared hit=1495
14. 52.156 519.805 ↓ 1.0 25,724 1

Hash Left Join (cost=1,215.10..4,755.22 rows=25,716 width=1,443) (actual time=55.182..519.805 rows=25,724 loops=1)

  • Hash Cond: (sh.ship_type_id = sht.id)
  • Buffers: shared hit=1494
15. 51.176 466.793 ↓ 1.0 25,724 1

Hash Left Join (cost=1,194.01..4,381.81 rows=25,716 width=1,401) (actual time=54.308..466.793 rows=25,724 loops=1)

  • Hash Cond: (prt.id = prtt.person_resident_type_id)
  • Buffers: shared hit=1484
16. 46.549 415.159 ↓ 1.0 25,724 1

Hash Left Join (cost=1,176.48..3,978.54 rows=25,716 width=1,342) (actual time=53.825..415.159 rows=25,724 loops=1)

  • Hash Cond: (sh.root_resident_type_id = rprt.id)
  • Buffers: shared hit=1476
17. 50.338 367.337 ↓ 1.0 25,724 1

Hash Left Join (cost=1,146.75..3,852.37 rows=25,716 width=1,300) (actual time=52.533..367.337 rows=25,724 loops=1)

  • Hash Cond: (sh.build_resident_type_id = brt.id)
  • Buffers: shared hit=1465
18. 53.568 315.734 ↓ 1.0 25,724 1

Hash Left Join (cost=1,117.02..3,632.34 rows=25,716 width=1,233) (actual time=51.250..315.734 rows=25,724 loops=1)

  • Hash Cond: (sh.resident_type_id = prt.id)
  • Buffers: shared hit=1454
19. 63.250 261.763 ↓ 1.0 25,724 1

Hash Join (cost=1,108.30..3,270.03 rows=25,716 width=1,225) (actual time=50.825..261.763 rows=25,724 loops=1)

  • Hash Cond: (sh.ship_main_id = shm.id)
  • Buffers: shared hit=1451
20. 46.941 175.558 ↓ 1.0 25,724 1

Hash Left Join (cost=637.40..2,445.53 rows=25,716 width=1,201) (actual time=27.792..175.558 rows=25,724 loops=1)

  • Hash Cond: (sh.root_port_id = rsp.id)
  • Buffers: shared hit=1309
21. 76.565 118.547 ↓ 1.0 25,724 1

Hash Left Join (cost=401.32..2,113.01 rows=25,716 width=1,180) (actual time=17.690..118.547 rows=25,724 loops=1)

  • Hash Cond: (sh.subscription_port_id = sp.id)
  • Buffers: shared hit=1232
22. 24.337 24.337 ↓ 1.0 25,724 1

Seq Scan on ship sh (cost=0.00..1,360.16 rows=25,716 width=1,138) (actual time=0.009..24.337 rows=25,724 loops=1)

  • Buffers: shared hit=1103
23. 2.121 17.645 ↑ 1.0 2,157 1

Hash (cost=374.36..374.36 rows=2,157 width=50) (actual time=17.645..17.645 rows=2,157 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 206kB
  • Buffers: shared hit=129
24. 3.108 15.524 ↑ 1.0 2,157 1

Hash Left Join (cost=206.42..374.36 rows=2,157 width=50) (actual time=7.457..15.524 rows=2,157 loops=1)

  • Hash Cond: (sp.id = spt_en.subscription_port_id)
  • Buffers: shared hit=129
25. 3.133 8.416 ↑ 1.0 2,157 1

Hash Right Join (cost=73.53..209.12 rows=2,157 width=29) (actual time=3.421..8.416 rows=2,157 loops=1)

  • Hash Cond: (spt.subscription_port_id = sp.id)
  • Buffers: shared hit=77
26. 1.905 1.905 ↑ 1.0 2,157 1

Seq Scan on subscription_port_translation spt (cost=0.00..105.93 rows=2,157 width=29) (actual time=0.019..1.905 rows=2,157 loops=1)

  • Filter: (languages_id = '1'::bigint)
  • Rows Removed by Filter: 2157
  • Buffers: shared hit=52
27. 1.680 3.378 ↑ 1.0 2,157 1

Hash (cost=46.57..46.57 rows=2,157 width=8) (actual time=3.378..3.378 rows=2,157 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 117kB
  • Buffers: shared hit=25
28. 1.698 1.698 ↑ 1.0 2,157 1

Seq Scan on subscription_port sp (cost=0.00..46.57 rows=2,157 width=8) (actual time=0.008..1.698 rows=2,157 loops=1)

  • Buffers: shared hit=25
29. 1.804 4.000 ↑ 1.0 2,157 1

Hash (cost=105.93..105.93 rows=2,157 width=29) (actual time=4.000..4.000 rows=2,157 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 149kB
  • Buffers: shared hit=52
30. 2.196 2.196 ↑ 1.0 2,157 1

Seq Scan on subscription_port_translation spt_en (cost=0.00..105.93 rows=2,157 width=29) (actual time=0.007..2.196 rows=2,157 loops=1)

  • Filter: (languages_id = '2'::bigint)
  • Rows Removed by Filter: 2157
  • Buffers: shared hit=52
31. 1.994 10.070 ↑ 1.0 2,157 1

Hash (cost=209.12..209.12 rows=2,157 width=29) (actual time=10.070..10.070 rows=2,157 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 180kB
  • Buffers: shared hit=77
32. 3.105 8.076 ↑ 1.0 2,157 1

Hash Right Join (cost=73.53..209.12 rows=2,157 width=29) (actual time=3.187..8.076 rows=2,157 loops=1)

  • Hash Cond: (rspt.subscription_port_id = rsp.id)
  • Buffers: shared hit=77
33. 1.820 1.820 ↑ 1.0 2,157 1

Seq Scan on subscription_port_translation rspt (cost=0.00..105.93 rows=2,157 width=29) (actual time=0.009..1.820 rows=2,157 loops=1)

  • Filter: (languages_id = '1'::bigint)
  • Rows Removed by Filter: 2157
  • Buffers: shared hit=52
34. 1.632 3.151 ↑ 1.0 2,157 1

Hash (cost=46.57..46.57 rows=2,157 width=8) (actual time=3.151..3.151 rows=2,157 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 117kB
  • Buffers: shared hit=25
35. 1.519 1.519 ↑ 1.0 2,157 1

Seq Scan on subscription_port rsp (cost=0.00..46.57 rows=2,157 width=8) (actual time=0.009..1.519 rows=2,157 loops=1)

  • Buffers: shared hit=25
36. 11.770 22.955 ↑ 1.0 14,618 1

Hash (cost=288.18..288.18 rows=14,618 width=24) (actual time=22.955..22.955 rows=14,618 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 928kB
  • Buffers: shared hit=142
37. 11.185 11.185 ↑ 1.0 14,618 1

Seq Scan on ship_main shm (cost=0.00..288.18 rows=14,618 width=24) (actual time=0.009..11.185 rows=14,618 loops=1)

  • Buffers: shared hit=142
38. 0.200 0.403 ↑ 1.0 254 1

Hash (cost=5.54..5.54 rows=254 width=8) (actual time=0.403..0.403 rows=254 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 18kB
  • Buffers: shared hit=3
39. 0.203 0.203 ↑ 1.0 254 1

Seq Scan on person_resident_type prt (cost=0.00..5.54 rows=254 width=8) (actual time=0.010..0.203 rows=254 loops=1)

  • Buffers: shared hit=3
40. 0.233 1.265 ↑ 1.0 254 1

Hash (cost=26.56..26.56 rows=254 width=75) (actual time=1.265..1.265 rows=254 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 34kB
  • Buffers: shared hit=11
41. 0.373 1.032 ↑ 1.0 254 1

Hash Right Join (cost=8.71..26.56 rows=254 width=75) (actual time=0.442..1.032 rows=254 loops=1)

  • Hash Cond: (brtt.person_resident_type_id = brt.id)
  • Buffers: shared hit=11
42. 0.249 0.249 ↑ 1.0 254 1

Seq Scan on person_resident_type_translation brtt (cost=0.00..14.35 rows=254 width=75) (actual time=0.011..0.249 rows=254 loops=1)

  • Filter: (language_id = '1'::bigint)
  • Rows Removed by Filter: 254
  • Buffers: shared hit=8
43. 0.210 0.410 ↑ 1.0 254 1

Hash (cost=5.54..5.54 rows=254 width=8) (actual time=0.410..0.410 rows=254 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 18kB
  • Buffers: shared hit=3
44. 0.200 0.200 ↑ 1.0 254 1

Seq Scan on person_resident_type brt (cost=0.00..5.54 rows=254 width=8) (actual time=0.006..0.200 rows=254 loops=1)

  • Buffers: shared hit=3
45. 0.255 1.273 ↑ 1.0 254 1

Hash (cost=26.56..26.56 rows=254 width=50) (actual time=1.273..1.273 rows=254 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 29kB
  • Buffers: shared hit=11
46. 0.387 1.018 ↑ 1.0 254 1

Hash Right Join (cost=8.71..26.56 rows=254 width=50) (actual time=0.426..1.018 rows=254 loops=1)

  • Hash Cond: (rprtt.person_resident_type_id = rprt.id)
  • Buffers: shared hit=11
47. 0.225 0.225 ↑ 1.0 254 1

Seq Scan on person_resident_type_translation rprtt (cost=0.00..14.35 rows=254 width=50) (actual time=0.008..0.225 rows=254 loops=1)

  • Filter: (language_id = '1'::bigint)
  • Rows Removed by Filter: 254
  • Buffers: shared hit=8
48. 0.216 0.406 ↑ 1.0 254 1

Hash (cost=5.54..5.54 rows=254 width=8) (actual time=0.406..0.406 rows=254 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 18kB
  • Buffers: shared hit=3
49. 0.190 0.190 ↑ 1.0 254 1

Seq Scan on person_resident_type rprt (cost=0.00..5.54 rows=254 width=8) (actual time=0.008..0.190 rows=254 loops=1)

  • Buffers: shared hit=3
50. 0.239 0.458 ↑ 1.0 254 1

Hash (cost=14.35..14.35 rows=254 width=75) (actual time=0.458..0.458 rows=254 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 35kB
  • Buffers: shared hit=8
51. 0.219 0.219 ↑ 1.0 254 1

Seq Scan on person_resident_type_translation prtt (cost=0.00..14.35 rows=254 width=75) (actual time=0.008..0.219 rows=254 loops=1)

  • Filter: (language_id = '1'::bigint)
  • Rows Removed by Filter: 254
  • Buffers: shared hit=8
52. 0.449 0.856 ↑ 1.0 493 1

Hash (cost=14.93..14.93 rows=493 width=50) (actual time=0.856..0.856 rows=493 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 50kB
  • Buffers: shared hit=10
53. 0.407 0.407 ↑ 1.0 493 1

Seq Scan on ship_type sht (cost=0.00..14.93 rows=493 width=50) (actual time=0.013..0.407 rows=493 loops=1)

  • Buffers: shared hit=10
54. 0.021 0.036 ↑ 1.0 7 1

Hash (cost=1.07..1.07 rows=7 width=19) (actual time=0.036..0.036 rows=7 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=1
55. 0.015 0.015 ↑ 1.0 7 1

Seq Scan on ship_purpose ssp (cost=0.00..1.07 rows=7 width=19) (actual time=0.009..0.015 rows=7 loops=1)

  • Buffers: shared hit=1
56. 23.751 47.916 ↑ 1.0 28,131 1

Hash (cost=899.00..899.00 rows=28,400 width=24) (actual time=47.916..47.916 rows=28,131 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 1741kB
  • Buffers: shared hit=615
57. 24.165 24.165 ↑ 1.0 28,131 1

Seq Scan on service_request sr (cost=0.00..899.00 rows=28,400 width=24) (actual time=0.012..24.165 rows=28,131 loops=1)

  • Buffers: shared hit=615
58. 31.575 61.076 ↓ 1.0 27,976 1

Hash (cost=567.61..567.61 rows=27,661 width=24) (actual time=61.076..61.076 rows=27,976 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 1786kB
  • Buffers: shared hit=291
59. 29.501 29.501 ↓ 1.0 27,976 1

Seq Scan on service_request_answer sra (cost=0.00..567.61 rows=27,661 width=24) (actual time=0.020..29.501 rows=27,976 loops=1)

  • Buffers: shared hit=291
60. 0.013 0.111 ↑ 1.0 1 1

Hash (cost=2.10..2.10 rows=1 width=8) (actual time=0.111..0.111 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=2
61. 0.012 0.098 ↑ 1.0 1 1

Nested Loop (cost=0.00..2.10 rows=1 width=8) (actual time=0.089..0.098 rows=1 loops=1)

  • Join Filter: (at.id = att.srvreq_answer_type_id)
  • Rows Removed by Join Filter: 1
  • Buffers: shared hit=2
62. 0.053 0.053 ↑ 1.0 1 1

Seq Scan on srvreq_answer_type at (cost=0.00..1.02 rows=1 width=8) (actual time=0.051..0.053 rows=1 loops=1)

  • Filter: ((code)::text = '1'::text)
  • Rows Removed by Filter: 1
  • Buffers: shared hit=1
63. 0.033 0.033 ↑ 1.0 2 1

Seq Scan on srvreq_answer_type_translation att (cost=0.00..1.05 rows=2 width=8) (actual time=0.029..0.033 rows=2 loops=1)

  • Filter: (languages_id = '1'::bigint)
  • Rows Removed by Filter: 2
  • Buffers: shared hit=1
64. 0.017 0.100 ↑ 1.0 4 1

Hash (cost=2.25..2.25 rows=4 width=61) (actual time=0.100..0.100 rows=4 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=2
65. 0.039 0.083 ↑ 1.0 4 1

Hash Right Join (cost=1.09..2.25 rows=4 width=61) (actual time=0.064..0.083 rows=4 loops=1)

  • Hash Cond: (srtt.ship_registration_type_id = srt.id)
  • Buffers: shared hit=2
66. 0.015 0.015 ↑ 1.0 4 1

Seq Scan on ship_reg_type_translation srtt (cost=0.00..1.10 rows=4 width=49) (actual time=0.009..0.015 rows=4 loops=1)

  • Filter: (languages_id = '1'::bigint)
  • Rows Removed by Filter: 4
  • Buffers: shared hit=1
67. 0.012 0.029 ↑ 1.0 4 1

Hash (cost=1.04..1.04 rows=4 width=20) (actual time=0.029..0.029 rows=4 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=1
68. 0.017 0.017 ↑ 1.0 4 1

Seq Scan on ship_registration_type srt (cost=0.00..1.04 rows=4 width=20) (actual time=0.012..0.017 rows=4 loops=1)

  • Buffers: shared hit=1
69. 0.025 0.045 ↑ 1.0 7 1

Hash (cost=1.18..1.18 rows=7 width=42) (actual time=0.045..0.045 rows=7 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=1
70. 0.020 0.020 ↑ 1.0 7 1

Seq Scan on ship_purpose_translation sspt (cost=0.00..1.18 rows=7 width=42) (actual time=0.011..0.020 rows=7 loops=1)

  • Filter: (languages_id = '1'::bigint)
  • Rows Removed by Filter: 7
  • Buffers: shared hit=1
71. 0.017 0.083 ↑ 1.0 5 1

Hash (cost=2.36..2.36 rows=5 width=46) (actual time=0.083..0.083 rows=5 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=2
72. 0.021 0.066 ↑ 1.0 5 1

Hash Join (cost=1.14..2.36 rows=5 width=46) (actual time=0.053..0.066 rows=5 loops=1)

  • Hash Cond: (sst.ship_status_id = ss.id)
  • Buffers: shared hit=2
73. 0.020 0.020 ↑ 1.0 6 1

Seq Scan on ship_status_translation sst (cost=0.00..1.15 rows=6 width=29) (actual time=0.014..0.020 rows=6 loops=1)

  • Filter: (languages_id = '1'::bigint)
  • Rows Removed by Filter: 6
  • Buffers: shared hit=1
74. 0.011 0.025 ↑ 1.0 5 1

Hash (cost=1.07..1.07 rows=5 width=17) (actual time=0.025..0.025 rows=5 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=1
75. 0.014 0.014 ↑ 1.0 5 1

Seq Scan on ship_status ss (cost=0.00..1.07 rows=5 width=17) (actual time=0.006..0.014 rows=5 loops=1)

  • Filter: ((code)::text <> 'DELETED'::text)
  • Rows Removed by Filter: 1
  • Buffers: shared hit=1
76. 0.011 0.082 ↑ 1.0 4 1

Hash (cost=2.25..2.25 rows=4 width=36) (actual time=0.082..0.082 rows=4 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=2
77. 0.030 0.071 ↑ 1.0 4 1

Hash Join (cost=1.09..2.25 rows=4 width=36) (actual time=0.056..0.071 rows=4 loops=1)

  • Hash Cond: (crt.ship_change_reason_id = cr.id)
  • Buffers: shared hit=2
78. 0.016 0.016 ↑ 1.0 4 1

Seq Scan on ship_change_reason_translation crt (cost=0.00..1.10 rows=4 width=30) (actual time=0.012..0.016 rows=4 loops=1)

  • Filter: (languages_id = '1'::bigint)
  • Rows Removed by Filter: 4
  • Buffers: shared hit=1
79. 0.011 0.025 ↑ 1.0 4 1

Hash (cost=1.04..1.04 rows=4 width=14) (actual time=0.025..0.025 rows=4 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=1
80. 0.014 0.014 ↑ 1.0 4 1

Seq Scan on ship_change_reason cr (cost=0.00..1.04 rows=4 width=14) (actual time=0.008..0.014 rows=4 loops=1)

  • Buffers: shared hit=1
81. 55.414 99.520 ↑ 1.0 41,808 1

Hash (cost=1,501.59..1,501.59 rows=41,959 width=99) (actual time=99.520..99.520 rows=41,808 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 6026kB
  • Buffers: shared hit=1082
82. 44.106 44.106 ↑ 1.0 41,808 1

Seq Scan on legal_person csms (cost=0.00..1,501.59 rows=41,959 width=99) (actual time=0.014..44.106 rows=41,808 loops=1)

  • Buffers: shared hit=1082
83. 64.425 1,739.475 ↑ 1.0 1 21,475

Limit (cost=21.72..21.72 rows=1 width=8) (actual time=0.080..0.081 rows=1 loops=21,475)

  • Buffers: shared hit=504296
84. 171.800 1,675.050 ↑ 1.0 1 21,475

Sort (cost=21.72..21.72 rows=1 width=8) (actual time=0.078..0.078 rows=1 loops=21,475)

  • Sort Key: ssra.srvreq_answer_date
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=504296
85. 213.708 1,503.250 ↓ 3.0 3 21,475

Nested Loop (cost=0.99..21.71 rows=1 width=8) (actual time=0.027..0.070 rows=3 loops=21,475)

  • Buffers: shared hit=504296
86. 220.431 1,116.700 ↓ 1.5 3 21,475

Nested Loop (cost=0.86..21.39 rows=2 width=16) (actual time=0.021..0.052 rows=3 loops=21,475)

  • Join Filter: (ssr.id = ssra.service_request_id)
  • Buffers: shared hit=389068
87. 198.956 665.725 ↓ 1.5 3 21,475

Nested Loop (cost=0.57..20.64 rows=2 width=16) (actual time=0.015..0.031 rows=3 loops=21,475)

  • Buffers: shared hit=215861
88. 236.225 236.225 ↓ 1.5 3 21,475

Index Scan using servicereq_docum_fk_i on service_request ssr (cost=0.29..12.01 rows=2 width=8) (actual time=0.007..0.011 rows=3 loops=21,475)

  • Index Cond: (sr.document_id = document_id)
  • Buffers: shared hit=98763
89. 230.544 230.544 ↑ 1.0 1 57,636

Index Only Scan using ship_pk on ship ss_1 (cost=0.29..4.30 rows=1 width=8) (actual time=0.003..0.004 rows=1 loops=57,636)

  • Index Cond: (id = ssr.id)
  • Heap Fetches: 1378
  • Buffers: shared hit=117098
90. 230.544 230.544 ↑ 1.0 1 57,636

Index Scan using srvreqansw_srvreq_fk_i on service_request_answer ssra (cost=0.29..0.36 rows=1 width=24) (actual time=0.004..0.004 rows=1 loops=57,636)

  • Index Cond: (service_request_id = ss_1.id)
  • Buffers: shared hit=173207
91. 172.842 172.842 ↑ 1.0 1 57,614

Index Scan using srvreq_ansver_type_pk on srvreq_answer_type sat (cost=0.13..0.15 rows=1 width=8) (actual time=0.002..0.003 rows=1 loops=57,614)

  • Index Cond: (id = ssra.srvreq_answer_type_id)
  • Filter: ((code)::text = '1'::text)
  • Buffers: shared hit=115228
92. 5.470 11.657 ↓ 1.0 5,354 1

Hash (cost=152.16..152.16 rows=5,349 width=16) (actual time=11.657..11.657 rows=5,354 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 315kB
  • Buffers: shared hit=45
93. 6.187 6.187 ↓ 1.0 5,354 1

Seq Scan on supervisfilial_ship sf (cost=0.00..152.16 rows=5,349 width=16) (actual time=0.025..6.187 rows=5,354 loops=1)

  • Filter: ((statement_timestamp() >= start_date) AND (statement_timestamp() <= end_date))
  • Rows Removed by Filter: 9
  • Buffers: shared hit=45
94. 85.685 85.900 ↑ 1.0 5 21,475

Materialize (cost=0.58..79.96 rows=5 width=115) (actual time=0.001..0.004 rows=5 loops=21,475)

  • Buffers: shared hit=49
95. 0.022 0.215 ↑ 1.0 5 1

Nested Loop Left Join (cost=0.58..79.94 rows=5 width=115) (actual time=0.073..0.215 rows=5 loops=1)

  • Buffers: shared hit=49
96. 0.023 0.148 ↑ 1.0 5 1

Nested Loop Left Join (cost=0.29..76.93 rows=5 width=24) (actual time=0.056..0.148 rows=5 loops=1)

  • Buffers: shared hit=34
97. 0.015 0.015 ↑ 1.0 5 1

Seq Scan on supervising_filial fil (cost=0.00..1.05 rows=5 width=16) (actual time=0.010..0.015 rows=5 loops=1)

  • Buffers: shared hit=1
98. 0.110 0.110 ↑ 1.0 1 5

Index Scan using personver_person_fk_i on person_version sfpv (cost=0.29..15.17 rows=1 width=16) (actual time=0.020..0.022 rows=1 loops=5)

  • Index Cond: (person_id = fil.person_id)
  • Filter: ((statement_timestamp() >= start_date) AND (statement_timestamp() <= end_date))
  • Rows Removed by Filter: 4
  • Buffers: shared hit=33
99. 0.045 0.045 ↑ 1.0 1 5

Index Scan using legal_person_pk on legal_person sflp (cost=0.29..0.59 rows=1 width=99) (actual time=0.007..0.009 rows=1 loops=5)

  • Index Cond: (id = sfpv.id)
  • Buffers: shared hit=15
100. 42.950 300.650 ↓ 0.0 0 21,475

GroupAggregate (cost=0.00..2.71 rows=1 width=524) (actual time=0.014..0.014 rows=0 loops=21,475)

  • Group Key: grs.ship_id
  • Buffers: shared hit=21532
101. 85.615 257.700 ↓ 0.0 0 21,475

Nested Loop (cost=0.00..2.69 rows=1 width=19) (actual time=0.012..0.012 rows=0 loops=21,475)

  • Join Filter: (grs.gmssb_region_id = gr.id)
  • Rows Removed by Join Filter: 0
  • Buffers: shared hit=21532
102. 171.800 171.800 ↓ 0.0 0 21,475

Seq Scan on gmssb_region_ship grs (cost=0.00..1.58 rows=1 width=16) (actual time=0.008..0.008 rows=0 loops=21,475)

  • Filter: (ship_id = sh.id)
  • Rows Removed by Filter: 57
  • Buffers: shared hit=21475
103. 0.285 0.285 ↑ 1.0 5 57

Seq Scan on gmssb_region gr (cost=0.00..1.05 rows=5 width=19) (actual time=0.002..0.005 rows=5 loops=57)

  • Buffers: shared hit=57