explain.depesz.com

PostgreSQL's explain analyze made readable

Result: RDj2 : enable_nestloop_on_2_unions_after_analyze

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 609,494.390 ↑ 1.0 1 1

Aggregate (cost=4,582,186.77..4,582,186.78 rows=1 width=8) (actual time=609,494.390..609,494.390 rows=1 loops=1)

2. 0.001 609,494.387 ↓ 0.0 0 1

Unique (cost=4,582,186.64..4,582,186.74 rows=2 width=1,410) (actual time=609,494.387..609,494.387 rows=0 loops=1)

3. 0.012 609,494.386 ↓ 0.0 0 1

Sort (cost=4,582,186.64..4,582,186.64 rows=2 width=1,410) (actual time=609,494.386..609,494.386 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.001 609,494.374 ↓ 0.0 0 1

Append (cost=2,042,633.09..4,582,186.63 rows=2 width=1,410) (actual time=609,494.374..609,494.374 rows=0 loops=1)

5. 0.001 2,669.312 ↓ 0.0 0 1

Nested Loop Left Join (cost=2,042,633.09..2,342,102.05 rows=1 width=302) (actual time=2,669.312..2,669.312 rows=0 loops=1)

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

Nested Loop Left Join (cost=1,511,086.94..1,808,101.06 rows=1 width=234) (actual time=2,669.311..2,669.311 rows=0 loops=1)

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

Nested Loop Left Join (cost=1,198,409.41..1,455,860.35 rows=1 width=209) (actual time=2,669.310..2,669.310 rows=0 loops=1)

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

Nested Loop Left Join (cost=592,652.29..744,836.48 rows=1 width=177) (actual time=2,669.309..2,669.309 rows=0 loops=1)

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

Nested Loop Left Join (cost=467,843.63..618,318.35 rows=1 width=145) (actual time=2,669.309..2,669.309 rows=0 loops=1)

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

Nested Loop Left Join (cost=328,981.59..475,645.34 rows=1 width=141) (actual time=2,669.308..2,669.308 rows=0 loops=1)

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

Nested Loop (cost=97,645.87..214,298.36 rows=1 width=119) (actual time=2,669.307..2,669.307 rows=0 loops=1)

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

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

  • Workers Planned: 2
  • Workers Launched: 2
13. 13.058 147.215 ↑ 2.5 2,617 3

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

14. 71.323 134.153 ↑ 2.5 2,617 3

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

  • Hash Cond: (mttr_orgn.orgn_id = o2.orgn_id)
15. 62.763 62.763 ↑ 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..62.763 rows=192,237 loops=3)

16. 0.014 0.067 ↑ 1.0 18 3

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

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

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

18. 0.018 0.018 ↑ 1.0 1 3

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

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

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

  • Recheck Cond: (orgn_ctgry_id = '18'::numeric)
  • Heap Blocks: exact=4
20. 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)
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. 338.213 2,190.708 ↓ 24.6 197 7,852

Materialize (cost=96,629.40..197,825.60 rows=8 width=116) (actual time=0.174..0.279 rows=197 loops=7,852)

23. 0.184 1,852.495 ↓ 24.6 197 1

Nested Loop (cost=96,629.40..197,825.56 rows=8 width=116) (actual time=1,362.724..1,852.495 rows=197 loops=1)

24. 0.232 1,851.720 ↓ 24.6 197 1

Nested Loop Anti Join (cost=96,628.98..197,758.02 rows=8 width=104) (actual time=1,362.711..1,851.720 rows=197 loops=1)

25. 1.028 1,847.162 ↓ 77.2 618 1

Hash Join (cost=96,628.13..197,672.42 rows=8 width=104) (actual time=1,362.693..1,847.162 rows=618 loops=1)

  • Hash Cond: (mttr.dstrt_id = d.dstrt_id)
26. 67.106 1,846.010 ↓ 38.1 2,172 1

Hash Right Join (cost=96,617.77..197,661.34 rows=57 width=87) (actual time=1,362.491..1,846.010 rows=2,172 loops=1)

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

Gather (cost=45,870.68..144,120.36 rows=203,181 width=55) (actual time=1,024.197..1,671.131 rows=204,272 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
28. 79.065 1,598.329 ↑ 1.2 68,091 3

Hash Left Join (cost=44,870.68..121,617.04 rows=84,659 width=55) (actual time=1,014.362..1,598.329 rows=68,091 loops=3)

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

Nested Loop (cost=44,866.79..119,706.69 rows=84,659 width=25) (actual time=1,014.248..1,519.186 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. 168.086 1,258.686 ↑ 1.2 68,819 3

Hash Join (cost=44,866.37..59,436.81 rows=85,787 width=51) (actual time=1,014.222..1,258.686 rows=68,819 loops=3)

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

Parallel Seq Scan on xcld_fp_mttr_id_tbl x_4 (cost=0.00..7,620.05 rows=331,605 width=12) (actual time=0.005..76.836 rows=265,284 loops=3)

32. 97.133 1,013.764 ↓ 1.0 206,456 3

Hash (cost=40,683.76..40,683.76 rows=205,889 width=39) (actual time=1,013.764..1,013.764 rows=206,456 loops=3)

  • Buckets: 65536 Batches: 8 Memory Usage: 2412kB
33. 247.657 916.631 ↓ 1.0 206,456 3

Hash Join (cost=26,096.67..40,683.76 rows=205,889 width=39) (actual time=580.582..916.631 rows=206,456 loops=3)

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

Seq Scan on mttr_bllbl_entty mttr_bllbl_entty_1 (cost=0.00..5,285.74 rows=205,889 width=27) (actual time=0.009..88.969 rows=206,472 loops=3)

  • Filter: ((crrnt_fl)::text = 'Y'::text)
  • Rows Removed by Filter: 8227
35. 324.477 580.005 ↑ 1.0 795,852 3

Hash (cost=12,262.52..12,262.52 rows=795,852 width=12) (actual time=580.005..580.005 rows=795,852 loops=3)

  • Buckets: 131072 Batches: 16 Memory Usage: 3166kB
36. 255.528 255.528 ↑ 1.0 795,852 3

Seq Scan on xcld_fp_mttr_id_tbl x_3 (cost=0.00..12,262.52 rows=795,852 width=12) (actual time=0.006..255.528 rows=795,852 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.038 0.078 ↑ 1.0 84 3

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

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

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

40. 0.611 107.773 ↓ 29.2 1,665 1

Hash (cost=50,746.37..50,746.37 rows=57 width=78) (actual time=107.773..107.773 rows=1,665 loops=1)

  • Buckets: 2048 (originally 1024) Batches: 1 (originally 1) Memory Usage: 142kB
41. 1.924 107.162 ↓ 29.2 1,665 1

Merge Left Join (cost=50,354.68..50,746.37 rows=57 width=78) (actual time=105.958..107.162 rows=1,665 loops=1)

  • Merge Cond: ((mttr.mttr_id)::text = (zz5.mttr_id)::text)
42. 1.590 12.668 ↓ 29.2 1,665 1

Sort (cost=11,352.16..11,352.30 rows=57 width=74) (actual time=12.281..12.668 rows=1,665 loops=1)

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

Index Scan using mttr_st_id_idx on mttr (cost=0.42..11,350.50 rows=57 width=74) (actual time=0.037..11.078 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.151 92.570 ↓ 101.6 4,370 1

Materialize (cost=39,002.52..39,393.81 rows=43 width=21) (actual time=80.213..92.570 rows=4,370 loops=1)

45. 2.556 90.419 ↓ 101.6 4,370 1

Subquery Scan on zz5 (cost=39,002.52..39,393.70 rows=43 width=21) (actual time=80.211..90.419 rows=4,370 loops=1)

  • Filter: (zz5.rn = 1)
  • Rows Removed by Filter: 3458
46. 6.031 87.863 ↑ 1.1 7,828 1

WindowAgg (cost=39,002.52..39,285.04 rows=8,693 width=55) (actual time=80.209..87.863 rows=7,828 loops=1)

47. 8.366 81.832 ↑ 1.1 7,828 1

Sort (cost=39,002.52..39,024.25 rows=8,693 width=25) (actual time=80.204..81.832 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.597 73.466 ↑ 1.1 7,828 1

Gather (cost=1,005.16..38,433.75 rows=8,693 width=25) (actual time=3.551..73.466 rows=7,828 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
49. 14.466 67.869 ↑ 1.3 3,914 2

Nested Loop (cost=5.17..36,528.66 rows=5,114 width=25) (actual time=1.079..67.869 rows=3,914 loops=2)

50. 3.467 53.401 ↑ 1.3 3,914 2

Hash Left Join (cost=4.74..33,888.87 rows=5,114 width=54) (actual time=1.067..53.401 rows=3,914 loops=2)

  • Hash Cond: (mttr_bllbl_entty_2.bllbl_entty_id = b2_1.bllbl_entty_id)
51. 17.414 49.847 ↑ 1.3 3,914 2

Nested Loop (cost=0.85..33,820.95 rows=5,114 width=49) (actual time=0.944..49.847 rows=3,914 loops=2)

  • 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: 200
52. 15.985 32.430 ↑ 1.3 4,114 2

Nested Loop (cost=0.42..30,180.32 rows=5,182 width=39) (actual time=0.304..32.430 rows=4,114 loops=2)

53. 16.442 16.442 ↑ 1.3 4,114 2

Parallel Seq Scan on mttr_bllbl_entty mttr_bllbl_entty_2 (cost=0.00..4,180.67 rows=5,182 width=27) (actual time=0.286..16.442 rows=4,114 loops=2)

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

Index Only Scan using xcld_fp_mttr_id_tbl_pkey on xcld_fp_mttr_id_tbl x_5 (cost=0.42..5.02 rows=1 width=12) (actual time=0.003..0.003 rows=1 loops=8,227)

  • Index Cond: (mttr_id = (mttr_bllbl_entty_2.mttr_id)::text)
  • Heap Fetches: 3893
55. 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)
56. 0.045 0.087 ↑ 1.0 84 2

Hash (cost=2.84..2.84 rows=84 width=10) (actual time=0.087..0.087 rows=84 loops=2)

  • Buckets: 1024 Batches: 1 Memory Usage: 12kB
57. 0.042 0.042 ↑ 1.0 84 2

Seq Scan on bllbl_entty_lk b2_1 (cost=0.00..2.84 rows=84 width=10) (actual time=0.007..0.042 rows=84 loops=2)

58. 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: 3694
59. 0.012 0.124 ↑ 1.1 23 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
60. 0.112 0.112 ↑ 1.1 23 1

Seq Scan on dstrt_lk d (cost=0.00..10.05 rows=25 width=27) (actual time=0.007..0.112 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
61. 1.012 4.326 ↑ 1.0 1 618

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

62. 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.94 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
63. 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.75 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
64. 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
65. 0.000 0.000 ↓ 0.0 0

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

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

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

67. 0.000 0.000 ↓ 0.0 0

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

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

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

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

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

  • Hash Cond: ((mttr_cause.mttr_id)::text = (x_7.mttr_id)::text)
70. 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)

71. 0.000 0.000 ↓ 0.0 0

Hash (cost=12,262.52..12,262.52 rows=795,852 width=12) (never executed)

72. 0.000 0.000 ↓ 0.0 0

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

73. 0.000 0.000 ↓ 0.0 0

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

74. 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)

75. 0.000 0.000 ↓ 0.0 0

Subquery Scan on zz7 (cost=138,862.03..142,665.70 rows=585 width=16) (never executed)

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

WindowAgg (cost=138,862.03..141,202.75 rows=117,036 width=80) (never executed)

77. 0.000 0.000 ↓ 0.0 0

Sort (cost=138,862.03..139,154.62 rows=117,036 width=18) (never executed)

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

Gather (cost=3,263.72..126,608.60 rows=117,036 width=18) (never executed)

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

Nested Loop (cost=2,263.72..113,905.00 rows=48,765 width=18) (never executed)

80. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=2,263.29..89,276.94 rows=48,765 width=18) (never executed)

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

Parallel Seq Scan on mttr_cntct (cost=0.00..62,040.71 rows=337,728 width=18) (never executed)

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

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

83. 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))
84. 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.51 rows=1 width=12) (never executed)

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

Subquery Scan on zz8 (cost=124,808.67..126,515.47 rows=213 width=44) (never executed)

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

WindowAgg (cost=124,808.67..125,982.09 rows=42,670 width=58) (never executed)

87. 0.000 0.000 ↓ 0.0 0

Sort (cost=124,808.67..124,915.34 rows=42,670 width=301) (never executed)

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

Gather (cost=1,927.99..115,545.65 rows=42,670 width=301) (never executed)

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

Nested Loop (cost=927.99..110,278.65 rows=17,779 width=301) (never executed)

90. 0.000 0.000 ↓ 0.0 0

Parallel Bitmap Heap Scan on mttr_cmmnt (cost=927.56..81,291.64 rows=17,779 width=301) (never executed)

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

Bitmap Index Scan on mttr_cmmnt_idx2 (cost=0.00..916.89 rows=43,262 width=0) (never executed)

  • Index Cond: (mttr_cmmnt_type_id = '14'::numeric)
92. 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.63 rows=1 width=12) (never executed)

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

Subquery Scan on zz9 (cost=605,757.12..710,859.64 rows=13,138 width=44) (never executed)

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

WindowAgg (cost=605,757.12..678,015.10 rows=2,627,563 width=54) (never executed)

95. 0.000 0.000 ↓ 0.0 0

Sort (cost=605,757.12..612,326.02 rows=2,627,563 width=31) (never executed)

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

Hash Join (cost=26,491.35..199,855.35 rows=2,627,563 width=31) (never executed)

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

Hash Join (cost=26,096.67..166,290.16 rows=2,627,563 width=19) (never executed)

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

Seq Scan on mttr_staff (cost=0.00..72,342.54 rows=2,627,563 width=19) (never executed)

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

Hash (cost=12,262.52..12,262.52 rows=795,852 width=12) (never executed)

100. 0.000 0.000 ↓ 0.0 0

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

101. 0.000 0.000 ↓ 0.0 0

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

102. 0.000 0.000 ↓ 0.0 0

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

103. 0.000 0.000 ↓ 0.0 0

Subquery Scan on zz10 (cost=312,677.53..352,164.77 rows=6,075 width=37) (never executed)

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

WindowAgg (cost=312,677.53..336,977.37 rows=1,214,992 width=51) (never executed)

105. 0.000 0.000 ↓ 0.0 0

Sort (cost=312,677.53..315,715.01 rows=1,214,992 width=43) (never executed)

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

Hash Left Join (cost=26,100.85..115,134.31 rows=1,214,992 width=43) (never executed)

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

Hash Join (cost=26,096.67..99,896.96 rows=1,214,992 width=27) (never executed)

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

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

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

Hash (cost=12,262.52..12,262.52 rows=795,852 width=12) (never executed)

110. 0.000 0.000 ↓ 0.0 0

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

111. 0.000 0.000 ↓ 0.0 0

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

112. 0.000 0.000 ↓ 0.0 0

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

113. 0.000 0.000 ↓ 0.0 0

Unique (cost=531,546.15..532,159.86 rows=81,828 width=44) (never executed)

114. 0.000 0.000 ↓ 0.0 0

Sort (cost=531,546.15..531,750.72 rows=81,828 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))
115. 0.000 0.000 ↓ 0.0 0

Finalize GroupAggregate (cost=492,466.96..522,348.86 rows=81,828 width=44) (never executed)

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

Gather Merge (cost=492,466.96..520,098.59 rows=163,656 width=44) (never executed)

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

Partial GroupAggregate (cost=491,466.93..500,208.60 rows=81,828 width=44) (never executed)

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

Sort (cost=491,466.93..492,110.17 rows=257,294 width=22) (never executed)

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

Hash Left Join (cost=47,282.17..463,067.13 rows=257,294 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))
120. 0.000 0.000 ↓ 0.0 0

Parallel Bitmap Heap Scan on tm_entry (cost=21,185.50..426,820.12 rows=257,294 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))
121. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on tm_entry_idx2 (cost=0.00..21,031.12 rows=1,003,267 width=0) (never executed)

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

Hash (cost=12,262.52..12,262.52 rows=795,852 width=12) (never executed)

123. 0.000 0.000 ↓ 0.0 0

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

124. 2.433 606,825.061 ↓ 0.0 0 1

Merge Join (cost=2,181,690.18..2,240,084.56 rows=1 width=302) (actual time=606,825.061..606,825.061 rows=0 loops=1)

  • Merge Cond: ((mttr_3.asctd_mttr_id)::text = (x_14.mttr_id)::text)
125. 2,615.459 606,659.933 ↓ 42.1 337 1

Nested Loop Left Join (cost=2,165,994.37..2,632,533.11 rows=8 width=266) (actual time=34,919.835..606,659.933 rows=337 loops=1)

  • Join Filter: ((mttr_3.mttr_id)::text = (m8.mttr_id)::text)
  • Rows Removed by Join Filter: 10683064
126. 62,798.334 598,458.699 ↓ 42.1 337 1

Nested Loop Left Join (cost=1,634,448.22..2,083,771.04 rows=8 width=234) (actual time=31,571.660..598,458.699 rows=337 loops=1)

  • Join Filter: ((mttr_3.mttr_id)::text = (zz19.mttr_id)::text)
  • Rows Removed by Join Filter: 218129440
127. 74,457.124 471,999.717 ↓ 42.1 337 1

Nested Loop Left Join (cost=1,321,770.69..1,730,862.08 rows=8 width=209) (actual time=25,224.981..471,999.717 rows=337 loops=1)

  • Join Filter: ((mttr_3.mttr_id)::text = (zz18.mttr_id)::text)
  • Rows Removed by Join Filter: 267969354
128. 3,654.014 313,196.885 ↓ 42.1 337 1

Nested Loop Left Join (cost=716,013.57..1,018,393.04 rows=8 width=177) (actual time=12,054.753..313,196.885 rows=337 loops=1)

  • Join Filter: ((mttr_3.mttr_id)::text = (zz_1.mttr_id)::text)
  • Rows Removed by Join Filter: 12895961
129. 29,682.772 305,429.112 ↓ 42.1 337 1

Nested Loop Left Join (cost=591,204.90..891,851.48 rows=8 width=145) (actual time=11,787.900..305,429.112 rows=337 loops=1)

  • Join Filter: ((mttr_3.mttr_id)::text = (zz17.mttr_id)::text)
  • Rows Removed by Join Filter: 105651016
130. 61,322.349 247,313.313 ↓ 42.1 337 1

Nested Loop Left Join (cost=452,342.87..749,114.11 rows=8 width=141) (actual time=9,820.839..247,313.313 rows=337 loops=1)

  • Join Filter: ((mttr_3.mttr_id)::text = (zz.mttr_id)::text)
  • Rows Removed by Join Filter: 220919431
131. 52,774.847 122,631.257 ↓ 42.1 337 1

Nested Loop Left Join (cost=221,007.15..487,260.26 rows=8 width=119) (actual time=5,187.222..122,631.257 rows=337 loops=1)

  • Join Filter: ((mttr_3.mttr_id)::text = (zz16.mttr_id)::text)
  • Rows Removed by Join Filter: 190565195
132. 365.140 16,566.263 ↓ 42.1 337 1

Nested Loop Left Join (cost=85,874.22..333,030.93 rows=8 width=104) (actual time=1,765.288..16,566.263 rows=337 loops=1)

  • Join Filter: ((mttr_3.mttr_id)::text = (zz15.mttr_id)::text)
  • Rows Removed by Join Filter: 1472664
133. 7,318.617 15,821.661 ↓ 42.1 337 1

Nested Loop Left Join (cost=46,871.70..293,631.96 rows=8 width=95) (actual time=1,676.050..15,821.661 rows=337 loops=1)

  • Join Filter: ((mttr_3.mttr_id)::text = (zz13.mttr_id)::text)
  • Rows Removed by Join Filter: 25687069
134. 0.000 27.780 ↓ 15.8 126 1

Gather Merge (cost=1,001.02..113,062.11 rows=8 width=86) (actual time=27.266..27.780 rows=126 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
135. 0.177 298.866 ↓ 31.0 93 3

Nested Loop (cost=0.99..112,061.16 rows=3 width=86) (actual time=21.445..99.622 rows=93 loops=3)

136. 1.299 297.852 ↓ 31.0 93 3

Nested Loop (cost=0.57..112,035.84 rows=3 width=86) (actual time=21.423..99.284 rows=93 loops=3)

137. 293.223 293.223 ↓ 23.1 555 3

Parallel Index Scan using mttr_idx13 on mttr mttr_3 (cost=0.42..112,022.73 rows=24 width=74) (actual time=19.414..97.741 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
138. 3.330 3.330 ↓ 0.0 0 1,665

Index Scan using dstrt_lk_pkey on dstrt_lk d_1 (cost=0.14..0.54 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
139. 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
140. 6,788.784 8,475.264 ↓ 1.0 203,868 126

Materialize (cost=45,870.68..148,359.08 rows=203,181 width=21) (actual time=7.995..67.264 rows=203,868 loops=126)

141. 92.675 1,686.480 ↓ 1.0 204,272 1

Subquery Scan on zz13 (cost=45,870.68..146,152.17 rows=203,181 width=21) (actual time=1,007.087..1,686.480 rows=204,272 loops=1)

142. 25.924 1,593.805 ↓ 1.0 204,272 1

Gather (cost=45,870.68..144,120.36 rows=203,181 width=55) (actual time=1,007.085..1,593.805 rows=204,272 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
143. 73.101 1,567.881 ↑ 1.2 68,091 3

Hash Left Join (cost=44,870.68..121,617.04 rows=84,659 width=55) (actual time=1,006.640..1,567.881 rows=68,091 loops=3)

  • Hash Cond: (mttr_bllbl_entty_3.bllbl_entty_id = b2_2.bllbl_entty_id)
144. 254.622 1,494.708 ↑ 1.2 68,091 3

Nested Loop (cost=44,866.79..119,706.69 rows=84,659 width=25) (actual time=1,006.534..1,494.708 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
145. 163.394 1,240.083 ↑ 1.2 68,819 3

Hash Join (cost=44,866.37..59,436.81 rows=85,787 width=51) (actual time=1,006.506..1,240.083 rows=68,819 loops=3)

  • Hash Cond: ((x_16.mttr_id)::text = (x_15.mttr_id)::text)
146. 70.627 70.627 ↑ 1.2 265,284 3

Parallel Seq Scan on xcld_fp_mttr_id_tbl x_16 (cost=0.00..7,620.05 rows=331,605 width=12) (actual time=0.006..70.627 rows=265,284 loops=3)

147. 97.070 1,006.062 ↓ 1.0 206,456 3

Hash (cost=40,683.76..40,683.76 rows=205,889 width=39) (actual time=1,006.062..1,006.062 rows=206,456 loops=3)

  • Buckets: 65536 Batches: 8 Memory Usage: 2412kB
148. 334.321 908.992 ↓ 1.0 206,456 3

Hash Join (cost=26,096.67..40,683.76 rows=205,889 width=39) (actual time=491.492..908.992 rows=206,456 loops=3)

  • Hash Cond: ((mttr_bllbl_entty_3.mttr_id)::text = (x_15.mttr_id)::text)
149. 83.722 83.722 ↓ 1.0 206,472 3

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

  • Filter: ((crrnt_fl)::text = 'Y'::text)
  • Rows Removed by Filter: 8227
150. 283.453 490.949 ↑ 1.0 795,852 3

Hash (cost=12,262.52..12,262.52 rows=795,852 width=12) (actual time=490.949..490.949 rows=795,852 loops=3)

  • Buckets: 131072 Batches: 16 Memory Usage: 3166kB
151. 207.496 207.496 ↑ 1.0 795,852 3

Seq Scan on xcld_fp_mttr_id_tbl x_15 (cost=0.00..12,262.52 rows=795,852 width=12) (actual time=0.006..207.496 rows=795,852 loops=3)

152. 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)
153. 0.036 0.072 ↑ 1.0 84 3

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

  • Buckets: 1024 Batches: 1 Memory Usage: 12kB
154. 0.036 0.036 ↑ 1.0 84 3

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

155. 293.303 379.462 ↓ 101.6 4,370 337

Materialize (cost=39,002.52..39,393.92 rows=43 width=21) (actual time=0.226..1.126 rows=4,370 loops=337)

156. 2.599 86.159 ↓ 101.6 4,370 1

Subquery Scan on zz15 (cost=39,002.52..39,393.70 rows=43 width=21) (actual time=75.894..86.159 rows=4,370 loops=1)

  • Filter: (zz15.rn = 1)
  • Rows Removed by Filter: 3458
157. 6.032 83.560 ↑ 1.1 7,828 1

WindowAgg (cost=39,002.52..39,285.04 rows=8,693 width=55) (actual time=75.892..83.560 rows=7,828 loops=1)

158. 7.853 77.528 ↑ 1.1 7,828 1

Sort (cost=39,002.52..39,024.25 rows=8,693 width=25) (actual time=75.886..77.528 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
159. 5.651 69.675 ↑ 1.1 7,828 1

Gather (cost=1,005.16..38,433.75 rows=8,693 width=25) (actual time=3.666..69.675 rows=7,828 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
160. 13.661 64.024 ↑ 1.3 3,914 2

Nested Loop (cost=5.17..36,528.66 rows=5,114 width=25) (actual time=1.197..64.024 rows=3,914 loops=2)

161. 2.917 50.361 ↑ 1.3 3,914 2

Hash Left Join (cost=4.74..33,888.87 rows=5,114 width=54) (actual time=1.184..50.361 rows=3,914 loops=2)

  • Hash Cond: (mttr_bllbl_entty_4.bllbl_entty_id = b2_3.bllbl_entty_id)
162. 16.055 47.375 ↑ 1.3 3,914 2

Nested Loop (cost=0.85..33,820.95 rows=5,114 width=49) (actual time=1.077..47.375 rows=3,914 loops=2)

  • 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: 200
163. 15.110 31.317 ↑ 1.3 4,114 2

Nested Loop (cost=0.42..30,180.32 rows=5,182 width=39) (actual time=0.365..31.317 rows=4,114 loops=2)

164. 16.204 16.204 ↑ 1.3 4,114 2

Parallel Seq Scan on mttr_bllbl_entty mttr_bllbl_entty_4 (cost=0.00..4,180.67 rows=5,182 width=27) (actual time=0.344..16.204 rows=4,114 loops=2)

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

Index Only Scan using xcld_fp_mttr_id_tbl_pkey on xcld_fp_mttr_id_tbl x_17 (cost=0.42..5.02 rows=1 width=12) (actual time=0.003..0.003 rows=1 loops=8,227)

  • Index Cond: (mttr_id = (mttr_bllbl_entty_4.mttr_id)::text)
  • Heap Fetches: 3915
166. 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)
167. 0.037 0.069 ↑ 1.0 84 2

Hash (cost=2.84..2.84 rows=84 width=10) (actual time=0.069..0.069 rows=84 loops=2)

  • Buckets: 1024 Batches: 1 Memory Usage: 12kB
168. 0.032 0.032 ↑ 1.0 84 2

Seq Scan on bllbl_entty_lk b2_3 (cost=0.00..2.84 rows=84 width=10) (actual time=0.007..0.032 rows=84 loops=2)

169. 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: 3714
170. 50,287.610 53,290.147 ↓ 196.1 565,476 337

Materialize (cost=135,132.93..153,890.46 rows=2,884 width=27) (actual time=5.957..158.131 rows=565,476 loops=337)

171. 239.099 3,002.537 ↓ 196.1 565,506 1

Subquery Scan on zz16 (cost=135,132.93..153,876.04 rows=2,884 width=27) (actual time=2,006.475..3,002.537 rows=565,506 loops=1)

  • Filter: (zz16.rn = 1)
  • Rows Removed by Filter: 11143
172. 500.678 2,763.438 ↑ 1.0 576,649 1

WindowAgg (cost=135,132.93..146,667.15 rows=576,711 width=43) (actual time=2,006.473..2,763.438 rows=576,649 loops=1)

173. 756.845 2,262.760 ↑ 1.0 576,649 1

Sort (cost=135,132.93..136,574.71 rows=576,711 width=35) (actual time=2,006.467..2,262.760 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
174. 373.958 1,505.915 ↑ 1.0 576,649 1

Hash Join (cost=26,132.07..64,177.93 rows=576,711 width=35) (actual time=445.192..1,505.915 rows=576,649 loops=1)

  • Hash Cond: (mttr_orgn_2.orgn_id = o2_2.orgn_id)
175. 509.170 1,131.052 ↑ 1.0 576,649 1

Hash Join (cost=26,096.67..56,212.75 rows=576,711 width=25) (actual time=444.278..1,131.052 rows=576,649 loops=1)

  • Hash Cond: ((mttr_orgn_2.mttr_id)::text = (x_19.mttr_id)::text)
176. 177.974 177.974 ↑ 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.005..177.974 rows=576,711 loops=1)

177. 257.540 443.908 ↑ 1.0 795,852 1

Hash (cost=12,262.52..12,262.52 rows=795,852 width=12) (actual time=443.908..443.908 rows=795,852 loops=1)

  • Buckets: 131072 Batches: 16 Memory Usage: 3156kB
178. 186.368 186.368 ↑ 1.0 795,852 1

Seq Scan on xcld_fp_mttr_id_tbl x_19 (cost=0.00..12,262.52 rows=795,852 width=12) (actual time=0.006..186.368 rows=795,852 loops=1)

179. 0.234 0.905 ↑ 1.0 674 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 44kB
180. 0.441 0.671 ↑ 1.0 674 1

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

  • Hash Cond: (o2_2.orgn_ctgry_id = o3_2.orgn_ctgry_id)
181. 0.171 0.171 ↑ 1.0 674 1

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

182. 0.032 0.059 ↑ 1.0 80 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 13kB
183. 0.027 0.027 ↑ 1.0 80 1

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

184. 58,929.127 63,359.707 ↓ 142.3 655,548 337

Materialize (cost=231,335.72..261,312.42 rows=4,608 width=34) (actual time=8.881..188.011 rows=655,548 loops=337)

185. 335.863 4,430.580 ↓ 142.3 655,903 1

Subquery Scan on zz (cost=231,335.72..261,289.38 rows=4,608 width=34) (actual time=2,991.745..4,430.580 rows=655,903 loops=1)

  • Filter: (zz.rn = 1)
  • Rows Removed by Filter: 265667
186. 741.504 4,094.717 ↑ 1.0 921,570 1

WindowAgg (cost=231,335.72..249,768.74 rows=921,651 width=50) (actual time=2,991.743..4,094.717 rows=921,570 loops=1)

187. 1,268.146 3,353.213 ↑ 1.0 921,570 1

Sort (cost=231,335.72..233,639.85 rows=921,651 width=42) (actual time=2,991.737..3,353.213 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
188. 582.504 2,085.067 ↑ 1.0 921,570 1

Hash Join (cost=26,127.82..83,321.39 rows=921,651 width=42) (actual time=441.041..2,085.067 rows=921,570 loops=1)

  • Hash Cond: (mttr_cause_1.cause_code_id = c2_2.cause_code_id)
189. 778.054 1,501.973 ↑ 1.0 921,570 1

Hash Join (cost=26,096.67..71,664.01 rows=921,651 width=25) (actual time=440.441..1,501.973 rows=921,570 loops=1)

  • Hash Cond: ((mttr_cause_1.mttr_id)::text = (x_20.mttr_id)::text)
190. 283.667 283.667 ↑ 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.667 rows=921,651 loops=1)

191. 254.872 440.252 ↑ 1.0 795,852 1

Hash (cost=12,262.52..12,262.52 rows=795,852 width=12) (actual time=440.252..440.252 rows=795,852 loops=1)

  • Buckets: 131072 Batches: 16 Memory Usage: 3156kB
192. 185.380 185.380 ↑ 1.0 795,852 1

Seq Scan on xcld_fp_mttr_id_tbl x_20 (cost=0.00..12,262.52 rows=795,852 width=12) (actual time=0.006..185.380 rows=795,852 loops=1)

193. 0.321 0.590 ↑ 1.0 851 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 58kB
194. 0.269 0.269 ↑ 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.269 rows=851 loops=1)

195. 26,704.662 28,433.027 ↓ 535.9 313,505 337

Materialize (cost=138,862.03..142,668.63 rows=585 width=16) (actual time=3.508..84.371 rows=313,505 loops=337)

196. 144.289 1,728.365 ↓ 535.9 313,507 1

Subquery Scan on zz17 (cost=138,862.03..142,665.70 rows=585 width=16) (actual time=1,180.865..1,728.365 rows=313,507 loops=1)

  • Filter: (zz17.rn = 1)
  • Rows Removed by Filter: 51014
197. 300.702 1,584.076 ↓ 3.1 364,521 1

WindowAgg (cost=138,862.03..141,202.75 rows=117,036 width=80) (actual time=1,180.863..1,584.076 rows=364,521 loops=1)

198. 678.123 1,283.374 ↓ 3.1 364,521 1

Sort (cost=138,862.03..139,154.62 rows=117,036 width=18) (actual time=1,180.857..1,283.374 rows=364,521 loops=1)

  • Sort Key: mttr_cntct_1.mttr_id, mttr_cntct_1.prmry_fl DESC NULLS LAST
  • Sort Method: external merge Disk: 10352kB
199. 0.000 605.251 ↓ 3.1 364,521 1

Gather (cost=3,263.72..126,608.60 rows=117,036 width=18) (actual time=14.542..605.251 rows=364,521 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
200. 425.189 838.135 ↓ 2.5 121,507 3

Nested Loop (cost=2,263.72..113,905.00 rows=48,765 width=18) (actual time=13.019..838.135 rows=121,507 loops=3)

201. 127.113 412.944 ↓ 2.5 121,509 3

Hash Join (cost=2,263.29..89,276.94 rows=48,765 width=18) (actual time=12.996..412.944 rows=121,509 loops=3)

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

Parallel Seq Scan on mttr_cntct mttr_cntct_1 (cost=0.00..62,040.71 rows=337,728 width=18) (actual time=0.007..272.958 rows=264,783 loops=3)

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

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

  • Buckets: 8192 Batches: 1 Memory Usage: 303kB
204. 10.450 10.450 ↓ 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=0.809..10.450 rows=6,596 loops=3)

  • Filter: (((mkt_cntr_id)::text ~~ 'NASDAQ'::text) AND (xprtn_dt = '2399-12-31'::date))
  • Rows Removed by Filter: 55102
205. 0.002 0.002 ↑ 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.51 rows=1 width=12) (actual time=0.002..0.002 rows=1 loops=364,527)

  • Index Cond: (mttr_id = (mttr_cntct_1.mttr_id)::text)
  • Heap Fetches: 46005
206. 3,884.211 4,113.759 ↓ 179.7 38,267 337

Materialize (cost=124,808.67..126,516.53 rows=213 width=44) (actual time=0.408..12.207 rows=38,267 loops=337)

207. 17.086 229.548 ↓ 179.7 38,267 1

Subquery Scan on zz_1 (cost=124,808.67..126,515.47 rows=213 width=44) (actual time=136.060..229.548 rows=38,267 loops=1)

  • Filter: (zz_1.rn = 1)
  • Rows Removed by Filter: 2513
208. 63.036 212.462 ↑ 1.0 40,780 1

WindowAgg (cost=124,808.67..125,982.09 rows=42,670 width=58) (actual time=136.058..212.462 rows=40,780 loops=1)

209. 80.482 149.426 ↑ 1.0 40,780 1

Sort (cost=124,808.67..124,915.34 rows=42,670 width=301) (actual time=136.045..149.426 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
210. 0.000 68.944 ↑ 1.0 40,780 1

Gather (cost=1,927.99..115,545.65 rows=42,670 width=301) (actual time=17.662..68.944 rows=40,780 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
211. 53.630 84.862 ↑ 1.3 13,593 3

Nested Loop (cost=927.99..110,278.65 rows=17,779 width=301) (actual time=13.300..84.862 rows=13,593 loops=3)

212. 21.203 31.229 ↑ 1.3 13,598 3

Parallel Bitmap Heap Scan on mttr_cmmnt mttr_cmmnt_1 (cost=927.56..81,291.64 rows=17,779 width=301) (actual time=13.275..31.229 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=3325
213. 10.026 10.026 ↑ 1.1 41,034 1

Bitmap Index Scan on mttr_cmmnt_idx2 (cost=0.00..916.89 rows=43,262 width=0) (actual time=10.026..10.026 rows=41,034 loops=1)

  • Index Cond: (mttr_cmmnt_type_id = '14'::numeric)
214. 0.003 0.003 ↑ 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.63 rows=1 width=12) (actual time=0.003..0.003 rows=1 loops=40,793)

  • Index Cond: (mttr_id = (mttr_cmmnt_1.mttr_id)::text)
  • Heap Fetches: 4748
215. 70,759.158 84,345.708 ↓ 60.5 795,162 337

Materialize (cost=605,757.12..710,925.33 rows=13,138 width=44) (actual time=24.220..250.284 rows=795,162 loops=337)

216. 737.321 13,586.550 ↓ 60.6 795,732 1

Subquery Scan on zz18 (cost=605,757.12..710,859.64 rows=13,138 width=44) (actual time=8,160.701..13,586.550 rows=795,732 loops=1)

  • Filter: (zz18.rn = 1)
  • Rows Removed by Filter: 1829642
217. 3,735.215 12,849.229 ↑ 1.0 2,625,374 1

WindowAgg (cost=605,757.12..678,015.10 rows=2,627,563 width=54) (actual time=8,160.698..12,849.229 rows=2,625,374 loops=1)

218. 3,836.610 9,114.014 ↑ 1.0 2,625,374 1

Sort (cost=605,757.12..612,326.02 rows=2,627,563 width=31) (actual time=8,160.680..9,114.014 rows=2,625,374 loops=1)

  • Sort Key: mttr_staff_1.mttr_id, mttr_staff_1.prmry_fl DESC NULLS LAST
  • Sort Method: external merge Disk: 99784kB
219. 1,678.147 5,277.404 ↑ 1.0 2,625,374 1

Hash Join (cost=26,491.35..199,855.35 rows=2,627,563 width=31) (actual time=446.819..5,277.404 rows=2,625,374 loops=1)

  • Hash Cond: (mttr_staff_1.staff_id = s2_1.staff_id)
220. 2,129.109 3,592.278 ↑ 1.0 2,625,374 1

Hash Join (cost=26,096.67..166,290.16 rows=2,627,563 width=19) (actual time=439.822..3,592.278 rows=2,625,374 loops=1)

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

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

  • Filter: ((actv_ind)::text = 'A'::text)
222. 254.370 439.629 ↑ 1.0 795,852 1

Hash (cost=12,262.52..12,262.52 rows=795,852 width=12) (actual time=439.629..439.629 rows=795,852 loops=1)

  • Buckets: 131072 Batches: 16 Memory Usage: 3156kB
223. 185.259 185.259 ↑ 1.0 795,852 1

Seq Scan on xcld_fp_mttr_id_tbl x_23 (cost=0.00..12,262.52 rows=795,852 width=12) (actual time=0.006..185.259 rows=795,852 loops=1)

224. 3.689 6.979 ↑ 1.0 9,408 1

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

  • Buckets: 16384 Batches: 1 Memory Usage: 635kB
225. 3.290 3.290 ↑ 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.290 rows=9,408 loops=1)

226. 57,590.602 63,660.648 ↓ 106.5 647,269 337

Materialize (cost=312,677.53..352,195.15 rows=6,075 width=37) (actual time=12.684..188.904 rows=647,269 loops=337)

227. 397.386 6,070.046 ↓ 106.6 647,543 1

Subquery Scan on zz19 (cost=312,677.53..352,164.77 rows=6,075 width=37) (actual time=4,273.266..6,070.046 rows=647,543 loops=1)

  • Filter: (zz19.rn = 1)
  • Rows Removed by Filter: 565254
228. 936.307 5,672.660 ↑ 1.0 1,212,797 1

WindowAgg (cost=312,677.53..336,977.37 rows=1,214,992 width=51) (actual time=4,273.264..5,672.660 rows=1,212,797 loops=1)

229. 2,010.028 4,736.353 ↑ 1.0 1,212,797 1

Sort (cost=312,677.53..315,715.01 rows=1,214,992 width=43) (actual time=4,273.258..4,736.353 rows=1,212,797 loops=1)

  • Sort Key: mttr_prdct_1.mttr_id, mttr_prdct_1.mttr_prdct_id DESC
  • Sort Method: external merge Disk: 55456kB
230. 756.249 2,726.325 ↑ 1.0 1,212,797 1

Hash Left Join (cost=26,100.85..115,134.31 rows=1,214,992 width=43) (actual time=447.960..2,726.325 rows=1,212,797 loops=1)

  • Hash Cond: (mttr_prdct_1.prdct_id = p2_1.prdct_id)
231. 1,009.739 1,969.999 ↑ 1.0 1,212,797 1

Hash Join (cost=26,096.67..99,896.96 rows=1,214,992 width=27) (actual time=447.870..1,969.999 rows=1,212,797 loops=1)

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

Seq Scan on mttr_prdct mttr_prdct_1 (cost=0.00..37,963.04 rows=1,214,992 width=27) (actual time=0.012..512.594 rows=1,212,940 loops=1)

  • Filter: ((actv_ind)::text = 'A'::text)
  • Rows Removed by Filter: 107703
233. 261.440 447.666 ↑ 1.0 795,852 1

Hash (cost=12,262.52..12,262.52 rows=795,852 width=12) (actual time=447.666..447.666 rows=795,852 loops=1)

  • Buckets: 131072 Batches: 16 Memory Usage: 3166kB
234. 186.226 186.226 ↑ 1.0 795,852 1

Seq Scan on xcld_fp_mttr_id_tbl x_24 (cost=0.00..12,262.52 rows=795,852 width=12) (actual time=0.007..186.226 rows=795,852 loops=1)

235. 0.042 0.077 ↑ 1.0 97 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 14kB
236. 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)

237. 2,259.559 5,585.775 ↑ 2.6 31,701 337

Materialize (cost=531,546.15..534,107.28 rows=81,828 width=44) (actual time=9.764..16.575 rows=31,701 loops=337)

238. 12.905 3,326.216 ↑ 2.6 31,728 1

Subquery Scan on m8 (cost=531,546.15..532,978.14 rows=81,828 width=44) (actual time=3,290.129..3,326.216 rows=31,728 loops=1)

239. 16.770 3,313.311 ↑ 2.6 31,728 1

Unique (cost=531,546.15..532,159.86 rows=81,828 width=44) (actual time=3,290.127..3,313.311 rows=31,728 loops=1)

240. 20.292 3,296.541 ↑ 2.6 31,728 1

Sort (cost=531,546.15..531,750.72 rows=81,828 width=44) (actual time=3,290.126..3,296.541 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
241. 86.315 3,276.249 ↑ 2.6 31,728 1

Finalize GroupAggregate (cost=492,466.96..522,348.86 rows=81,828 width=44) (actual time=2,830.975..3,276.249 rows=31,728 loops=1)

  • Group Key: tm_entry_1.mttr_id
242. 0.000 3,189.934 ↑ 1.9 86,318 1

Gather Merge (cost=492,466.96..520,098.59 rows=163,656 width=44) (actual time=2,830.946..3,189.934 rows=86,318 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
243. 550.848 9,369.312 ↑ 2.8 28,773 3

Partial GroupAggregate (cost=491,466.93..500,208.60 rows=81,828 width=44) (actual time=2,819.624..3,123.104 rows=28,773 loops=3)

  • Group Key: tm_entry_1.mttr_id
244. 1,070.070 8,818.464 ↓ 1.1 291,685 3

Sort (cost=491,466.93..492,110.17 rows=257,294 width=22) (actual time=2,819.608..2,939.488 rows=291,685 loops=3)

  • Sort Key: tm_entry_1.mttr_id
  • Sort Method: external merge Disk: 9224kB
245. 1,044.078 7,748.394 ↓ 1.1 291,685 3

Hash Left Join (cost=47,282.17..463,067.13 rows=257,294 width=22) (actual time=672.951..2,582.798 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))
246. 4,956.998 5,075.625 ↓ 1.1 291,685 3

Parallel Bitmap Heap Scan on tm_entry tm_entry_1 (cost=21,185.50..426,820.12 rows=257,294 width=22) (actual time=129.046..1,691.875 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=19107 lossy=87429
247. 118.627 118.627 ↑ 1.0 976,299 1

Bitmap Index Scan on tm_entry_idx2 (cost=0.00..21,031.12 rows=1,003,267 width=0) (actual time=118.627..118.627 rows=976,299 loops=1)

  • Index Cond: (bllbl_entty_id = ANY ('{23,24,25,26,8,15}'::numeric[]))
248. 932.739 1,628.691 ↑ 1.0 795,852 3

Hash (cost=12,262.52..12,262.52 rows=795,852 width=12) (actual time=542.897..542.897 rows=795,852 loops=3)

  • Buckets: 131072 Batches: 16 Memory Usage: 3166kB
249. 695.952 695.952 ↑ 1.0 795,852 3

Seq Scan on xcld_fp_mttr_id_tbl x_25 (cost=0.00..12,262.52 rows=795,852 width=12) (actual time=0.012..231.984 rows=795,852 loops=3)

250. 7.847 162.695 ↑ 2.0 7,808 1

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

  • Sort Key: mttr_orgn_1.mttr_id
  • Sort Method: quicksort Memory: 806kB
251. 4.651 154.848 ↑ 2.0 7,852 1

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

  • Workers Planned: 2
  • Workers Launched: 2
252. 11.074 150.197 ↑ 2.5 2,617 3

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

253. 74.510 139.120 ↑ 2.5 2,617 3

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

  • Hash Cond: (mttr_orgn_1.orgn_id = o2_1.orgn_id)
254. 64.539 64.539 ↑ 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.539 rows=192,237 loops=3)

255. 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
256. 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)

257. 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
258. 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
259. 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)
260. 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: 2633