explain.depesz.com

PostgreSQL's explain analyze made readable

Result: no16

Settings
# exclusive inclusive rows x rows loops node
1. 0.008 1,328,469.736 ↑ 1.0 1 1

Aggregate (cost=88,584,230.78..88,584,230.79 rows=1 width=8) (actual time=1,328,469.736..1,328,469.736 rows=1 loops=1)

  • Buffers: shared hit=137871850 dirtied=1
2. 0.010 1,328,469.728 ↑ 24,283,237.5 2 1

Nested Loop (cost=3,820.48..88,462,814.59 rows=48,566,475 width=0) (actual time=194,399.744..1,328,469.728 rows=2 loops=1)

  • Buffers: shared hit=137871850 dirtied=1
3. 23.555 1,328,469.700 ↑ 132.0 2 1

Nested Loop (cost=3,818.37..29,309.76 rows=264 width=8) (actual time=194,399.731..1,328,469.7 rows=2 loops=1)

  • Filter: ((alternatives: SubPlan 1 or hashed SubPlan 2) OR (p.person_root_id = '7275633'::bigint))
  • Buffers: shared hit=137871850 dirtied=1
4. 12.065 1,328,329.373 ↓ 6.1 3,156 1

Hash Join (cost=3,817.94..16,295.44 rows=518 width=24) (actual time=388.153..1,328,329.373 rows=3,156 loops=1)

  • Buffers: shared hit=137817267
5. 13.782 1,328,317.269 ↓ 5.3 3,156 1

Nested Loop (cost=3,813.97..16,283.95 rows=600 width=40) (actual time=388.098..1,328,317.269 rows=3,156 loops=1)

  • Buffers: shared hit=137817265
6. 16.369 1,328,303.487 ↓ 18.1 3,156 1

Nested Loop (cost=3,813.69..15,505.34 rows=174 width=40) (actual time=388.081..1,328,303.487 rows=3,156 loops=1)

  • Buffers: shared hit=137817265
7. 12.691 1,328,265.026 ↓ 18.1 3,156 1

Nested Loop (cost=3,813.41..14,727.28 rows=174 width=44) (actual time=388.069..1,328,265.026 rows=3,156 loops=1)

  • Buffers: shared hit=137809702
8. 6.760 491.575 ↓ 18.1 3,156 1

Nested Loop (cost=3,808.88..11,613.69 rows=174 width=44) (actual time=54.721..491.575 rows=3,156 loops=1)

  • Buffers: shared hit=56134
9. 9.903 456.411 ↓ 18.1 3,156 1

Nested Loop (cost=3,800.58..10,164.71 rows=174 width=44) (actual time=54.708..456.411 rows=3,156 loops=1)

  • Buffers: shared hit=49822
10. 12.393 386.544 ↓ 18.1 3,156 1

Nested Loop (cost=3,792.13..8,689.62 rows=174 width=44) (actual time=54.69..386.544 rows=3,156 loops=1)

  • Buffers: shared hit=37188
11. 10.125 311.031 ↓ 18.1 3,156 1

Hash Join (cost=3,783.67..7,214.54 rows=174 width=44) (actual time=54.667..311.031 rows=3,156 loops=1)

  • Buffers: shared hit=27645
12. 9.874 300.866 ↓ 18.1 3,156 1

Hash Join (cost=3,779.54..7,208.22 rows=174 width=32) (actual time=54.614..300.866 rows=3,156 loops=1)

  • Buffers: shared hit=27643
13. 8.340 290.985 ↓ 18.1 3,156 1

Hash Join (cost=3,778.29..7,204.92 rows=174 width=40) (actual time=54.588..290.985 rows=3,156 loops=1)

  • Buffers: shared hit=27642
14. 15.830 282.613 ↓ 18.1 3,156 1

Nested Loop (cost=3,775.41..7,201.38 rows=174 width=48) (actual time=54.544..282.613 rows=3,156 loops=1)

  • Buffers: shared hit=27640
15. 17.620 70.677 ↓ 18.0 3,163 1

Bitmap Heap Scan on fdc_request request (cost=3,774.98..5,521.77 rows=176 width=32) (actual time=54.313..70.677 rows=3,163 loops=1)

  • Heap Blocks: exact=2446
  • Buffers: shared hit=5238
16. 3.445 53.057 ↓ 0.0 0 1

BitmapAnd (cost=3,774.98..3,774.98 rows=176 width=0) (actual time=53.057..53.057 rows=0 loops=1)

  • Buffers: shared hit=2792
17. 26.106 26.106 ↓ 9.3 136,867 1

Bitmap Index Scan on fdc_request_rtype_i (cost=0..954.34 rows=14,684 width=0) (actual time=26.106..26.106 rows=136,867 loops=1)

  • Index Cond: ((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=1742
18. 23.506 23.506 ↓ 1.7 118,941 1

Bitmap Index Scan on fdc_request_request_date_i (cost=0..2,820.3 rows=71,587 width=0) (actual time=23.506..23.506 rows=118,941 loops=1)

  • Index Cond: ((request.request_date >= '2020-03-24 00:00:00'::timestamp without time zone) AND (request.request_date < '2020-03-26 00:00:00'::timestamp without time zone))
  • Buffers: shared hit=1050
19. 196.106 196.106 ↑ 1.0 1 3,163

Index Scan using fdc_request_status_history_request_i on fdc_request_status_history rsh (cost=0.43..9.53 rows=1 width=24) (actual time=0.054..0.062 rows=1 loops=3,163)

  • 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=22402
20. 0.005 0.032 ↑ 1.0 25 1

Hash (cost=2.56..2.56 rows=25 width=8) (actual time=0.032..0.032 rows=25 loops=1)

  • Buffers: shared hit=2
21. 0.013 0.027 ↑ 1.0 25 1

Hash Join (cost=1.07..2.56 rows=25 width=8) (actual time=0.02..0.027 rows=25 loops=1)

  • Buffers: shared hit=2
22. 0.006 0.006 ↑ 1.0 25 1

Seq Scan on fdc_change_status_reason c_1 (cost=0..1.25 rows=25 width=16) (actual time=0.005..0.006 rows=25 loops=1)

  • Buffers: shared hit=1
23. 0.003 0.008 ↑ 1.0 3 1

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

  • Buffers: shared hit=1
24. 0.005 0.005 ↑ 1.0 3 1

Seq Scan on fdc_object_type c_2 (cost=0..1.03 rows=3 width=8) (actual time=0.004..0.005 rows=3 loops=1)

  • Buffers: shared hit=1
25. 0.003 0.007 ↑ 1.0 11 1

Hash (cost=1.11..1.11 rows=11 width=8) (actual time=0.007..0.007 rows=11 loops=1)

  • Buffers: shared hit=1
26. 0.004 0.004 ↑ 1.0 11 1

Seq Scan on fdc_request_status c (cost=0..1.11 rows=11 width=8) (actual time=0.003..0.004 rows=11 loops=1)

  • Buffers: shared hit=1
27. 0.030 0.040 ↑ 1.0 95 1

Hash (cost=2.95..2.95 rows=95 width=12) (actual time=0.04..0.04 rows=95 loops=1)

  • Buffers: shared hit=2
28. 0.010 0.010 ↑ 1.0 95 1

Seq Scan on fdc_request_type c_3 (cost=0..2.95 rows=95 width=12) (actual time=0.002..0.01 rows=95 loops=1)

  • Buffers: shared hit=2
29. 9.468 63.120 ↓ 0.0 0 3,156

Limit (cost=8.45..8.46 rows=1 width=1,044) (actual time=0.02..0.02 rows=0 loops=3,156)

  • Buffers: shared hit=9543
30. 25.248 53.652 ↓ 0.0 0 3,156

Sort (cost=8.45..8.46 rows=1 width=1,044) (actual time=0.017..0.017 rows=0 loops=3,156)

  • Sort Key: e.start_date
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=9543
31. 28.404 28.404 ↓ 0.0 0 3,156

Index Scan using fdc_pts_encumbrance_start_request_i on fdc_pts_encumbrance e (cost=0.42..8.44 rows=1 width=1,044) (actual time=0.009..0.009 rows=0 loops=3,156)

  • Index Cond: (e.start_request_id = request.id)
  • Buffers: shared hit=9543
32. 9.468 59.964 ↑ 1.0 1 3,156

Limit (cost=8.45..8.46 rows=1 width=1,044) (actual time=0.019..0.019 rows=1 loops=3,156)

  • Buffers: shared hit=12634
33. 12.624 50.496 ↑ 1.0 1 3,156

Sort (cost=8.45..8.46 rows=1 width=1,044) (actual time=0.016..0.016 rows=1 loops=3,156)

  • Sort Key: fdc_pts_ownership.date_add
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=12634
34. 37.872 37.872 ↑ 1.0 1 3,156

Index Scan using fdc_pts_ownership_req_i on fdc_pts_ownership fdc_pts_ownership (cost=0.42..8.44 rows=1 width=1,044) (actual time=0.011..0.012 rows=1 loops=3,156)

  • Index Cond: (fdc_pts_ownership.request_id = request.id)
  • Buffers: shared hit=12634
35. 6.312 28.404 ↓ 0.0 0 3,156

Limit (cost=8.3..8.31 rows=1 width=1,044) (actual time=0.009..0.009 rows=0 loops=3,156)

  • Buffers: shared hit=6312
36. 9.468 22.092 ↓ 0.0 0 3,156

Sort (cost=8.3..8.31 rows=1 width=1,044) (actual time=0.007..0.007 rows=0 loops=3,156)

  • Sort Key: fdc_pts_dealer.start_date
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=6312
37. 12.624 12.624 ↓ 0.0 0 3,156

Index Scan using fdc_pts_dealer_start_request_i on fdc_pts_dealer fdc_pts_dealer (cost=0.28..8.29 rows=1 width=1,044) (actual time=0.004..0.004 rows=0 loops=3,156)

  • Index Cond: (fdc_pts_dealer.start_request_id = request.id)
  • Buffers: shared hit=6312
38. 6.312 1,327,760.760 ↑ 1.0 1 3,156

Limit (cost=4.53..17.87 rows=1 width=2,505) (actual time=420.71..420.71 rows=1 loops=3,156)

  • Buffers: shared hit=137753568
39. 9.468 1,327,754.448 ↑ 149,320.0 1 3,156

Result (cost=4.53..1,993,306.67 rows=149,320 width=2,505) (actual time=420.708..420.708 rows=1 loops=3,156)

  • Buffers: shared hit=137753568
40. 29.355 1,327,744.980 ↑ 149,320.0 1 3,156

Nested Loop (cost=4.53..1,993,306.67 rows=149,320 width=2,505) (actual time=420.705..420.705 rows=1 loops=3,156)

  • 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=137753568
41. 20.838 1,327,700.796 ↑ 276,196.5 2 3,156

Nested Loop (cost=4.1..1,708,761.74 rows=552,393 width=34) (actual time=295.458..420.691 rows=2 loops=3,156)

  • Buffers: shared hit=137738174
42. 33.400 1,327,650.300 ↑ 276,196.5 2 3,156

Nested Loop (cost=3.67..1,151,743.66 rows=552,393 width=34) (actual time=295.447..420.675 rows=2 loops=3,156)

  • Buffers: shared hit=137726510
43. 176,801.313 1,327,063.284 ↑ 1.5 2 3,156

Nested Loop (cost=1.56..146,817.47 rows=3 width=34) (actual time=295.335..420.489 rows=2 loops=3,156)

  • Buffers: shared hit=137592834
44. 17,808.353 1,018,832.544 ↑ 1.5 2 3,156

Nested Loop (cost=1.56..106,744.69 rows=3 width=34) (actual time=232.982..322.824 rows=2 loops=3,156)

  • Buffers: shared hit=137587069
45. 35.709 988,424.484 ↑ 1.5 2 3,156

Nested Loop (cost=1.56..101,642.06 rows=3 width=26) (actual time=226.825..313.189 rows=2 loops=3,156)

  • Buffers: shared hit=137585246
46. 3,693.287 988,225.656 ↓ 2.0 2 3,156

Nested Loop (cost=1.28..101,637.59 rows=1 width=26) (actual time=226.787..313.126 rows=2 loops=3,156)

  • Buffers: shared hit=137548690
47. 17,123.691 981,452.880 ↓ 2.0 2 3,156

Nested Loop (cost=1.28..100,841.03 rows=1 width=26) (actual time=225.446..310.98 rows=2 loops=3,156)

  • Buffers: shared hit=135598640
48. 99.738 950,315.784 ↓ 2.0 2 3,156

Nested Loop (cost=1.28..81,651.25 rows=1 width=26) (actual time=218.905..301.114 rows=2 loops=3,156)

  • Buffers: shared hit=133632668
49. 27.265 950,186.388 ↓ 2.0 2 3,156

Nested Loop (cost=1.28..81,647.11 rows=1 width=34) (actual time=218.878..301.073 rows=2 loops=3,156)

  • Buffers: shared hit=133627725
50. 37.538 950,094.864 ↓ 2.0 2 3,156

Nested Loop (cost=0.84..81,638.65 rows=1 width=18) (actual time=218.86..301.044 rows=2 loops=3,156)

  • Buffers: shared hit=133607934
51. 150,170.788 949,750.860 ↓ 2.0 2 3,156

Nested Loop (cost=0.56..81,629.72 rows=1 width=24) (actual time=218.791..300.935 rows=2 loops=3,156)

  • Buffers: shared hit=133593104
52. 23,773.124 401,787.204 ↓ 2.0 2 3,156

Nested Loop (cost=0.56..51,970 rows=1 width=32) (actual time=107.89..127.309 rows=2 loops=3,156)

  • Buffers: shared hit=48291611
53. 55,087.809 346,715.004 ↓ 2.0 2 3,156

Nested Loop (cost=0.56..48,863.67 rows=1 width=40) (actual time=96.812..109.859 rows=2 loops=3,156)

  • Buffers: shared hit=39363140
54. 80,365.914 146,258.508 ↓ 2.0 2 3,156

Nested Loop (cost=0.56..19,203.95 rows=1 width=40) (actual time=40.547..46.343 rows=2 loops=3,156)

  • Buffers: shared hit=9158335
55. 25.217 318.756 ↓ 2.0 2 3,156

Nested Loop (cost=0.56..14.16 rows=1 width=32) (actual time=0.061..0.101 rows=2 loops=3,156)

  • Buffers: shared hit=23378
56. 31.560 31.560 ↓ 2.0 2 3,156

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.008..0.01 rows=2 loops=3,156)

  • Index Cond: (sp.request_id = request.id)
  • Buffers: shared hit=13490
57. 9.886 261.979 ↑ 1.0 1 4,943

Nested Loop (cost=0.13..5.71 rows=1 width=8) (actual time=0.052..0.053 rows=1 loops=4,943)

  • Buffers: shared hit=9887
58. 39.544 247.150 ↑ 1.0 1 4,943

Nested Loop (cost=0.13..5.68 rows=1 width=8) (actual time=0.049..0.05 rows=1 loops=4,943)

  • Buffers: shared hit=9887
59. 19.772 19.772 ↑ 1.0 1 4,943

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=4,943)

  • Index Cond: (c_4.id = sp.person_type_id)
  • Buffers: shared hit=4944
60. 187.834 187.834 ↑ 6.0 1 4,943

Seq Scan on fdc_person_type_translation t (cost=0..1.45 rows=6 width=8) (actual time=0.038..0.038 rows=1 loops=4,943)

  • Filter: (t.language_id = lang.get_current_lang_id())
  • Buffers: shared hit=4943
61. 4.943 4.943 ↑ 1.0 1 4,943

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

62. 65,573.838 65,573.838 ↑ 2.9 206,693 4,943

Seq Scan on fdc_person p_1 (cost=0..11,731.57 rows=596,657 width=16) (actual time=0.002..13.266 rows=206,693 loops=4,943)

  • Buffers: shared hit=9134957
63. 145,368.687 145,368.687 ↑ 2.8 198,876 4,943

Seq Scan on fdc_legal_person pers_org (cost=0..22,768.21 rows=551,321 width=8) (actual time=0.002..29.409 rows=198,876 loops=4,943)

  • Buffers: shared hit=30204805
64. 31,299.076 31,299.076 ↑ 1.0 55,678 4,943

Seq Scan on fdc_individual pers_ind (cost=0..2,393.37 rows=57,037 width=8) (actual time=0.002..6.332 rows=55,678 loops=4,943)

  • Buffers: shared hit=8928471
65. 397,792.868 397,792.868 ↑ 1.0 544,493 4,943

Seq Scan on fdc_legal_person pers_lp (cost=0..22,768.21 rows=551,321 width=8) (actual time=0.002..80.476 rows=544,493 loops=4,943)

  • Buffers: shared hit=85301493
66. 247.150 306.466 ↑ 1.0 1 4,943

Nested Loop (cost=0.28..8.92 rows=1 width=10) (actual time=0.061..0.062 rows=1 loops=4,943)

  • Buffers: shared hit=14830
67. 39.544 39.544 ↑ 1.0 1 4,943

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=4,943)

  • Index Cond: (c_5.id = sp.signatory_type_id)
  • Buffers: shared hit=9886
68. 19.772 19.772 ↑ 1.0 1 4,943

Index Only Scan using fdc_signatory_type_translation_stype_i on fdc_signatory_type_translation t_1 (cost=0.14..0.7 rows=1 width=8) (actual time=0.004..0.004 rows=1 loops=4,943)

  • Index Cond: ((t_1.signatory_type_id = c_5.id) AND (t_1.language_id = lang.get_current_lang_id()))
  • Buffers: shared hit=4944
69. 64.259 64.259 ↑ 1.0 1 4,943

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=4,943)

  • Index Cond: (req.id = request.id)
  • Buffers: shared hit=19791
70. 29.658 29.658 ↑ 1.2 80 4,943

Seq Scan on fdc_request_type reqtype (cost=0..2.95 rows=95 width=8) (actual time=0.003..0.006 rows=80 loops=4,943)

  • Buffers: shared hit=4943
71. 14,013.405 14,013.405 ↑ 12.6 47,289 4,943

Seq Scan on fdc_person org (cost=0..11,731.57 rows=596,657 width=16) (actual time=0.003..2.835 rows=47,289 loops=4,943)

  • Buffers: shared hit=1965972
72. 3,079.489 3,079.489 ↑ 1.4 4,492 4,943

Seq Scan on fdc_user usr (cost=0..715.69 rows=6,469 width=16) (actual time=0.002..0.623 rows=4,492 loops=4,943)

  • Buffers: shared hit=1950050
73. 163.119 163.119 ↑ 3.0 1 4,943

Index Scan using fdc_person_root_date_uk on fdc_person per_2 (cost=0.28..4.44 rows=3 width=16) (actual time=0.03..0.033 rows=1 loops=4,943)

  • 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=36556
74. 12,590.688 12,599.707 ↑ 1.0 55,879 4,943

Materialize (cost=0..2,678.55 rows=57,037 width=8) (actual time=0.001..2.549 rows=55,879 loops=4,943)

  • Buffers: shared hit=1823
75. 9.019 9.019 ↑ 1.0 55,879 1

Seq Scan on fdc_individual ind (cost=0..2,393.37 rows=57,037 width=8) (actual time=0.005..9.019 rows=55,879 loops=1)

  • Buffers: shared hit=1823
76. 131,366.118 131,429.427 ↓ 1.0 603,694 4,943

Materialize (cost=0..14,714.85 rows=596,657 width=16) (actual time=0.001..26.589 rows=603,694 loops=4,943)

  • Buffers: shared hit=5765
77. 63.309 63.309 ↓ 1.0 603,694 1

Seq Scan on fdc_person ind_per_1 (cost=0..11,731.57 rows=596,657 width=16) (actual time=0.011..63.309 rows=603,694 loops=1)

  • Buffers: shared hit=5765
78. 23.362 553.616 ↑ 33,244,119.0 1 4,943

Nested Loop (cost=2.12..2,534.21 rows=33,244,119 width=16) (actual time=0.102..0.112 rows=1 loops=4,943)

  • Buffers: shared hit=133676
79. 22.843 380.611 ↑ 5,766.0 1 4,943

Nested Loop (cost=1.84..15.85 rows=5,766 width=16) (actual time=0.074..0.077 rows=1 loops=4,943)

  • Buffers: shared hit=92031
80. 11.579 192.777 ↑ 1.0 1 4,943

Nested Loop (cost=1.56..15.41 rows=1 width=24) (actual time=0.039..0.039 rows=1 loops=4,943)

  • Buffers: shared hit=54287
81. 19.253 158.176 ↑ 1.0 1 4,943

Nested Loop (cost=1.13..9.86 rows=1 width=24) (actual time=0.031..0.032 rows=1 loops=4,943)

  • Buffers: shared hit=38893
82. 33.563 123.575 ↑ 1.0 1 4,943

Nested Loop (cost=0.71..4.3 rows=1 width=24) (actual time=0.025..0.025 rows=1 loops=4,943)

  • Buffers: shared hit=23540
83. 59.316 59.316 ↑ 1.0 1 4,943

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.012 rows=1 loops=4,943)

  • Index Cond: (ofp_1.id = per_2.id)
  • Buffers: shared hit=11520
84. 30.696 30.696 ↑ 1.0 1 3,837

Index Only Scan using fdc_person_id_i on fdc_person per_3 (cost=0.42..4 rows=1 width=8) (actual time=0.008..0.008 rows=1 loops=3,837)

  • Index Cond: (per_3.id = ofp_1.id)
  • Heap Fetches: 508
  • Buffers: shared hit=12020
85. 15.348 15.348 ↑ 1.0 1 3,837

Index Scan using fdc_person_id_i on fdc_person ind_ver_1 (cost=0.42..5.56 rows=1 width=16) (actual time=0.004..0.004 rows=1 loops=3,837)

  • Index Cond: (ind_ver_1.id = ofp_1.individual_id)
  • Buffers: shared hit=15353
86. 23.022 23.022 ↑ 1.0 1 3,837

Index Scan using fdc_person_id_i on fdc_person leg_ver_1 (cost=0.42..5.56 rows=1 width=16) (actual time=0.006..0.006 rows=1 loops=3,837)

  • Index Cond: (leg_ver_1.id = ofp_1.legal_person_id)
  • Buffers: shared hit=15394
87. 164.991 164.991 ↑ 3.0 1 3,837

Index Scan using fdc_person_root_date_uk on fdc_person ind_per_2 (cost=0.28..0.41 rows=3 width=8) (actual time=0.038..0.043 rows=1 loops=3,837)

  • 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=37744
88. 149.643 149.643 ↑ 3.0 1 3,837

Index Scan using fdc_person_root_date_uk on fdc_person leg_per_1 (cost=0.28..0.41 rows=3 width=16) (actual time=0.031..0.039 rows=1 loops=3,837)

  • 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=41645
89. 29.658 29.658 ↑ 1.0 1 4,943

Index Only Scan using fdc_legal_person_id_i on fdc_legal_person lp_op (cost=0.42..1.01 rows=1 width=8) (actual time=0.006..0.006 rows=1 loops=4,943)

  • Index Cond: (lp_op.id = leg_per_1.id)
  • Heap Fetches: 150
  • Buffers: shared hit=11664
90. 14.829 14.829 ↑ 1.0 1 4,943

Index Scan using fdc_person_id_i on fdc_person lp_per (cost=0.42..0.5 rows=1 width=16) (actual time=0.003..0.003 rows=1 loops=4,943)

  • Index Cond: (lp_op.id = lp_per.id)
  • Buffers: shared hit=15394
91. 22.092 22.092 ↑ 1.0 1 3,156

Index Scan using fdc_user_id_i on fdc_user req_initiator (cost=0.28..4.46 rows=1 width=16) (actual time=0.006..0.007 rows=1 loops=3,156)

  • Index Cond: (req_initiator.id = request.user_add)
  • Buffers: shared hit=7563
92. 0.000 0.000 ↓ 0.0 0 3,156

Index Scan using fdc_person_root_date_uk on fdc_person per (cost=0.28..4.44 rows=3 width=16) (actual time=0..0 rows=0 loops=3,156)

  • Index Cond: (per.person_root_id = req_initiator.person_root_id)
  • Filter: ((statement_timestamp() >= per.date_from) AND (statement_timestamp() <= per.date_to))
93. 0.014 0.039 ↑ 1.0 82 1

Hash (cost=2.95..2.95 rows=82 width=8) (actual time=0.039..0.039 rows=82 loops=1)

  • Buffers: shared hit=2
94. 0.025 0.025 ↑ 1.0 82 1

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

  • Filter: (rt.is_visible_arm IS TRUE)
  • Buffers: shared hit=2
95. 15.780 15.780 ↑ 1.0 1 3,156

Index Scan using fdc_person_id_i on fdc_person p (cost=0.42..8.22 rows=1 width=16) (actual time=0.005..0.005 rows=1 loops=3,156)

  • Index Cond: (p.id = request.org_add)
  • Buffers: shared hit=12657
96.          

SubPlan (for Nested Loop)

97. 15.078 100.992 ↓ 0.0 0 3,156

Nested Loop (cost=0.86..16.9 rows=1 width=0) (actual time=0.032..0.032 rows=0 loops=3,156)

  • Buffers: shared hit=41926 dirtied=1
98. 44.184 44.184 ↓ 2.0 2 3,156

Index Scan using fdc_request_signatory_person_req_i on fdc_request_signatory_person sp_1 (cost=0.43..8.45 rows=1 width=8) (actual time=0.012..0.014 rows=2 loops=3,156)

  • Index Cond: (sp_1.request_id = request.id)
  • Buffers: shared hit=14042 dirtied=1
99. 41.730 41.730 ↓ 0.0 0 6,955

Index Scan using fdc_person_id_i on fdc_person sp_per (cost=0.42..8.45 rows=1 width=8) (actual time=0.006..0.006 rows=0 loops=6,955)

  • Index Cond: (sp_per.id = sp_1.person_id)
  • Filter: (sp_per.person_root_id = ANY ('{7275633,NULL}'::bigint[]))
  • Buffers: shared hit=27884
100. 0.000 0.000 ↓ 0.0 0 0

Hash Join (cost=6,342.59..257,035.08 rows=120,341 width=8) (never executed)

101. 0.000 0.000 ↓ 0.0 0 0

Seq Scan on fdc_request_signatory_person sp_2 (cost=0..168,952.01 rows=6,474,501 width=16) (never executed)

102. 0.000 0.000 ↓ 0.0 0 0

Hash (cost=6,203.97..6,203.97 rows=11,090 width=8) (never executed)

103. 0.000 0.000 ↓ 0.0 0 0

Bitmap Heap Scan on fdc_person sp_per_1 (cost=246.8..6,203.97 rows=11,090 width=8) (never executed)

104. 0.000 0.000 ↓ 0.0 0 0

Bitmap Index Scan on fdc_person_person_root_i (cost=0..244.03 rows=11,090 width=0) (never executed)

  • Index Cond: (sp_per_1.person_root_id = ANY ('{7275633,NULL}'::bigint[]))
105. 0.004 0.018 ↓ 0.0 0 2

Nested Loop (cost=2.12..2,534.21 rows=33,244,119 width=8) (actual time=0.009..0.009 rows=0 loops=2)

106. 0.002 0.014 ↓ 0.0 0 2

Nested Loop (cost=1.84..15.85 rows=5,766 width=16) (actual time=0.007..0.007 rows=0 loops=2)

107. 0.002 0.012 ↓ 0.0 0 2

Nested Loop (cost=1.56..15.41 rows=1 width=24) (actual time=0.006..0.006 rows=0 loops=2)

108. 0.004 0.010 ↓ 0.0 0 2

Nested Loop (cost=1.13..9.86 rows=1 width=24) (actual time=0.005..0.005 rows=0 loops=2)

109. 0.002 0.006 ↓ 0.0 0 2

Nested Loop (cost=0.71..4.3 rows=1 width=24) (actual time=0.003..0.003 rows=0 loops=2)

110. 0.004 0.004 ↓ 0.0 0 2

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

  • Index Cond: (ofp.id = per.id)
111. 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 rows=1 width=8) (never executed)

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

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

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

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

  • Index Cond: (leg_ver.id = ofp.legal_person_id)
114. 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.41 rows=3 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))
115. 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.41 rows=3 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))