explain.depesz.com

PostgreSQL's explain analyze made readable

Result: rFVG : retail id 43, shared buffer 512mb work_mem 2gb

Settings
# exclusive inclusive rows x rows loops node
1. 358.876 56,436.537 ↑ 1.0 50 1

Limit (cost=234,991.85..236,067.98 rows=50 width=4,939) (actual time=56,433.334..56,436.537 rows=50 loops=1)

  • Buffers: shared hit=1904397 read=68445
  • I/O Timings: read=9502.808
  • Functions: 378
  • Options: Inlining false, Optimization false, Expressions true, Deforming true
  • Timing: Generation 68.272 ms, Inlining 0.000 ms, Optimization 43.652 ms, Emission 693.308 ms, Total 805.231 ms
2. 0.015 56,077.661 ↑ 908.4 50 1

Subquery Scan on limqry (cost=234,991.85..1,212,565.32 rows=45,421 width=4,939) (actual time=56,074.738..56,077.661 rows=50 loops=1)

  • Buffers: shared hit=1904397 read=68445
  • I/O Timings: read=9502.808
3. 3.324 56,077.646 ↑ 908.4 50 1

GroupAggregate (cost=234,991.85..1,212,111.11 rows=45,421 width=5,139) (actual time=56,074.735..56,077.646 rows=50 loops=1)

  • Group Key: mih.mih_category_1, mss.mss_cat1, mcd1.mcd_cat_name, mih.mih_category_2, mss.mss_cat2, mcd2.mcd_cat_name, mih.mih_category_3, mss.mss_cat3, mcd3.mcd_cat_name, mih.mih_category_4, mss.mss_cat4, mcd4.mcd_cat_name, mih.mih_category_5, mss.mss_cat5, mcd5.mcd_cat_name, mss.mss_cat6, mcd6.mcd_cat_name, mih.mih_category_6, mih.mih_category_7, mss.mss_cat7, mcd7.mcd_cat_name, mih.mih_category_8, mss.mss_cat8, mcd8.mcd_cat_name, mss.retail_outlet_id, cs.outlet_name, mc.mc_name, md.md_name, ml.ml_name, mtm.mtm_type_name, mmm.mmm_mfr_name, mss.mss_itemcode, mmm.mmm_mfr_code, mih.mih_item_code, mih.mih_item_name, mih.mih_item_alias, mih.mih_eancode, mid.mid_barcodevalue, mss.mss_invtype, mih.mih_item_rack, mih.mih_item_shelf, mih.mih_item_box, mih.mih_prodtype, pt.pt_name, mih.mih_hsn_code, ('R'::text), ('Regular'::text)
  • Buffers: shared hit=1904397 read=68445
  • I/O Timings: read=9502.808
4. 48,954.755 56,072.872 ↑ 91.8 495 1

Sort (cost=234,991.85..235,105.40 rows=45,421 width=657) (actual time=56,072.824..56,072.872 rows=495 loops=1)

  • Sort Key: mih.mih_category_1, mss.mss_cat1, mcd1.mcd_cat_name, mih.mih_category_2, mss.mss_cat2, mcd2.mcd_cat_name, mih.mih_category_3, mss.mss_cat3, mcd3.mcd_cat_name, mih.mih_category_4, mss.mss_cat4, mcd4.mcd_cat_name, mih.mih_category_5, mss.mss_cat5, mcd5.mcd_cat_name, mss.mss_cat6, mcd6.mcd_cat_name, mih.mih_category_6, mih.mih_category_7, mss.mss_cat7, mcd7.mcd_cat_name, mih.mih_category_8, mss.mss_cat8, mcd8.mcd_cat_name, cs.outlet_name, mc.mc_name, md.md_name, ml.ml_name, mtm.mtm_type_name, mmm.mmm_mfr_name, mss.mss_itemcode, mmm.mmm_mfr_code, mih.mih_item_code, mih.mih_item_name, mih.mih_item_alias, mih.mih_eancode, mid.mid_barcodevalue, mss.mss_invtype, mih.mih_item_rack, mih.mih_item_shelf, mih.mih_item_box, mih.mih_prodtype, pt.pt_name, mih.mih_hsn_code, ('R'::text), ('Regular'::text)
  • Sort Method: quicksort Memory: 438622kB
  • Buffers: shared hit=1902898 read=68444
  • I/O Timings: read=9502.626
5. 337.708 7,118.117 ↓ 17.7 802,997 1

Hash Left Join (cost=44,412.47..231,478.29 rows=45,421 width=657) (actual time=338.975..7,118.117 rows=802,997 loops=1)

  • Hash Cond: ((mss.retail_outlet_id = mcd8.retail_outlet_id) AND (mss.mss_cat8 = mcd8.mcd_cat_code))
  • Buffers: shared hit=1902895 read=68444
  • I/O Timings: read=9502.626
6. 331.652 6,775.448 ↓ 17.7 802,997 1

Hash Left Join (cost=40,007.94..226,835.23 rows=45,421 width=635) (actual time=333.988..6,775.448 rows=802,997 loops=1)

  • Hash Cond: ((mss.retail_outlet_id = mcd7.retail_outlet_id) AND (mss.mss_cat7 = mcd7.mcd_cat_code))
  • Buffers: shared hit=1901430 read=68444
  • I/O Timings: read=9502.626
7. 331.479 6,438.906 ↓ 17.7 802,997 1

Hash Left Join (cost=35,603.41..222,192.17 rows=45,421 width=613) (actual time=329.075..6,438.906 rows=802,997 loops=1)

  • Hash Cond: ((mss.retail_outlet_id = mcd6.retail_outlet_id) AND (mss.mss_cat6 = mcd6.mcd_cat_code))
  • Buffers: shared hit=1899965 read=68444
  • I/O Timings: read=9502.626
8. 326.876 6,102.630 ↓ 17.7 802,997 1

Hash Left Join (cost=31,198.88..217,549.11 rows=45,421 width=591) (actual time=324.256..6,102.630 rows=802,997 loops=1)

  • Hash Cond: ((mss.retail_outlet_id = mcd5.retail_outlet_id) AND (mss.mss_cat5 = mcd5.mcd_cat_code))
  • Buffers: shared hit=1898500 read=68444
  • I/O Timings: read=9502.626
9. 338.240 5,770.804 ↓ 17.7 802,997 1

Hash Left Join (cost=26,794.35..212,906.05 rows=45,421 width=569) (actual time=319.283..5,770.804 rows=802,997 loops=1)

  • Hash Cond: ((mss.retail_outlet_id = mcd4.retail_outlet_id) AND (mss.mss_cat4 = mcd4.mcd_cat_code))
  • Buffers: shared hit=1897035 read=68444
  • I/O Timings: read=9502.626
10. 333.290 5,427.671 ↓ 17.7 802,997 1

Hash Left Join (cost=22,389.82..208,262.98 rows=45,421 width=547) (actual time=314.365..5,427.671 rows=802,997 loops=1)

  • Hash Cond: ((mss.retail_outlet_id = mcd3.retail_outlet_id) AND (mss.mss_cat3 = mcd3.mcd_cat_code))
  • Buffers: shared hit=1895570 read=68444
  • I/O Timings: read=9502.626
11. 330.389 5,089.210 ↓ 17.7 802,997 1

Hash Left Join (cost=17,985.30..203,619.92 rows=45,421 width=525) (actual time=309.170..5,089.210 rows=802,997 loops=1)

  • Hash Cond: ((mss.retail_outlet_id = mcd2.retail_outlet_id) AND (mss.mss_cat2 = mcd2.mcd_cat_code))
  • Buffers: shared hit=1894105 read=68444
  • I/O Timings: read=9502.626
12. 351.727 4,753.526 ↓ 17.7 802,997 1

Hash Left Join (cost=13,580.77..198,976.86 rows=45,421 width=503) (actual time=303.847..4,753.526 rows=802,997 loops=1)

  • Hash Cond: ((mss.retail_outlet_id = mcd1.retail_outlet_id) AND (mss.mss_cat1 = mcd1.mcd_cat_code))
  • Buffers: shared hit=1892640 read=68444
  • I/O Timings: read=9502.626
13. 809.264 4,280.361 ↓ 17.7 802,997 1

Nested Loop Left Join (cost=9,176.24..194,333.80 rows=45,421 width=481) (actual time=182.376..4,280.361 rows=802,997 loops=1)

  • Join Filter: ((mih.mih_trade_conf)::text = ('R'::text))
  • Rows Removed by Join Filter: 1605994
  • Buffers: shared hit=1891626 read=67993
  • I/O Timings: read=9390.916
14. 169.860 3,471.097 ↓ 17.7 802,997 1

Nested Loop (cost=9,176.15..192,289.69 rows=45,421 width=419) (actual time=182.351..3,471.097 rows=802,997 loops=1)

  • Buffers: shared hit=1891626 read=67993
  • I/O Timings: read=9390.916
15. 0.038 0.038 ↑ 1.0 1 1

Seq Scan on csds_shop_info cs (cost=0.00..1.90 rows=1 width=16) (actual time=0.031..0.038 rows=1 loops=1)

  • Filter: (outlet_id = '8'::numeric)
  • Rows Removed by Filter: 71
  • Buffers: shared hit=1
16. 390.911 3,301.199 ↓ 17.7 802,997 1

Hash Join (cost=9,176.15..191,833.58 rows=45,421 width=408) (actual time=182.316..3,301.199 rows=802,997 loops=1)

  • Hash Cond: (mih.mih_prodtype = pt.pt_code)
  • Buffers: shared hit=1891625 read=67993
  • I/O Timings: read=9390.916
17. 629.298 2,909.999 ↓ 17.7 802,997 1

Nested Loop (cost=9,156.97..191,644.08 rows=45,421 width=403) (actual time=182.012..2,909.999 rows=802,997 loops=1)

  • Join Filter: ((mc.mc_id = mss.mss_compid) AND (md.md_id = mss.mss_diviid) AND (ml.ml_id = mss.mss_locaid))
  • Buffers: shared hit=1891625 read=67984
  • I/O Timings: read=9390.769
18. 0.002 0.111 ↑ 1.0 1 1

Nested Loop (cost=0.00..5.83 rows=1 width=73) (actual time=0.030..0.111 rows=1 loops=1)

  • Buffers: shared hit=3
19. 0.001 0.080 ↑ 1.0 1 1

Nested Loop (cost=0.00..3.88 rows=1 width=49) (actual time=0.018..0.080 rows=1 loops=1)

  • Buffers: shared hit=2
20. 0.056 0.056 ↑ 1.0 1 1

Seq Scan on med_company mc (cost=0.00..1.94 rows=1 width=25) (actual time=0.010..0.056 rows=1 loops=1)

  • Filter: (retail_outlet_id = '8'::numeric)
  • Rows Removed by Filter: 74
  • Buffers: shared hit=1
21. 0.023 0.023 ↑ 1.0 1 1

Seq Scan on med_division md (cost=0.00..1.94 rows=1 width=24) (actual time=0.007..0.023 rows=1 loops=1)

  • Filter: (retail_outlet_id = '8'::numeric)
  • Rows Removed by Filter: 74
  • Buffers: shared hit=1
22. 0.029 0.029 ↑ 1.0 1 1

Seq Scan on med_location ml (cost=0.00..1.94 rows=1 width=24) (actual time=0.010..0.029 rows=1 loops=1)

  • Filter: (retail_outlet_id = '8'::numeric)
  • Rows Removed by Filter: 74
  • Buffers: shared hit=1
23. 0.000 2,280.590 ↓ 16.3 802,997 1

Gather (cost=9,156.97..190,776.25 rows=49,257 width=375) (actual time=181.976..2,280.590 rows=802,997 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
  • Buffers: shared hit=1891622 read=67984
  • I/O Timings: read=9390.769
24. 3,049.468 4,790.975 ↓ 13.0 267,666 3

Nested Loop (cost=8,156.97..184,850.55 rows=20,524 width=375) (actual time=189.097..4,790.975 rows=267,666 loops=3)

  • Buffers: shared hit=1891622 read=67984
  • I/O Timings: read=9390.769
25. 1,218.156 1,741.466 ↓ 3.4 69,101 3

Nested Loop (cost=8,156.41..135,458.87 rows=20,534 width=320) (actual time=186.273..1,741.466 rows=69,101 loops=3)

  • Buffers: shared hit=333639 read=30634
  • I/O Timings: read=3648.238
26. 10.668 523.249 ↓ 3.2 18,588 3

Hash Join (cost=8,155.85..57,049.58 rows=5,808 width=266) (actual time=184.466..523.249 rows=18,588 loops=3)

  • Hash Cond: (mih.mih_mitem_type = mtm.mtm_type_code)
  • Buffers: shared hit=8328 read=12427
  • I/O Timings: read=843.556
27. 43.082 389.650 ↓ 3.1 18,588 3

Parallel Hash Join (cost=8,095.21..56,971.37 rows=5,954 width=258) (actual time=61.513..389.650 rows=18,588 loops=3)

  • Hash Cond: (mih.mih_item_mfr_code = mmm.mmm_mfr_code)
  • Buffers: shared hit=8298 read=12413
  • I/O Timings: read=842.278
28. 287.972 293.370 ↓ 1.6 18,588 3

Parallel Index Scan using med_item_hdr_pkey on med_item_hdr mih (cost=5.17..48,849.94 rows=11,952 width=240) (actual time=8.201..293.370 rows=18,588 loops=3)

  • Index Cond: (retail_outlet_id = '8'::numeric)
  • Filter: (NOT (hashed SubPlan 9))
  • Buffers: shared hit=8294 read=10457
  • I/O Timings: read=731.086
29.          

SubPlan (for Parallel Index Scan)

30. 5.398 5.398 ↑ 1.0 219 3

Seq Scan on med_report_skip_prodtype (cost=0.00..4.19 rows=219 width=5) (actual time=5.343..5.398 rows=219 loops=3)

  • Buffers: shared hit=4 read=2
  • I/O Timings: read=0.058
31. 0.000 53.198 ↑ 1.3 1,478 3

Parallel Hash (cost=8,066.50..8,066.50 rows=1,884 width=28) (actual time=53.197..53.198 rows=1,478 loops=3)

  • Buckets: 8192 Batches: 1 Memory Usage: 352kB
  • Buffers: shared hit=4 read=1956
  • I/O Timings: read=111.192
32. 36.655 157.476 ↓ 2.4 4,434 1

Parallel Bitmap Heap Scan on med_mfr_mast mmm (cost=4,604.84..8,066.50 rows=1,884 width=28) (actual time=121.103..157.476 rows=4,434 loops=1)

  • Recheck Cond: (retail_outlet_id = '8'::numeric)
  • Heap Blocks: exact=456
  • Buffers: shared hit=4 read=1956
  • I/O Timings: read=111.192
33. 120.821 120.821 ↑ 1.0 4,434 1

Bitmap Index Scan on med_mfr_mast_pkey (cost=0.00..4,603.71 rows=4,521 width=0) (actual time=120.821..120.821 rows=4,434 loops=1)

  • Index Cond: (retail_outlet_id = '8'::numeric)
  • Buffers: shared hit=4 read=1500
  • I/O Timings: read=78.521
34. 0.022 122.931 ↑ 1.0 37 3

Hash (cost=60.17..60.17 rows=37 width=23) (actual time=122.931..122.931 rows=37 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
  • Buffers: shared hit=30 read=14
  • I/O Timings: read=1.277
35. 122.612 122.909 ↑ 1.0 37 3

Bitmap Heap Scan on med_type_master mtm (cost=35.36..60.17 rows=37 width=23) (actual time=122.879..122.909 rows=37 loops=3)

  • Recheck Cond: (retail_outlet_id = '8'::numeric)
  • Heap Blocks: exact=2
  • Buffers: shared hit=30 read=14
  • I/O Timings: read=1.277
36. 0.297 0.297 ↑ 1.0 37 3

Bitmap Index Scan on med_type_master_pkey (cost=0.00..35.35 rows=37 width=0) (actual time=0.297..0.297 rows=37 loops=3)

  • Index Cond: (retail_outlet_id = '8'::numeric)
  • Buffers: shared hit=26 read=12
  • I/O Timings: read=0.096
37. 0.061 0.061 ↑ 3.8 4 55,765

Index Scan using mid1 on med_item_dtl mid (cost=0.56..13.35 rows=15 width=60) (actual time=0.009..0.061 rows=4 loops=55,765)

  • Index Cond: ((retail_outlet_id = '8'::numeric) AND (mid_item_code = mih.mih_item_code))
  • Buffers: shared hit=325311 read=18207
  • I/O Timings: read=2804.683
38. 0.041 0.041 ↓ 4.0 4 207,303

Index Scan using mss_idx1 on med_stock_sales mss (cost=0.56..2.40 rows=1 width=72) (actual time=0.015..0.041 rows=4 loops=207,303)

  • Index Cond: ((retail_outlet_id = '8'::numeric) AND (mss_item_rowid = mid.mid_row_id))
  • Buffers: shared hit=1557983 read=37350
  • I/O Timings: read=5742.531
39. 0.006 0.289 ↑ 1.0 11 1

Hash (cost=19.04..19.04 rows=11 width=20) (actual time=0.289..0.289 rows=11 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared read=9
  • I/O Timings: read=0.147
40. 0.283 0.283 ↑ 1.0 11 1

Seq Scan on producttype pt (cost=0.00..19.04 rows=11 width=20) (actual time=0.148..0.283 rows=11 loops=1)

  • Filter: (retail_outlet_id = '8'::numeric)
  • Rows Removed by Filter: 792
  • Buffers: shared read=9
  • I/O Timings: read=0.147
41. 0.000 0.000 ↑ 1.0 3 802,997

Materialize (cost=0.09..0.16 rows=3 width=64) (actual time=0.000..0.000 rows=3 loops=802,997)

42. 0.013 0.019 ↑ 1.0 3 1

HashAggregate (cost=0.09..0.12 rows=3 width=64) (actual time=0.016..0.019 rows=3 loops=1)

  • Group Key: ('R'::text), ('Regular'::text)
43. 0.002 0.006 ↑ 1.0 3 1

Append (cost=0.00..0.07 rows=3 width=64) (actual time=0.002..0.006 rows=3 loops=1)

44. 0.002 0.002 ↑ 1.0 1 1

Result (cost=0.00..0.01 rows=1 width=64) (actual time=0.001..0.002 rows=1 loops=1)

45. 0.001 0.001 ↑ 1.0 1 1

Result (cost=0.00..0.01 rows=1 width=64) (actual time=0.001..0.001 rows=1 loops=1)

46. 0.001 0.001 ↑ 1.0 1 1

Result (cost=0.00..0.01 rows=1 width=64) (actual time=0.001..0.001 rows=1 loops=1)

47. 3.612 121.438 ↑ 1.0 7,737 1

Hash (cost=4,288.16..4,288.16 rows=7,758 width=32) (actual time=121.438..121.438 rows=7,737 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 548kB
  • Buffers: shared hit=1014 read=451
  • I/O Timings: read=111.710
48. 117.826 117.826 ↑ 1.0 7,737 1

Index Scan using med_category_dtl_pkey on med_category_dtl mcd1 (cost=0.42..4,288.16 rows=7,758 width=32) (actual time=2.079..117.826 rows=7,737 loops=1)

  • Index Cond: (retail_outlet_id = '8'::numeric)
  • Buffers: shared hit=1014 read=451
  • I/O Timings: read=111.710
49. 1.904 5.295 ↑ 1.0 7,737 1

Hash (cost=4,288.16..4,288.16 rows=7,758 width=32) (actual time=5.295..5.295 rows=7,737 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 548kB
  • Buffers: shared hit=1465
50. 3.391 3.391 ↑ 1.0 7,737 1

Index Scan using med_category_dtl_pkey on med_category_dtl mcd2 (cost=0.42..4,288.16 rows=7,758 width=32) (actual time=0.027..3.391 rows=7,737 loops=1)

  • Index Cond: (retail_outlet_id = '8'::numeric)
  • Buffers: shared hit=1465
51. 1.993 5.171 ↑ 1.0 7,737 1

Hash (cost=4,288.16..4,288.16 rows=7,758 width=32) (actual time=5.171..5.171 rows=7,737 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 548kB
  • Buffers: shared hit=1465
52. 3.178 3.178 ↑ 1.0 7,737 1

Index Scan using med_category_dtl_pkey on med_category_dtl mcd3 (cost=0.42..4,288.16 rows=7,758 width=32) (actual time=0.027..3.178 rows=7,737 loops=1)

  • Index Cond: (retail_outlet_id = '8'::numeric)
  • Buffers: shared hit=1465
53. 1.964 4.893 ↑ 1.0 7,737 1

Hash (cost=4,288.16..4,288.16 rows=7,758 width=32) (actual time=4.893..4.893 rows=7,737 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 548kB
  • Buffers: shared hit=1465
54. 2.929 2.929 ↑ 1.0 7,737 1

Index Scan using med_category_dtl_pkey on med_category_dtl mcd4 (cost=0.42..4,288.16 rows=7,758 width=32) (actual time=0.024..2.929 rows=7,737 loops=1)

  • Index Cond: (retail_outlet_id = '8'::numeric)
  • Buffers: shared hit=1465
55. 2.006 4.950 ↑ 1.0 7,737 1

Hash (cost=4,288.16..4,288.16 rows=7,758 width=32) (actual time=4.950..4.950 rows=7,737 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 548kB
  • Buffers: shared hit=1465
56. 2.944 2.944 ↑ 1.0 7,737 1

Index Scan using med_category_dtl_pkey on med_category_dtl mcd5 (cost=0.42..4,288.16 rows=7,758 width=32) (actual time=0.034..2.944 rows=7,737 loops=1)

  • Index Cond: (retail_outlet_id = '8'::numeric)
  • Buffers: shared hit=1465
57. 1.934 4.797 ↑ 1.0 7,737 1

Hash (cost=4,288.16..4,288.16 rows=7,758 width=32) (actual time=4.797..4.797 rows=7,737 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 548kB
  • Buffers: shared hit=1465
58. 2.863 2.863 ↑ 1.0 7,737 1

Index Scan using med_category_dtl_pkey on med_category_dtl mcd6 (cost=0.42..4,288.16 rows=7,758 width=32) (actual time=0.022..2.863 rows=7,737 loops=1)

  • Index Cond: (retail_outlet_id = '8'::numeric)
  • Buffers: shared hit=1465
59. 1.993 4.890 ↑ 1.0 7,737 1

Hash (cost=4,288.16..4,288.16 rows=7,758 width=32) (actual time=4.889..4.890 rows=7,737 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 548kB
  • Buffers: shared hit=1465
60. 2.897 2.897 ↑ 1.0 7,737 1

Index Scan using med_category_dtl_pkey on med_category_dtl mcd7 (cost=0.42..4,288.16 rows=7,758 width=32) (actual time=0.022..2.897 rows=7,737 loops=1)

  • Index Cond: (retail_outlet_id = '8'::numeric)
  • Buffers: shared hit=1465
61. 2.019 4.961 ↑ 1.0 7,737 1

Hash (cost=4,288.16..4,288.16 rows=7,758 width=32) (actual time=4.961..4.961 rows=7,737 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 548kB
  • Buffers: shared hit=1465
62. 2.942 2.942 ↑ 1.0 7,737 1

Index Scan using med_category_dtl_pkey on med_category_dtl mcd8 (cost=0.42..4,288.16 rows=7,758 width=32) (actual time=0.033..2.942 rows=7,737 loops=1)

  • Index Cond: (retail_outlet_id = '8'::numeric)
  • Buffers: shared hit=1465
63.          

SubPlan (for GroupAggregate)

64. 0.200 0.200 ↑ 1.0 1 50

Index Scan using med_category_dtl_pkey on med_category_dtl (cost=0.42..2.64 rows=1 width=22) (actual time=0.004..0.004 rows=1 loops=50)

  • Index Cond: ((retail_outlet_id = mss.retail_outlet_id) AND (mcd_cat_code = mih.mih_category_1))
  • Buffers: shared hit=200
65. 0.150 0.150 ↑ 1.0 1 50

Index Scan using med_category_dtl_pkey on med_category_dtl med_category_dtl_1 (cost=0.42..2.64 rows=1 width=22) (actual time=0.003..0.003 rows=1 loops=50)

  • Index Cond: ((retail_outlet_id = mss.retail_outlet_id) AND (mcd_cat_code = mih.mih_category_2))
  • Buffers: shared hit=200
66. 0.150 0.150 ↑ 1.0 1 50

Index Scan using med_category_dtl_pkey on med_category_dtl med_category_dtl_2 (cost=0.42..2.64 rows=1 width=22) (actual time=0.003..0.003 rows=1 loops=50)

  • Index Cond: ((retail_outlet_id = mss.retail_outlet_id) AND (mcd_cat_code = mih.mih_category_3))
  • Buffers: shared hit=200
67. 0.150 0.150 ↑ 1.0 1 50

Index Scan using med_category_dtl_pkey on med_category_dtl med_category_dtl_3 (cost=0.42..2.64 rows=1 width=22) (actual time=0.003..0.003 rows=1 loops=50)

  • Index Cond: ((retail_outlet_id = mss.retail_outlet_id) AND (mcd_cat_code = mih.mih_category_4))
  • Buffers: shared hit=200
68. 0.350 0.350 ↑ 1.0 1 50

Index Scan using med_category_dtl_pkey on med_category_dtl med_category_dtl_4 (cost=0.42..2.64 rows=1 width=22) (actual time=0.007..0.007 rows=1 loops=50)

  • Index Cond: ((retail_outlet_id = mss.retail_outlet_id) AND (mcd_cat_code = mih.mih_category_5))
  • Buffers: shared hit=199 read=1
  • I/O Timings: read=0.181
69. 0.150 0.150 ↑ 1.0 1 50

Index Scan using med_category_dtl_pkey on med_category_dtl med_category_dtl_5 (cost=0.42..2.64 rows=1 width=22) (actual time=0.003..0.003 rows=1 loops=50)

  • Index Cond: ((retail_outlet_id = mss.retail_outlet_id) AND (mcd_cat_code = mih.mih_category_6))
  • Buffers: shared hit=200
70. 0.150 0.150 ↓ 0.0 0 50

Index Scan using med_category_dtl_pkey on med_category_dtl med_category_dtl_6 (cost=0.42..2.64 rows=1 width=22) (actual time=0.003..0.003 rows=0 loops=50)

  • Index Cond: ((retail_outlet_id = mss.retail_outlet_id) AND (mcd_cat_code = mih.mih_category_7))
  • Buffers: shared hit=150
71. 0.150 0.150 ↓ 0.0 0 50

Index Scan using med_category_dtl_pkey on med_category_dtl med_category_dtl_7 (cost=0.42..2.64 rows=1 width=22) (actual time=0.003..0.003 rows=0 loops=50)

  • Index Cond: ((retail_outlet_id = mss.retail_outlet_id) AND (mcd_cat_code = mih.mih_category_8))
  • Buffers: shared hit=150
Planning time : 66.224 ms
Execution time : 56,489.256 ms