explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Grmo : Optimization for: plan #CLCtc

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.004 74,950.725 ↑ 1.0 4 1

Limit (cost=490,873.33..4,417,500.79 rows=4 width=1,438) (actual time=74,609.194..74,950.725 rows=4 loops=1)

  • Buffers: shared hit=8448189
2. 134.289 74,950.721 ↑ 3,059,676.2 4 1

Nested Loop (cost=490,873.33..12,014,209,289,664.3 rows=12,238,705 width=1,438) (actual time=74,609.193..74,950.721 rows=4 loops=1)

  • Filter: ((alternatives: SubPlan 1 or hashed SubPlan 2) OR (p.person_root_id = secr.get_current_org_root_id()) OR (u.person_root_id = secr.get_current_individual_root_id()))
  • Buffers: shared hit=8448189
3. 1.856 73,815.936 ↑ 72,849.4 336 1

Nested Loop (cost=490,873.05..12,013,682,345,364.3 rows=24,477,410 width=1,807) (actual time=204.594..73,815.936 rows=336 loops=1)

  • Buffers: shared hit=8371284
4. 1.884 73,736.800 ↑ 72,849.4 336 1

Nested Loop (cost=245,471.22..6,006,880,546,405.48 rows=24,477,410 width=1,775) (actual time=204.211..73,736.8 rows=336 loops=1)

  • Buffers: shared hit=8346685
5. 1.733 73,639.828 ↑ 72,849.4 336 1

Nested Loop (cost=69.44..79,665,349.51 rows=24,477,410 width=1,743) (actual time=203.849..73,639.828 rows=336 loops=1)

  • Buffers: shared hit=8322621
6. 1.564 73,638.095 ↑ 72,849.4 336 1

Nested Loop (cost=69.15..69,811,273.58 rows=24,477,410 width=1,701) (actual time=203.844..73,638.095 rows=336 loops=1)

  • Buffers: shared hit=8322621
7. 1.693 73,636.195 ↑ 72,849.4 336 1

Nested Loop (cost=68.73..29,876,506.74 rows=24,477,410 width=1,624) (actual time=203.836..73,636.195 rows=336 loops=1)

  • Buffers: shared hit=8322621
8. 1.681 73,632.150 ↓ 1.4 336 1

Nested Loop (cost=66.62..435,412.66 rows=241 width=1,616) (actual time=203.825..73,632.15 rows=336 loops=1)

  • Buffers: shared hit=8322621
9. 2.605 73,628.453 ↓ 1.4 336 1

Nested Loop (cost=66.2..433,445.36 rows=241 width=1,608) (actual time=203.816..73,628.453 rows=336 loops=1)

  • Buffers: shared hit=8321272
10. 1.463 73,624.168 ↓ 1.2 336 1

Nested Loop (cost=66.2..433,102.64 rows=279 width=1,616) (actual time=203.774..73,624.168 rows=336 loops=1)

  • Buffers: shared hit=8321271
11. 2.449 73,621.697 ↓ 2.6 336 1

Nested Loop (cost=65.64..432,257.93 rows=130 width=1,566) (actual time=203.756..73,621.697 rows=336 loops=1)

  • Buffers: shared hit=8321271
12. 1.838 73,617.232 ↓ 2.6 336 1

Nested Loop (cost=65.36..431,657.63 rows=130 width=1,558) (actual time=203.731..73,617.232 rows=336 loops=1)

  • Buffers: shared hit=8320588
13. 1.657 435.602 ↓ 2.6 336 1

Nested Loop (cost=60.85..429,452.91 rows=130 width=1,526) (actual time=1.985..435.602 rows=336 loops=1)

  • Buffers: shared hit=55180
14. 1.095 421.849 ↓ 2.6 336 1

Nested Loop (cost=35.49..426,151.23 rows=130 width=1,486) (actual time=1.936..421.849 rows=336 loops=1)

  • Buffers: shared hit=51530
15. 1.221 417.730 ↓ 2.6 336 1

Nested Loop (cost=27.19..425,068.98 rows=130 width=923) (actual time=1.921..417.73 rows=336 loops=1)

  • Buffers: shared hit=50858
16. 1.309 410.125 ↓ 2.6 336 1

Nested Loop (cost=18.74..423,967.23 rows=130 width=850) (actual time=1.892..410.125 rows=336 loops=1)

  • Buffers: shared hit=49514
17. 4.405 403.440 ↓ 2.6 336 1

Nested Loop (cost=10.28..422,865.16 rows=130 width=282) (actual time=1.867..403.44 rows=336 loops=1)

  • Buffers: shared hit=48506
18. 0.864 393.323 ↓ 2.6 336 1

Nested Loop (cost=1.13..422,652.9 rows=130 width=127) (actual time=1.721..393.323 rows=336 loops=1)

  • Buffers: shared hit=48486
19. 1.105 392.123 ↓ 2.6 336 1

Nested Loop (cost=1.13..422,631.25 rows=130 width=108) (actual time=1.664..392.123 rows=336 loops=1)

  • Buffers: shared hit=48485
20. 1.426 390.682 ↓ 2.6 336 1

Nested Loop (cost=1.13..422,610.31 rows=130 width=98) (actual time=1.656..390.682 rows=336 loops=1)

  • Buffers: shared hit=48484
21. 1.428 388.584 ↓ 2.6 336 1

Nested Loop (cost=0.86..422,506.15 rows=130 width=106) (actual time=1.653..388.584 rows=336 loops=1)

  • Buffers: shared hit=48484
22. 375.732 375.732 ↓ 2.6 336 1

Index Scan using fdc_request_request_date_i on fdc_request request (cost=0.43..421,215.73 rows=130 width=90) (actual time=1.584..375.732 rows=336 loops=1)

  • Index Cond: ((request.request_date >= '2020-01-28 00:00:00'::timestamp without time zone) AND (request.request_date < '2020-01-30 00:00:00'::timestamp without time zone))
  • Filter: ((request.request_type_id = ANY (ARRAY[nsi.c_request_type_031_id(), nsi.c_request_type_032_id(), nsi.c_request_type_033_id(), nsi.c_request_type_035_id(), nsi.c_request_type_078_id()])) AND (request.request_type_id = ANY (ARRAY[nsi.c_request_type_031_id(), nsi.c_request_type_033_id(), nsi.c_request_type_032_id(), nsi.c_request_type_034_id(), nsi.c_request_type_035_id(), nsi.c_request_type_029_id(), nsi.c_request_type_030_id(), nsi.c_request_type_028_id(), nsi.c_request_type_027_id(), nsi.c_request_type_081_id(), nsi.c_request_type_078_id(), nsi.c_request_type_075_id(), nsi.c_request_type_076_id(), nsi.c_request_type_077_id(), nsi.c_request_type_070_id(), nsi.c_request_type_071_id(), nsi.c_request_type_072_id(), nsi.c_request_type_079_id(), nsi.c_request_type_080_id()])))
  • Buffers: shared hit=46266
23. 11.424 11.424 ↑ 1.0 1 336

Index Scan using fdc_request_status_history_request_i on fdc_request_status_history rsh (cost=0.43..9.92 rows=1 width=24) (actual time=0.026..0.034 rows=1 loops=336)

  • Index Cond: (rsh.request_id = request.id)
  • Filter: ((statement_timestamp() >= rsh.date_from) AND (statement_timestamp() <= rsh.date_to) AND (rsh.status_id <> request.c_request_status_removed_id()))
  • Buffers: shared hit=2218
24. 0.336 0.672 ↓ 0.0 0 336

Nested Loop (cost=0.27..0.79 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=336)

25. 0.336 0.336 ↓ 0.0 0 336

Index Scan using fdc_change_status_reason_pk on fdc_change_status_reason c_1 (cost=0.14..0.16 rows=1 width=16) (actual time=0.001..0.001 rows=0 loops=336)

  • Index Cond: (c_1.id = rsh.reason_id)
26. 0.000 0.000 ↓ 0.0 0 0

Index Only Scan using fdc_object_type_pk on fdc_object_type c_2 (cost=0.13..0.47 rows=1 width=8) (never executed)

  • Index Cond: (c_2.id = c_1.object_type_id)
27. 0.334 0.336 ↑ 3.7 3 336

Materialize (cost=0..1.17 rows=11 width=10) (actual time=0.001..0.001 rows=3 loops=336)

  • Buffers: shared hit=1
28. 0.002 0.002 ↑ 2.8 4 1

Seq Scan on fdc_request_status c (cost=0..1.11 rows=11 width=10) (actual time=0.002..0.002 rows=4 loops=1)

  • Buffers: shared hit=1
29. 0.201 0.336 ↑ 3.7 3 336

Materialize (cost=0..1.88 rows=11 width=35) (actual time=0.001..0.001 rows=3 loops=336)

  • Buffers: shared hit=1
30. 0.135 0.135 ↑ 1.1 10 1

Seq Scan on fdc_request_status_translation t (cost=0..1.82 rows=11 width=35) (actual time=0.029..0.135 rows=10 loops=1)

  • Filter: (t.language_id = lang.get_current_lang_id())
  • Buffers: shared hit=1
31. 5.541 5.712 ↑ 1.0 95 336

Materialize (cost=9.15..27.24 rows=95 width=155) (actual time=0.001..0.017 rows=95 loops=336)

  • Buffers: shared hit=20
32. 0.059 0.171 ↑ 1.0 95 1

Hash Join (cost=9.15..26.77 rows=95 width=155) (actual time=0.088..0.171 rows=95 loops=1)

  • Buffers: shared hit=20
33. 0.044 0.073 ↑ 1.0 95 1

Bitmap Heap Scan on fdc_request_type_translation t_1 (cost=5.01..21.44 rows=95 width=147) (actual time=0.035..0.073 rows=95 loops=1)

  • Heap Blocks: exact=15
  • Buffers: shared hit=18
34. 0.029 0.029 ↑ 1.0 95 1

Bitmap Index Scan on fdc_request_type_translation_l_i (cost=0..4.99 rows=95 width=0) (actual time=0.029..0.029 rows=95 loops=1)

  • Index Cond: (t_1.language_id = lang.get_current_lang_id())
  • Buffers: shared hit=3
35. 0.022 0.039 ↑ 1.0 95 1

Hash (cost=2.95..2.95 rows=95 width=16) (actual time=0.039..0.039 rows=95 loops=1)

  • Buffers: shared hit=2
36. 0.017 0.017 ↑ 1.0 95 1

Seq Scan on fdc_request_type c_3 (cost=0..2.95 rows=95 width=16) (actual time=0.004..0.017 rows=95 loops=1)

  • Buffers: shared hit=2
37. 1.008 5.376 ↓ 0.0 0 336

Limit (cost=8.45..8.46 rows=1 width=576) (actual time=0.016..0.016 rows=0 loops=336)

  • Buffers: shared hit=1008
38. 1.680 4.368 ↓ 0.0 0 336

Sort (cost=8.45..8.46 rows=1 width=576) (actual time=0.013..0.013 rows=0 loops=336)

  • Sort Key: e.start_date
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=1008
39. 2.688 2.688 ↓ 0.0 0 336

Index Scan using fdc_pts_encumbrance_start_request_i on fdc_pts_encumbrance e (cost=0.42..8.44 rows=1 width=576) (actual time=0.008..0.008 rows=0 loops=336)

  • Index Cond: (e.start_request_id = request.id)
  • Buffers: shared hit=1008
40. 0.672 6.384 ↑ 1.0 1 336

Limit (cost=8.45..8.46 rows=1 width=81) (actual time=0.019..0.019 rows=1 loops=336)

  • Buffers: shared hit=1344
41. 1.680 5.712 ↑ 1.0 1 336

Sort (cost=8.45..8.46 rows=1 width=81) (actual time=0.017..0.017 rows=1 loops=336)

  • Sort Key: fdc_pts_ownership.date_add
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=1344
42. 4.032 4.032 ↑ 1.0 1 336

Index Scan using fdc_pts_ownership_req_i on fdc_pts_ownership fdc_pts_ownership (cost=0.42..8.44 rows=1 width=81) (actual time=0.012..0.012 rows=1 loops=336)

  • Index Cond: (fdc_pts_ownership.request_id = request.id)
  • Buffers: shared hit=1344
43. 0.672 3.024 ↓ 0.0 0 336

Limit (cost=8.3..8.31 rows=1 width=571) (actual time=0.009..0.009 rows=0 loops=336)

  • Buffers: shared hit=672
44. 0.672 2.352 ↓ 0.0 0 336

Sort (cost=8.3..8.31 rows=1 width=571) (actual time=0.007..0.007 rows=0 loops=336)

  • Sort Key: fdc_pts_dealer.start_date
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=672
45. 1.680 1.680 ↓ 0.0 0 336

Index Scan using fdc_pts_dealer_start_request_i on fdc_pts_dealer fdc_pts_dealer (cost=0.27..8.29 rows=1 width=571) (actual time=0.005..0.005 rows=0 loops=336)

  • Index Cond: (fdc_pts_dealer.start_request_id = request.id)
  • Buffers: shared hit=672
46. 1.680 12.096 ↑ 1.0 1 336

Aggregate (cost=25.37..25.38 rows=1 width=40) (actual time=0.036..0.036 rows=1 loops=336)

  • Buffers: shared hit=3650
47. 1.680 10.416 ↑ 1.0 2 336

Nested Loop (cost=0.86..25.36 rows=2 width=16) (actual time=0.028..0.031 rows=2 loops=336)

  • Buffers: shared hit=3650
48. 4.368 4.368 ↑ 1.0 2 336

Index Only Scan using fdc_request_pts_req_i on fdc_request_pts pts_list (cost=0.43..8.47 rows=2 width=8) (actual time=0.012..0.013 rows=2 loops=336)

  • Index Cond: (pts_list.request_id = request.id)
  • Heap Fetches: 546
  • Buffers: shared hit=1466
49. 4.368 4.368 ↑ 1.0 1 546

Index Scan using fdc_pts_root_pk on fdc_pts_root r (cost=0.43..8.45 rows=1 width=24) (actual time=0.008..0.008 rows=1 loops=546)

  • Index Cond: (r.id = pts_list.pasport_root_id)
  • Buffers: shared hit=2184
50. 0.672 73,179.792 ↑ 1.0 1 336

Limit (cost=4.5..16.94 rows=1 width=2,505) (actual time=217.796..217.797 rows=1 loops=336)

  • Buffers: shared hit=8265408
51. 1.344 73,179.120 ↑ 55,326.0 1 336

Result (cost=4.5..688,086.86 rows=55,326 width=2,505) (actual time=217.795..217.795 rows=1 loops=336)

  • Buffers: shared hit=8265408
52. 3.420 73,177.776 ↑ 55,326.0 1 336

Nested Loop (cost=4.5..688,086.86 rows=55,326 width=2,505) (actual time=217.791..217.791 rows=1 loops=336)

  • Filter: ((p_1.person_root_id = COALESCE(ind_per_1.person_root_id, lp_per.person_root_id)) OR (p_1.person_root_id = org.person_root_id) OR ((c_5.code)::text = ANY ('{10,11,13}'::text[])))
  • Buffers: shared hit=8265408
53. 1.860 73,173.408 ↑ 203,283.0 1 336

Nested Loop (cost=4.08..577,887.85 rows=203,283 width=127) (actual time=163.946..217.778 rows=1 loops=336)

  • Buffers: shared hit=8264095
54. 3.750 73,168.704 ↑ 203,283.0 1 336

Nested Loop (cost=3.66..332,984.03 rows=203,283 width=127) (actual time=163.935..217.764 rows=1 loops=336)

  • Buffers: shared hit=8263109
55. 10,209.402 73,118.976 ↑ 2.0 1 336

Nested Loop (cost=1.55..88,659.6 rows=2 width=127) (actual time=163.842..217.616 rows=1 loops=336)

  • Buffers: shared hit=8252584
56. 911.370 55,819.008 ↑ 2.0 1 336

Nested Loop (cost=1.55..67,738.47 rows=2 width=127) (actual time=127.385..166.128 rows=1 loops=336)

  • Buffers: shared hit=8246846
57. 2.520 54,324.144 ↑ 2.0 1 336

Nested Loop (cost=1.55..65,642.11 rows=2 width=119) (actual time=124.232..161.679 rows=1 loops=336)

  • Buffers: shared hit=8245988
58. 173.808 54,308.352 ↑ 1.0 1 336

Nested Loop (cost=1.27..65,636.41 rows=1 width=119) (actual time=124.202..161.632 rows=1 loops=336)

  • Buffers: shared hit=8243177
59. 736.950 53,872.896 ↑ 1.0 1 336

Nested Loop (cost=1.27..64,901.27 rows=1 width=119) (actual time=123.292..160.336 rows=1 loops=336)

  • Buffers: shared hit=8051691
60. 7.968 52,388.448 ↑ 1.0 1 336

Nested Loop (cost=1.27..51,125.14 rows=1 width=119) (actual time=120.393..155.918 rows=1 loops=336)

  • Buffers: shared hit=7955121
61. 2.910 52,376.688 ↑ 1.0 1 336

Nested Loop (cost=1.27..51,121 rows=1 width=127) (actual time=120.368..155.883 rows=1 loops=336)

  • Buffers: shared hit=7954647
62. 3.462 52,367.616 ↑ 1.0 1 336

Nested Loop (cost=0.84..51,112.55 rows=1 width=111) (actual time=120.348..155.856 rows=1 loops=336)

  • Buffers: shared hit=7952749
63. 7,726.020 52,333.344 ↑ 1.0 1 336

Nested Loop (cost=0.56..51,103.62 rows=1 width=117) (actual time=120.277..155.754 rows=1 loops=336)

  • Buffers: shared hit=7951326
64. 1,216.092 22,315.104 ↑ 1.0 1 336

Nested Loop (cost=0.56..33,203.76 rows=1 width=125) (actual time=56.936..66.414 rows=1 loops=336)

  • Buffers: shared hit=2933088
65. 2,719.020 19,547.136 ↑ 1.0 1 336

Nested Loop (cost=0.56..31,690.15 rows=1 width=125) (actual time=51.101..58.176 rows=1 loops=336)

  • Buffers: shared hit=2526768
66. 3,935.376 8,958.768 ↑ 1.0 1 336

Nested Loop (cost=0.56..13,790.29 rows=1 width=40) (actual time=23.066..26.663 rows=1 loops=336)

  • Buffers: shared hit=880404
67. 2.328 25.536 ↑ 1.0 1 336

Nested Loop (cost=0.56..14.16 rows=1 width=32) (actual time=0.047..0.076 rows=1 loops=336)

  • Buffers: shared hit=2338
68. 2.352 2.352 ↑ 1.0 1 336

Index Scan using fdc_request_signatory_person_req_i on fdc_request_signatory_person sp (cost=0.43..8.45 rows=1 width=40) (actual time=0.006..0.007 rows=1 loops=336)

  • Index Cond: (sp.request_id = request.id)
  • Buffers: shared hit=1389
69. 0.948 20.856 ↑ 1.0 1 474

Nested Loop (cost=0.13..5.71 rows=1 width=8) (actual time=0.043..0.044 rows=1 loops=474)

  • Buffers: shared hit=949
70. 3.318 19.434 ↑ 1.0 1 474

Nested Loop (cost=0.13..5.68 rows=1 width=8) (actual time=0.04..0.041 rows=1 loops=474)

  • Buffers: shared hit=949
71. 1.896 1.896 ↑ 1.0 1 474

Index Only Scan using fdc_person_type_pk on fdc_person_type c_4 (cost=0.13..4.15 rows=1 width=8) (actual time=0.003..0.004 rows=1 loops=474)

  • Index Cond: (c_4.id = sp.person_type_id)
  • Buffers: shared hit=475
72. 14.220 14.220 ↑ 6.0 1 474

Seq Scan on fdc_person_type_translation t_2 (cost=0..1.45 rows=6 width=8) (actual time=0.029..0.03 rows=1 loops=474)

  • Filter: (t_2.language_id = lang.get_current_lang_id())
  • Buffers: shared hit=474
73. 0.474 0.474 ↑ 1.0 1 474

Result (cost=0..0.01 rows=1 width=64) (actual time=0.001..0.001 rows=1 loops=474)

74. 4,997.856 4,997.856 ↑ 2.9 123,705 474

Seq Scan on fdc_person p_1 (cost=0..9,310.5 rows=357,250 width=16) (actual time=0.004..10.544 rows=123,705 loops=474)

  • Buffers: shared hit=878066
75. 7,869.348 7,869.348 ↑ 3.0 106,981 474

Seq Scan on fdc_legal_person pers_org (cost=0..13,837.16 rows=325,016 width=93) (actual time=0.002..16.602 rows=106,981 loops=474)

  • Buffers: shared hit=1646364
76. 1,551.876 1,551.876 ↑ 1.0 29,116 474

Seq Scan on fdc_individual pers_ind (cost=0..1,149.38 rows=29,138 width=8) (actual time=0.002..3.274 rows=29,116 loops=474)

  • Buffers: shared hit=406320
77. 22,292.220 22,292.220 ↑ 1.0 324,255 474

Seq Scan on fdc_legal_person pers_lp (cost=0..13,837.16 rows=325,016 width=8) (actual time=0.002..47.03 rows=324,255 loops=474)

  • Buffers: shared hit=5018238
78. 24.648 30.810 ↑ 1.0 1 474

Nested Loop (cost=0.28..8.92 rows=1 width=10) (actual time=0.064..0.065 rows=1 loops=474)

  • Buffers: shared hit=1423
79. 3.792 3.792 ↑ 1.0 1 474

Index Scan using fdc_signatory_type_pk on fdc_signatory_type c_5 (cost=0.14..8.15 rows=1 width=10) (actual time=0.008..0.008 rows=1 loops=474)

  • Index Cond: (c_5.id = sp.signatory_type_id)
  • Buffers: shared hit=948
80. 2.370 2.370 ↑ 1.0 1 474

Index Only Scan using fdc_signatory_type_translation_stype_i on fdc_signatory_type_translation t_3 (cost=0.14..0.7 rows=1 width=8) (actual time=0.005..0.005 rows=1 loops=474)

  • Index Cond: ((t_3.signatory_type_id = c_5.id) AND (t_3.language_id = lang.get_current_lang_id()))
  • Buffers: shared hit=475
81. 6.162 6.162 ↑ 1.0 1 474

Index Scan using fdc_request_pk on fdc_request req (cost=0.43..8.45 rows=1 width=32) (actual time=0.013..0.013 rows=1 loops=474)

  • Index Cond: (req.id = request.id)
  • Buffers: shared hit=1898
82. 3.792 3.792 ↑ 1.2 81 474

Seq Scan on fdc_request_type reqtype (cost=0..2.95 rows=95 width=8) (actual time=0.004..0.008 rows=81 loops=474)

  • Buffers: shared hit=474
83. 747.498 747.498 ↑ 15.2 23,464 474

Seq Scan on fdc_person org (cost=0..9,310.5 rows=357,250 width=16) (actual time=0.004..1.577 rows=23,464 loops=474)

  • Buffers: shared hit=96570
84. 261.648 261.648 ↑ 1.3 2,817 474

Seq Scan on fdc_user usr (cost=0..688.4 rows=3,740 width=16) (actual time=0.003..0.552 rows=2,817 loops=474)

  • Buffers: shared hit=191486
85. 13.272 13.272 ↑ 2.0 1 474

Index Scan using fdc_person_root_date_uk on fdc_person per_2 (cost=0.28..5.67 rows=2 width=16) (actual time=0.024..0.028 rows=1 loops=474)

  • Index Cond: (per_2.person_root_id = usr.person_root_id)
  • Filter: ((statement_timestamp() >= per_2.date_from) AND (statement_timestamp() <= per_2.date_to))
  • Buffers: shared hit=2811
86. 578.719 583.494 ↑ 1.0 29,136 474

Materialize (cost=0..1,295.07 rows=29,138 width=8) (actual time=0.001..1.231 rows=29,136 loops=474)

  • Buffers: shared hit=858
87. 4.775 4.775 ↑ 1.0 29,136 1

Seq Scan on fdc_individual ind_1 (cost=0..1,149.38 rows=29,138 width=8) (actual time=0.005..4.775 rows=29,136 loops=1)

  • Buffers: shared hit=858
88. 7,050.425 7,090.566 ↑ 1.0 356,405 474

Materialize (cost=0..11,096.75 rows=357,250 width=16) (actual time=0..14.959 rows=356,405 loops=474)

  • Buffers: shared hit=5738
89. 40.141 40.141 ↑ 1.0 356,405 1

Seq Scan on fdc_person ind_per_1 (cost=0..9,310.5 rows=357,250 width=16) (actual time=0.007..40.141 rows=356,405 loops=1)

  • Buffers: shared hit=5738
90. 1.533 45.978 ↑ 12,068,140.0 1 474

Nested Loop (cost=2.1..1,480.82 rows=12,068,140 width=16) (actual time=0.087..0.097 rows=1 loops=474)

  • Buffers: shared hit=10525
91. 1.908 33.654 ↑ 3,474.0 1 474

Nested Loop (cost=1.82..14.99 rows=3,474 width=16) (actual time=0.067..0.071 rows=1 loops=474)

  • Buffers: shared hit=7556
92. 1.683 18.012 ↑ 1.0 1 474

Nested Loop (cost=1.55..14.57 rows=1 width=24) (actual time=0.038..0.038 rows=1 loops=474)

  • Buffers: shared hit=4688
93. 1.536 14.694 ↑ 1.0 1 474

Nested Loop (cost=1.12..9.66 rows=1 width=24) (actual time=0.031..0.031 rows=1 loops=474)

  • Buffers: shared hit=3375
94. 3.366 11.850 ↑ 1.0 1 474

Nested Loop (cost=0.7..4.75 rows=1 width=24) (actual time=0.025..0.025 rows=1 loops=474)

  • Buffers: shared hit=2067
95. 5.214 5.214 ↑ 1.0 1 474

Index Scan using fdc_official_person_pk on fdc_official_person ofp_1 (cost=0.28..0.3 rows=1 width=24) (actual time=0.011..0.011 rows=1 loops=474)

  • Index Cond: (ofp_1.id = per_2.id)
  • Buffers: shared hit=981
96. 3.270 3.270 ↑ 1.0 1 327

Index Only Scan using fdc_person_id_i on fdc_person per_3 (cost=0.42..4.45 rows=1 width=8) (actual time=0.01..0.01 rows=1 loops=327)

  • Index Cond: (per_3.id = ofp_1.id)
  • Heap Fetches: 104
  • Buffers: shared hit=1086
97. 1.308 1.308 ↑ 1.0 1 327

Index Scan using fdc_person_id_i on fdc_person ind_ver_1 (cost=0.42..4.91 rows=1 width=16) (actual time=0.004..0.004 rows=1 loops=327)

  • Index Cond: (ind_ver_1.id = ofp_1.individual_id)
  • Buffers: shared hit=1308
98. 1.635 1.635 ↑ 1.0 1 327

Index Scan using fdc_person_id_i on fdc_person leg_ver_1 (cost=0.42..4.91 rows=1 width=16) (actual time=0.005..0.005 rows=1 loops=327)

  • Index Cond: (leg_ver_1.id = ofp_1.legal_person_id)
  • Buffers: shared hit=1313
99. 13.734 13.734 ↑ 2.0 1 327

Index Scan using fdc_person_root_date_uk on fdc_person ind_per_2 (cost=0.28..0.4 rows=2 width=8) (actual time=0.036..0.042 rows=1 loops=327)

  • Index Cond: (ind_per_2.person_root_id = ind_ver_1.person_root_id)
  • Filter: ((statement_timestamp() >= ind_per_2.date_from) AND (statement_timestamp() <= ind_per_2.date_to))
  • Buffers: shared hit=2868
100. 10.791 10.791 ↑ 2.0 1 327

Index Scan using fdc_person_root_date_uk on fdc_person leg_per_1 (cost=0.28..0.4 rows=2 width=16) (actual time=0.025..0.033 rows=1 loops=327)

  • Index Cond: (leg_per_1.person_root_id = leg_ver_1.person_root_id)
  • Filter: ((statement_timestamp() >= leg_per_1.date_from) AND (statement_timestamp() <= leg_per_1.date_to))
  • Buffers: shared hit=2969
101. 2.844 2.844 ↑ 1.0 1 474

Index Only Scan using fdc_legal_person_id_i on fdc_legal_person lp_op_1 (cost=0.42..1.2 rows=1 width=8) (actual time=0.006..0.006 rows=1 loops=474)

  • Index Cond: (lp_op_1.id = leg_per_1.id)
  • Heap Fetches: 4
  • Buffers: shared hit=986
102. 0.948 0.948 ↑ 1.0 1 474

Index Scan using fdc_person_id_i on fdc_person lp_per (cost=0.42..0.52 rows=1 width=16) (actual time=0.002..0.002 rows=1 loops=474)

  • Index Cond: (lp_op_1.id = lp_per.id)
  • Buffers: shared hit=1313
103. 2.016 2.016 ↑ 1.0 1 336

Index Scan using fdc_user_id_i on fdc_user req_initiator (cost=0.28..4.61 rows=1 width=16) (actual time=0.006..0.006 rows=1 loops=336)

  • Index Cond: (req_initiator.id = request.user_add)
  • Buffers: shared hit=683
104. 1.008 1.008 ↓ 0.0 0 336

Nested Loop (cost=0.56..6.48 rows=2 width=66) (actual time=0.003..0.003 rows=0 loops=336)

105. 0.000 0.000 ↓ 0.0 0 336

Index Scan using fdc_person_root_date_uk on fdc_person per (cost=0.28..5.67 rows=2 width=16) (actual time=0..0 rows=0 loops=336)

  • Index Cond: (per.person_root_id = req_initiator.person_root_id)
  • Filter: ((statement_timestamp() >= per.date_from) AND (statement_timestamp() <= per.date_to))
106. 0.000 0.000 ↓ 0.0 0 0

Index Scan using fdc_individual_id_i on fdc_individual ind (cost=0.29..0.4 rows=1 width=58) (never executed)

  • Index Cond: (ind.id = per.id)
107. 1.657 1.680 ↑ 1.2 71 336

Materialize (cost=0..3.36 rows=82 width=8) (actual time=0..0.005 rows=71 loops=336)

  • Buffers: shared hit=1
108. 0.023 0.023 ↑ 1.2 71 1

Seq Scan on fdc_request_type rt (cost=0..2.95 rows=82 width=8) (actual time=0.013..0.023 rows=71 loops=1)

  • Filter: (rt.is_visible_arm IS TRUE)
  • Buffers: shared hit=1
109. 2.016 2.016 ↑ 1.0 1 336

Index Scan using fdc_person_id_i on fdc_person p (cost=0.42..8.16 rows=1 width=16) (actual time=0.006..0.006 rows=1 loops=336)

  • Index Cond: (p.id = request.org_add)
  • Buffers: shared hit=1349
110. 0.336 2.352 ↓ 0.0 0 336

Nested Loop (cost=2.1..1,480.82 rows=12,068,140 width=24) (actual time=0.007..0.007 rows=0 loops=336)

111. 0.672 2.016 ↓ 0.0 0 336

Nested Loop (cost=1.82..14.99 rows=3,474 width=24) (actual time=0.006..0.006 rows=0 loops=336)

112. 0.336 1.344 ↓ 0.0 0 336

Nested Loop (cost=1.55..14.57 rows=1 width=24) (actual time=0.004..0.004 rows=0 loops=336)

113. 0.336 1.008 ↓ 0.0 0 336

Nested Loop (cost=1.12..9.66 rows=1 width=24) (actual time=0.003..0.003 rows=0 loops=336)

114. 0.672 0.672 ↓ 0.0 0 336

Nested Loop (cost=0.7..4.75 rows=1 width=24) (actual time=0.002..0.002 rows=0 loops=336)

115. 0.000 0.000 ↓ 0.0 0 336

Index Scan using fdc_official_person_pk on fdc_official_person ofp (cost=0.28..0.3 rows=1 width=24) (actual time=0..0 rows=0 loops=336)

  • Index Cond: (ofp.id = per.id)
116. 0.000 0.000 ↓ 0.0 0 0

Index Only Scan using fdc_person_id_i on fdc_person per_1 (cost=0.42..4.45 rows=1 width=8) (never executed)

  • Index Cond: (per_1.id = ofp.id)
117. 0.000 0.000 ↓ 0.0 0 0

Index Scan using fdc_person_id_i on fdc_person ind_ver (cost=0.42..4.91 rows=1 width=16) (never executed)

  • Index Cond: (ind_ver.id = ofp.individual_id)
118. 0.000 0.000 ↓ 0.0 0 0

Index Scan using fdc_person_id_i on fdc_person leg_ver (cost=0.42..4.91 rows=1 width=16) (never executed)

  • Index Cond: (leg_ver.id = ofp.legal_person_id)
119. 0.000 0.000 ↓ 0.0 0 0

Index Scan using fdc_person_root_date_uk on fdc_person ind_per (cost=0.28..0.4 rows=2 width=16) (never executed)

  • Index Cond: (ind_per.person_root_id = ind_ver.person_root_id)
  • Filter: ((statement_timestamp() >= ind_per.date_from) AND (statement_timestamp() <= ind_per.date_to))
120. 0.000 0.000 ↓ 0.0 0 0

Index Scan using fdc_person_root_date_uk on fdc_person leg_per (cost=0.28..0.4 rows=2 width=16) (never executed)

  • Index Cond: (leg_per.person_root_id = leg_ver.person_root_id)
  • Filter: ((statement_timestamp() >= leg_per.date_from) AND (statement_timestamp() <= leg_per.date_to))
121. 0.336 0.336 ↓ 0.0 0 336

Index Scan using fdc_legal_person_id_i on fdc_legal_person lp_op (cost=0.42..1.63 rows=1 width=93) (actual time=0.001..0.001 rows=0 loops=336)

  • Index Cond: (lp_op.id = leg_per.id)
122. 0.000 0.000 ↓ 0.0 0 336

Index Scan using fdc_individual_id_i on fdc_individual ind_op (cost=0.29..0.4 rows=1 width=58) (actual time=0..0 rows=0 loops=336)

  • Index Cond: (ind_op.id = ind_per.id)
123. 8.736 95.088 ↑ 1.0 1 336

Aggregate (cost=245,401.79..245,401.8 rows=1 width=32) (actual time=0.283..0.283 rows=1 loops=336)

  • Buffers: shared hit=24064
124. 1.344 86.352 ↑ 203,283.0 1 336

Nested Loop (cost=12.82..244,385.37 rows=203,283 width=93) (actual time=0.2..0.257 rows=1 loops=336)

  • Buffers: shared hit=24064
125. 1.344 58.464 ↑ 2.0 1 336

Nested Loop (cost=10.72..60.94 rows=2 width=101) (actual time=0.149..0.174 rows=1 loops=336)

  • Buffers: shared hit=15099
126. 1.344 49.728 ↑ 1.0 1 336

Nested Loop (cost=10.44..55.24 rows=1 width=101) (actual time=0.131..0.148 rows=1 loops=336)

  • Buffers: shared hit=12474
127. 5.937 47.712 ↑ 1.0 1 336

Nested Loop (cost=10.16..46.94 rows=1 width=101) (actual time=0.124..0.142 rows=1 loops=336)

  • Filter: CASE WHEN (sp_1.confirmation_is_required OR (sp_1.confirmation_is_required IS NULL)) THEN CASE WHEN ((c_6.code)::text = ANY ('{1,2,5,8,9,10,11,13}'::text[])) THEN true ELSE CASE WHEN (((reqtype_1.code)::text = '077'::text) AND ((c_6.code)::text = '15'::text)) THEN true ELSE false END END ELSE CASE WHEN (((reqtype_1.code)::text = ANY ('{072,079}'::text[])) AND ((c_6.code)::text = '1'::text)) THEN true ELSE false END END
  • Buffers: shared hit=11795
128. 4.032 40.992 ↓ 2.0 2 336

Merge Join (cost=10.16..45.31 rows=1 width=114) (actual time=0.096..0.122 rows=2 loops=336)

  • Buffers: shared hit=11012
129. 1.680 27.888 ↑ 31.7 3 336

Nested Loop (cost=1.71..52.03 rows=95 width=122) (actual time=0.059..0.083 rows=3 loops=336)

  • Buffers: shared hit=9665
130. 2.016 2.016 ↑ 47.5 2 336

Index Scan using fdc_request_type_pk on fdc_request_type reqtype_1 (cost=0.14..17.2 rows=95 width=12) (actual time=0.006..0.006 rows=2 loops=336)

  • Buffers: shared hit=672
131. 1.680 24.192 ↓ 2.0 2 672

Materialize (cost=1.56..33.64 rows=1 width=110) (actual time=0.024..0.036 rows=2 loops=672)

  • Buffers: shared hit=8993
132. 1.797 22.512 ↓ 2.0 2 336

Nested Loop (cost=1.56..33.64 rows=1 width=110) (actual time=0.045..0.067 rows=2 loops=336)

  • Buffers: shared hit=8993
133. 1.686 16.800 ↓ 2.0 2 336

Nested Loop (cost=1.28..25.33 rows=1 width=110) (actual time=0.034..0.05 rows=2 loops=336)

  • Buffers: shared hit=7246
134. 2.133 10.416 ↓ 2.0 2 336

Nested Loop (cost=0.85..16.89 rows=1 width=25) (actual time=0.023..0.031 rows=2 loops=336)

  • Buffers: shared hit=4292
135. 4.368 4.368 ↓ 2.0 2 336

Index Scan using fdc_request_signatory_person_req_i on fdc_request_signatory_person sp_1 (cost=0.43..8.45 rows=1 width=41) (actual time=0.012..0.013 rows=2 loops=336)

  • Index Cond: (sp_1.request_id = request.id)
  • Buffers: shared hit=1453
136. 3.915 3.915 ↑ 1.0 1 783

Index Only Scan using fdc_person_id_i on fdc_person p_2 (cost=0.42..8.44 rows=1 width=8) (actual time=0.005..0.005 rows=1 loops=783)

  • Index Cond: (p_2.id = sp_1.person_id)
  • Heap Fetches: 482
  • Buffers: shared hit=2839
137. 4.698 4.698 ↑ 1.0 1 783

Index Scan using fdc_legal_person_id_i on fdc_legal_person pers_org_1 (cost=0.42..8.44 rows=1 width=93) (actual time=0.006..0.006 rows=1 loops=783)

  • Index Cond: (pers_org_1.id = sp_1.person_id)
  • Buffers: shared hit=2954
138. 3.915 3.915 ↓ 0.0 0 783

Index Only Scan using fdc_individual_id_i on fdc_individual pers_ind_1 (cost=0.29..8.3 rows=1 width=8) (actual time=0.005..0.005 rows=0 loops=783)

  • Index Cond: (pers_ind_1.id = sp_1.person_id)
  • Heap Fetches: 179
  • Buffers: shared hit=1747
139. 4.368 9.072 ↑ 1.0 1 336

Sort (cost=8.46..8.46 rows=1 width=32) (actual time=0.027..0.027 rows=1 loops=336)

  • Sort Key: req_1.request_type_id
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=1347
140. 4.704 4.704 ↑ 1.0 1 336

Index Scan using fdc_request_pk on fdc_request req_1 (cost=0.43..8.45 rows=1 width=32) (actual time=0.013..0.014 rows=1 loops=336)

  • Index Cond: (req_1.id = request.id)
  • Buffers: shared hit=1347
141. 0.783 0.783 ↑ 5.0 3 783

Seq Scan on fdc_signatory_type c_6 (cost=0..1.15 rows=15 width=10) (actual time=0.001..0.001 rows=3 loops=783)

  • Buffers: shared hit=783
142. 0.672 0.672 ↑ 1.0 1 336

Index Scan using fdc_user_id_i on fdc_user usr_1 (cost=0.28..8.3 rows=1 width=16) (actual time=0.002..0.002 rows=1 loops=336)

  • Index Cond: (usr_1.id = req_1.user_add)
  • Buffers: shared hit=679
143. 7.392 7.392 ↑ 2.0 1 336

Index Scan using fdc_person_root_date_uk on fdc_person per_4 (cost=0.28..5.67 rows=2 width=16) (actual time=0.014..0.022 rows=1 loops=336)

  • Index Cond: (per_4.person_root_id = usr_1.person_root_id)
  • Filter: ((statement_timestamp() >= per_4.date_from) AND (statement_timestamp() <= per_4.date_to))
  • Buffers: shared hit=2625
144. 1.521 26.544 ↑ 12,068,140.0 1 336

Nested Loop (cost=2.1..1,480.82 rows=12,068,140 width=8) (actual time=0.047..0.079 rows=1 loops=336)

  • Buffers: shared hit=8965
145. 0.972 14.448 ↑ 3,474.0 1 336

Nested Loop (cost=1.82..14.99 rows=3,474 width=16) (actual time=0.031..0.043 rows=1 loops=336)

  • Buffers: shared hit=5925
146. 0.894 5.376 ↑ 1.0 1 336

Nested Loop (cost=1.55..14.57 rows=1 width=24) (actual time=0.016..0.016 rows=1 loops=336)

  • Buffers: shared hit=3232
147. 1.230 4.032 ↑ 1.0 1 336

Nested Loop (cost=1.12..9.66 rows=1 width=24) (actual time=0.011..0.012 rows=1 loops=336)

  • Buffers: shared hit=2327
148. 1.005 2.352 ↑ 1.0 1 336

Nested Loop (cost=0.7..4.75 rows=1 width=24) (actual time=0.007..0.007 rows=1 loops=336)

  • Buffers: shared hit=1427
149. 0.672 0.672 ↑ 1.0 1 336

Index Scan using fdc_official_person_pk on fdc_official_person ofp_2 (cost=0.28..0.3 rows=1 width=24) (actual time=0.002..0.002 rows=1 loops=336)

  • Index Cond: (ofp_2.id = per_4.id)
  • Buffers: shared hit=676
150. 0.675 0.675 ↑ 1.0 1 225

Index Only Scan using fdc_person_id_i on fdc_person per_5 (cost=0.42..4.45 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=225)

  • Index Cond: (per_5.id = ofp_2.id)
  • Heap Fetches: 75
  • Buffers: shared hit=751
151. 0.450 0.450 ↑ 1.0 1 225

Index Scan using fdc_person_id_i on fdc_person ind_ver_2 (cost=0.42..4.91 rows=1 width=16) (actual time=0.002..0.002 rows=1 loops=225)

  • Index Cond: (ind_ver_2.id = ofp_2.individual_id)
  • Buffers: shared hit=900
152. 0.450 0.450 ↑ 1.0 1 225

Index Scan using fdc_person_id_i on fdc_person leg_ver_2 (cost=0.42..4.91 rows=1 width=16) (actual time=0.002..0.002 rows=1 loops=225)

  • Index Cond: (leg_ver_2.id = ofp_2.legal_person_id)
  • Buffers: shared hit=905
153. 8.100 8.100 ↑ 2.0 1 225

Index Scan using fdc_person_root_date_uk on fdc_person ind_per_3 (cost=0.28..0.4 rows=2 width=8) (actual time=0.019..0.036 rows=1 loops=225)

  • Index Cond: (ind_per_3.person_root_id = ind_ver_2.person_root_id)
  • Filter: ((statement_timestamp() >= ind_per_3.date_from) AND (statement_timestamp() <= ind_per_3.date_to))
  • Buffers: shared hit=2693
154. 10.575 10.575 ↑ 2.0 1 225

Index Scan using fdc_person_root_date_uk on fdc_person leg_per_2 (cost=0.28..0.4 rows=2 width=16) (actual time=0.019..0.047 rows=1 loops=225)

  • Index Cond: (leg_per_2.person_root_id = leg_ver_2.person_root_id)
  • Filter: ((statement_timestamp() >= leg_per_2.date_from) AND (statement_timestamp() <= leg_per_2.date_to))
  • Buffers: shared hit=3040
155. 19.824 77.280 ↑ 1.0 1 336

Aggregate (cost=245,401.82..245,401.83 rows=1 width=32) (actual time=0.23..0.23 rows=1 loops=336)

  • Buffers: shared hit=24599
156. 1.008 57.456 ↑ 203,283.0 1 336

Nested Loop (cost=12.82..244,385.41 rows=203,283 width=93) (actual time=0.131..0.171 rows=1 loops=336)

  • Buffers: shared hit=24061
157. 1.344 33.264 ↑ 2.0 1 336

Nested Loop (cost=10.72..60.97 rows=2 width=101) (actual time=0.081..0.099 rows=1 loops=336)

  • Buffers: shared hit=15096
158. 1.344 24.864 ↑ 1.0 1 336

Nested Loop (cost=10.44..55.28 rows=1 width=101) (actual time=0.064..0.074 rows=1 loops=336)

  • Buffers: shared hit=12471
159. 2.577 22.848 ↑ 1.0 1 336

Nested Loop (cost=10.16..46.98 rows=1 width=101) (actual time=0.058..0.068 rows=1 loops=336)

  • Filter: CASE WHEN (sp_2.confirmation_is_required OR (sp_2.confirmation_is_required IS NULL)) THEN CASE WHEN ((c_7.code)::text = ANY ('{3,4,6,7,12}'::text[])) THEN true ELSE CASE WHEN (((reqtype_2.code)::text = ANY ('{075,081}'::text[])) AND ((c_7.code)::text = '15'::text)) THEN true ELSE false END END ELSE CASE WHEN (((reqtype_2.code)::text = ANY ('{071,072,079}'::text[])) AND ((c_7.code)::text = '3'::text)) THEN true WHEN (((reqtype_2.code)::text = '080'::text) AND ((c_7.code)::text = '1'::text)) THEN true ELSE false END END
  • Buffers: shared hit=11792
160. 2.688 19.488 ↓ 2.0 2 336

Merge Join (cost=10.16..45.31 rows=1 width=114) (actual time=0.043..0.058 rows=2 loops=336)

  • Buffers: shared hit=11009
161. 2.016 14.448 ↑ 31.7 3 336

Nested Loop (cost=1.71..52.03 rows=95 width=122) (actual time=0.03..0.043 rows=3 loops=336)

  • Buffers: shared hit=9662
162. 1.008 1.008 ↑ 47.5 2 336

Index Scan using fdc_request_type_pk on fdc_request_type reqtype_2 (cost=0.14..17.2 rows=95 width=12) (actual time=0.003..0.003 rows=2 loops=336)

  • Buffers: shared hit=672
163. 0.336 11.424 ↓ 2.0 2 672

Materialize (cost=1.56..33.64 rows=1 width=110) (actual time=0.012..0.017 rows=2 loops=672)

  • Buffers: shared hit=8990
164. 1.122 11.088 ↓ 2.0 2 336

Nested Loop (cost=1.56..33.64 rows=1 width=110) (actual time=0.022..0.033 rows=2 loops=336)

  • Buffers: shared hit=8990
165. 1.011 8.400 ↓ 2.0 2 336

Nested Loop (cost=1.28..25.33 rows=1 width=110) (actual time=0.017..0.025 rows=2 loops=336)

  • Buffers: shared hit=7243
166. 2.130 5.040 ↓ 2.0 2 336

Nested Loop (cost=0.85..16.89 rows=1 width=25) (actual time=0.01..0.015 rows=2 loops=336)

  • Buffers: shared hit=4289
167. 1.344 1.344 ↓ 2.0 2 336

Index Scan using fdc_request_signatory_person_req_i on fdc_request_signatory_person sp_2 (cost=0.43..8.45 rows=1 width=41) (actual time=0.003..0.004 rows=2 loops=336)

  • Index Cond: (sp_2.request_id = request.id)
  • Buffers: shared hit=1450
168. 1.566 1.566 ↑ 1.0 1 783

Index Only Scan using fdc_person_id_i on fdc_person p_3 (cost=0.42..8.44 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=783)

  • Index Cond: (p_3.id = sp_2.person_id)
  • Heap Fetches: 482
  • Buffers: shared hit=2839
169. 2.349 2.349 ↑ 1.0 1 783

Index Scan using fdc_legal_person_id_i on fdc_legal_person pers_org_2 (cost=0.42..8.44 rows=1 width=93) (actual time=0.003..0.003 rows=1 loops=783)

  • Index Cond: (pers_org_2.id = sp_2.person_id)
  • Buffers: shared hit=2954
170. 1.566 1.566 ↓ 0.0 0 783

Index Only Scan using fdc_individual_id_i on fdc_individual pers_ind_2 (cost=0.29..8.3 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=783)

  • Index Cond: (pers_ind_2.id = sp_2.person_id)
  • Heap Fetches: 179
  • Buffers: shared hit=1747
171. 1.008 2.352 ↑ 1.0 1 336

Sort (cost=8.46..8.46 rows=1 width=32) (actual time=0.007..0.007 rows=1 loops=336)

  • Sort Key: req_2.request_type_id
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=1347
172. 1.344 1.344 ↑ 1.0 1 336

Index Scan using fdc_request_pk on fdc_request req_2 (cost=0.43..8.45 rows=1 width=32) (actual time=0.004..0.004 rows=1 loops=336)

  • Index Cond: (req_2.id = request.id)
  • Buffers: shared hit=1347
173. 0.783 0.783 ↑ 5.0 3 783

Seq Scan on fdc_signatory_type c_7 (cost=0..1.15 rows=15 width=10) (actual time=0..0.001 rows=3 loops=783)

  • Buffers: shared hit=783
174. 0.672 0.672 ↑ 1.0 1 336

Index Scan using fdc_user_id_i on fdc_user usr_2 (cost=0.28..8.3 rows=1 width=16) (actual time=0.002..0.002 rows=1 loops=336)

  • Index Cond: (usr_2.id = req_2.user_add)
  • Buffers: shared hit=679
175. 7.056 7.056 ↑ 2.0 1 336

Index Scan using fdc_person_root_date_uk on fdc_person per_6 (cost=0.28..5.67 rows=2 width=16) (actual time=0.013..0.021 rows=1 loops=336)

  • Index Cond: (per_6.person_root_id = usr_2.person_root_id)
  • Filter: ((statement_timestamp() >= per_6.date_from) AND (statement_timestamp() <= per_6.date_to))
  • Buffers: shared hit=2625
176. 0.747 23.184 ↑ 12,068,140.0 1 336

Nested Loop (cost=2.1..1,480.82 rows=12,068,140 width=8) (actual time=0.048..0.069 rows=1 loops=336)

  • Buffers: shared hit=8965
177. 1.200 14.112 ↑ 3,474.0 1 336

Nested Loop (cost=1.82..14.99 rows=3,474 width=16) (actual time=0.032..0.042 rows=1 loops=336)

  • Buffers: shared hit=5925
178. 1.005 5.712 ↑ 1.0 1 336

Nested Loop (cost=1.55..14.57 rows=1 width=24) (actual time=0.016..0.017 rows=1 loops=336)

  • Buffers: shared hit=3232
179. 1.230 4.032 ↑ 1.0 1 336

Nested Loop (cost=1.12..9.66 rows=1 width=24) (actual time=0.012..0.012 rows=1 loops=336)

  • Buffers: shared hit=2327
180. 1.005 2.352 ↑ 1.0 1 336

Nested Loop (cost=0.7..4.75 rows=1 width=24) (actual time=0.007..0.007 rows=1 loops=336)

  • Buffers: shared hit=1427
181. 0.672 0.672 ↑ 1.0 1 336

Index Scan using fdc_official_person_pk on fdc_official_person ofp_3 (cost=0.28..0.3 rows=1 width=24) (actual time=0.002..0.002 rows=1 loops=336)

  • Index Cond: (ofp_3.id = per_6.id)
  • Buffers: shared hit=676
182. 0.675 0.675 ↑ 1.0 1 225

Index Only Scan using fdc_person_id_i on fdc_person per_7 (cost=0.42..4.45 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=225)

  • Index Cond: (per_7.id = ofp_3.id)
  • Heap Fetches: 75
  • Buffers: shared hit=751
183. 0.450 0.450 ↑ 1.0 1 225

Index Scan using fdc_person_id_i on fdc_person ind_ver_3 (cost=0.42..4.91 rows=1 width=16) (actual time=0.002..0.002 rows=1 loops=225)

  • Index Cond: (ind_ver_3.id = ofp_3.individual_id)
  • Buffers: shared hit=900
184. 0.675 0.675 ↑ 1.0 1 225

Index Scan using fdc_person_id_i on fdc_person leg_ver_3 (cost=0.42..4.91 rows=1 width=16) (actual time=0.003..0.003 rows=1 loops=225)

  • Index Cond: (leg_ver_3.id = ofp_3.legal_person_id)
  • Buffers: shared hit=905
185. 7.200 7.200 ↑ 2.0 1 225

Index Scan using fdc_person_root_date_uk on fdc_person ind_per_4 (cost=0.28..0.4 rows=2 width=8) (actual time=0.019..0.032 rows=1 loops=225)

  • Index Cond: (ind_per_4.person_root_id = ind_ver_3.person_root_id)
  • Filter: ((statement_timestamp() >= ind_per_4.date_from) AND (statement_timestamp() <= ind_per_4.date_to))
  • Buffers: shared hit=2693
186. 8.325 8.325 ↑ 2.0 1 225

Index Scan using fdc_person_root_date_uk on fdc_person leg_per_3 (cost=0.28..0.4 rows=2 width=16) (actual time=0.019..0.037 rows=1 loops=225)

  • Index Cond: (leg_per_3.person_root_id = leg_ver_3.person_root_id)
  • Filter: ((statement_timestamp() >= leg_per_3.date_from) AND (statement_timestamp() <= leg_per_3.date_to))
  • Buffers: shared hit=3040
187. 0.672 0.672 ↑ 1.0 1 336

Index Scan using fdc_user_id_i on fdc_user u (cost=0.28..4.61 rows=1 width=16) (actual time=0.002..0.002 rows=1 loops=336)

  • Index Cond: (u.id = request.user_add)
  • Buffers: shared hit=679
188.          

SubPlan (for Nested Loop)

189. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=0.85..16.89 rows=1 width=0) (never executed)

190. 0.000 0.000 ↓ 0.0 0 0

Index Scan using fdc_request_signatory_person_req_i on fdc_request_signatory_person sp_3 (cost=0.43..8.45 rows=1 width=8) (never executed)

  • Index Cond: (sp_3.request_id = request.id)
191. 0.000 0.000 ↓ 0.0 0 0

Index Scan using fdc_person_id_i on fdc_person sp_per (cost=0.42..8.44 rows=1 width=8) (never executed)

  • Index Cond: (sp_per.id = sp_3.person_id)
  • Filter: (sp_per.person_root_id = ANY ('{7044114,39889}'::bigint[]))
192. 578.704 999.824 ↑ 3.1 252,347 1

Hash Join (cost=8,570.73..181,687.97 rows=786,838 width=8) (actual time=28.049..999.824 rows=252,347 loops=1)

  • Buffers: shared hit=76226
193. 394.114 394.114 ↑ 1.0 4,417,407 1

Seq Scan on fdc_request_signatory_person sp_4 (cost=0..117,236.81 rows=4,426,181 width=16) (actual time=0.01..394.114 rows=4,417,407 loops=1)

  • Buffers: shared hit=72975
194. 10.135 27.006 ↑ 1.0 63,146 1

Hash (cost=7,776.88..7,776.88 rows=63,508 width=8) (actual time=27.006..27.006 rows=63,146 loops=1)

  • Buffers: shared hit=3251
195. 14.187 16.871 ↑ 1.0 63,146 1

Bitmap Heap Scan on fdc_person sp_per_1 (cost=1,245.03..7,776.88 rows=63,508 width=8) (actual time=3.024..16.871 rows=63,146 loops=1)

  • Heap Blocks: exact=3059
  • Buffers: shared hit=3251
196. 2.684 2.684 ↑ 1.0 63,146 1

Bitmap Index Scan on fdc_person_person_root_i (cost=0..1,229.15 rows=63,508 width=0) (actual time=2.684..2.684 rows=63,146 loops=1)

  • Index Cond: (sp_per_1.person_root_id = ANY ('{7044114,39889}'::bigint[]))
  • Buffers: shared hit=192