explain.depesz.com

PostgreSQL's explain analyze made readable

Result: o5ww

Settings
# exclusive inclusive rows x rows loops node
1. 0.039 11,638,303.453 ↑ 1.0 1 1

Aggregate (cost=138,437.56..138,437.57 rows=1 width=8) (actual time=11,638,303.453..11,638,303.453 rows=1 loops=1)

  • Buffers: shared hit=1,518,776,891 read=35
2. 0.011 11,638,303.414 ↑ 833.3 12 1

Limit (cost=77,728.46..138,312.56 rows=10,000 width=8) (actual time=4,575,867.835..11,638,303.414 rows=12 loops=1)

  • Buffers: shared hit=1,518,776,891 read=35
3.          

Initplan (for Limit)

4. 0.000 0.000 ↓ 0.0 0 0

Result (cost=0..0.01 rows=1 width=8) (never executed)

5. 114.230 11,638,303.403 ↑ 50,741,886.1 12 1

Merge Join (cost=77,728.45..3,689,059,408.11 rows=608,902,633 width=8) (actual time=4,575,867.834..11,638,303.403 rows=12 loops=1)

  • Filter: ((alternatives: SubPlan 2 or hashed SubPlan 3) OR (p.person_root_id = '6444092'::bigint) OR (u.person_root_id = '8998555'::bigint))
  • Buffers: shared hit=1,518,776,891 read=35
6. 43.300 11,636,456.615 ↑ 85,248.4 14,222 1

Nested Loop (cost=77,689.2..2,728,882,024.85 rows=1,212,402,971 width=24) (actual time=1,148.776..11,636,456.615 rows=14,222 loops=1)

  • Buffers: shared hit=1,518,637,241 read=35
7. 57.975 11,636,313.761 ↓ 3.5 14,222 1

Nested Loop (cost=77,687.09..230,741.17 rows=4,015 width=32) (actual time=1,148.763..11,636,313.761 rows=14,222 loops=1)

  • Buffers: shared hit=1,518,637,241 read=35
8. 73.913 11,636,127.788 ↓ 3.5 14,222 1

Nested Loop (cost=77,686.66..203,737.75 rows=4,015 width=32) (actual time=1,148.748..11,636,127.788 rows=14,222 loops=1)

  • Buffers: shared hit=1,518,580,446 read=35
9. 90.350 11,635,911.655 ↓ 1.2 14,222 1

Nested Loop (cost=77,686.52..201,607.58 rows=11,920 width=48) (actual time=1,148.735..11,635,911.655 rows=14,222 loops=1)

  • Buffers: shared hit=1,518,552,002 read=35
10. 41.348 11,635,821.305 ↓ 5.7 14,222 1

Nested Loop (cost=77,686.24..188,090.38 rows=2,482 width=48) (actual time=1,148.708..11,635,821.305 rows=14,222 loops=1)

  • Buffers: shared hit=1,518,552,002 read=35
11. 33.082 1,245.305 ↓ 5.7 14,222 1

Nested Loop (cost=77,681.3..140,476.91 rows=2,482 width=52) (actual time=282.293..1,245.305 rows=14,222 loops=1)

  • Buffers: shared hit=226,798
12. 47.161 1,070.003 ↓ 5.7 14,222 1

Nested Loop (cost=77,672.99..119,808.06 rows=2,482 width=52) (actual time=282.274..1,070.003 rows=14,222 loops=1)

  • Buffers: shared hit=198,354
13. 42.010 795.290 ↓ 5.7 14,222 1

Nested Loop (cost=77,664.54..98,766.9 rows=2,482 width=52) (actual time=282.254..795.29 rows=14,222 loops=1)

  • Buffers: shared hit=152,801
14. 51.359 369.286 ↓ 5.7 14,222 1

Merge Join (cost=77,656.09..77,725.75 rows=2,482 width=52) (actual time=282.228..369.286 rows=14,222 loops=1)

  • Buffers: shared hit=110,135
15. 30.875 303.137 ↓ 5.7 14,222 1

Sort (cost=75,981.93..75,988.14 rows=2,482 width=44) (actual time=275.253..303.137 rows=14,222 loops=1)

  • Sort Key: request.user_add
  • Sort Method: quicksort Memory: 1,496kB
  • Buffers: shared hit=109,323
16. 2.262 272.262 ↓ 5.7 14,222 1

Merge Join (cost=75,804.42..75,841.98 rows=2,482 width=44) (actual time=269.229..272.262 rows=14,222 loops=1)

  • Buffers: shared hit=109,323
17. 4.825 269.954 ↓ 5.7 14,222 1

Sort (cost=75,798.35..75,804.55 rows=2,482 width=32) (actual time=269.181..269.954 rows=14,222 loops=1)

  • Sort Key: request.request_type_id
  • Sort Method: quicksort Memory: 1,496kB
  • Buffers: shared hit=109,321
18. 0.000 265.129 ↓ 5.7 14,222 1

Nested Loop (cost=13,380.29..75,658.4 rows=2,482 width=32) (actual time=127.687..265.129 rows=14,222 loops=1)

  • Buffers: shared hit=109,321
19. 2.345 253.284 ↓ 5.7 14,222 1

Hash Join (cost=13,380.15..75,282.81 rows=2,482 width=40) (actual time=127.671..253.284 rows=14,222 loops=1)

  • Buffers: shared hit=95,098
20. 9.773 250.890 ↓ 5.7 14,222 1

Nested Loop (cost=13,377.28..75,270.62 rows=2,482 width=48) (actual time=127.611..250.89 rows=14,222 loops=1)

  • Buffers: shared hit=95,096
21. 14.607 141.115 ↓ 5.9 14,286 1

Bitmap Heap Scan on fdc_request request (cost=13,376.84..51,530.11 rows=2,437 width=32) (actual time=127.399..141.115 rows=14,286 loops=1)

  • Heap Blocks: exact=5,661
  • Buffers: shared hit=14,855
22. 4.639 126.508 ↓ 0.0 0 1

BitmapAnd (cost=13,376.84..13,376.84 rows=2,437 width=0) (actual time=126.508..126.508 rows=0 loops=1)

  • Buffers: shared hit=9,194
23. 18.682 18.682 ↓ 1.0 88,842 1

Bitmap Index Scan on fdc_request_request_date_i (cost=0..3,533.78 rows=85,735 width=0) (actual time=18.682..18.682 rows=88,842 loops=1)

  • Index Cond: ((request.request_date >= '2020-06-01 00:00:00'::timestamp without time zone) AND (request.request_date < '2020-06-04 00:00:00'::timestamp without time zone))
  • Buffers: shared hit=690
24. 103.187 103.187 ↓ 4.5 953,620 1

Bitmap Index Scan on fdc_request_rtype_i (cost=0..9,841.59 rows=212,580 width=0) (actual time=103.187..103.187 rows=953,620 loops=1)

  • Index Cond: ((request.request_type_id = ANY (ARRAY[nsi.c_request_type_031_id(), nsi.c_request_type_101_id(), nsi.c_request_type_114_id(), nsi.c_request_type_115_id(), nsi.c_request_type_116_id(), nsi.c_request_type_117_id(), nsi.c_request_type_118_id(), nsi.c_request_type_119_id(), nsi.c_request_type_120_id(), nsi.c_request_type_121_id(), nsi.c_request_type_122_id(), nsi.c_request_type_123_id(), nsi.c_request_type_124_id(), nsi.c_request_type_125_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(), nsi.c_request_type_052_id(), nsi.c_request_type_101_id(), nsi.c_request_type_114_id(), nsi.c_request_type_115_id(), nsi.c_request_type_116_id(), nsi.c_request_type_117_id(), nsi.c_request_type_118_id(), nsi.c_request_type_119_id(), nsi.c_request_type_120_id(), nsi.c_request_type_121_id(), nsi.c_request_type_122_id(), nsi.c_request_type_123_id(), nsi.c_request_type_124_id(), nsi.c_request_type_125_id(), nsi.c_request_type_048_id()])))
  • Buffers: shared hit=8,504
25. 100.002 100.002 ↑ 1.0 1 14,286

Index Scan using fdc_request_status_history_request_i on fdc_request_status_history rsh (cost=0.44..9.73 rows=1 width=24) (actual time=0.006..0.007 rows=1 loops=14,286)

  • 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=80,241
26. 0.007 0.049 ↑ 1.0 25 1

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

  • Buffers: shared hit=2
27. 0.028 0.042 ↑ 1.0 25 1

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

  • Buffers: shared hit=2
28. 0.005 0.005 ↑ 1.0 25 1

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

  • Buffers: shared hit=1
29. 0.004 0.009 ↑ 1.0 3 1

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

  • Buffers: shared hit=1
30. 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
31. 14.222 14.222 ↑ 1.0 1 14,222

Index Only Scan using fdc_request_status_pk on fdc_request_status c (cost=0.14..0.15 rows=1 width=8) (actual time=0.001..0.001 rows=1 loops=14,222)

  • Index Cond: (c.id = rsh.status_id)
  • Buffers: shared hit=14,223
32. 0.028 0.046 ↑ 1.9 49 1

Sort (cost=6.07..6.31 rows=95 width=12) (actual time=0.043..0.046 rows=49 loops=1)

  • Sort Key: c_3.id
  • Sort Method: quicksort Memory: 29kB
  • Buffers: shared hit=2
33. 0.018 0.018 ↑ 1.0 95 1

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

  • Buffers: shared hit=2
34. 10.604 14.790 ↓ 1.2 13,063 1

Sort (cost=1,674.14..1,702.05 rows=11,163 width=16) (actual time=6.959..14.79 rows=13,063 loops=1)

  • Sort Key: req_initiator.id
  • Sort Method: quicksort Memory: 913kB
  • Buffers: shared hit=812
35. 4.186 4.186 ↓ 1.0 11,283 1

Seq Scan on fdc_user req_initiator (cost=0..923.63 rows=11,163 width=16) (actual time=0.013..4.186 rows=11,283 loops=1)

  • Buffers: shared hit=812
36. 71.110 383.994 ↓ 0.0 0 14,222

Limit (cost=8.45..8.46 rows=1 width=1,044) (actual time=0.027..0.027 rows=0 loops=14,222)

  • Buffers: shared hit=42,666
37. 184.886 312.884 ↓ 0.0 0 14,222

Sort (cost=8.45..8.46 rows=1 width=1,044) (actual time=0.022..0.022 rows=0 loops=14,222)

  • Sort Key: e.start_date
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=42,666
38. 127.998 127.998 ↓ 0.0 0 14,222

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=14,222)

  • Index Cond: (e.start_request_id = request.id)
  • Buffers: shared hit=42,666
39. 28.444 227.552 ↓ 0.0 0 14,222

Limit (cost=8.45..8.46 rows=1 width=1,044) (actual time=0.016..0.016 rows=0 loops=14,222)

  • Buffers: shared hit=45,553
40. 56.888 199.108 ↓ 0.0 0 14,222

Sort (cost=8.45..8.46 rows=1 width=1,044) (actual time=0.014..0.014 rows=0 loops=14,222)

  • Sort Key: fdc_pts_ownership.date_add
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=45,553
41. 142.220 142.220 ↓ 0.0 0 14,222

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.01..0.01 rows=0 loops=14,222)

  • Index Cond: (fdc_pts_ownership.request_id = request.id)
  • Buffers: shared hit=45,553
42. 28.444 142.220 ↓ 0.0 0 14,222

Limit (cost=8.3..8.31 rows=1 width=1,044) (actual time=0.01..0.01 rows=0 loops=14,222)

  • Buffers: shared hit=28,444
43. 42.666 113.776 ↓ 0.0 0 14,222

Sort (cost=8.3..8.31 rows=1 width=1,044) (actual time=0.008..0.008 rows=0 loops=14,222)

  • Sort Key: fdc_pts_dealer.start_date
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=28,444
44. 71.110 71.110 ↓ 0.0 0 14,222

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.005..0.005 rows=0 loops=14,222)

  • Index Cond: (fdc_pts_dealer.start_request_id = request.id)
  • Buffers: shared hit=28,444
45. 28.444 11,634,534.652 ↑ 1.0 1 14,222

Limit (cost=4.94..19.16 rows=1 width=2,505) (actual time=818.065..818.066 rows=1 loops=14,222)

  • Buffers: shared hit=1,518,325,204 read=35
46. 56.888 11,634,506.208 ↑ 403,264.0 1 14,222

Result (cost=4.94..5,734,825.98 rows=403,264 width=2,505) (actual time=818.064..818.064 rows=1 loops=14,222)

  • Buffers: shared hit=1,518,325,204 read=35
47. 86.843 11,634,449.320 ↑ 403,264.0 1 14,222

Nested Loop (cost=4.94..5,734,825.98 rows=403,264 width=2,505) (actual time=818.06..818.06 rows=1 loops=14,222)

  • 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=1,518,325,204 read=35
48. 47.199 11,634,349.766 ↑ 1,509,782.0 1 14,222

Nested Loop (cost=4.51..4,919,420.82 rows=1,509,782 width=34) (actual time=807.302..818.053 rows=1 loops=14,222)

  • Buffers: shared hit=1,518,314,652 read=35
49. 101.595 11,634,264.434 ↑ 1,509,782.0 1 14,222

Nested Loop (cost=4.09..3,797,282.42 rows=1,509,782 width=34) (actual time=807.296..818.047 rows=1 loops=14,222)

  • Buffers: shared hit=1,518,306,411 read=35
50. 696,398.061 11,633,667.110 ↑ 5.0 1 14,222

Nested Loop (cost=1.97..399,211.08 rows=5 width=34) (actual time=807.264..818.005 rows=1 loops=14,222)

  • Buffers: shared hit=1,518,213,062 read=35
51. 67,331.424 10,441,451.072 ↑ 5.0 1 14,222

Nested Loop (cost=1.97..312,327.8 rows=5 width=34) (actual time=729.302..734.176 rows=1 loops=14,222)

  • Buffers: shared hit=1,518,200,416 read=35
52. 103.464 10,327,063.526 ↑ 5.0 1 14,222

Nested Loop (cost=1.97..302,668.43 rows=5 width=26) (actual time=721.827..726.133 rows=1 loops=14,222)

  • Buffers: shared hit=1,518,198,097 read=35
53. 16,864.739 10,326,807.530 ↑ 1.0 1 14,222

Nested Loop (cost=1.69..302,662.98 rows=1 width=26) (actual time=721.812..726.115 rows=1 loops=14,222)

  • Buffers: shared hit=1,518,170,434 read=35
54. 84,070.792 10,287,711.252 ↑ 1.0 1 14,222

Nested Loop (cost=1.69..301,599.82 rows=1 width=26) (actual time=719.216..723.366 rows=1 loops=14,222)

  • Buffers: shared hit=1,508,768,050 read=35
55. 198.485 10,141,509.092 ↑ 1.0 1 14,222

Nested Loop (cost=1.69..269,864.23 rows=1 width=26) (actual time=709.421..713.086 rows=1 loops=14,222)

  • Buffers: shared hit=1,500,223,106 read=35
56. 75.020 10,141,196.208 ↑ 1.0 1 14,222

Nested Loop (cost=1.69..269,860.09 rows=1 width=34) (actual time=709.401..713.064 rows=1 loops=14,222)

  • Buffers: shared hit=1,500,210,395 read=35
57. 57.948 10,140,968.656 ↑ 1.0 1 14,222

Nested Loop (cost=1.26..269,851.63 rows=1 width=18) (actual time=709.386..713.048 rows=1 loops=14,222)

  • Buffers: shared hit=1,500,159,550
58. 86.843 10,139,944.672 ↑ 1.0 1 14,222

Nested Loop (cost=0.98..269,842.7 rows=1 width=24) (actual time=709.319..712.976 rows=1 loops=14,222)

  • Buffers: shared hit=1,500,121,416
59. 122,377.620 10,139,845.118 ↑ 1.0 1 14,222

Nested Loop (cost=0.56..269,826.24 rows=1 width=32) (actual time=709.312..712.969 rows=1 loops=14,222)

  • Buffers: shared hit=1,500,121,416
60. 86.220 9,910,771.364 ↑ 1.0 1 14,222

Nested Loop (cost=0.56..265,619.72 rows=1 width=40) (actual time=694.351..696.862 rows=1 loops=14,222)

  • Buffers: shared hit=1,470,940,214
61. 161,812.626 9,910,558.034 ↑ 1.0 1 14,222

Nested Loop (cost=0.13..265,611.28 rows=1 width=40) (actual time=694.337..696.847 rows=1 loops=14,222)

  • Buffers: shared hit=1,470,900,755
62. 202.209 9,600,077.552 ↑ 1.0 1 14,222

Nested Loop (cost=0.13..233,875.69 rows=1 width=32) (actual time=674.709..675.016 rows=1 loops=14,222)

  • Buffers: shared hit=1,447,099,657
63. 9,598,413.578 9,598,413.578 ↑ 1.0 1 14,222

Seq Scan on fdc_request_signatory_person sp (cost=0..233,869.98 rows=1 width=40) (actual time=674.598..674.899 rows=1 loops=14,222)

  • Filter: (sp.request_id = request.id)
  • Buffers: shared hit=1,447,074,234
64. 25.422 1,461.765 ↑ 1.0 1 12,711

Nested Loop (cost=0.13..5.71 rows=1 width=8) (actual time=0.115..0.115 rows=1 loops=12,711)

  • Buffers: shared hit=25,423
65. 203.376 1,423.632 ↑ 1.0 1 12,711

Nested Loop (cost=0.13..5.68 rows=1 width=8) (actual time=0.112..0.112 rows=1 loops=12,711)

  • Buffers: shared hit=25,423
66. 101.688 101.688 ↑ 1.0 1 12,711

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.008..0.008 rows=1 loops=12,711)

  • Index Cond: (c_4.id = sp.person_type_id)
  • Buffers: shared hit=12,712
67. 1,118.568 1,118.568 ↑ 6.0 1 12,711

Seq Scan on fdc_person_type_translation t (cost=0..1.45 rows=6 width=8) (actual time=0.088..0.088 rows=1 loops=12,711)

  • Filter: (t.language_id = lang.get_current_lang_id())
  • Buffers: shared hit=12,711
68. 12.711 12.711 ↑ 1.0 1 12,711

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

69. 148,667.856 148,667.856 ↑ 4.9 174,902 12,711

Seq Scan on fdc_person p_1 (cost=0..21,130.26 rows=848,426 width=16) (actual time=0.003..11.696 rows=174,902 loops=12,711)

  • Buffers: shared hit=23,801,098
70. 127.110 127.110 ↑ 1.0 1 12,711

Index Only Scan using fdc_legal_person_id_i on fdc_legal_person pers_org (cost=0.42..8.44 rows=1 width=8) (actual time=0.01..0.01 rows=1 loops=12,711)

  • Index Cond: (pers_org.id = sp.person_id)
  • Heap Fetches: 1,321
  • Buffers: shared hit=39,459
71. 106,696.134 106,696.134 ↓ 1.0 83,902 12,711

Seq Scan on fdc_individual pers_ind (cost=0..3,157.9 rows=83,890 width=8) (actual time=0.002..8.394 rows=83,902 loops=12,711)

  • Buffers: shared hit=29,181,202
72. 12.711 12.711 ↓ 0.0 0 12,711

Index Only Scan using fdc_legal_person_id_i on fdc_legal_person pers_lp (cost=0.42..8.44 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=12,711)

  • Index Cond: (pers_lp.id = sp.legal_person_id)
73. 826.215 966.036 ↑ 1.0 1 12,711

Nested Loop (cost=0.28..8.92 rows=1 width=10) (actual time=0.075..0.076 rows=1 loops=12,711)

  • Buffers: shared hit=38,134
74. 76.266 76.266 ↑ 1.0 1 12,711

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.006..0.006 rows=1 loops=12,711)

  • Index Cond: (c_5.id = sp.signatory_type_id)
  • Buffers: shared hit=25,422
75. 63.555 63.555 ↑ 1.0 1 12,711

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.005..0.005 rows=1 loops=12,711)

  • Index Cond: ((t_1.signatory_type_id = c_5.id) AND (t_1.language_id = lang.get_current_lang_id()))
  • Buffers: shared hit=12,712
76. 152.532 152.532 ↑ 1.0 1 12,711

Index Scan using fdc_request_pk on fdc_request req (cost=0.43..8.45 rows=1 width=32) (actual time=0.012..0.012 rows=1 loops=12,711)

  • Index Cond: (req.id = request.id)
  • Buffers: shared hit=50,845 read=35
77. 114.399 114.399 ↑ 1.2 77 12,711

Seq Scan on fdc_request_type reqtype (cost=0..2.95 rows=95 width=8) (actual time=0.005..0.009 rows=77 loops=12,711)

  • Buffers: shared hit=12,711
78. 62,131.368 62,131.368 ↑ 10.6 80,085 12,711

Seq Scan on fdc_person org (cost=0..21,130.26 rows=848,426 width=16) (actual time=0.003..4.888 rows=80,085 loops=12,711)

  • Buffers: shared hit=8,544,944
79. 22,231.539 22,231.539 ↑ 1.1 10,575 12,711

Seq Scan on fdc_user usr (cost=0..923.63 rows=11,163 width=16) (actual time=0.005..1.749 rows=10,575 loops=12,711)

  • Buffers: shared hit=9,402,384
80. 152.532 152.532 ↓ 0.0 0 12,711

Index Scan using fdc_person_root_date_uk on fdc_person per_2 (cost=0.28..5.4 rows=5 width=16) (actual time=0.011..0.012 rows=0 loops=12,711)

  • 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=27,663
81. 47,044.949 47,056.122 ↓ 1.0 84,581 12,711

Materialize (cost=0..3,577.35 rows=83,890 width=8) (actual time=0.001..3.702 rows=84,581 loops=12,711)

  • Buffers: shared hit=2,319
82. 11.173 11.173 ↓ 1.0 84,581 1

Seq Scan on fdc_individual ind (cost=0..3,157.9 rows=83,890 width=8) (actual time=0.005..11.173 rows=84,581 loops=1)

  • Buffers: shared hit=2,319
83. 495,716.732 495,817.977 ↓ 1.0 855,424 12,711

Materialize (cost=0..25,372.39 rows=848,426 width=16) (actual time=0.001..39.007 rows=855,424 loops=12,711)

  • Buffers: shared hit=12,646
84. 101.245 101.245 ↓ 1.0 855,424 1

Seq Scan on fdc_person ind_per_1 (cost=0..21,130.26 rows=848,426 width=16) (actual time=0.006..101.245 rows=855,424 loops=1)

  • Buffers: shared hit=12,646
85. 19.719 495.729 ↓ 0.0 0 12,711

Nested Loop (cost=2.12..4,396.62 rows=67,521,765 width=16) (actual time=0.038..0.039 rows=0 loops=12,711)

  • Buffers: shared hit=93,349
86. 30.674 381.330 ↓ 0.0 0 12,711

Nested Loop (cost=1.84..16.92 rows=8,217 width=16) (actual time=0.029..0.03 rows=0 loops=12,711)

  • Buffers: shared hit=66,118
87. 24.983 203.376 ↓ 0.0 0 12,711

Nested Loop (cost=1.56..16.38 rows=1 width=24) (actual time=0.016..0.016 rows=0 loops=12,711)

  • Buffers: shared hit=37,994
88. 14.902 165.243 ↓ 0.0 0 12,711

Nested Loop (cost=1.13..10.25 rows=1 width=24) (actual time=0.013..0.013 rows=0 loops=12,711)

  • Buffers: shared hit=27,442
89. 62.677 139.821 ↓ 0.0 0 12,711

Nested Loop (cost=0.71..4.11 rows=1 width=24) (actual time=0.011..0.011 rows=0 loops=12,711)

  • Buffers: shared hit=16,909
90. 50.844 50.844 ↓ 0.0 0 12,711

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.004..0.004 rows=0 loops=12,711)

  • Index Cond: (ofp_1.id = per_2.id)
  • Buffers: shared hit=7,908
91. 26.300 26.300 ↑ 1.0 1 2,630

Index Only Scan using fdc_person_id_i on fdc_person per_3 (cost=0.42..3.82 rows=1 width=8) (actual time=0.01..0.01 rows=1 loops=2,630)

  • Index Cond: (per_3.id = ofp_1.id)
  • Heap Fetches: 1,110
  • Buffers: shared hit=9,001
92. 10.520 10.520 ↑ 1.0 1 2,630

Index Scan using fdc_person_id_i on fdc_person ind_ver_1 (cost=0.42..6.13 rows=1 width=16) (actual time=0.004..0.004 rows=1 loops=2,630)

  • Index Cond: (ind_ver_1.id = ofp_1.individual_id)
  • Buffers: shared hit=10,533
93. 13.150 13.150 ↑ 1.0 1 2,630

Index Scan using fdc_person_id_i on fdc_person leg_ver_1 (cost=0.42..6.13 rows=1 width=16) (actual time=0.005..0.005 rows=1 loops=2,630)

  • Index Cond: (leg_ver_1.id = ofp_1.legal_person_id)
  • Buffers: shared hit=10,552
94. 147.280 147.280 ↑ 5.0 1 2,630

Index Scan using fdc_person_root_date_uk on fdc_person ind_per_2 (cost=0.28..0.48 rows=5 width=8) (actual time=0.054..0.056 rows=1 loops=2,630)

  • 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=28,124
95. 94.680 94.680 ↑ 5.0 1 2,630

Index Scan using fdc_person_root_date_uk on fdc_person leg_per_1 (cost=0.28..0.48 rows=5 width=16) (actual time=0.031..0.036 rows=1 loops=2,630)

  • 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=27,231
96. 38.133 38.133 ↓ 0.0 0 12,711

Index Only Scan using fdc_legal_person_id_i on fdc_legal_person lp_op (cost=0.42..0.74 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=12,711)

  • Index Cond: (lp_op.id = leg_per_1.id)
  • Heap Fetches: 348
  • Buffers: shared hit=8,241
97. 12.711 12.711 ↓ 0.0 0 12,711

Index Scan using fdc_person_id_i on fdc_person lp_per (cost=0.42..0.52 rows=1 width=16) (actual time=0.001..0.001 rows=0 loops=12,711)

  • Index Cond: (lp_op.id = lp_per.id)
  • Buffers: shared hit=10,552
98. 0.000 0.000 ↓ 0.0 0 14,222

Index Scan using fdc_person_root_date_uk on fdc_person per (cost=0.28..5.4 rows=5 width=16) (actual time=0..0 rows=0 loops=14,222)

  • Index Cond: (per.person_root_id = req_initiator.person_root_id)
  • Filter: ((statement_timestamp() >= per.date_from) AND (statement_timestamp() <= per.date_to))
99. 142.220 142.220 ↑ 1.0 1 14,222

Index Scan using fdc_request_type_pk on fdc_request_type rt (cost=0.14..0.17 rows=1 width=8) (actual time=0.01..0.01 rows=1 loops=14,222)

  • Index Cond: (rt.id = request.request_type_id)
  • Filter: (rt.is_visible_portal IS TRUE)
  • Buffers: shared hit=28,444
100. 127.998 127.998 ↑ 1.0 1 14,222

Index Scan using fdc_person_id_i on fdc_person p (cost=0.42..6.73 rows=1 width=16) (actual time=0.009..0.009 rows=1 loops=14,222)

  • Index Cond: (p.id = request.org_add)
  • Buffers: shared hit=56,795
101. 14.222 99.554 ↓ 0.0 0 14,222

Nested Loop (cost=2.12..4,396.62 rows=67,521,765 width=8) (actual time=0.007..0.007 rows=0 loops=14,222)

102. 28.444 85.332 ↓ 0.0 0 14,222

Nested Loop (cost=1.84..16.92 rows=8,217 width=16) (actual time=0.006..0.006 rows=0 loops=14,222)

103. 14.222 56.888 ↓ 0.0 0 14,222

Nested Loop (cost=1.56..16.38 rows=1 width=24) (actual time=0.004..0.004 rows=0 loops=14,222)

104. 14.222 42.666 ↓ 0.0 0 14,222

Nested Loop (cost=1.13..10.25 rows=1 width=24) (actual time=0.003..0.003 rows=0 loops=14,222)

105. 28.444 28.444 ↓ 0.0 0 14,222

Nested Loop (cost=0.71..4.11 rows=1 width=24) (actual time=0.002..0.002 rows=0 loops=14,222)

106. 0.000 0.000 ↓ 0.0 0 14,222

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=14,222)

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

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

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

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

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

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

  • Index Cond: (leg_ver.id = ofp.legal_person_id)
110. 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.48 rows=5 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))
111. 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.48 rows=5 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))
112. 4.776 18.104 ↑ 1.2 9,485 1

Materialize (cost=0.29..3,595.23 rows=11,163 width=16) (actual time=0.02..18.104 rows=9,485 loops=1)

  • Buffers: shared hit=9,224
113. 13.328 13.328 ↑ 1.2 9,485 1

Index Scan using fdc_user_id_i on fdc_user u (cost=0.29..3,567.32 rows=11,163 width=16) (actual time=0.01..13.328 rows=9,485 loops=1)

  • Buffers: shared hit=9,224
114.          

SubPlan (for Merge Join)

115. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=0.86..16.9 rows=1 width=0) (never executed)

116. 0.000 0.000 ↓ 0.0 0 0

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) (never executed)

  • Index Cond: (sp_1.request_id = request.id)
117. 0.000 0.000 ↓ 0.0 0 0

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

  • Index Cond: (sp_per.id = sp_1.person_id)
  • Filter: (sp_per.person_root_id = ANY ('{6444092,8998555}'::bigint[]))
118. 1,000.628 1,714.454 ↑ 1.9 19,443 1

Hash Join (cost=8,213.24..328,063.8 rows=37,143 width=8) (actual time=29.303..1,714.454 rows=19,443 loops=1)

  • Buffers: shared hit=130,426
119. 708.402 708.402 ↑ 1.0 8,422,885 1

Seq Scan on fdc_request_signatory_person sp_2 (cost=0..212,640.18 rows=8,491,918 width=16) (actual time=0.011..708.402 rows=8,422,885 loops=1)

  • Buffers: shared hit=127,721
120. 0.413 5.424 ↓ 1.0 3,762 1

Hash (cost=8,166.86..8,166.86 rows=3,711 width=8) (actual time=5.424..5.424 rows=3,762 loops=1)

  • Buffers: shared hit=2,705
121. 4.463 5.011 ↓ 1.0 3,762 1

Bitmap Heap Scan on fdc_person sp_per_1 (cost=85.6..8,166.86 rows=3,711 width=8) (actual time=0.832..5.011 rows=3,762 loops=1)

  • Heap Blocks: exact=2,685
  • Buffers: shared hit=2,705
122. 0.548 0.548 ↓ 1.0 3,762 1

Bitmap Index Scan on fdc_person_person_root_i (cost=0..84.67 rows=3,711 width=0) (actual time=0.548..0.548 rows=3,762 loops=1)

  • Index Cond: (sp_per_1.person_root_id = ANY ('{6444092,8998555}'::bigint[]))
  • Buffers: shared hit=20