explain.depesz.com

PostgreSQL's explain analyze made readable

Result: BLKF

Settings
# exclusive inclusive rows x rows loops node
1. 5.943 132.273 ↑ 2.7 12 1

Result (cost=152.12..359,319.39 rows=32 width=1,556) (actual time=35.633..132.273 rows=12 loops=1)

  • Buffers: shared hit=89,308
2. 0.070 0.930 ↑ 2.7 12 1

Sort (cost=152.12..152.20 rows=32 width=222) (actual time=0.919..0.930 rows=12 loops=1)

  • Sort Key: v.start_time, v.end_time, v.cln_visit_id
  • Sort Method: quicksort Memory: 28kB
  • Buffers: shared hit=94
3. 0.021 0.860 ↑ 2.7 12 1

Nested Loop (cost=45.13..151.32 rows=32 width=222) (actual time=0.722..0.860 rows=12 loops=1)

  • Buffers: shared hit=88
4. 0.175 0.683 ↑ 2.7 12 1

Hash Right Join (cost=44.71..72.92 rows=32 width=163) (actual time=0.674..0.683 rows=12 loops=1)

  • Hash Cond: (cvt.cln_visit_id = v.cln_visit_id)
  • Buffers: shared hit=40
5. 0.363 0.363 ↑ 1.0 675 1

Seq Scan on cln_visitops cvt (cost=0.00..26.44 rows=675 width=16) (actual time=0.006..0.363 rows=675 loops=1)

  • Filter: (defunct_ind = 'N'::bpchar)
  • Buffers: shared hit=18
6. 0.015 0.145 ↑ 2.7 12 1

Hash (cost=44.31..44.31 rows=32 width=155) (actual time=0.145..0.145 rows=12 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 10kB
  • Buffers: shared hit=22
7. 0.130 0.130 ↑ 2.7 12 1

Index Scan using ndx_vst_clinicid_vstdt on cln_visit v (cost=0.42..44.31 rows=32 width=155) (actual time=0.058..0.130 rows=12 loops=1)

  • Index Cond: ((ptf_clinic_id = 1) AND (visit_datetime < (CURRENT_DATE + 1)) AND (visit_datetime >= CURRENT_DATE))
  • Filter: (((visit_type)::text <> ALL ('{VTY4,VTY6,VTY7,VTY3,VTY8}'::text[])) AND ((visit_status)::text = ANY ('{VST3,VST4,VST5,VST6,VST7,VST8,VST9,VST10}'::text[])))
  • Rows Removed by Filter: 2
  • Buffers: shared hit=22
8. 0.144 0.144 ↑ 1.0 1 12

Index Scan using pk_cln_patient on cln_patient p (cost=0.42..2.44 rows=1 width=65) (actual time=0.012..0.012 rows=1 loops=12)

  • Index Cond: (cln_patient_id = v.cln_patient_id)
  • Buffers: shared hit=48
9.          

SubPlan (for Nested Loop)

10. 0.012 0.012 ↑ 1.0 1 12

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

11.          

SubPlan (for Result)

12. 0.108 0.108 ↑ 1.0 1 12

Index Scan using pk_cln_specialty on cln_specialty sp (cost=0.28..2.30 rows=1 width=11) (actual time=0.009..0.009 rows=1 loops=12)

  • Index Cond: (cln_specialty_id = v.visit_specialty_id)
  • Filter: (defunct_ind = 'N'::bpchar)
  • Buffers: shared hit=36
13. 0.132 0.132 ↑ 1.0 1 12

Index Scan using pk_cln_doctor on cln_doctor d (cost=0.29..2.30 rows=1 width=9) (actual time=0.011..0.011 rows=1 loops=12)

  • Index Cond: (cln_doctor_id = v.see_doctor_id)
  • Buffers: shared hit=36
14. 0.024 0.024 ↑ 1.0 1 12

Index Scan using pk_cln_doctor on cln_doctor d_1 (cost=0.29..2.30 rows=1 width=9) (actual time=0.002..0.002 rows=1 loops=12)

  • Index Cond: (cln_doctor_id = v.booking_doctor_id)
  • Buffers: shared hit=36
15. 0.012 0.072 ↓ 0.0 0 12

Nested Loop Left Join (cost=0.72..4.76 rows=1 width=32) (actual time=0.006..0.006 rows=0 loops=12)

  • Buffers: shared hit=24
16. 0.060 0.060 ↓ 0.0 0 12

Index Scan using ndx_vstdiag_vstid on cln_visitdiagnosis vd (cost=0.29..2.31 rows=1 width=23) (actual time=0.005..0.005 rows=0 loops=12)

  • Index Cond: (cln_visit_id = v.cln_visit_id)
  • Filter: (defunct_ind = 'N'::bpchar)
  • Buffers: shared hit=24
17. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_cln_diagnosis on cln_diagnosis diag (cost=0.43..2.45 rows=1 width=33) (never executed)

  • Index Cond: (vd.cln_diagnosis_id = cln_diagnosis_id)
18. 0.048 22.416 ↑ 1.0 1 12

Aggregate (cost=15.12..15.13 rows=1 width=8) (actual time=1.868..1.868 rows=1 loops=12)

  • Buffers: shared hit=10,235
19. 0.830 22.368 ↓ 3.0 3 12

Nested Loop (cost=0.84..15.12 rows=1 width=0) (actual time=1.593..1.864 rows=3 loops=12)

  • Buffers: shared hit=10,235
20. 4.752 4.752 ↓ 127.0 127 12

Index Scan using ndx_vst_ptid on cln_visit v2 (cost=0.42..4.12 rows=1 width=8) (actual time=0.014..0.396 rows=127 loops=12)

  • Index Cond: (cln_patient_id = v.cln_patient_id)
  • Filter: ((ptf_clinic_id = 1) AND ((visit_type)::text <> ALL ('{VTY4,VTY6,VTY7,VTY3,VTY8}'::text[])))
  • Rows Removed by Filter: 26
  • Buffers: shared hit=1,498
21. 16.786 16.786 ↓ 0.0 0 1,526

Index Scan using ndx_vstcharge_vstid on cln_visitcharge vc (cost=0.42..10.98 rows=2 width=8) (actual time=0.011..0.011 rows=0 loops=1,526)

  • Index Cond: (cln_visit_id = v2.cln_visit_id)
  • Filter: ((payment_ind = 'N'::bpchar) AND ((charge_status)::text = 'CST1'::text))
  • Rows Removed by Filter: 4
  • Buffers: shared hit=8,737
22. 0.048 32.364 ↑ 1.0 1 12

Aggregate (cost=5,566.18..5,566.19 rows=1 width=8) (actual time=2.697..2.697 rows=1 loops=12)

  • Buffers: shared hit=19,408
23. 0.123 32.316 ↓ 9.0 9 12

Nested Loop (cost=5,563.59..5,566.17 rows=1 width=0) (actual time=2.635..2.693 rows=9 loops=12)

  • Buffers: shared hit=19,408
24. 0.252 31.668 ↓ 9.0 9 12

Hash Join (cost=5,563.17..5,564.49 rows=1 width=8) (actual time=2.624..2.639 rows=9 loops=12)

  • Hash Cond: (csitem.cln_item_id = i.cln_item_id)
  • Buffers: shared hit=18,988
25. 0.210 8.604 ↑ 1.1 51 12

HashAggregate (cost=5,542.66..5,543.21 rows=55 width=8) (actual time=0.703..0.717 rows=51 loops=12)

  • Group Key: csitem.cln_item_id
  • Buffers: shared hit=983
26. 0.023 8.394 ↑ 1.1 51 1

Append (cost=0.42..5,542.52 rows=55 width=8) (actual time=0.436..8.394 rows=51 loops=1)

  • Buffers: shared hit=983
27. 0.113 0.113 ↓ 0.0 0 1

Index Scan using ndx_storeitem_storeid on cln_storeitem csitem (cost=0.42..46.36 rows=14 width=8) (actual time=0.113..0.113 rows=0 loops=1)

  • Index Cond: (cln_store_id = ANY ('{639173185180001,640069063820001,636698337260001}'::bigint[]))
  • Filter: ((ptf_clinic_id = 1) AND (defunct_ind = 'N'::bpchar))
  • Rows Removed by Filter: 13
  • Buffers: shared hit=17
28. 8.258 8.258 ↓ 1.2 51 1

Index Scan using ndx_clncitm_clncid on cln_itemclinic thisic (cost=0.42..5,495.34 rows=41 width=8) (actual time=0.320..8.258 rows=51 loops=1)

  • Index Cond: (ptf_clinic_id = 1)
  • Filter: (entered_ind = 'Y'::bpchar)
  • Rows Removed by Filter: 10,900
  • Buffers: shared hit=966
29. 0.360 22.812 ↓ 68.0 68 12

Hash (cost=20.50..20.50 rows=1 width=24) (actual time=1.901..1.901 rows=68 loops=12)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=18,005
30. 0.328 22.452 ↓ 68.0 68 12

Nested Loop (cost=1.26..20.50 rows=1 width=24) (actual time=0.084..1.871 rows=68 loops=12)

  • Buffers: shared hit=18,005
31. 1.057 18.876 ↓ 68.0 68 12

Nested Loop (cost=0.84..18.60 rows=1 width=16) (actual time=0.072..1.573 rows=68 loops=12)

  • Buffers: shared hit=14,757
32. 3.626 6.780 ↓ 131.0 131 12

Index Scan using ndx_vst_ptid on cln_visit vt (cost=0.42..11.43 rows=1 width=8) (actual time=0.017..0.565 rows=131 loops=12)

  • Index Cond: (cln_patient_id = v.cln_patient_id)
  • Filter: (((visit_type)::text <> ALL ('{VTY4,VTY6,VTY7,VTY3,VTY8}'::text[])) AND ((SubPlan 7) = 'N'::bpchar))
  • Rows Removed by Filter: 22
  • Buffers: shared hit=7,806
33.          

SubPlan (for Index Scan)

34. 3.154 3.154 ↑ 1.0 1 1,577

Index Scan using pk_cln_patient on cln_patient (cost=0.42..2.44 rows=1 width=2) (actual time=0.002..0.002 rows=1 loops=1,577)

  • Index Cond: (cln_patient_id = vt.cln_patient_id)
  • Buffers: shared hit=6,308
35. 11.039 11.039 ↑ 1.0 1 1,577

Index Scan using ndx_dd_vstid on cln_visitdrugdispense vdd (cost=0.42..7.16 rows=1 width=24) (actual time=0.006..0.007 rows=1 loops=1,577)

  • Index Cond: (cln_visit_id = vt.cln_visit_id)
  • Filter: (((material_type)::text = 'MTY1'::text) AND ((dispense_status)::text = 'DST0'::text) AND (ptf_clinic_id = 1))
  • Rows Removed by Filter: 2
  • Buffers: shared hit=6,951
36. 3.248 3.248 ↑ 1.0 1 812

Index Scan using pk_cln_item on cln_item i (cost=0.42..1.89 rows=1 width=8) (actual time=0.004..0.004 rows=1 loops=812)

  • Index Cond: (cln_item_id = vdd.cln_item_id)
  • Filter: (material_item_ind = 'Y'::bpchar)
  • Buffers: shared hit=3,248
37. 0.525 0.525 ↑ 1.0 1 105

Index Scan using pk_cln_visitcharge on cln_visitcharge vc_1 (cost=0.42..1.69 rows=1 width=8) (actual time=0.005..0.005 rows=1 loops=105)

  • Index Cond: (cln_visitcharge_id = vdd.cln_visitcharge_id)
  • Filter: ((payment_ind = 'Y'::bpchar) AND ((charge_status)::text = 'CST1'::text))
  • Buffers: shared hit=420
38. 0.012 17.796 ↑ 1.0 1 12

Aggregate (cost=5,567.39..5,567.40 rows=1 width=8) (actual time=1.483..1.483 rows=1 loops=12)

  • Buffers: shared hit=15,861
39. 0.036 17.784 ↓ 0.0 0 12

Nested Loop (cost=5,564.10..5,567.38 rows=1 width=0) (actual time=1.482..1.482 rows=0 loops=12)

  • Buffers: shared hit=15,861
40. 0.148 17.748 ↓ 0.0 0 12

Hash Join (cost=5,563.68..5,565.00 rows=1 width=8) (actual time=1.479..1.479 rows=0 loops=12)

  • Hash Cond: (csitem_1.cln_item_id = i_1.cln_item_id)
  • Buffers: shared hit=15,861
41. 0.133 4.184 ↑ 1.1 51 8

HashAggregate (cost=5,542.66..5,543.21 rows=55 width=8) (actual time=0.510..0.523 rows=51 loops=8)

  • Group Key: csitem_1.cln_item_id
  • Buffers: shared hit=980
42. 0.022 4.051 ↑ 1.1 51 1

Append (cost=0.42..5,542.52 rows=55 width=8) (actual time=0.124..4.051 rows=51 loops=1)

  • Buffers: shared hit=980
43. 0.034 0.034 ↓ 0.0 0 1

Index Scan using ndx_storeitem_storeid on cln_storeitem csitem_1 (cost=0.42..46.36 rows=14 width=8) (actual time=0.034..0.034 rows=0 loops=1)

  • Index Cond: (cln_store_id = ANY ('{639173185180001,640069063820001,636698337260001}'::bigint[]))
  • Filter: ((ptf_clinic_id = 1) AND (defunct_ind = 'N'::bpchar))
  • Rows Removed by Filter: 13
  • Buffers: shared hit=14
44. 3.995 3.995 ↓ 1.2 51 1

Index Scan using ndx_clncitm_clncid on cln_itemclinic thisic_1 (cost=0.42..5,495.34 rows=41 width=8) (actual time=0.088..3.995 rows=51 loops=1)

  • Index Cond: (ptf_clinic_id = 1)
  • Filter: (entered_ind = 'Y'::bpchar)
  • Rows Removed by Filter: 10,900
  • Buffers: shared hit=966
45. 0.048 13.416 ↓ 3.0 3 12

Hash (cost=21.01..21.01 rows=1 width=24) (actual time=1.118..1.118 rows=3 loops=12)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=14,881
46. 0.052 13.368 ↓ 3.0 3 12

Nested Loop (cost=1.26..21.01 rows=1 width=24) (actual time=0.422..1.114 rows=3 loops=12)

  • Buffers: shared hit=14,881
47. 1.473 13.068 ↓ 3.0 3 12

Nested Loop (cost=0.84..18.60 rows=1 width=16) (actual time=0.411..1.089 rows=3 loops=12)

  • Buffers: shared hit=14,757
48. 3.710 6.864 ↓ 131.0 131 12

Index Scan using ndx_vst_ptid on cln_visit vt_1 (cost=0.42..11.43 rows=1 width=8) (actual time=0.014..0.572 rows=131 loops=12)

  • Index Cond: (cln_patient_id = v.cln_patient_id)
  • Filter: (((visit_type)::text <> ALL ('{VTY4,VTY6,VTY7,VTY3,VTY8}'::text[])) AND ((SubPlan 9) = 'N'::bpchar))
  • Rows Removed by Filter: 22
  • Buffers: shared hit=7,806
49.          

SubPlan (for Index Scan)

50. 3.154 3.154 ↑ 1.0 1 1,577

Index Scan using pk_cln_patient on cln_patient cln_patient_1 (cost=0.42..2.44 rows=1 width=2) (actual time=0.002..0.002 rows=1 loops=1,577)

  • Index Cond: (cln_patient_id = vt_1.cln_patient_id)
  • Buffers: shared hit=6,308
51. 4.731 4.731 ↓ 0.0 0 1,577

Index Scan using ndx_dd_vstid on cln_visitdrugdispense vdd_1 (cost=0.42..7.16 rows=1 width=24) (actual time=0.003..0.003 rows=0 loops=1,577)

  • Index Cond: (cln_visit_id = vt_1.cln_visit_id)
  • Filter: (((material_type)::text = 'MTY2'::text) AND ((dispense_status)::text = 'DST0'::text) AND (ptf_clinic_id = 1))
  • Rows Removed by Filter: 3
  • Buffers: shared hit=6,951
52. 0.248 0.248 ↑ 1.0 1 31

Index Scan using pk_cln_item on cln_item i_1 (cost=0.42..2.40 rows=1 width=8) (actual time=0.008..0.008 rows=1 loops=31)

  • Index Cond: (cln_item_id = vdd_1.cln_item_id)
  • Filter: (material_item_ind = 'Y'::bpchar)
  • Buffers: shared hit=124
53. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_cln_visitcharge on cln_visitcharge vc_2 (cost=0.42..2.39 rows=1 width=8) (never executed)

  • Index Cond: (cln_visitcharge_id = vdd_1.cln_visitcharge_id)
  • Filter: ((payment_ind = 'Y'::bpchar) AND ((charge_status)::text = 'CST1'::text))
54. 0.084 44.856 ↑ 1.0 1 12

Aggregate (cost=30.80..30.81 rows=1 width=8) (actual time=3.738..3.738 rows=1 loops=12)

  • Buffers: shared hit=34,866
55. 1.068 44.772 ↓ 16.0 16 12

Nested Loop (cost=2.10..30.79 rows=1 width=0) (actual time=0.150..3.731 rows=16 loops=12)

  • Join Filter: (oe.cln_visitorderentry_id = pe.cln_visitorderentry_id)
  • Buffers: shared hit=34,866
56. 0.598 38.208 ↓ 114.0 114 12

Nested Loop Semi Join (cost=1.68..27.76 rows=1 width=16) (actual time=0.079..3.184 rows=114 loops=12)

  • Buffers: shared hit=29,332
57. 1.201 14.640 ↓ 191.0 191 12

Nested Loop (cost=0.84..23.78 rows=1 width=8) (actual time=0.030..1.220 rows=191 loops=12)

  • Buffers: shared hit=8,150
58. 2.400 2.400 ↓ 43.7 131 12

Index Scan using ndx_vst_ptid on cln_visit vt_2 (cost=0.42..4.11 rows=3 width=8) (actual time=0.008..0.200 rows=131 loops=12)

  • Index Cond: (cln_patient_id = v.cln_patient_id)
  • Filter: ((visit_type)::text <> ALL ('{VTY4,VTY6,VTY7,VTY3,VTY8}'::text[]))
  • Rows Removed by Filter: 22
  • Buffers: shared hit=1,498
59. 11.039 11.039 ↑ 1.0 1 1,577

Index Scan using ndx_vstoe_vstid on cln_visitorderentry oe (cost=0.42..6.54 rows=1 width=16) (actual time=0.004..0.007 rows=1 loops=1,577)

  • Index Cond: (cln_visit_id = vt_2.cln_visit_id)
  • Filter: ((ptf_clinic_id = 1) AND ((order_status)::text = 'OST1'::text) AND (lab_ind = 'N'::bpchar))
  • Rows Removed by Filter: 0
  • Buffers: shared hit=6,652
60. 4.926 22.970 ↑ 3.0 1 2,297

Nested Loop (cost=0.84..3.95 rows=3 width=8) (actual time=0.010..0.010 rows=1 loops=2,297)

  • Buffers: shared hit=21,182
61. 9.188 9.188 ↑ 4.0 1 2,297

Index Scan using ndx_vstoei_vstoeid on cln_visitorderentryitem oei (cost=0.42..1.88 rows=4 width=16) (actual time=0.004..0.004 rows=1 loops=2,297)

  • Index Cond: (cln_visitorderentry_id = oe.cln_visitorderentry_id)
  • Filter: ((order_status)::text = 'OST1'::text)
  • Rows Removed by Filter: 0
  • Buffers: shared hit=9,267
62. 8.856 8.856 ↓ 0.0 0 2,952

Index Scan using ndx_vstcharge_oeiid on cln_visitcharge vc_3 (cost=0.42..0.51 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=2,952)

  • Index Cond: (cln_visitorderentryitem_id = oei.cln_visitorderentryitem_id)
  • Filter: ((payment_ind = 'Y'::bpchar) AND ((charge_status)::text = 'CST1'::text))
  • Rows Removed by Filter: 1
  • Buffers: shared hit=11,915
63. 4.131 5.496 ↓ 0.0 0 1,374

Index Scan using ndx_pe_oeid on cln_visitplannedexecution pe (cost=0.42..3.02 rows=1 width=8) (actual time=0.004..0.004 rows=0 loops=1,374)

  • Index Cond: (cln_visitorderentry_id = oei.cln_visitorderentry_id)
  • Filter: (((end_date IS NULL) OR (end_date > '2020-10-14 23:59:59'::timestamp without time zone)) AND ((order_status)::text = 'OST1'::text) AND (completion_ind = 'N'::bpchar) AND (qty_per_day > ((SubPlan 11))::numeric))
  • Rows Removed by Filter: 0
  • Buffers: shared hit=5,534
64.          

SubPlan (for Index Scan)

65. 0.195 1.365 ↑ 1.0 1 195

Aggregate (cost=2.44..2.45 rows=1 width=8) (actual time=0.007..0.007 rows=1 loops=195)

  • Buffers: shared hit=911
66. 1.170 1.170 ↓ 0.0 0 195

Index Scan using ndx_osj_pe_id on cln_visitorderstatusjournal osj (cost=0.41..2.44 rows=1 width=0) (actual time=0.006..0.006 rows=0 loops=195)

  • Index Cond: (cln_visitplannedexecution_id = pe.cln_visitplannedexecution_id)
  • Filter: ((execed_datetime >= '2020-10-14 00:00:00'::timestamp without time zone) AND (execed_datetime <= '2020-10-14 23:59:59'::timestamp without time zone) AND (defunct_ind = 'N'::bpchar))
  • Rows Removed by Filter: 2
  • Buffers: shared hit=911
67. 0.024 7.632 ↑ 1.0 1 12

Aggregate (cost=32.50..32.51 rows=1 width=8) (actual time=0.636..0.636 rows=1 loops=12)

  • Buffers: shared hit=8,210
68. 0.016 7.608 ↓ 0.0 0 12

Nested Loop Semi Join (cost=2.10..32.50 rows=1 width=0) (actual time=0.340..0.634 rows=0 loops=12)

  • Buffers: shared hit=8,210
69. 0.016 7.536 ↓ 0.0 0 12

Nested Loop (cost=1.25..28.76 rows=1 width=16) (actual time=0.335..0.628 rows=0 loops=12)

  • Buffers: shared hit=8,178
70. 0.549 7.464 ↓ 0.0 0 12

Nested Loop (cost=0.84..23.85 rows=1 width=8) (actual time=0.329..0.622 rows=0 loops=12)

  • Buffers: shared hit=8,150
71. 2.184 2.184 ↓ 43.7 131 12

Index Scan using ndx_vst_ptid on cln_visit vt_3 (cost=0.42..4.11 rows=3 width=8) (actual time=0.008..0.182 rows=131 loops=12)

  • Index Cond: (cln_patient_id = v.cln_patient_id)
  • Filter: ((visit_type)::text <> ALL ('{VTY4,VTY6,VTY7,VTY3,VTY8}'::text[]))
  • Rows Removed by Filter: 22
  • Buffers: shared hit=1,498
72. 4.731 4.731 ↓ 0.0 0 1,577

Index Scan using ndx_vstoe_vstid on cln_visitorderentry oe_1 (cost=0.42..6.57 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=1,577)

  • Index Cond: (cln_visit_id = vt_3.cln_visit_id)
  • Filter: ((entered_datetime >= '2020-10-14 00:00:00'::timestamp without time zone) AND (entered_datetime <= '2020-10-14 23:59:59'::timestamp without time zone) AND (ptf_clinic_id = 1) AND ((order_status)::text = 'OST1'::text) AND (lab_ind = 'Y'::bpchar))
  • Rows Removed by Filter: 2
  • Buffers: shared hit=6,652
73. 0.036 0.056 ↑ 1.0 1 4

Index Scan using ndx_pe_oeid on cln_visitplannedexecution pe_1 (cost=0.42..4.90 rows=1 width=8) (actual time=0.013..0.014 rows=1 loops=4)

  • Index Cond: (cln_visitorderentry_id = oe_1.cln_visitorderentry_id)
  • Filter: (((end_date IS NULL) OR (end_date > '2020-10-14 23:59:59'::timestamp without time zone)) AND ((order_status)::text = 'OST1'::text) AND (completion_ind = 'N'::bpchar) AND (qty_per_day > ((SubPlan 13))::numeric))
  • Buffers: shared hit=28
74.          

SubPlan (for Index Scan)

75. 0.008 0.020 ↑ 1.0 1 4

Aggregate (cost=2.44..2.45 rows=1 width=8) (actual time=0.005..0.005 rows=1 loops=4)

  • Buffers: shared hit=12
76. 0.012 0.012 ↓ 0.0 0 4

Index Scan using ndx_osj_pe_id on cln_visitorderstatusjournal osj_1 (cost=0.41..2.44 rows=1 width=0) (actual time=0.003..0.003 rows=0 loops=4)

  • Index Cond: (cln_visitplannedexecution_id = pe_1.cln_visitplannedexecution_id)
  • Filter: ((execed_datetime >= '2020-10-14 00:00:00'::timestamp without time zone) AND (execed_datetime <= '2020-10-14 23:59:59'::timestamp without time zone) AND (defunct_ind = 'N'::bpchar))
  • Buffers: shared hit=12
77. 0.012 0.056 ↑ 3.0 1 4

Nested Loop (cost=0.84..3.72 rows=3 width=8) (actual time=0.014..0.014 rows=1 loops=4)

  • Buffers: shared hit=32
78. 0.020 0.020 ↑ 4.0 1 4

Index Scan using ndx_vstoei_vstoeid on cln_visitorderentryitem oei_1 (cost=0.42..1.66 rows=4 width=16) (actual time=0.005..0.005 rows=1 loops=4)

  • Index Cond: (cln_visitorderentry_id = pe_1.cln_visitorderentry_id)
  • Filter: ((order_status)::text = 'OST1'::text)
  • Buffers: shared hit=16
79. 0.024 0.024 ↑ 1.0 1 4

Index Scan using ndx_vstcharge_oeiid on cln_visitcharge vc_4 (cost=0.42..0.51 rows=1 width=8) (actual time=0.006..0.006 rows=1 loops=4)

  • Index Cond: (cln_visitorderentryitem_id = oei_1.cln_visitorderentryitem_id)
  • Filter: ((payment_ind = 'Y'::bpchar) AND ((charge_status)::text = 'CST1'::text))
  • Buffers: shared hit=16
Planning time : 13.551 ms
Execution time : 134.109 ms