explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Akrj : enable_nestloop_on_2unions_2.5_hight_analyze

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 611,323.874 ↑ 1.0 1 1

Aggregate (cost=4,617,537.87..4,617,537.88 rows=1 width=8) (actual time=611,323.874..611,323.874 rows=1 loops=1)

2. 0.001 611,323.871 ↓ 0.0 0 1

Unique (cost=4,617,537.74..4,617,537.85 rows=2 width=1,410) (actual time=611,323.871..611,323.871 rows=0 loops=1)

3. 0.012 611,323.870 ↓ 0.0 0 1

Sort (cost=4,617,537.74..4,617,537.75 rows=2 width=1,410) (actual time=611,323.870..611,323.870 rows=0 loops=1)

  • Sort Key: ('One'::text), ((mttr.crtd_dt)::date), mttr.mttr_id, o3.orgn_ctgry_ds, zz5.prior_bllbl_entty_cd, b2.bllbl_entty_cd, (substr(btrim(zz8.cmmnt_nt), 4000, 1)), ((mttr_bllbl_entty_1.last_updt_dt)::date), zz5.last_updt_dt_prior, (sum(CASE WHEN (tm_entry.bllbl_entty_id = ANY ('{8,15}'::numeric[])) THEN tm_entry.actvy_hours_ct WHEN (tm_entry.bllbl_entty_id = '23'::numeric) THEN (tm_entry.actvy_hours_ct * 0.05) WHEN (tm_entry.bllbl_entty_id = '24'::numeric) THEN (tm_entry.actvy_hours_ct * 0.04) WHEN (tm_entry.bllbl_entty_id = '25'::numeric) THEN (tm_entry.actvy_hours_ct * 0.03) WHEN (tm_entry.bllbl_entty_id = '26'::numeric) THEN (tm_entry.actvy_hours_ct * 0.02) ELSE NULL::numeric END)), d.dstrt_cd, d.dstrt_ds, zz9.staff_nm, zz7.mp_id, zz10.prdct_ds, zz10.prdct_sym, zz6.cause_code_ds, mttr.mttr_ds, mttr.asctd_mttr_id, mttr.crtd_dt
  • Sort Method: quicksort Memory: 25kB
4. 0.002 611,323.858 ↓ 0.0 0 1

Append (cost=2,061,304.56..4,617,537.73 rows=2 width=1,410) (actual time=611,323.858..611,323.858 rows=0 loops=1)

5. 0.001 2,934.016 ↓ 0.0 0 1

Nested Loop Left Join (cost=2,061,304.56..2,363,277.64 rows=1 width=301) (actual time=2,934.016..2,934.016 rows=0 loops=1)

  • Join Filter: ((mttr.mttr_id)::text = (tm_entry.mttr_id)::text)
6. 0.001 2,934.015 ↓ 0.0 0 1

Nested Loop Left Join (cost=1,500,904.08..1,798,196.16 rows=1 width=233) (actual time=2,934.015..2,934.015 rows=0 loops=1)

  • Join Filter: ((mttr.mttr_id)::text = (zz10.mttr_id)::text)
7. 0.000 2,934.014 ↓ 0.0 0 1

Nested Loop Left Join (cost=1,188,504.03..1,446,276.25 rows=1 width=208) (actual time=2,934.014..2,934.014 rows=0 loops=1)

  • Join Filter: ((mttr.mttr_id)::text = (zz9.mttr_id)::text)
8. 0.001 2,934.014 ↓ 0.0 0 1

Nested Loop Left Join (cost=582,933.99..735,475.73 rows=1 width=176) (actual time=2,934.014..2,934.014 rows=0 loops=1)

  • Join Filter: ((mttr.mttr_id)::text = (zz8.mttr_id)::text)
9. 0.001 2,934.013 ↓ 0.0 0 1

Nested Loop Left Join (cost=461,478.56..612,401.54 rows=1 width=144) (actual time=2,934.013..2,934.013 rows=0 loops=1)

  • Join Filter: ((mttr.mttr_id)::text = (zz7.mttr_id)::text)
10. 0.000 2,934.012 ↓ 0.0 0 1

Nested Loop Left Join (cost=320,488.46..467,441.02 rows=1 width=140) (actual time=2,934.012..2,934.012 rows=0 loops=1)

  • Join Filter: ((mttr.mttr_id)::text = (zz6.mttr_id)::text)
11. 442.626 2,934.012 ↓ 0.0 0 1

Nested Loop (cost=89,150.63..206,091.93 rows=1 width=118) (actual time=2,934.012..2,934.012 rows=0 loops=1)

  • Join Filter: ((x.mttr_id)::text = (x_2.mttr_id)::text)
  • Rows Removed by Join Filter: 1546844
12. 0.000 25.858 ↑ 2.0 7,852 1

Gather (cost=1,016.47..14,624.54 rows=15,402 width=39) (actual time=1.665..25.858 rows=7,852 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
13. 12.970 146.056 ↑ 2.5 2,617 3

Nested Loop (cost=16.47..12,084.34 rows=6,418 width=39) (actual time=0.223..146.056 rows=2,617 loops=3)

14. 72.497 133.082 ↑ 2.5 2,617 3

Hash Join (cost=16.04..8,680.29 rows=6,418 width=27) (actual time=0.201..133.082 rows=2,617 loops=3)

  • Hash Cond: (mttr_orgn.orgn_id = o2.orgn_id)
15. 60.520 60.520 ↑ 1.2 192,237 3

Parallel Seq Scan on mttr_orgn (cost=0.00..7,698.96 rows=240,296 width=17) (actual time=0.006..60.520 rows=192,237 loops=3)

16. 0.013 0.065 ↑ 1.0 18 3

Hash (cost=15.82..15.82 rows=18 width=20) (actual time=0.065..0.065 rows=18 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
17. 0.013 0.052 ↑ 1.0 18 3

Nested Loop (cost=4.41..15.82 rows=18 width=20) (actual time=0.028..0.052 rows=18 loops=3)

18. 0.017 0.017 ↑ 1.0 1 3

Seq Scan on orgn_ctgry_lk o3 (cost=0.00..2.00 rows=1 width=20) (actual time=0.011..0.017 rows=1 loops=3)

  • Filter: (orgn_ctgry_id = '18'::numeric)
  • Rows Removed by Filter: 79
19. 0.012 0.022 ↑ 1.0 18 3

Bitmap Heap Scan on orgn_lk o2 (cost=4.41..13.64 rows=18 width=10) (actual time=0.014..0.022 rows=18 loops=3)

  • Recheck Cond: (orgn_ctgry_id = '18'::numeric)
  • Heap Blocks: exact=4
20. 0.010 0.010 ↑ 1.0 18 3

Bitmap Index Scan on tmporgn_lk_idx1 (cost=0.00..4.41 rows=18 width=0) (actual time=0.010..0.010 rows=18 loops=3)

  • Index Cond: (orgn_ctgry_id = '18'::numeric)
21. 0.004 0.004 ↑ 1.0 1 7,852

Index Only Scan using xcld_fp_mttr_id_tbl_pkey on xcld_fp_mttr_id_tbl x_2 (cost=0.42..0.53 rows=1 width=12) (actual time=0.004..0.004 rows=1 loops=7,852)

  • Index Cond: (mttr_id = (mttr_orgn.mttr_id)::text)
  • Heap Fetches: 3
22. 326.895 2,465.528 ↓ 24.6 197 7,852

Materialize (cost=88,134.16..189,619.17 rows=8 width=115) (actual time=0.210..0.314 rows=197 loops=7,852)

23. 0.164 2,138.633 ↓ 24.6 197 1

Nested Loop (cost=88,134.16..189,619.13 rows=8 width=115) (actual time=1,650.890..2,138.633 rows=197 loops=1)

24. 0.222 2,137.878 ↓ 24.6 197 1

Nested Loop Anti Join (cost=88,133.73..189,551.59 rows=8 width=103) (actual time=1,650.879..2,137.878 rows=197 loops=1)

25. 0.962 2,133.330 ↓ 68.7 618 1

Hash Join (cost=88,132.89..189,460.23 rows=9 width=103) (actual time=1,650.859..2,133.330 rows=618 loops=1)

  • Hash Cond: (mttr.dstrt_id = d.dstrt_id)
26. 69.054 2,132.245 ↓ 36.8 2,172 1

Hash Right Join (cost=88,122.52..189,449.12 rows=59 width=86) (actual time=1,650.629..2,132.245 rows=2,172 loops=1)

  • Hash Cond: ((mttr_bllbl_entty_1.mttr_id)::text = (mttr.mttr_id)::text)
27. 69.673 1,769.597 ↓ 1.0 204,272 1

Gather (cost=45,900.44..144,421.96 rows=203,995 width=55) (actual time=1,094.367..1,769.597 rows=204,272 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
28. 79.520 1,699.924 ↑ 1.2 68,091 3

Hash Left Join (cost=44,900.44..121,832.49 rows=84,998 width=55) (actual time=1,099.173..1,699.924 rows=68,091 loops=3)

  • Hash Cond: (mttr_bllbl_entty_1.bllbl_entty_id = b2.bllbl_entty_id)
29. 261.081 1,620.320 ↑ 1.2 68,091 3

Nested Loop (cost=44,896.55..119,914.50 rows=84,998 width=25) (actual time=1,099.056..1,620.320 rows=68,091 loops=3)

  • Join Filter: ((mttr_1.dstrt_id <> '35'::numeric) OR ((mttr_1.dstrt_id = '35'::numeric) AND ((mttr_bllbl_entty_1.tm_trckg_fl)::text = 'Y'::text)))
  • Rows Removed by Join Filter: 728
30. 176.360 1,359.236 ↑ 1.3 68,819 3

Hash Join (cost=44,896.13..59,474.03 rows=86,030 width=51) (actual time=1,099.034..1,359.236 rows=68,819 loops=3)

  • Hash Cond: ((x_4.mttr_id)::text = (x_3.mttr_id)::text)
31. 84.293 84.293 ↑ 1.2 265,286 3

Parallel Seq Scan on xcld_fp_mttr_id_tbl x_4 (cost=0.00..7,620.07 rows=331,607 width=12) (actual time=0.006..84.293 rows=265,286 loops=3)

32. 101.183 1,098.583 ↑ 1.0 206,456 3

Hash (cost=40,701.23..40,701.23 rows=206,472 width=39) (actual time=1,098.583..1,098.583 rows=206,456 loops=3)

  • Buckets: 65536 Batches: 8 Memory Usage: 2412kB
33. 319.405 997.400 ↑ 1.0 206,456 3

Hash Join (cost=26,097.78..40,701.23 rows=206,472 width=39) (actual time=583.598..997.400 rows=206,456 loops=3)

  • Hash Cond: ((mttr_bllbl_entty_1.mttr_id)::text = (x_3.mttr_id)::text)
34. 95.064 95.064 ↑ 1.0 206,472 3

Seq Scan on mttr_bllbl_entty mttr_bllbl_entty_1 (cost=0.00..5,285.74 rows=206,472 width=27) (actual time=0.010..95.064 rows=206,472 loops=3)

  • Filter: ((crrnt_fl)::text = 'Y'::text)
  • Rows Removed by Filter: 8227
35. 327.503 582.931 ↑ 1.0 795,857 3

Hash (cost=12,262.57..12,262.57 rows=795,857 width=12) (actual time=582.931..582.931 rows=795,857 loops=3)

  • Buckets: 131072 Batches: 16 Memory Usage: 3226kB
36. 255.428 255.428 ↑ 1.0 795,857 3

Seq Scan on xcld_fp_mttr_id_tbl x_3 (cost=0.00..12,262.57 rows=795,857 width=12) (actual time=0.007..255.428 rows=795,857 loops=3)

37. 0.003 0.003 ↑ 1.0 1 206,456

Index Scan using mttr_pkey on mttr mttr_1 (cost=0.42..0.69 rows=1 width=17) (actual time=0.003..0.003 rows=1 loops=206,456)

  • Index Cond: ((mttr_id)::text = (x_3.mttr_id)::text)
38. 0.042 0.084 ↑ 1.0 84 3

Hash (cost=2.84..2.84 rows=84 width=10) (actual time=0.084..0.084 rows=84 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 12kB
39. 0.042 0.042 ↑ 1.0 84 3

Seq Scan on bllbl_entty_lk b2 (cost=0.00..2.84 rows=84 width=10) (actual time=0.012..0.042 rows=84 loops=3)

40. 0.609 293.594 ↓ 28.2 1,665 1

Hash (cost=42,221.34..42,221.34 rows=59 width=77) (actual time=293.594..293.594 rows=1,665 loops=1)

  • Buckets: 2048 (originally 1024) Batches: 1 (originally 1) Memory Usage: 142kB
41. 1.914 292.985 ↓ 28.2 1,665 1

Merge Left Join (cost=41,855.12..42,221.34 rows=59 width=77) (actual time=291.766..292.985 rows=1,665 loops=1)

  • Merge Cond: ((mttr.mttr_id)::text = (zz5.mttr_id)::text)
42. 1.630 12.778 ↓ 28.2 1,665 1

Sort (cost=12,273.63..12,273.78 rows=59 width=73) (actual time=12.380..12.778 rows=1,665 loops=1)

  • Sort Key: mttr.mttr_id
  • Sort Method: quicksort Memory: 224kB
43. 11.148 11.148 ↓ 28.2 1,665 1

Index Scan using mttr_st_id_idx on mttr (cost=0.42..12,271.90 rows=59 width=73) (actual time=0.024..11.148 rows=1,665 loops=1)

  • Index Cond: (mttr_st_id = '1'::numeric)
  • Filter: (((crtd_dt)::date >= to_date('2018-11-01'::text, 'yyyy-mm-dd'::text)) AND ((crtd_dt)::date <= to_date('2018-12-03'::text, 'yyyy-mm-dd'::text)))
  • Rows Removed by Filter: 10213
44. 2.139 278.293 ↓ 106.6 4,370 1

Materialize (cost=29,581.48..29,947.30 rows=41 width=21) (actual time=265.929..278.293 rows=4,370 loops=1)

45. 2.559 276.154 ↓ 106.6 4,370 1

Subquery Scan on zz5 (cost=29,581.48..29,947.20 rows=41 width=21) (actual time=265.927..276.154 rows=4,370 loops=1)

  • Filter: (zz5.rn = 1)
  • Rows Removed by Filter: 3458
46. 6.080 273.595 ↑ 1.0 7,828 1

WindowAgg (cost=29,581.48..29,845.61 rows=8,127 width=55) (actual time=265.925..273.595 rows=7,828 loops=1)

47. 8.105 267.515 ↑ 1.0 7,828 1

Sort (cost=29,581.48..29,601.80 rows=8,127 width=25) (actual time=265.918..267.515 rows=7,828 loops=1)

  • Sort Key: mttr_bllbl_entty_2.mttr_id, (CASE WHEN (mttr_bllbl_entty_2.bllbl_entty_id = ANY ('{23,24,25,26,8,15}'::numeric[])) THEN 1 ELSE 2 END), ((mttr_bllbl_entty_2.last_updt_dt)::date) DESC
  • Sort Method: quicksort Memory: 804kB
48. 5.358 259.410 ↑ 1.0 7,828 1

Gather (cost=6,393.32..29,053.69 rows=8,127 width=25) (actual time=49.203..259.410 rows=7,828 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
49. 10.744 254.052 ↑ 1.3 2,609 3

Nested Loop (cost=5,393.32..27,193.58 rows=3,386 width=25) (actual time=66.783..254.052 rows=2,609 loops=3)

50. 2.500 243.306 ↑ 1.3 2,609 3

Hash Left Join (cost=5,392.89..25,445.76 rows=3,386 width=54) (actual time=66.761..243.306 rows=2,609 loops=3)

  • Hash Cond: (mttr_bllbl_entty_2.bllbl_entty_id = b2_1.bllbl_entty_id)
51. 11.574 240.713 ↑ 1.3 2,609 3

Nested Loop (cost=5,389.00..25,399.48 rows=3,386 width=49) (actual time=66.641..240.713 rows=2,609 loops=3)

  • Join Filter: ((mttr_2.dstrt_id <> '35'::numeric) OR ((mttr_2.dstrt_id = '35'::numeric) AND ((mttr_bllbl_entty_2.tm_trckg_fl)::text = 'N'::text)))
  • Rows Removed by Join Filter: 133
52. 98.061 229.136 ↑ 1.3 2,742 3

Hash Join (cost=5,388.57..22,991.14 rows=3,428 width=39) (actual time=61.685..229.136 rows=2,742 loops=3)

  • Hash Cond: ((x_5.mttr_id)::text = (mttr_bllbl_entty_2.mttr_id)::text)
53. 87.689 87.689 ↑ 1.2 265,286 3

Parallel Seq Scan on xcld_fp_mttr_id_tbl x_5 (cost=0.00..7,620.07 rows=331,607 width=12) (actual time=0.007..87.689 rows=265,286 loops=3)

54. 4.563 43.386 ↑ 1.0 8,227 3

Hash (cost=5,285.74..5,285.74 rows=8,227 width=27) (actual time=43.386..43.386 rows=8,227 loops=3)

  • Buckets: 16384 Batches: 1 Memory Usage: 635kB
55. 38.823 38.823 ↑ 1.0 8,227 3

Seq Scan on mttr_bllbl_entty mttr_bllbl_entty_2 (cost=0.00..5,285.74 rows=8,227 width=27) (actual time=0.659..38.823 rows=8,227 loops=3)

  • Filter: ((crrnt_fl)::text = 'N'::text)
  • Rows Removed by Filter: 206472
56. 0.003 0.003 ↑ 1.0 1 8,227

Index Scan using mttr_pkey on mttr mttr_2 (cost=0.42..0.69 rows=1 width=17) (actual time=0.003..0.003 rows=1 loops=8,227)

  • Index Cond: ((mttr_id)::text = (x_5.mttr_id)::text)
57. 0.049 0.093 ↑ 1.0 84 3

Hash (cost=2.84..2.84 rows=84 width=10) (actual time=0.093..0.093 rows=84 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 12kB
58. 0.044 0.044 ↑ 1.0 84 3

Seq Scan on bllbl_entty_lk b2_1 (cost=0.00..2.84 rows=84 width=10) (actual time=0.010..0.044 rows=84 loops=3)

59. 0.002 0.002 ↑ 1.0 1 7,828

Index Only Scan using xcld_fp_mttr_id_tbl_pkey on xcld_fp_mttr_id_tbl x_6 (cost=0.42..0.51 rows=1 width=12) (actual time=0.002..0.002 rows=1 loops=7,828)

  • Index Cond: (mttr_id = (x_5.mttr_id)::text)
  • Heap Fetches: 2583
60. 0.012 0.123 ↑ 1.1 23 1

Hash (cost=10.05..10.05 rows=25 width=27) (actual time=0.123..0.123 rows=23 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
61. 0.111 0.111 ↑ 1.1 23 1

Seq Scan on dstrt_lk d (cost=0.00..10.05 rows=25 width=27) (actual time=0.006..0.111 rows=23 loops=1)

  • Filter: ((dstrt_cd)::text = ANY ('{OL,OO,CI,DF,FQ,MI,OT,OH,TR,TA,TP,TC,TD,MB,FI,SI,SS,OC,SH,BT,RL,TC,TD,SV,AX}'::text[]))
  • Rows Removed by Filter: 148
62. 1.012 4.326 ↑ 1.0 1 618

Nested Loop (cost=0.84..10.14 rows=1 width=12) (actual time=0.007..0.007 rows=1 loops=618)

63. 2.472 2.472 ↑ 1.0 1 618

Index Scan using mttr_bllbl_entty_mttr_id_idx on mttr_bllbl_entty (cost=0.42..8.38 rows=1 width=12) (actual time=0.004..0.004 rows=1 loops=618)

  • Index Cond: ((mttr.mttr_id)::text = (mttr_id)::text)
  • Filter: (bllbl_entty_id = ANY ('{23,24,25,26,8,15}'::numeric[]))
  • Rows Removed by Filter: 3
64. 0.842 0.842 ↑ 1.0 1 421

Index Only Scan using xcld_fp_mttr_id_tbl_pkey on xcld_fp_mttr_id_tbl x_1 (cost=0.42..1.76 rows=1 width=12) (actual time=0.002..0.002 rows=1 loops=421)

  • Index Cond: (mttr_id = (mttr_bllbl_entty.mttr_id)::text)
  • Heap Fetches: 421
65. 0.591 0.591 ↑ 1.0 1 197

Index Only Scan using xcld_fp_mttr_id_tbl_pkey on xcld_fp_mttr_id_tbl x (cost=0.42..8.44 rows=1 width=12) (actual time=0.003..0.003 rows=1 loops=197)

  • Index Cond: (mttr_id = (mttr.mttr_id)::text)
  • Heap Fetches: 197
66. 0.000 0.000 ↓ 0.0 0

Subquery Scan on zz6 (cost=231,337.83..261,291.49 rows=4,608 width=34) (never executed)

  • Filter: (zz6.rn = 1)
67. 0.000 0.000 ↓ 0.0 0

WindowAgg (cost=231,337.83..249,770.85 rows=921,651 width=50) (never executed)

68. 0.000 0.000 ↓ 0.0 0

Sort (cost=231,337.83..233,641.96 rows=921,651 width=42) (never executed)

  • Sort Key: mttr_cause.mttr_id, mttr_cause.last_updt_dt DESC
69. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=26,128.93..83,323.51 rows=921,651 width=42) (never executed)

  • Hash Cond: (mttr_cause.cause_code_id = c2.cause_code_id)
70. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=26,097.78..71,666.13 rows=921,651 width=25) (never executed)

  • Hash Cond: ((mttr_cause.mttr_id)::text = (x_7.mttr_id)::text)
71. 0.000 0.000 ↓ 0.0 0

Seq Scan on mttr_cause (cost=0.00..17,443.51 rows=921,651 width=25) (never executed)

72. 0.000 0.000 ↓ 0.0 0

Hash (cost=12,262.57..12,262.57 rows=795,857 width=12) (never executed)

73. 0.000 0.000 ↓ 0.0 0

Seq Scan on xcld_fp_mttr_id_tbl x_7 (cost=0.00..12,262.57 rows=795,857 width=12) (never executed)

74. 0.000 0.000 ↓ 0.0 0

Hash (cost=20.51..20.51 rows=851 width=27) (never executed)

75. 0.000 0.000 ↓ 0.0 0

Seq Scan on cause_code_lk c2 (cost=0.00..20.51 rows=851 width=27) (never executed)

76. 0.000 0.000 ↓ 0.0 0

Subquery Scan on zz7 (cost=140,990.11..144,952.90 rows=610 width=16) (never executed)

  • Filter: (zz7.rn = 1)
77. 0.000 0.000 ↓ 0.0 0

WindowAgg (cost=140,990.11..143,428.75 rows=121,932 width=80) (never executed)

78. 0.000 0.000 ↓ 0.0 0

Sort (cost=140,990.11..141,294.94 rows=121,932 width=18) (never executed)

  • Sort Key: mttr_cntct.mttr_id, mttr_cntct.prmry_fl DESC NULLS LAST
79. 0.000 0.000 ↓ 0.0 0

Gather (cost=3,263.72..128,186.96 rows=121,932 width=18) (never executed)

  • Workers Planned: 2
  • Workers Launched: 0
80. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=2,263.72..114,993.76 rows=50,805 width=18) (never executed)

81. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=2,263.29..89,340.73 rows=50,805 width=18) (never executed)

  • Hash Cond: ((mttr_cntct.mp_id)::text = (c2_1.mkt_prtcp_id)::text)
82. 0.000 0.000 ↓ 0.0 0

Parallel Seq Scan on mttr_cntct (cost=0.00..62,043.22 rows=338,292 width=18) (never executed)

  • Filter: (((actv_ind)::text = 'A'::text) AND ((row_type)::text = 'F'::text))
83. 0.000 0.000 ↓ 0.0 0

Hash (cost=2,189.47..2,189.47 rows=5,906 width=4) (never executed)

84. 0.000 0.000 ↓ 0.0 0

Seq Scan on mkt_prtcp_eqty_hs c2_1 (cost=0.00..2,189.47 rows=5,906 width=4) (never executed)

  • Filter: (((mkt_cntr_id)::text ~~ 'NASDAQ'::text) AND (xprtn_dt = '2399-12-31'::date))
85. 0.000 0.000 ↓ 0.0 0

Index Only Scan using xcld_fp_mttr_id_tbl_pkey on xcld_fp_mttr_id_tbl x_8 (cost=0.42..0.50 rows=1 width=12) (never executed)

  • Index Cond: (mttr_id = (mttr_cntct.mttr_id)::text)
  • Heap Fetches: 0
86. 0.000 0.000 ↓ 0.0 0

Subquery Scan on zz8 (cost=121,455.43..123,071.67 rows=202 width=44) (never executed)

  • Filter: (zz8.rn = 1)
87. 0.000 0.000 ↓ 0.0 0

WindowAgg (cost=121,455.43..122,566.59 rows=40,406 width=58) (never executed)

88. 0.000 0.000 ↓ 0.0 0

Sort (cost=121,455.43..121,556.44 rows=40,406 width=300) (never executed)

  • Sort Key: mttr_cmmnt.mttr_id, mttr_cmmnt.mttr_cmmnt_id DESC
89. 0.000 0.000 ↓ 0.0 0

Gather (cost=1,894.54..112,700.91 rows=40,406 width=300) (never executed)

  • Workers Planned: 2
  • Workers Launched: 0
90. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=894.54..107,660.31 rows=16,836 width=300) (never executed)

91. 0.000 0.000 ↓ 0.0 0

Parallel Bitmap Heap Scan on mttr_cmmnt (cost=894.11..79,090.17 rows=16,836 width=300) (never executed)

  • Recheck Cond: (mttr_cmmnt_type_id = '14'::numeric)
  • Filter: ((actv_ind)::text = 'A'::text)
92. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on mttr_cmmnt_idx2 (cost=0.00..884.01 rows=41,011 width=0) (never executed)

  • Index Cond: (mttr_cmmnt_type_id = '14'::numeric)
93. 0.000 0.000 ↓ 0.0 0

Index Only Scan using xcld_fp_mttr_id_tbl_pkey on xcld_fp_mttr_id_tbl x_9 (cost=0.42..1.70 rows=1 width=12) (never executed)

  • Index Cond: (mttr_id = (mttr_cmmnt.mttr_id)::text)
  • Heap Fetches: 0
94. 0.000 0.000 ↓ 0.0 0

Subquery Scan on zz9 (cost=605,570.04..710,636.36 rows=13,133 width=44) (never executed)

  • Filter: (zz9.rn = 1)
95. 0.000 0.000 ↓ 0.0 0

WindowAgg (cost=605,570.04..677,803.14 rows=2,626,658 width=54) (never executed)

96. 0.000 0.000 ↓ 0.0 0

Sort (cost=605,570.04..612,136.69 rows=2,626,658 width=31) (never executed)

  • Sort Key: mttr_staff.mttr_id, mttr_staff.prmry_fl DESC NULLS LAST
97. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=26,492.46..199,813.30 rows=2,626,658 width=31) (never executed)

  • Hash Cond: (mttr_staff.staff_id = s2.staff_id)
98. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=26,097.78..166,259.54 rows=2,626,658 width=19) (never executed)

  • Hash Cond: ((mttr_staff.mttr_id)::text = (x_10.mttr_id)::text)
99. 0.000 0.000 ↓ 0.0 0

Seq Scan on mttr_staff (cost=0.00..72,331.23 rows=2,626,658 width=19) (never executed)

  • Filter: ((actv_ind)::text = 'A'::text)
100. 0.000 0.000 ↓ 0.0 0

Hash (cost=12,262.57..12,262.57 rows=795,857 width=12) (never executed)

101. 0.000 0.000 ↓ 0.0 0

Seq Scan on xcld_fp_mttr_id_tbl x_10 (cost=0.00..12,262.57 rows=795,857 width=12) (never executed)

102. 0.000 0.000 ↓ 0.0 0

Hash (cost=277.08..277.08 rows=9,408 width=22) (never executed)

103. 0.000 0.000 ↓ 0.0 0

Seq Scan on staff s2 (cost=0.00..277.08 rows=9,408 width=22) (never executed)

104. 0.000 0.000 ↓ 0.0 0

Subquery Scan on zz10 (cost=312,400.04..351,844.06 rows=6,068 width=37) (never executed)

  • Filter: (zz10.rn = 1)
105. 0.000 0.000 ↓ 0.0 0

WindowAgg (cost=312,400.04..336,673.28 rows=1,213,662 width=51) (never executed)

106. 0.000 0.000 ↓ 0.0 0

Sort (cost=312,400.04..315,434.20 rows=1,213,662 width=43) (never executed)

  • Sort Key: mttr_prdct.mttr_id, mttr_prdct.mttr_prdct_id DESC
107. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=26,101.97..115,084.82 rows=1,213,662 width=43) (never executed)

  • Hash Cond: (mttr_prdct.prdct_id = p2.prdct_id)
108. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=26,097.78..99,864.29 rows=1,213,662 width=27) (never executed)

  • Hash Cond: ((mttr_prdct.mttr_id)::text = (x_11.mttr_id)::text)
109. 0.000 0.000 ↓ 0.0 0

Seq Scan on mttr_prdct (cost=0.00..37,963.04 rows=1,213,662 width=27) (never executed)

  • Filter: ((actv_ind)::text = 'A'::text)
110. 0.000 0.000 ↓ 0.0 0

Hash (cost=12,262.57..12,262.57 rows=795,857 width=12) (never executed)

111. 0.000 0.000 ↓ 0.0 0

Seq Scan on xcld_fp_mttr_id_tbl x_11 (cost=0.00..12,262.57 rows=795,857 width=12) (never executed)

112. 0.000 0.000 ↓ 0.0 0

Hash (cost=2.97..2.97 rows=97 width=26) (never executed)

113. 0.000 0.000 ↓ 0.0 0

Seq Scan on prdct_lk p2 (cost=0.00..2.97 rows=97 width=26) (never executed)

114. 0.000 0.000 ↓ 0.0 0

Unique (cost=560,400.49..561,570.73 rows=156,033 width=44) (never executed)

115. 0.000 0.000 ↓ 0.0 0

Sort (cost=560,400.49..560,790.57 rows=156,033 width=44) (never executed)

  • Sort Key: tm_entry.mttr_id, (sum(CASE WHEN (tm_entry.bllbl_entty_id = ANY ('{8,15}'::numeric[])) THEN tm_entry.actvy_hours_ct WHEN (tm_entry.bllbl_entty_id = '23'::numeric) THEN (tm_entry.actvy_hours_ct * 0.05) WHEN (tm_entry.bllbl_entty_id = '24'::numeric) THEN (tm_entry.actvy_hours_ct * 0.04) WHEN (tm_entry.bllbl_entty_id = '25'::numeric) THEN (tm_entry.actvy_hours_ct * 0.03) WHEN (tm_entry.bllbl_entty_id = '26'::numeric) THEN (tm_entry.actvy_hours_ct * 0.02) ELSE NULL::numeric END))
116. 0.000 0.000 ↓ 0.0 0

Finalize GroupAggregate (cost=492,201.54..542,139.48 rows=156,033 width=44) (never executed)

  • Group Key: tm_entry.mttr_id
117. 0.000 0.000 ↓ 0.0 0

Gather Merge (cost=492,201.54..537,848.57 rows=312,066 width=44) (never executed)

  • Workers Planned: 2
  • Workers Launched: 0
118. 0.000 0.000 ↓ 0.0 0

Partial GroupAggregate (cost=491,201.51..500,828.38 rows=156,033 width=44) (never executed)

  • Group Key: tm_entry.mttr_id
119. 0.000 0.000 ↓ 0.0 0

Sort (cost=491,201.51..491,841.22 rows=255,882 width=22) (never executed)

  • Sort Key: tm_entry.mttr_id
120. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=47,278.95..462,966.76 rows=255,882 width=22) (never executed)

  • Hash Cond: ((tm_entry.mttr_id)::text = (x_12.mttr_id)::text)
  • Filter: ((tm_entry.mttr_id IS NULL) OR (x_12.mttr_id IS NOT NULL))
121. 0.000 0.000 ↓ 0.0 0

Parallel Bitmap Heap Scan on tm_entry (cost=21,181.17..426,751.47 rows=255,882 width=22) (never executed)

  • Recheck Cond: (bllbl_entty_id = ANY ('{23,24,25,26,8,15}'::numeric[]))
  • Filter: ((mttr_id IS NOT NULL) AND (actvy_hours_ct > '0'::numeric) AND ((actv_ind)::text = 'A'::text))
122. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on tm_entry_idx2 (cost=0.00..21,027.64 rows=996,405 width=0) (never executed)

  • Index Cond: (bllbl_entty_id = ANY ('{23,24,25,26,8,15}'::numeric[]))
123. 0.000 0.000 ↓ 0.0 0

Hash (cost=12,262.57..12,262.57 rows=795,857 width=12) (never executed)

124. 0.000 0.000 ↓ 0.0 0

Seq Scan on xcld_fp_mttr_id_tbl x_12 (cost=0.00..12,262.57 rows=795,857 width=12) (never executed)

125. 2.553 608,389.840 ↓ 0.0 0 1

Merge Join (cost=2,199,467.73..2,254,260.07 rows=1 width=301) (actual time=608,389.840..608,389.840 rows=0 loops=1)

  • Merge Cond: ((mttr_3.asctd_mttr_id)::text = (x_14.mttr_id)::text)
126. 2,622.849 608,224.403 ↓ 37.4 337 1

Nested Loop Left Join (cost=2,183,771.92..2,676,209.70 rows=9 width=265) (actual time=35,681.276..608,224.403 rows=337 loops=1)

  • Join Filter: ((mttr_3.mttr_id)::text = (m8.mttr_id)::text)
  • Rows Removed by Join Filter: 10683064
127. 62,554.480 600,131.370 ↓ 37.4 337 1

Nested Loop Left Join (cost=1,623,371.43..2,079,276.10 rows=9 width=233) (actual time=32,454.416..600,131.370 rows=337 loops=1)

  • Join Filter: ((mttr_3.mttr_id)::text = (zz19.mttr_id)::text)
  • Rows Removed by Join Filter: 218131120
128. 74,703.914 473,691.126 ↓ 37.4 337 1

Nested Loop Left Join (cost=1,310,971.39..1,726,597.69 rows=9 width=208) (actual time=25,935.527..473,691.126 rows=337 loops=1)

  • Join Filter: ((mttr_3.mttr_id)::text = (zz18.mttr_id)::text)
  • Rows Removed by Join Filter: 267971034
129. 3,636.392 313,981.658 ↓ 37.4 337 1

Nested Loop Left Join (cost=705,401.35..1,014,155.54 rows=9 width=176) (actual time=12,539.668..313,981.658 rows=337 loops=1)

  • Join Filter: ((mttr_3.mttr_id)::text = (zz_1.mttr_id)::text)
  • Rows Removed by Join Filter: 12895961
130. 29,568.489 306,214.994 ↓ 37.4 337 1

Nested Loop Left Join (cost=583,945.92..891,056.10 rows=9 width=144) (actual time=12,242.807..306,214.994 rows=337 loops=1)

  • Join Filter: ((mttr_3.mttr_id)::text = (zz17.mttr_id)::text)
  • Rows Removed by Join Filter: 105652696
131. 61,809.593 248,020.377 ↓ 37.4 337 1

Nested Loop Left Join (cost=442,955.82..746,019.33 rows=9 width=140) (actual time=10,140.165..248,020.377 rows=337 loops=1)

  • Join Filter: ((mttr_3.mttr_id)::text = (zz.mttr_id)::text)
  • Rows Removed by Join Filter: 220919431
132. 52,788.638 122,504.304 ↓ 37.4 337 1

Nested Loop Left Join (cost=211,617.99..484,094.24 rows=9 width=118) (actual time=5,444.742..122,504.304 rows=337 loops=1)

  • Join Filter: ((mttr_3.mttr_id)::text = (zz16.mttr_id)::text)
  • Rows Removed by Join Filter: 190565195
133. 365.913 16,877.773 ↓ 37.4 337 1

Nested Loop Left Join (cost=76,482.94..329,819.54 rows=9 width=103) (actual time=1,957.297..16,877.773 rows=337 loops=1)

  • Join Filter: ((mttr_3.mttr_id)::text = (zz15.mttr_id)::text)
  • Rows Removed by Join Filter: 1472664
134. 7,474.828 15,955.136 ↓ 37.4 337 1

Nested Loop Left Join (cost=46,901.46..299,866.71 rows=9 width=94) (actual time=1,691.418..15,955.136 rows=337 loops=1)

  • Join Filter: ((mttr_3.mttr_id)::text = (zz13.mttr_id)::text)
  • Rows Removed by Join Filter: 25687745
135. 0.000 28.102 ↓ 14.0 126 1

Gather Merge (cost=1,001.02..114,591.49 rows=9 width=85) (actual time=27.540..28.102 rows=126 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
136. 0.210 299.370 ↓ 23.2 93 3

Nested Loop (cost=0.99..113,590.43 rows=4 width=85) (actual time=21.624..99.790 rows=93 loops=3)

137. 1.644 298.323 ↓ 23.2 93 3

Nested Loop (cost=0.57..113,556.66 rows=4 width=85) (actual time=21.603..99.441 rows=93 loops=3)

138. 293.349 293.349 ↓ 22.2 555 3

Parallel Index Scan using mttr_idx13 on mttr mttr_3 (cost=0.42..113,543.31 rows=25 width=73) (actual time=19.563..97.783 rows=555 loops=3)

  • Filter: ((mttr_st_id = '1'::numeric) AND ((crtd_dt)::date >= to_date('2018-11-01'::text, 'yyyy-mm-dd'::text)) AND ((crtd_dt)::date <= to_date('2018-12-03'::text, 'yyyy-mm-dd'::text)))
  • Rows Removed by Filter: 264805
139. 3.330 3.330 ↓ 0.0 0 1,665

Index Scan using dstrt_lk_pkey on dstrt_lk d_1 (cost=0.14..0.53 rows=1 width=27) (actual time=0.002..0.002 rows=0 loops=1,665)

  • Index Cond: (dstrt_id = mttr_3.dstrt_id)
  • Filter: ((dstrt_cd)::text = ANY ('{OL,OO,CI,DF,FQ,MI,OT,OH,TR,TA,TP,TC,TD,MB,FI,SI,SS,OC,SH,BT,RL,TC,TD,SV,AX}'::text[]))
  • Rows Removed by Filter: 1
140. 0.837 0.837 ↑ 1.0 1 279

Index Only Scan using xcld_fp_mttr_id_tbl_pkey on xcld_fp_mttr_id_tbl x_13 (cost=0.42..8.44 rows=1 width=12) (actual time=0.003..0.003 rows=1 loops=279)

  • Index Cond: (mttr_id = (mttr_3.mttr_id)::text)
  • Heap Fetches: 1
141. 6,766.538 8,452.206 ↑ 1.0 203,874 126

Materialize (cost=45,900.44..148,677.88 rows=203,995 width=21) (actual time=7.461..67.081 rows=203,874 loops=126)

142. 102.464 1,685.668 ↓ 1.0 204,272 1

Subquery Scan on zz13 (cost=45,900.44..146,461.91 rows=203,995 width=21) (actual time=939.734..1,685.668 rows=204,272 loops=1)

143. 26.204 1,583.204 ↓ 1.0 204,272 1

Gather (cost=45,900.44..144,421.96 rows=203,995 width=55) (actual time=939.732..1,583.204 rows=204,272 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
144. 82.050 1,557.000 ↑ 1.2 68,091 3

Hash Left Join (cost=44,900.44..121,832.49 rows=84,998 width=55) (actual time=948.378..1,557.000 rows=68,091 loops=3)

  • Hash Cond: (mttr_bllbl_entty_3.bllbl_entty_id = b2_2.bllbl_entty_id)
145. 262.028 1,474.867 ↑ 1.2 68,091 3

Nested Loop (cost=44,896.55..119,914.50 rows=84,998 width=25) (actual time=948.263..1,474.867 rows=68,091 loops=3)

  • Join Filter: ((mttr_4.dstrt_id <> '35'::numeric) OR ((mttr_4.dstrt_id = '35'::numeric) AND ((mttr_bllbl_entty_3.tm_trckg_fl)::text = 'Y'::text)))
  • Rows Removed by Join Filter: 728
146. 178.822 1,212.836 ↑ 1.3 68,819 3

Hash Join (cost=44,896.13..59,474.03 rows=86,030 width=51) (actual time=948.242..1,212.836 rows=68,819 loops=3)

  • Hash Cond: ((x_16.mttr_id)::text = (x_15.mttr_id)::text)
147. 86.232 86.232 ↑ 1.2 265,286 3

Parallel Seq Scan on xcld_fp_mttr_id_tbl x_16 (cost=0.00..7,620.07 rows=331,607 width=12) (actual time=0.007..86.232 rows=265,286 loops=3)

148. 102.099 947.782 ↑ 1.0 206,456 3

Hash (cost=40,701.23..40,701.23 rows=206,472 width=39) (actual time=947.782..947.782 rows=206,456 loops=3)

  • Buckets: 65536 Batches: 8 Memory Usage: 2412kB
149. 257.657 845.683 ↑ 1.0 206,456 3

Hash Join (cost=26,097.78..40,701.23 rows=206,472 width=39) (actual time=494.640..845.683 rows=206,456 loops=3)

  • Hash Cond: ((mttr_bllbl_entty_3.mttr_id)::text = (x_15.mttr_id)::text)
150. 94.054 94.054 ↑ 1.0 206,472 3

Seq Scan on mttr_bllbl_entty mttr_bllbl_entty_3 (cost=0.00..5,285.74 rows=206,472 width=27) (actual time=0.010..94.054 rows=206,472 loops=3)

  • Filter: ((crrnt_fl)::text = 'Y'::text)
  • Rows Removed by Filter: 8227
151. 286.270 493.972 ↑ 1.0 795,857 3

Hash (cost=12,262.57..12,262.57 rows=795,857 width=12) (actual time=493.972..493.972 rows=795,857 loops=3)

  • Buckets: 131072 Batches: 16 Memory Usage: 3226kB
152. 207.702 207.702 ↑ 1.0 795,857 3

Seq Scan on xcld_fp_mttr_id_tbl x_15 (cost=0.00..12,262.57 rows=795,857 width=12) (actual time=0.007..207.702 rows=795,857 loops=3)

153. 0.003 0.003 ↑ 1.0 1 206,456

Index Scan using mttr_pkey on mttr mttr_4 (cost=0.42..0.69 rows=1 width=17) (actual time=0.003..0.003 rows=1 loops=206,456)

  • Index Cond: ((mttr_id)::text = (x_15.mttr_id)::text)
154. 0.041 0.083 ↑ 1.0 84 3

Hash (cost=2.84..2.84 rows=84 width=10) (actual time=0.083..0.083 rows=84 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 12kB
155. 0.042 0.042 ↑ 1.0 84 3

Seq Scan on bllbl_entty_lk b2_2 (cost=0.00..2.84 rows=84 width=10) (actual time=0.012..0.042 rows=84 loops=3)

156. 293.923 556.724 ↓ 106.6 4,370 337

Materialize (cost=29,581.48..29,947.40 rows=41 width=21) (actual time=0.750..1.652 rows=4,370 loops=337)

157. 2.616 262.801 ↓ 106.6 4,370 1

Subquery Scan on zz15 (cost=29,581.48..29,947.20 rows=41 width=21) (actual time=252.518..262.801 rows=4,370 loops=1)

  • Filter: (zz15.rn = 1)
  • Rows Removed by Filter: 3458
158. 6.079 260.185 ↑ 1.0 7,828 1

WindowAgg (cost=29,581.48..29,845.61 rows=8,127 width=55) (actual time=252.516..260.185 rows=7,828 loops=1)

159. 8.139 254.106 ↑ 1.0 7,828 1

Sort (cost=29,581.48..29,601.80 rows=8,127 width=25) (actual time=252.510..254.106 rows=7,828 loops=1)

  • Sort Key: mttr_bllbl_entty_4.mttr_id, (CASE WHEN (mttr_bllbl_entty_4.bllbl_entty_id = ANY ('{23,24,25,26,8,15}'::numeric[])) THEN 1 ELSE 2 END), ((mttr_bllbl_entty_4.last_updt_dt)::date) DESC
  • Sort Method: quicksort Memory: 804kB
160. 4.688 245.967 ↑ 1.0 7,828 1

Gather (cost=6,393.32..29,053.69 rows=8,127 width=25) (actual time=44.479..245.967 rows=7,828 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
161. 10.673 241.279 ↑ 1.3 2,609 3

Nested Loop (cost=5,393.32..27,193.58 rows=3,386 width=25) (actual time=42.957..241.279 rows=2,609 loops=3)

162. 2.482 230.604 ↑ 1.3 2,609 3

Hash Left Join (cost=5,392.89..25,445.76 rows=3,386 width=54) (actual time=42.935..230.604 rows=2,609 loops=3)

  • Hash Cond: (mttr_bllbl_entty_4.bllbl_entty_id = b2_3.bllbl_entty_id)
163. 11.438 228.033 ↑ 1.3 2,609 3

Nested Loop (cost=5,389.00..25,399.48 rows=3,386 width=49) (actual time=42.823..228.033 rows=2,609 loops=3)

  • Join Filter: ((mttr_5.dstrt_id <> '35'::numeric) OR ((mttr_5.dstrt_id = '35'::numeric) AND ((mttr_bllbl_entty_4.tm_trckg_fl)::text = 'N'::text)))
  • Rows Removed by Join Filter: 133
164. 96.595 216.592 ↑ 1.3 2,742 3

Hash Join (cost=5,388.57..22,991.14 rows=3,428 width=39) (actual time=42.803..216.592 rows=2,742 loops=3)

  • Hash Cond: ((x_17.mttr_id)::text = (mttr_bllbl_entty_4.mttr_id)::text)
165. 86.711 86.711 ↑ 1.2 265,286 3

Parallel Seq Scan on xcld_fp_mttr_id_tbl x_17 (cost=0.00..7,620.07 rows=331,607 width=12) (actual time=0.007..86.711 rows=265,286 loops=3)

166. 3.522 33.286 ↑ 1.0 8,227 3

Hash (cost=5,285.74..5,285.74 rows=8,227 width=27) (actual time=33.286..33.286 rows=8,227 loops=3)

  • Buckets: 16384 Batches: 1 Memory Usage: 635kB
167. 29.764 29.764 ↑ 1.0 8,227 3

Seq Scan on mttr_bllbl_entty mttr_bllbl_entty_4 (cost=0.00..5,285.74 rows=8,227 width=27) (actual time=0.512..29.764 rows=8,227 loops=3)

  • Filter: ((crrnt_fl)::text = 'N'::text)
  • Rows Removed by Filter: 206472
168. 0.003 0.003 ↑ 1.0 1 8,227

Index Scan using mttr_pkey on mttr mttr_5 (cost=0.42..0.69 rows=1 width=17) (actual time=0.003..0.003 rows=1 loops=8,227)

  • Index Cond: ((mttr_id)::text = (x_17.mttr_id)::text)
169. 0.047 0.089 ↑ 1.0 84 3

Hash (cost=2.84..2.84 rows=84 width=10) (actual time=0.089..0.089 rows=84 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 12kB
170. 0.042 0.042 ↑ 1.0 84 3

Seq Scan on bllbl_entty_lk b2_3 (cost=0.00..2.84 rows=84 width=10) (actual time=0.008..0.042 rows=84 loops=3)

171. 0.002 0.002 ↑ 1.0 1 7,828

Index Only Scan using xcld_fp_mttr_id_tbl_pkey on xcld_fp_mttr_id_tbl x_18 (cost=0.42..0.51 rows=1 width=12) (actual time=0.002..0.002 rows=1 loops=7,828)

  • Index Cond: (mttr_id = (x_17.mttr_id)::text)
  • Heap Fetches: 2376
172. 49,772.115 52,837.893 ↓ 196.1 565,476 337

Materialize (cost=135,135.04..153,892.57 rows=2,884 width=27) (actual time=6.167..156.789 rows=565,476 loops=337)

173. 238.640 3,065.778 ↓ 196.1 565,506 1

Subquery Scan on zz16 (cost=135,135.04..153,878.15 rows=2,884 width=27) (actual time=2,077.347..3,065.778 rows=565,506 loops=1)

  • Filter: (zz16.rn = 1)
  • Rows Removed by Filter: 11143
174. 492.463 2,827.138 ↑ 1.0 576,649 1

WindowAgg (cost=135,135.04..146,669.26 rows=576,711 width=43) (actual time=2,077.344..2,827.138 rows=576,649 loops=1)

175. 776.719 2,334.675 ↑ 1.0 576,649 1

Sort (cost=135,135.04..136,576.82 rows=576,711 width=35) (actual time=2,077.339..2,334.675 rows=576,649 loops=1)

  • Sort Key: mttr_orgn_2.mttr_id, mttr_orgn_2.last_updt_dt DESC
  • Sort Method: external merge Disk: 24928kB
176. 384.001 1,557.956 ↑ 1.0 576,649 1

Hash Join (cost=26,133.19..64,180.04 rows=576,711 width=35) (actual time=442.617..1,557.956 rows=576,649 loops=1)

  • Hash Cond: (mttr_orgn_2.orgn_id = o2_2.orgn_id)
177. 550.147 1,172.999 ↑ 1.0 576,649 1

Hash Join (cost=26,097.78..56,214.86 rows=576,711 width=25) (actual time=441.653..1,172.999 rows=576,649 loops=1)

  • Hash Cond: ((mttr_orgn_2.mttr_id)::text = (x_19.mttr_id)::text)
178. 181.629 181.629 ↑ 1.0 576,711 1

Seq Scan on mttr_orgn mttr_orgn_2 (cost=0.00..11,063.11 rows=576,711 width=25) (actual time=0.006..181.629 rows=576,711 loops=1)

179. 255.716 441.223 ↑ 1.0 795,857 1

Hash (cost=12,262.57..12,262.57 rows=795,857 width=12) (actual time=441.223..441.223 rows=795,857 loops=1)

  • Buckets: 131072 Batches: 16 Memory Usage: 3157kB
180. 185.507 185.507 ↑ 1.0 795,857 1

Seq Scan on xcld_fp_mttr_id_tbl x_19 (cost=0.00..12,262.57 rows=795,857 width=12) (actual time=0.007..185.507 rows=795,857 loops=1)

181. 0.245 0.956 ↑ 1.0 674 1

Hash (cost=26.98..26.98 rows=674 width=20) (actual time=0.956..0.956 rows=674 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 44kB
182. 0.472 0.711 ↑ 1.0 674 1

Hash Join (cost=2.80..26.98 rows=674 width=20) (actual time=0.076..0.711 rows=674 loops=1)

  • Hash Cond: (o2_2.orgn_ctgry_id = o3_2.orgn_ctgry_id)
183. 0.176 0.176 ↑ 1.0 674 1

Seq Scan on orgn_lk o2_2 (cost=0.00..15.74 rows=674 width=10) (actual time=0.008..0.176 rows=674 loops=1)

184. 0.035 0.063 ↑ 1.0 80 1

Hash (cost=1.80..1.80 rows=80 width=20) (actual time=0.063..0.063 rows=80 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 13kB
185. 0.028 0.028 ↑ 1.0 80 1

Seq Scan on orgn_ctgry_lk o3_2 (cost=0.00..1.80 rows=80 width=20) (actual time=0.006..0.028 rows=80 loops=1)

186. 59,220.923 63,706.480 ↓ 142.3 655,548 337

Materialize (cost=231,337.83..261,314.53 rows=4,608 width=34) (actual time=8.929..189.040 rows=655,548 loops=337)

187. 341.746 4,485.557 ↓ 142.3 655,903 1

Subquery Scan on zz (cost=231,337.83..261,291.49 rows=4,608 width=34) (actual time=3,008.091..4,485.557 rows=655,903 loops=1)

  • Filter: (zz.rn = 1)
  • Rows Removed by Filter: 265667
188. 769.884 4,143.811 ↑ 1.0 921,570 1

WindowAgg (cost=231,337.83..249,770.85 rows=921,651 width=50) (actual time=3,008.089..4,143.811 rows=921,570 loops=1)

189. 1,277.733 3,373.927 ↑ 1.0 921,570 1

Sort (cost=231,337.83..233,641.96 rows=921,651 width=42) (actual time=3,008.082..3,373.927 rows=921,570 loops=1)

  • Sort Key: mttr_cause_1.mttr_id, mttr_cause_1.last_updt_dt DESC
  • Sort Method: external merge Disk: 49096kB
190. 590.791 2,096.194 ↑ 1.0 921,570 1

Hash Join (cost=26,128.93..83,323.51 rows=921,651 width=42) (actual time=438.511..2,096.194 rows=921,570 loops=1)

  • Hash Cond: (mttr_cause_1.cause_code_id = c2_2.cause_code_id)
191. 783.170 1,504.812 ↑ 1.0 921,570 1

Hash Join (cost=26,097.78..71,666.13 rows=921,651 width=25) (actual time=437.909..1,504.812 rows=921,570 loops=1)

  • Hash Cond: ((mttr_cause_1.mttr_id)::text = (x_20.mttr_id)::text)
192. 283.978 283.978 ↑ 1.0 921,651 1

Seq Scan on mttr_cause mttr_cause_1 (cost=0.00..17,443.51 rows=921,651 width=25) (actual time=0.006..283.978 rows=921,651 loops=1)

193. 252.021 437.664 ↑ 1.0 795,857 1

Hash (cost=12,262.57..12,262.57 rows=795,857 width=12) (actual time=437.664..437.664 rows=795,857 loops=1)

  • Buckets: 131072 Batches: 16 Memory Usage: 3157kB
194. 185.643 185.643 ↑ 1.0 795,857 1

Seq Scan on xcld_fp_mttr_id_tbl x_20 (cost=0.00..12,262.57 rows=795,857 width=12) (actual time=0.007..185.643 rows=795,857 loops=1)

195. 0.317 0.591 ↑ 1.0 851 1

Hash (cost=20.51..20.51 rows=851 width=27) (actual time=0.591..0.591 rows=851 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 58kB
196. 0.274 0.274 ↑ 1.0 851 1

Seq Scan on cause_code_lk c2_2 (cost=0.00..20.51 rows=851 width=27) (actual time=0.010..0.274 rows=851 loops=1)

197. 26,765.536 28,626.128 ↓ 514.0 313,510 337

Materialize (cost=140,990.11..144,955.95 rows=610 width=16) (actual time=3.907..84.944 rows=313,510 loops=337)

198. 145.526 1,860.592 ↓ 514.0 313,512 1

Subquery Scan on zz17 (cost=140,990.11..144,952.90 rows=610 width=16) (actual time=1,315.210..1,860.592 rows=313,512 loops=1)

  • Filter: (zz17.rn = 1)
  • Rows Removed by Filter: 51014
199. 298.185 1,715.066 ↓ 3.0 364,526 1

WindowAgg (cost=140,990.11..143,428.75 rows=121,932 width=80) (actual time=1,315.208..1,715.066 rows=364,526 loops=1)

200. 738.648 1,416.881 ↓ 3.0 364,526 1

Sort (cost=140,990.11..141,294.94 rows=121,932 width=18) (actual time=1,315.202..1,416.881 rows=364,526 loops=1)

  • Sort Key: mttr_cntct_1.mttr_id, mttr_cntct_1.prmry_fl DESC NULLS LAST
  • Sort Method: external merge Disk: 10352kB
201. 0.000 678.233 ↓ 3.0 364,526 1

Gather (cost=3,263.72..128,186.96 rows=121,932 width=18) (actual time=26.468..678.233 rows=364,526 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
202. 447.479 939.192 ↓ 2.4 121,509 3

Nested Loop (cost=2,263.72..114,993.76 rows=50,805 width=18) (actual time=20.095..939.192 rows=121,509 loops=3)

203. 143.405 491.710 ↓ 2.4 121,509 3

Hash Join (cost=2,263.29..89,340.73 rows=50,805 width=18) (actual time=20.069..491.710 rows=121,509 loops=3)

  • Hash Cond: ((mttr_cntct_1.mp_id)::text = (c2_3.mkt_prtcp_id)::text)
204. 328.407 328.407 ↑ 1.3 264,783 3

Parallel Seq Scan on mttr_cntct mttr_cntct_1 (cost=0.00..62,043.22 rows=338,292 width=18) (actual time=0.008..328.407 rows=264,783 loops=3)

  • Filter: (((actv_ind)::text = 'A'::text) AND ((row_type)::text = 'F'::text))
  • Rows Removed by Filter: 430215
205. 3.466 19.898 ↓ 1.1 6,596 3

Hash (cost=2,189.47..2,189.47 rows=5,906 width=4) (actual time=19.898..19.898 rows=6,596 loops=3)

  • Buckets: 8192 Batches: 1 Memory Usage: 303kB
206. 16.432 16.432 ↓ 1.1 6,596 3

Seq Scan on mkt_prtcp_eqty_hs c2_3 (cost=0.00..2,189.47 rows=5,906 width=4) (actual time=1.136..16.432 rows=6,596 loops=3)

  • Filter: (((mkt_cntr_id)::text ~~ 'NASDAQ'::text) AND (xprtn_dt = '2399-12-31'::date))
  • Rows Removed by Filter: 55102
207. 0.003 0.003 ↑ 1.0 1 364,527

Index Only Scan using xcld_fp_mttr_id_tbl_pkey on xcld_fp_mttr_id_tbl x_21 (cost=0.42..0.50 rows=1 width=12) (actual time=0.003..0.003 rows=1 loops=364,527)

  • Index Cond: (mttr_id = (mttr_cntct_1.mttr_id)::text)
  • Heap Fetches: 36456
208. 3,871.067 4,130.272 ↓ 189.4 38,267 337

Materialize (cost=121,455.43..123,072.68 rows=202 width=44) (actual time=0.494..12.256 rows=38,267 loops=337)

209. 16.792 259.205 ↓ 189.4 38,267 1

Subquery Scan on zz_1 (cost=121,455.43..123,071.67 rows=202 width=44) (actual time=164.977..259.205 rows=38,267 loops=1)

  • Filter: (zz_1.rn = 1)
  • Rows Removed by Filter: 2513
210. 63.752 242.413 ↓ 1.0 40,780 1

WindowAgg (cost=121,455.43..122,566.59 rows=40,406 width=58) (actual time=164.975..242.413 rows=40,780 loops=1)

211. 83.266 178.661 ↓ 1.0 40,780 1

Sort (cost=121,455.43..121,556.44 rows=40,406 width=300) (actual time=164.960..178.661 rows=40,780 loops=1)

  • Sort Key: mttr_cmmnt_1.mttr_id, mttr_cmmnt_1.mttr_cmmnt_id DESC
  • Sort Method: external merge Disk: 6456kB
212. 0.000 95.395 ↓ 1.0 40,780 1

Gather (cost=1,894.54..112,700.91 rows=40,406 width=300) (actual time=17.903..95.395 rows=40,780 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
213. 74.100 109.394 ↑ 1.2 13,593 3

Nested Loop (cost=894.54..107,660.31 rows=16,836 width=300) (actual time=12.354..109.394 rows=13,593 loops=3)

214. 25.072 35.290 ↑ 1.2 13,598 3

Parallel Bitmap Heap Scan on mttr_cmmnt mttr_cmmnt_1 (cost=894.11..79,090.17 rows=16,836 width=300) (actual time=12.327..35.290 rows=13,598 loops=3)

  • Recheck Cond: (mttr_cmmnt_type_id = '14'::numeric)
  • Filter: ((actv_ind)::text = 'A'::text)
  • Rows Removed by Filter: 80
  • Heap Blocks: exact=6793
215. 10.218 10.218 ↓ 1.0 41,034 1

Bitmap Index Scan on mttr_cmmnt_idx2 (cost=0.00..884.01 rows=41,011 width=0) (actual time=10.218..10.218 rows=41,034 loops=1)

  • Index Cond: (mttr_cmmnt_type_id = '14'::numeric)
216. 0.004 0.004 ↑ 1.0 1 40,793

Index Only Scan using xcld_fp_mttr_id_tbl_pkey on xcld_fp_mttr_id_tbl x_22 (cost=0.42..1.70 rows=1 width=12) (actual time=0.004..0.004 rows=1 loops=40,793)

  • Index Cond: (mttr_id = (mttr_cmmnt_1.mttr_id)::text)
  • Heap Fetches: 9405
217. 71,205.371 85,005.554 ↓ 60.5 795,167 337

Materialize (cost=605,570.04..710,702.03 rows=13,133 width=44) (actual time=24.734..252.242 rows=795,167 loops=337)

218. 760.490 13,800.183 ↓ 60.6 795,737 1

Subquery Scan on zz18 (cost=605,570.04..710,636.36 rows=13,133 width=44) (actual time=8,333.866..13,800.183 rows=795,737 loops=1)

  • Filter: (zz18.rn = 1)
  • Rows Removed by Filter: 1829662
219. 3,752.810 13,039.693 ↑ 1.0 2,625,399 1

WindowAgg (cost=605,570.04..677,803.14 rows=2,626,658 width=54) (actual time=8,333.865..13,039.693 rows=2,625,399 loops=1)

220. 3,883.548 9,286.883 ↑ 1.0 2,625,399 1

Sort (cost=605,570.04..612,136.69 rows=2,626,658 width=31) (actual time=8,333.849..9,286.883 rows=2,625,399 loops=1)

  • Sort Key: mttr_staff_1.mttr_id, mttr_staff_1.prmry_fl DESC NULLS LAST
  • Sort Method: external merge Disk: 99792kB
221. 1,737.297 5,403.335 ↑ 1.0 2,625,399 1

Hash Join (cost=26,492.46..199,813.30 rows=2,626,658 width=31) (actual time=452.764..5,403.335 rows=2,625,399 loops=1)

  • Hash Cond: (mttr_staff_1.staff_id = s2_1.staff_id)
222. 2,155.600 3,658.924 ↑ 1.0 2,625,399 1

Hash Join (cost=26,097.78..166,259.54 rows=2,626,658 width=19) (actual time=445.629..3,658.924 rows=2,625,399 loops=1)

  • Hash Cond: ((mttr_staff_1.mttr_id)::text = (x_23.mttr_id)::text)
223. 1,057.965 1,057.965 ↑ 1.0 2,626,658 1

Seq Scan on mttr_staff mttr_staff_1 (cost=0.00..72,331.23 rows=2,626,658 width=19) (actual time=0.006..1,057.965 rows=2,626,658 loops=1)

  • Filter: ((actv_ind)::text = 'A'::text)
224. 259.269 445.359 ↑ 1.0 795,857 1

Hash (cost=12,262.57..12,262.57 rows=795,857 width=12) (actual time=445.359..445.359 rows=795,857 loops=1)

  • Buckets: 131072 Batches: 16 Memory Usage: 3226kB
225. 186.090 186.090 ↑ 1.0 795,857 1

Seq Scan on xcld_fp_mttr_id_tbl x_23 (cost=0.00..12,262.57 rows=795,857 width=12) (actual time=0.006..186.090 rows=795,857 loops=1)

226. 3.752 7.114 ↑ 1.0 9,408 1

Hash (cost=277.08..277.08 rows=9,408 width=22) (actual time=7.114..7.114 rows=9,408 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 635kB
227. 3.362 3.362 ↑ 1.0 9,408 1

Seq Scan on staff s2_1 (cost=0.00..277.08 rows=9,408 width=22) (actual time=0.009..3.362 rows=9,408 loops=1)

228. 57,656.016 63,885.764 ↓ 106.7 647,274 337

Materialize (cost=312,400.04..351,874.40 rows=6,068 width=37) (actual time=13.052..189.572 rows=647,274 loops=337)

229. 406.391 6,229.748 ↓ 106.7 647,548 1

Subquery Scan on zz19 (cost=312,400.04..351,844.06 rows=6,068 width=37) (actual time=4,397.222..6,229.748 rows=647,548 loops=1)

  • Filter: (zz19.rn = 1)
  • Rows Removed by Filter: 565254
230. 953.349 5,823.357 ↑ 1.0 1,212,802 1

WindowAgg (cost=312,400.04..336,673.28 rows=1,213,662 width=51) (actual time=4,397.220..5,823.357 rows=1,212,802 loops=1)

231. 2,122.435 4,870.008 ↑ 1.0 1,212,802 1

Sort (cost=312,400.04..315,434.20 rows=1,213,662 width=43) (actual time=4,397.213..4,870.008 rows=1,212,802 loops=1)

  • Sort Key: mttr_prdct_1.mttr_id, mttr_prdct_1.mttr_prdct_id DESC
  • Sort Method: external merge Disk: 55440kB
232. 769.607 2,747.573 ↑ 1.0 1,212,802 1

Hash Left Join (cost=26,101.97..115,084.82 rows=1,213,662 width=43) (actual time=449.597..2,747.573 rows=1,212,802 loops=1)

  • Hash Cond: (mttr_prdct_1.prdct_id = p2_1.prdct_id)
233. 1,008.258 1,977.888 ↑ 1.0 1,212,802 1

Hash Join (cost=26,097.78..99,864.29 rows=1,213,662 width=27) (actual time=449.507..1,977.888 rows=1,212,802 loops=1)

  • Hash Cond: ((mttr_prdct_1.mttr_id)::text = (x_24.mttr_id)::text)
234. 520.405 520.405 ↑ 1.0 1,212,940 1

Seq Scan on mttr_prdct mttr_prdct_1 (cost=0.00..37,963.04 rows=1,213,662 width=27) (actual time=0.011..520.405 rows=1,212,940 loops=1)

  • Filter: ((actv_ind)::text = 'A'::text)
  • Rows Removed by Filter: 107703
235. 262.690 449.225 ↑ 1.0 795,857 1

Hash (cost=12,262.57..12,262.57 rows=795,857 width=12) (actual time=449.225..449.225 rows=795,857 loops=1)

  • Buckets: 131072 Batches: 16 Memory Usage: 3227kB
236. 186.535 186.535 ↑ 1.0 795,857 1

Seq Scan on xcld_fp_mttr_id_tbl x_24 (cost=0.00..12,262.57 rows=795,857 width=12) (actual time=0.007..186.535 rows=795,857 loops=1)

237. 0.043 0.078 ↑ 1.0 97 1

Hash (cost=2.97..2.97 rows=97 width=26) (actual time=0.078..0.078 rows=97 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 14kB
238. 0.035 0.035 ↑ 1.0 97 1

Seq Scan on prdct_lk p2_1 (cost=0.00..2.97 rows=97 width=26) (actual time=0.007..0.035 rows=97 loops=1)

239. 2,265.393 5,470.184 ↑ 4.9 31,701 337

Materialize (cost=560,400.49..565,283.23 rows=156,033 width=44) (actual time=9.403..16.232 rows=31,701 loops=337)

240. 12.916 3,204.791 ↑ 4.9 31,728 1

Subquery Scan on m8 (cost=560,400.49..563,131.06 rows=156,033 width=44) (actual time=3,168.630..3,204.791 rows=31,728 loops=1)

241. 16.890 3,191.875 ↑ 4.9 31,728 1

Unique (cost=560,400.49..561,570.73 rows=156,033 width=44) (actual time=3,168.628..3,191.875 rows=31,728 loops=1)

242. 18.878 3,174.985 ↑ 4.9 31,728 1

Sort (cost=560,400.49..560,790.57 rows=156,033 width=44) (actual time=3,168.627..3,174.985 rows=31,728 loops=1)

  • Sort Key: tm_entry_1.mttr_id, (sum(CASE WHEN (tm_entry_1.bllbl_entty_id = ANY ('{8,15}'::numeric[])) THEN tm_entry_1.actvy_hours_ct WHEN (tm_entry_1.bllbl_entty_id = '23'::numeric) THEN (tm_entry_1.actvy_hours_ct * 0.05) WHEN (tm_entry_1.bllbl_entty_id = '24'::numeric) THEN (tm_entry_1.actvy_hours_ct * 0.04) WHEN (tm_entry_1.bllbl_entty_id = '25'::numeric) THEN (tm_entry_1.actvy_hours_ct * 0.03) WHEN (tm_entry_1.bllbl_entty_id = '26'::numeric) THEN (tm_entry_1.actvy_hours_ct * 0.02) ELSE NULL::numeric END))
  • Sort Method: quicksort Memory: 3247kB
243. 80.845 3,156.107 ↑ 4.9 31,728 1

Finalize GroupAggregate (cost=492,201.54..542,139.48 rows=156,033 width=44) (actual time=2,748.090..3,156.107 rows=31,728 loops=1)

  • Group Key: tm_entry_1.mttr_id
244. 0.000 3,075.262 ↑ 3.6 86,296 1

Gather Merge (cost=492,201.54..537,848.57 rows=312,066 width=44) (actual time=2,748.069..3,075.262 rows=86,296 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
245. 508.176 9,044.370 ↑ 5.4 28,765 3

Partial GroupAggregate (cost=491,201.51..500,828.38 rows=156,033 width=44) (actual time=2,740.939..3,014.790 rows=28,765 loops=3)

  • Group Key: tm_entry_1.mttr_id
246. 962.397 8,536.194 ↓ 1.1 291,685 3

Sort (cost=491,201.51..491,841.22 rows=255,882 width=22) (actual time=2,740.923..2,845.398 rows=291,685 loops=3)

  • Sort Key: tm_entry_1.mttr_id
  • Sort Method: external merge Disk: 9232kB
247. 975.714 7,573.797 ↓ 1.1 291,685 3

Hash Left Join (cost=47,278.95..462,966.76 rows=255,882 width=22) (actual time=634.848..2,524.599 rows=291,685 loops=3)

  • Hash Cond: ((tm_entry_1.mttr_id)::text = (x_25.mttr_id)::text)
  • Filter: ((tm_entry_1.mttr_id IS NULL) OR (x_25.mttr_id IS NOT NULL))
248. 4,968.433 5,088.729 ↓ 1.1 291,685 3

Parallel Bitmap Heap Scan on tm_entry tm_entry_1 (cost=21,181.17..426,751.47 rows=255,882 width=22) (actual time=130.932..1,696.243 rows=291,685 loops=3)

  • Recheck Cond: (bllbl_entty_id = ANY ('{23,24,25,26,8,15}'::numeric[]))
  • Rows Removed by Index Recheck: 3954501
  • Filter: ((mttr_id IS NOT NULL) AND (actvy_hours_ct > '0'::numeric) AND ((actv_ind)::text = 'A'::text))
  • Rows Removed by Filter: 33748
  • Heap Blocks: exact=19268 lossy=87277
249. 120.296 120.296 ↑ 1.0 976,299 1

Bitmap Index Scan on tm_entry_idx2 (cost=0.00..21,027.64 rows=996,405 width=0) (actual time=120.296..120.296 rows=976,299 loops=1)

  • Index Cond: (bllbl_entty_id = ANY ('{23,24,25,26,8,15}'::numeric[]))
250. 871.623 1,509.354 ↑ 1.0 795,857 3

Hash (cost=12,262.57..12,262.57 rows=795,857 width=12) (actual time=503.118..503.118 rows=795,857 loops=3)

  • Buckets: 131072 Batches: 16 Memory Usage: 3226kB
251. 637.731 637.731 ↑ 1.0 795,857 3

Seq Scan on xcld_fp_mttr_id_tbl x_25 (cost=0.00..12,262.57 rows=795,857 width=12) (actual time=0.012..212.577 rows=795,857 loops=3)

252. 7.808 162.884 ↑ 2.0 7,808 1

Sort (cost=15,695.81..15,734.32 rows=15,402 width=24) (actual time=161.264..162.884 rows=7,808 loops=1)

  • Sort Key: mttr_orgn_1.mttr_id
  • Sort Method: quicksort Memory: 806kB
253. 4.779 155.076 ↑ 2.0 7,852 1

Gather (cost=1,016.47..14,624.54 rows=15,402 width=24) (actual time=1.791..155.076 rows=7,852 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
254. 11.164 150.297 ↑ 2.5 2,617 3

Nested Loop (cost=16.47..12,084.34 rows=6,418 width=24) (actual time=0.261..150.297 rows=2,617 loops=3)

255. 74.170 139.130 ↑ 2.5 2,617 3

Hash Join (cost=16.04..8,680.29 rows=6,418 width=12) (actual time=0.242..139.130 rows=2,617 loops=3)

  • Hash Cond: (mttr_orgn_1.orgn_id = o2_1.orgn_id)
256. 64.889 64.889 ↑ 1.2 192,237 3

Parallel Seq Scan on mttr_orgn mttr_orgn_1 (cost=0.00..7,698.96 rows=240,296 width=17) (actual time=0.007..64.889 rows=192,237 loops=3)

257. 0.014 0.071 ↑ 1.0 18 3

Hash (cost=15.82..15.82 rows=18 width=5) (actual time=0.071..0.071 rows=18 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
258. 0.014 0.057 ↑ 1.0 18 3

Nested Loop (cost=4.41..15.82 rows=18 width=5) (actual time=0.031..0.057 rows=18 loops=3)

259. 0.018 0.018 ↑ 1.0 1 3

Seq Scan on orgn_ctgry_lk o3_1 (cost=0.00..2.00 rows=1 width=5) (actual time=0.012..0.018 rows=1 loops=3)

  • Filter: (orgn_ctgry_id = '18'::numeric)
  • Rows Removed by Filter: 79
260. 0.013 0.025 ↑ 1.0 18 3

Bitmap Heap Scan on orgn_lk o2_1 (cost=4.41..13.64 rows=18 width=10) (actual time=0.016..0.025 rows=18 loops=3)

  • Recheck Cond: (orgn_ctgry_id = '18'::numeric)
  • Heap Blocks: exact=4
261. 0.012 0.012 ↑ 1.0 18 3

Bitmap Index Scan on tmporgn_lk_idx1 (cost=0.00..4.41 rows=18 width=0) (actual time=0.012..0.012 rows=18 loops=3)

  • Index Cond: (orgn_ctgry_id = '18'::numeric)
262. 0.003 0.003 ↑ 1.0 1 7,852

Index Only Scan using xcld_fp_mttr_id_tbl_pkey on xcld_fp_mttr_id_tbl x_14 (cost=0.42..0.53 rows=1 width=12) (actual time=0.003..0.003 rows=1 loops=7,852)

  • Index Cond: (mttr_id = (mttr_orgn_1.mttr_id)::text)
  • Heap Fetches: 2471