explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Vd77 : Add screening_attribute_counts table

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.091 39.113 ↑ 3,139,344.0 1 1

Nested Loop (cost=2,492.08..74,071.30 rows=3,139,344 width=32) (actual time=38.411..39.113 rows=1 loops=1)

2.          

CTE disposition_src

3. 3.133 19.560 ↑ 3.0 3 1

GroupAggregate (cost=41.87..45.54 rows=9 width=28) (actual time=13.783..19.560 rows=3 loops=1)

  • Group Key: ix.disposition_status_id, ds.name
  • Group Key: ()
4. 6.277 16.427 ↑ 1.0 358 1

Sort (cost=41.87..42.76 rows=358 width=28) (actual time=13.496..16.427 rows=358 loops=1)

  • Sort Key: ix.disposition_status_id, ds.name
  • Sort Method: quicksort Memory: 52kB
5. 6.542 10.150 ↑ 1.0 358 1

Hash Join (cost=1.50..26.68 rows=358 width=28) (actual time=0.173..10.150 rows=358 loops=1)

  • Hash Cond: (ix.disposition_status_id = ds.id)
6. 3.494 3.494 ↑ 1.0 358 1

Index Only Scan using idx__event_index__compound on event_index ix (cost=0.41..20.67 rows=358 width=16) (actual time=0.019..3.494 rows=358 loops=1)

  • Index Cond: (screening_id = 22)
  • Heap Fetches: 0
7. 0.061 0.114 ↑ 1.0 4 1

Hash (cost=1.04..1.04 rows=4 width=16) (actual time=0.114..0.114 rows=4 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
8. 0.053 0.053 ↑ 1.0 4 1

Seq Scan on data_status ds (cost=0.00..1.04 rows=4 width=16) (actual time=0.010..0.053 rows=4 loops=1)

9.          

CTE disposition_facets

10. 0.058 19.782 ↑ 1.0 1 1

Nested Loop (cost=0.29..0.51 rows=1 width=32) (actual time=19.742..19.782 rows=1 loops=1)

11. 0.085 19.706 ↑ 1.0 1 1

Aggregate (cost=0.29..0.30 rows=1 width=32) (actual time=19.698..19.706 rows=1 loops=1)

12. 19.621 19.621 ↑ 4.5 2 1

CTE Scan on disposition_src disposition_src_1 (cost=0.00..0.18 rows=9 width=532) (actual time=13.800..19.621 rows=2 loops=1)

  • Filter: (id IS NOT NULL)
  • Rows Removed by Filter: 1
13. 0.018 0.018 ↑ 1.0 1 1

CTE Scan on disposition_src (cost=0.00..0.18 rows=1 width=8) (actual time=0.010..0.018 rows=1 loops=1)

  • Filter: (id IS NULL)
  • Rows Removed by Filter: 2
14.          

CTE language_src

15. 0.168 0.635 ↑ 1.0 2 1

GroupAggregate (cost=22.51..23.31 rows=2 width=14) (actual time=0.619..0.635 rows=2 loops=1)

  • Group Key: ix_1.language_code
  • Group Key: ()
16. 0.287 0.467 ↑ 6.5 16 1

Sort (cost=22.51..22.77 rows=104 width=11) (actual time=0.336..0.467 rows=16 loops=1)

  • Sort Key: ix_1.language_code
  • Sort Method: quicksort Memory: 25kB
17. 0.180 0.180 ↑ 6.5 16 1

Index Only Scan using idx__event_index__compound on event_index ix_1 (cost=0.41..19.02 rows=104 width=11) (actual time=0.020..0.180 rows=16 loops=1)

  • Index Cond: ((screening_id = 22) AND (disposition_status_id = ANY ('{1}'::integer[])))
  • Heap Fetches: 0
18.          

CTE language_facets

19. 0.057 0.800 ↑ 1.0 1 1

Nested Loop (cost=0.06..0.13 rows=1 width=32) (actual time=0.758..0.800 rows=1 loops=1)

20. 0.048 0.726 ↑ 1.0 1 1

Aggregate (cost=0.06..0.07 rows=1 width=32) (actual time=0.718..0.726 rows=1 loops=1)

21. 0.678 0.678 ↑ 2.0 1 1

CTE Scan on language_src language_src_1 (cost=0.00..0.04 rows=2 width=72) (actual time=0.637..0.678 rows=1 loops=1)

  • Filter: (id IS NOT NULL)
  • Rows Removed by Filter: 1
22. 0.017 0.017 ↑ 1.0 1 1

CTE Scan on language_src (cost=0.00..0.04 rows=1 width=8) (actual time=0.008..0.017 rows=1 loops=1)

  • Filter: (id IS NULL)
  • Rows Removed by Filter: 1
23.          

CTE name_src

24. 0.163 4.573 ↑ 1,114.3 7 1

Hash Left Join (cost=111.71..306.51 rows=7,800 width=34) (actual time=3.816..4.573 rows=7 loops=1)

  • Hash Cond: ((unnest(ix2.names)) = n.id)
25. 0.459 2.233 ↑ 1,114.3 7 1

GroupAggregate (cost=106.99..147.35 rows=7,800 width=16) (actual time=1.607..2.233 rows=7 loops=1)

  • Group Key: (unnest(ix2.names))
  • Group Key: ()
26. 0.510 1.774 ↑ 4.5 23 1

Sort (cost=106.99..107.25 rows=104 width=16) (actual time=1.543..1.774 rows=23 loops=1)

  • Sort Key: (unnest(ix2.names))
  • Sort Method: quicksort Memory: 26kB
27. 0.569 1.264 ↑ 4.5 23 1

Hash Right Join (cost=51.94..103.50 rows=104 width=16) (actual time=0.518..1.264 rows=23 loops=1)

  • Hash Cond: (ix_2.id = ix2.id)
28. 0.241 0.241 ↑ 6.5 16 1

Index Scan using idx__event_index__compound on event_index ix_2 (cost=0.41..51.28 rows=104 width=16) (actual time=0.025..0.241 rows=16 loops=1)

  • Index Cond: ((screening_id = 22) AND (disposition_status_id = ANY ('{1}'::integer[])) AND (language_code = ANY ('{en}'::text[])))
  • Filter: (((NOT (locations <@ '{}'::bigint[])) OR (locations IS NULL)) AND ((NOT (occupations <@ '{}'::bigint[])) OR (occupations IS NULL)) AND ((NOT (dates_of_birth <@ '{}'::bigint[])) OR (dates_of_birth IS NULL)) AND (NOT (risk_ids <@ '{}'::bigint[])))
29. 0.166 0.454 ↑ 6.5 16 1

Hash (cost=50.24..50.24 rows=104 width=38) (actual time=0.454..0.454 rows=16 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 10kB
30. 0.288 0.288 ↑ 6.5 16 1

Index Scan using idx__event_index__compound on event_index ix2 (cost=0.41..50.24 rows=104 width=38) (actual time=0.027..0.288 rows=16 loops=1)

  • Index Cond: ((screening_id = 22) AND (disposition_status_id = ANY ('{1}'::integer[])) AND (language_code = ANY ('{en}'::text[])))
31. 1.117 2.177 ↑ 1.0 121 1

Hash (cost=3.21..3.21 rows=121 width=26) (actual time=2.177..2.177 rows=121 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 16kB
32. 1.060 1.060 ↑ 1.0 121 1

Seq Scan on name n (cost=0.00..3.21 rows=121 width=26) (actual time=0.023..1.060 rows=121 loops=1)

33.          

CTE name_facets

34. 0.066 6.098 ↑ 39.0 1 1

Nested Loop (cost=190.69..347.20 rows=39 width=32) (actual time=6.057..6.098 rows=1 loops=1)

35. 0.161 6.012 ↑ 1.0 1 1

Aggregate (cost=190.69..190.70 rows=1 width=32) (actual time=6.004..6.012 rows=1 loops=1)

36. 0.151 5.851 ↓ 1.5 6 1

Hash Join (cost=188.83..190.67 rows=4 width=38) (actual time=5.471..5.851 rows=6 loops=1)

  • Hash Cond: (src.subcategory_id = nmk.id)
37. 0.273 5.593 ↑ 6.5 6 1

GroupAggregate (cost=187.74..189.00 rows=39 width=40) (actual time=5.336..5.593 rows=6 loops=1)

  • Group Key: sac.count, src.subcategory_id
38. 0.135 5.320 ↑ 6.5 6 1

Sort (cost=187.74..187.83 rows=39 width=56) (actual time=5.257..5.320 rows=6 loops=1)

  • Sort Key: sac.count DESC, src.subcategory_id
  • Sort Method: quicksort Memory: 25kB
39. 0.145 5.185 ↑ 6.5 6 1

Hash Join (cost=1.21..186.71 rows=39 width=56) (actual time=4.192..5.185 rows=6 loops=1)

  • Hash Cond: (src.id = sac.attribute_id)
40. 4.722 4.722 ↑ 1,293.5 6 1

CTE Scan on name_src src (cost=0.00..156.00 rows=7,761 width=52) (actual time=3.837..4.722 rows=6 loops=1)

  • Filter: (id IS NOT NULL)
  • Rows Removed by Filter: 1
41. 0.161 0.318 ↓ 16.0 16 1

Hash (cost=1.20..1.20 rows=1 width=12) (actual time=0.318..0.318 rows=16 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
42. 0.157 0.157 ↓ 16.0 16 1

Seq Scan on screening_attribute_counts sac (cost=0.00..1.20 rows=1 width=12) (actual time=0.012..0.157 rows=16 loops=1)

  • Filter: (attribute_kind_id = 1)
43. 0.054 0.107 ↑ 1.0 4 1

Hash (cost=1.04..1.04 rows=4 width=10) (actual time=0.107..0.107 rows=4 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
44. 0.053 0.053 ↑ 1.0 4 1

Seq Scan on name_match_kind nmk (cost=0.00..1.04 rows=4 width=10) (actual time=0.015..0.053 rows=4 loops=1)

45. 0.020 0.020 ↑ 39.0 1 1

CTE Scan on name_src (cost=0.00..156.00 rows=39 width=8) (actual time=0.011..0.020 rows=1 loops=1)

  • Filter: (id IS NULL)
  • Rows Removed by Filter: 6
46.          

CTE location_src

47. 0.117 2.036 ↑ 400.0 3 1

Merge Left Join (cost=157.85..180.80 rows=1,200 width=25) (actual time=1.825..2.036 rows=3 loops=1)

  • Merge Cond: ((unnest(ix2_1.locations)) = l.id)
48. 0.188 1.644 ↑ 400.0 3 1

GroupAggregate (cost=156.52..163.39 rows=1,200 width=16) (actual time=1.564..1.644 rows=3 loops=1)

  • Group Key: (unnest(ix2_1.locations))
  • Group Key: ()
49. 0.349 1.456 ↑ 6.5 16 1

Sort (cost=156.52..156.78 rows=104 width=16) (actual time=1.326..1.456 rows=16 loops=1)

  • Sort Key: (unnest(ix2_1.locations))
  • Sort Method: quicksort Memory: 25kB
50. 0.581 1.107 ↑ 6.5 16 1

Nested Loop Left Join (cost=0.69..153.04 rows=104 width=16) (actual time=0.068..1.107 rows=16 loops=1)

51. 0.174 0.174 ↑ 6.5 16 1

Index Scan using idx__event_index__compound on event_index ix2_1 (cost=0.41..50.24 rows=104 width=37) (actual time=0.016..0.174 rows=16 loops=1)

  • Index Cond: ((screening_id = 22) AND (disposition_status_id = ANY ('{1}'::integer[])) AND (language_code = ANY ('{en}'::text[])))
52. 0.352 0.352 ↑ 1.0 1 16

Index Scan using event_index_pkey on event_index ix_3 (cost=0.28..0.98 rows=1 width=16) (actual time=0.014..0.022 rows=1 loops=16)

  • Index Cond: (id = ix2_1.id)
  • Filter: (((screening_id = 22) AND (disposition_status_id = ANY ('{1}'::integer[])) AND (language_code = ANY ('{en}'::text[])) AND (NOT (names <@ '{}'::bigint[])) AND ((NOT (occupations <@ '{}'::bigint[])) OR (occupations IS NULL)) AND ((NOT (dates_of_birth <@ '{}'::bigint[])) OR (dates_of_birth IS NULL)) AND (NOT (risk_ids <@ '{}'::bigint[]))) OR (risk_ids IS NULL))
53. 0.160 0.275 ↑ 2.0 6 1

Sort (cost=1.34..1.37 rows=12 width=17) (actual time=0.234..0.275 rows=6 loops=1)

  • Sort Key: l.id
  • Sort Method: quicksort Memory: 25kB
54. 0.115 0.115 ↑ 1.0 12 1

Seq Scan on location l (cost=0.00..1.12 rows=12 width=17) (actual time=0.017..0.115 rows=12 loops=1)

55.          

CTE location_facets

56. 0.065 2.303 ↑ 6.0 1 1

Nested Loop (cost=38.93..63.04 rows=6 width=32) (actual time=2.200..2.303 rows=1 loops=1)

57. 0.072 2.168 ↑ 1.0 1 1

Aggregate (cost=38.93..38.94 rows=1 width=32) (actual time=2.158..2.168 rows=1 loops=1)

58. 2.096 2.096 ↑ 597.0 2 1

CTE Scan on location_src src_1 (cost=0.00..24.00 rows=1,194 width=48) (actual time=1.843..2.096 rows=2 loops=1)

  • Filter: (id IS NOT NULL)
  • Rows Removed by Filter: 1
59. 0.070 0.070 ↑ 6.0 1 1

CTE Scan on location_src (cost=0.00..24.00 rows=6 width=8) (actual time=0.009..0.070 rows=1 loops=1)

  • Filter: (id IS NULL)
  • Rows Removed by Filter: 2
60.          

CTE occupation_src

61. 0.346 2.975 ↑ 866.7 6 1

Merge Left Join (cost=107.13..220.52 rows=5,200 width=26) (actual time=1.599..2.975 rows=6 loops=1)

  • Merge Cond: ((unnest(ix2_2.occupations)) = o.id)
62. 0.334 1.879 ↑ 866.7 6 1

GroupAggregate (cost=106.99..134.16 rows=5,200 width=16) (actual time=1.527..1.879 rows=6 loops=1)

  • Group Key: (unnest(ix2_2.occupations))
  • Group Key: ()
63. 0.462 1.545 ↑ 5.5 19 1

Sort (cost=106.99..107.25 rows=104 width=16) (actual time=1.334..1.545 rows=19 loops=1)

  • Sort Key: (unnest(ix2_2.occupations))
  • Sort Method: quicksort Memory: 25kB
64. 0.429 1.083 ↑ 5.5 19 1

Hash Right Join (cost=51.94..103.50 rows=104 width=16) (actual time=0.440..1.083 rows=19 loops=1)

  • Hash Cond: (ix_4.id = ix2_2.id)
65. 0.261 0.261 ↑ 6.5 16 1

Index Scan using idx__event_index__compound on event_index ix_4 (cost=0.41..51.28 rows=104 width=16) (actual time=0.017..0.261 rows=16 loops=1)

  • Index Cond: ((screening_id = 22) AND (disposition_status_id = ANY ('{1}'::integer[])) AND (language_code = ANY ('{en}'::text[])))
  • Filter: ((NOT (names <@ '{}'::bigint[])) AND ((NOT (locations <@ '{}'::bigint[])) OR (locations IS NULL)) AND ((NOT (dates_of_birth <@ '{}'::bigint[])) OR (dates_of_birth IS NULL)) AND (NOT (risk_ids <@ '{}'::bigint[])))
66. 0.173 0.393 ↑ 6.5 16 1

Hash (cost=50.24..50.24 rows=104 width=37) (actual time=0.393..0.393 rows=16 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 10kB
67. 0.220 0.220 ↑ 6.5 16 1

Index Scan using idx__event_index__compound on event_index ix2_2 (cost=0.41..50.24 rows=104 width=37) (actual time=0.027..0.220 rows=16 loops=1)

  • Index Cond: ((screening_id = 22) AND (disposition_status_id = ANY ('{1}'::integer[])) AND (language_code = ANY ('{en}'::text[])))
68. 0.387 0.750 ↑ 2.2 20 1

Materialize (cost=0.14..3.93 rows=45 width=18) (actual time=0.038..0.750 rows=20 loops=1)

69. 0.363 0.363 ↑ 2.2 20 1

Index Scan using occupation_pkey on occupation o (cost=0.14..3.82 rows=45 width=18) (actual time=0.018..0.363 rows=20 loops=1)

70.          

CTE occupation_facets

71. 0.064 3.383 ↑ 26.0 1 1

Nested Loop (cost=168.68..273.09 rows=26 width=32) (actual time=3.342..3.383 rows=1 loops=1)

72. 0.189 3.302 ↑ 1.0 1 1

Aggregate (cost=168.68..168.69 rows=1 width=32) (actual time=3.294..3.302 rows=1 loops=1)

73. 3.113 3.113 ↑ 1,034.8 5 1

CTE Scan on occupation_src occupation_src_1 (cost=0.00..104.00 rows=5,174 width=48) (actual time=1.621..3.113 rows=5 loops=1)

  • Filter: (id IS NOT NULL)
  • Rows Removed by Filter: 1
74. 0.017 0.017 ↑ 26.0 1 1

CTE Scan on occupation_src (cost=0.00..104.00 rows=26 width=8) (actual time=0.009..0.017 rows=1 loops=1)

  • Filter: (id IS NULL)
  • Rows Removed by Filter: 5
75.          

CTE dob_src

76. 0.146 2.222 ↑ 833.3 3 1

Merge Left Join (cost=108.86..158.45 rows=2,500 width=28) (actual time=1.982..2.222 rows=3 loops=1)

  • Merge Cond: ((unnest(ix2_3.dates_of_birth)) = dob.id)
77. 0.202 1.420 ↑ 833.3 3 1

GroupAggregate (cost=106.99..120.45 rows=2,500 width=16) (actual time=1.361..1.420 rows=3 loops=1)

  • Group Key: (unnest(ix2_3.dates_of_birth))
  • Group Key: ()
78. 0.301 1.218 ↑ 6.5 16 1

Sort (cost=106.99..107.25 rows=104 width=16) (actual time=1.074..1.218 rows=16 loops=1)

  • Sort Key: (unnest(ix2_3.dates_of_birth))
  • Sort Method: quicksort Memory: 25kB
79. 0.359 0.917 ↑ 6.5 16 1

Hash Right Join (cost=51.94..103.50 rows=104 width=16) (actual time=0.401..0.917 rows=16 loops=1)

  • Hash Cond: (ix_5.id = ix2_3.id)
80. 0.205 0.205 ↑ 6.5 16 1

Index Scan using idx__event_index__compound on event_index ix_5 (cost=0.41..51.28 rows=104 width=16) (actual time=0.019..0.205 rows=16 loops=1)

  • Index Cond: ((screening_id = 22) AND (disposition_status_id = ANY ('{1}'::integer[])) AND (language_code = ANY ('{en}'::text[])))
  • Filter: ((NOT (names <@ '{}'::bigint[])) AND ((NOT (locations <@ '{}'::bigint[])) OR (locations IS NULL)) AND ((NOT (occupations <@ '{}'::bigint[])) OR (occupations IS NULL)) AND (NOT (risk_ids <@ '{}'::bigint[])))
81. 0.164 0.353 ↑ 6.5 16 1

Hash (cost=50.24..50.24 rows=104 width=37) (actual time=0.353..0.353 rows=16 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 10kB
82. 0.189 0.189 ↑ 6.5 16 1

Index Scan using idx__event_index__compound on event_index ix2_3 (cost=0.41..50.24 rows=104 width=37) (actual time=0.022..0.189 rows=16 loops=1)

  • Index Cond: ((screening_id = 22) AND (disposition_status_id = ANY ('{1}'::integer[])) AND (language_code = ANY ('{en}'::text[])))
83. 0.398 0.656 ↑ 3.2 8 1

Sort (cost=1.87..1.94 rows=26 width=20) (actual time=0.594..0.656 rows=8 loops=1)

  • Sort Key: dob.id
  • Sort Method: quicksort Memory: 26kB
84. 0.258 0.258 ↑ 1.0 26 1

Seq Scan on date_of_birth dob (cost=0.00..1.26 rows=26 width=20) (actual time=0.016..0.258 rows=26 loops=1)

85.          

CTE dob_facets

86. 0.052 2.448 ↑ 12.0 1 1

Nested Loop (cost=87.32..137.52 rows=12 width=32) (actual time=2.408..2.448 rows=1 loops=1)

87. 0.091 2.378 ↑ 1.0 1 1

Aggregate (cost=87.32..87.33 rows=1 width=32) (actual time=2.370..2.378 rows=1 loops=1)

88. 2.287 2.287 ↑ 1,244.0 2 1

CTE Scan on dob_src dob_src_1 (cost=0.00..50.00 rows=2,488 width=28) (actual time=2.001..2.287 rows=2 loops=1)

  • Filter: (id IS NOT NULL)
  • Rows Removed by Filter: 1
89. 0.018 0.018 ↑ 12.0 1 1

CTE Scan on dob_src (cost=0.00..50.00 rows=12 width=8) (actual time=0.009..0.018 rows=1 loops=1)

  • Filter: (id IS NULL)
  • Rows Removed by Filter: 2
90.          

CTE risk_concept_src

91. 0.454 2.982 ↑ 661.5 13 1

Merge Left Join (cost=107.13..283.83 rows=8,600 width=33) (actual time=1.429..2.982 rows=13 loops=1)

  • Merge Cond: ((unnest(ix2_4.risk_ids)) = rc.id)
92. 0.406 1.943 ↑ 661.5 13 1

GroupAggregate (cost=106.99..151.41 rows=8,600 width=16) (actual time=1.372..1.943 rows=13 loops=1)

  • Group Key: (unnest(ix2_4.risk_ids))
  • Group Key: ()
93. 0.498 1.537 ↑ 3.7 28 1

Sort (cost=106.99..107.25 rows=104 width=16) (actual time=1.297..1.537 rows=28 loops=1)

  • Sort Key: (unnest(ix2_4.risk_ids))
  • Sort Method: quicksort Memory: 26kB
94. 0.495 1.039 ↑ 3.7 28 1

Hash Right Join (cost=51.94..103.50 rows=104 width=16) (actual time=0.386..1.039 rows=28 loops=1)

  • Hash Cond: (ix_6.id = ix2_4.id)
95. 0.210 0.210 ↑ 6.5 16 1

Index Scan using idx__event_index__compound on event_index ix_6 (cost=0.41..51.28 rows=104 width=16) (actual time=0.018..0.210 rows=16 loops=1)

  • Index Cond: ((screening_id = 22) AND (disposition_status_id = ANY ('{1}'::integer[])) AND (language_code = ANY ('{en}'::text[])))
  • Filter: ((NOT (names <@ '{}'::bigint[])) AND ((NOT (locations <@ '{}'::bigint[])) OR (locations IS NULL)) AND ((NOT (occupations <@ '{}'::bigint[])) OR (occupations IS NULL)) AND ((NOT (dates_of_birth <@ '{}'::bigint[])) OR (dates_of_birth IS NULL)))
96. 0.156 0.334 ↑ 6.5 16 1

Hash (cost=50.24..50.24 rows=104 width=40) (actual time=0.334..0.334 rows=16 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 10kB
97. 0.178 0.178 ↑ 6.5 16 1

Index Scan using idx__event_index__compound on event_index ix2_4 (cost=0.41..50.24 rows=104 width=40) (actual time=0.016..0.178 rows=16 loops=1)

  • Index Cond: ((screening_id = 22) AND (disposition_status_id = ANY ('{1}'::integer[])) AND (language_code = ANY ('{en}'::text[])))
98. 0.384 0.585 ↑ 1.4 23 1

Materialize (cost=0.14..3.72 rows=33 width=25) (actual time=0.030..0.585 rows=23 loops=1)

99. 0.201 0.201 ↑ 1.4 23 1

Index Scan using risk_concept_pkey on risk_concept rc (cost=0.14..3.64 rows=33 width=25) (actual time=0.013..0.201 rows=23 loops=1)

100.          

CTE risk_concept_facets

101. 0.069 3.569 ↑ 43.0 1 1

Nested Loop (cost=278.96..451.63 rows=43 width=32) (actual time=3.528..3.569 rows=1 loops=1)

102. 0.274 3.482 ↑ 1.0 1 1

Aggregate (cost=278.96..278.97 rows=1 width=32) (actual time=3.474..3.482 rows=1 loops=1)

103. 3.208 3.208 ↑ 713.1 12 1

CTE Scan on risk_concept_src risk_concept_src_1 (cost=0.00..172.00 rows=8,557 width=48) (actual time=1.446..3.208 rows=12 loops=1)

  • Filter: (id IS NOT NULL)
  • Rows Removed by Filter: 1
104. 0.018 0.018 ↑ 43.0 1 1

CTE Scan on risk_concept_src (cost=0.00..172.00 rows=43 width=8) (actual time=0.010..0.018 rows=1 loops=1)

  • Filter: (id IS NULL)
  • Rows Removed by Filter: 12
105. 0.051 35.419 ↑ 73,008.0 1 1

Nested Loop (cost=0.00..943.55 rows=73,008 width=192) (actual time=34.800..35.419 rows=1 loops=1)

106. 6.134 6.134 ↑ 39.0 1 1

CTE Scan on name_facets (cost=0.00..0.78 rows=39 width=32) (actual time=6.077..6.134 rows=1 loops=1)

107. 0.036 29.234 ↑ 1,872.0 1 1

Materialize (cost=0.00..34.84 rows=1,872 width=160) (actual time=28.696..29.234 rows=1 loops=1)

108. 0.068 29.198 ↑ 1,872.0 1 1

Nested Loop (cost=0.00..25.48 rows=1,872 width=160) (actual time=28.676..29.198 rows=1 loops=1)

109. 3.419 3.419 ↑ 26.0 1 1

CTE Scan on occupation_facets (cost=0.00..0.52 rows=26 width=32) (actual time=3.362..3.419 rows=1 loops=1)

110. 0.033 25.711 ↑ 72.0 1 1

Materialize (cost=0.00..1.75 rows=72 width=128) (actual time=25.288..25.711 rows=1 loops=1)

111. 0.050 25.678 ↑ 72.0 1 1

Nested Loop (cost=0.00..1.39 rows=72 width=128) (actual time=25.271..25.678 rows=1 loops=1)

112. 2.482 2.482 ↑ 12.0 1 1

CTE Scan on dob_facets (cost=0.00..0.24 rows=12 width=32) (actual time=2.426..2.482 rows=1 loops=1)

113. 0.033 23.146 ↑ 6.0 1 1

Materialize (cost=0.00..0.26 rows=6 width=96) (actual time=22.819..23.146 rows=1 loops=1)

114. 0.061 23.113 ↑ 6.0 1 1

Nested Loop (cost=0.00..0.23 rows=6 width=96) (actual time=22.802..23.113 rows=1 loops=1)

115. 0.062 20.713 ↑ 1.0 1 1

Nested Loop (cost=0.00..0.05 rows=1 width=64) (actual time=20.560..20.713 rows=1 loops=1)

116. 19.817 19.817 ↑ 1.0 1 1

CTE Scan on disposition_facets (cost=0.00..0.02 rows=1 width=32) (actual time=19.760..19.817 rows=1 loops=1)

117. 0.834 0.834 ↑ 1.0 1 1

CTE Scan on language_facets (cost=0.00..0.02 rows=1 width=32) (actual time=0.776..0.834 rows=1 loops=1)

118. 2.339 2.339 ↑ 6.0 1 1

CTE Scan on location_facets (cost=0.00..0.12 rows=6 width=32) (actual time=2.217..2.339 rows=1 loops=1)

119. 3.603 3.603 ↑ 43.0 1 1

CTE Scan on risk_concept_facets (cost=0.00..0.86 rows=43 width=32) (actual time=3.546..3.603 rows=1 loops=1)

Planning time : 7.179 ms
Execution time : 39.811 ms