explain.depesz.com

PostgreSQL's explain analyze made readable

Result: KNmM

Settings
# exclusive inclusive rows x rows loops node
1. 0.131 206,791.712 ↑ 1.0 1 1

Aggregate (cost=9,214.76..9,214.77 rows=1 width=144) (actual time=206,791.712..206,791.712 rows=1 loops=1)

  • Buffers: shared hit=84,245,914 read=349
2. 0.187 206,791.581 ↓ 502.0 502 1

Group (cost=9,214.70..9,214.73 rows=1 width=284) (actual time=206,791.332..206,791.581 rows=502 loops=1)

  • Group Key: v.cln_visit_id, "*SELECT* 1".group_time, ((0)::numeric), ((0)::numeric), "*SELECT* 1".chargetime, pt.cln_patient_id, ('N'::text), "*SELECT* 1".videodiagnosisamount, "*SELECT* 1".videotime, "*SELECT* 1".videoinfeetime
  • Buffers: shared hit=84,245,914 read=349
  • '::bpchar))
3.          

Initplan (for Group)

4. 0.039 0.039 ↑ 1.0 1 1

Index Scan using ndx_clndoc_userid on cln_doctor c (cost=0.29..4.31 rows=1 width=8) (actual time=0.029..0.039 rows=1 loops=1)

  • Index Cond: (cln_user_id = '6030580170001'::bigint)
  • Filter: (defunct_ind = 'N'::bpchar)
  • Buffers: shared hit=4
5. 1.839 206,791.355 ↓ 502.0 502 1

Sort (cost=9,210.39..9,210.39 rows=1 width=252) (actual time=206,791.322..206,791.355 rows=502 loops=1)

  • Sort Key: v.cln_visit_id, "*SELECT* 1".group_time, ((0)::numeric), ((0)::numeric), "*SELECT* 1".chargetime, pt.cln_patient_id, ('N'::text), "*SELECT* 1".videodiagnosisamount, "*SELECT* 1".videotime, "*SELECT* 1".videoinfeetime
  • Sort Method: quicksort Memory: 95kB
  • Buffers: shared hit=84,245,914 read=349
6. 300.679 206,789.516 ↓ 502.0 502 1

Nested Loop (cost=2,277.43..9,210.38 rows=1 width=252) (actual time=17,617.609..206,789.516 rows=502 loops=1)

  • Join Filter: (v.cln_visit_id = "*SELECT* 1".cln_visit_id)
  • Rows Removed by Join Filter: 518,566
  • Buffers: shared hit=84,245,902 read=349
7. 3.106 437.453 ↓ 1,034.0 1,034 1

Nested Loop (cost=1,320.02..3,179.66 rows=1 width=24) (actual time=23.808..437.453 rows=1,034 loops=1)

  • Buffers: shared hit=197,243 read=349
8. 3.668 340.253 ↓ 1,034.0 1,034 1

Nested Loop Left Join (cost=1,319.60..3,175.22 rows=1 width=24) (actual time=23.762..340.253 rows=1,034 loops=1)

  • Buffers: shared hit=193,686 read=109
9. 84.978 328.313 ↓ 1,034.0 1,034 1

Bitmap Heap Scan on cln_visit v (cost=1,319.31..3,170.90 rows=1 width=24) (actual time=23.752..328.313 rows=1,034 loops=1)

  • Recheck Cond: ((see_doctor_id = $0) AND (ptf_clinic_id = 603,057,984) AND (ptf_topclinic_id = 603,056,867))
  • Filter: (((visit_type)::text <> ALL ('{VTY4,VTY6,VTY7,VTY3,VTY8}'::text[])) AND (SubPlan 5))
  • Rows Removed by Filter: 21,317
  • Heap Blocks: exact=19,297
  • Buffers: shared hit=191,625 read=100
10. 1.780 19.825 ↓ 0.0 0 1

BitmapAnd (cost=1,319.31..1,319.31 rows=1 width=0) (actual time=19.825..19.825 rows=0 loops=1)

  • Buffers: shared hit=512
11. 5.005 5.005 ↓ 17.6 22,522 1

Bitmap Index Scan on ndx_vst_seedocid (cost=0.00..20.05 rows=1,283 width=0) (actual time=5.005..5.005 rows=22,522 loops=1)

  • Index Cond: (see_doctor_id = $0)
  • Buffers: shared hit=125
12. 6.883 6.883 ↑ 1.0 34,757 1

Bitmap Index Scan on ndx_vst_clinicid (cost=0.00..534.38 rows=35,993 width=0) (actual time=6.883..6.883 rows=34,757 loops=1)

  • Index Cond: (ptf_clinic_id = 603,057,984)
  • Buffers: shared hit=138
13. 6.157 6.157 ↑ 1.0 34,757 1

Bitmap Index Scan on ndx_vst_topclinicid_vstdt (cost=0.00..764.38 rows=35,993 width=0) (actual time=6.157..6.157 rows=34,757 loops=1)

  • Index Cond: (ptf_topclinic_id = 603,056,867)
  • Buffers: shared hit=249
14.          

SubPlan (for Bitmap Heap Scan)

15. 2.068 223.510 ↓ 0.0 0 22,351

Append (cost=1,005.38..3,537.96 rows=3 width=4) (actual time=0.010..0.010 rows=0 loops=22,351)

  • Buffers: shared hit=171,816 read=100
16. 177.843 178.808 ↓ 0.0 0 22,351

Index Scan using ndx_vstdiag_vstid on cln_visitdiagnosis vd (cost=1,005.38..1,009.40 rows=1 width=4) (actual time=0.008..0.008 rows=0 loops=22,351)

  • Index Cond: (cln_visit_id = v.cln_visit_id)
  • Filter: ((defunct_ind = 'N'::bpchar) AND ((hashed SubPlan 2) OR ((diagnosis_remark)::text ~~ '%不孕%'::text)))
  • Rows Removed by Filter: 1
  • Buffers: shared hit=86,479 read=100
17.          

SubPlan (for Index Scan)

18. 0.965 0.965 ↑ 1.0 1 1

Index Scan using ndx_clndns_clnid on cln_diagnosis dia (cost=0.43..1,004.95 rows=1 width=8) (actual time=0.903..0.965 rows=1 loops=1)

  • Index Cond: (ptf_topclinic_id = 603,056,867)
  • Filter: ((diagnosis_desc)::text ~~ '%不孕%'::text)
  • Rows Removed by Filter: 3,470
  • Buffers: shared hit=87
19. 21.317 21.317 ↓ 0.0 0 21,317

Index Scan using ndx_vcd_visitid on cln_visitchndisease vcd (cost=347.06..351.09 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=21,317)

  • Index Cond: (cln_visit_id = v.cln_visit_id)
  • Filter: ((defunct_ind = 'N'::bpchar) AND ((hashed SubPlan 3) OR ((chndisease_remark)::text ~~ '%不孕%'::text) OR ((chndisease_content)::text ~~ '%不孕%'::text)))
  • Buffers: shared hit=42,681
20.          

SubPlan (for Index Scan)

21. 0.000 0.000 ↓ 0.0 0

Index Scan using ndx_chndiag_top_id on cln_chinesediagnosis cdia (cost=0.42..346.77 rows=1 width=8) (never executed)

  • Index Cond: (ptf_topclinic_id = 603,056,867)
  • Filter: ((chinesediagnosis_desc)::text ~~ '%不孕%'::text)
22. 21.317 21.317 ↓ 0.0 0 21,317

Index Scan using ndx_vcs_visitid on cln_visitchnsyndrome vs (cost=2,173.39..2,177.42 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=21,317)

  • Index Cond: (cln_visit_id = v.cln_visit_id)
  • Filter: ((defunct_ind = 'N'::bpchar) AND ((hashed SubPlan 4) OR ((chnsyndrome_remark)::text ~~ '%不孕%'::text) OR ((chnsyndrome_content)::text ~~ '%不孕%'::text)))
  • Buffers: shared hit=42,656
23.          

SubPlan (for Index Scan)

24. 0.000 0.000 ↓ 0.0 0

Index Scan using ndx_cln_chnsymp_topclinic_id on cln_chinesesymptom csym (cost=0.42..2,173.10 rows=1 width=8) (never executed)

  • Index Cond: (ptf_topclinic_id = 603,056,867)
  • Filter: ((chinesesymptom_desc)::text ~~ '%不孕%'::text)
25. 8.272 8.272 ↓ 0.0 0 1,034

Index Only Scan using ndx_ped_visitid on cln_patientremind pr (cost=0.29..4.30 rows=1 width=8) (actual time=0.008..0.008 rows=0 loops=1,034)

  • Index Cond: (cln_visit_id = v.cln_visit_id)
  • Heap Fetches: 0
  • Buffers: shared hit=2,061 read=9
26. 94.094 94.094 ↑ 1.0 1 1,034

Index Only Scan using pk_cln_patient on cln_patient pt (cost=0.43..4.45 rows=1 width=8) (actual time=0.091..0.091 rows=1 loops=1,034)

  • Index Cond: (cln_patient_id = v.cln_patient_id)
  • Heap Fetches: 341
  • Buffers: shared hit=3,557 read=240
27. 40.326 206,051.384 ↓ 251.0 502 1,034

Append (cost=957.41..6,030.67 rows=2 width=236) (actual time=26.300..199.276 rows=502 loops=1,034)

  • Buffers: shared hit=84,048,655
28. 9.306 203,145.844 ↓ 20.0 20 1,034

Subquery Scan on *SELECT* 1 (cost=957.41..2,838.41 rows=1 width=236) (actual time=26.300..196.466 rows=20 loops=1,034)

  • Buffers: shared hit=83,859,555
29. 65.130 203,136.538 ↓ 20.0 20 1,034

Nested Loop Left Join (cost=957.41..2,838.39 rows=1 width=180) (actual time=26.299..196.457 rows=20 loops=1,034)

  • Buffers: shared hit=83,859,555
30.          

Initplan (for Nested Loop Left Join)

31. 0.012 0.012 ↑ 1.0 1 1

Index Scan using ndx_clndoc_userid on cln_doctor c_1 (cost=0.29..4.31 rows=1 width=8) (actual time=0.010..0.012 rows=1 loops=1)

  • Index Cond: (cln_user_id = '6030580170001'::bigint)
  • Filter: (defunct_ind = 'N'::bpchar)
  • Buffers: shared hit=4
32. 23,684.804 203,050.716 ↓ 20.0 20 1,034

Bitmap Heap Scan on cln_visit v_1 (cost=952.96..2,817.34 rows=1 width=21) (actual time=26.294..196.374 rows=20 loops=1,034)

  • Recheck Cond: ((see_doctor_id = $6) AND (ptf_clinic_id = 603,057,984) AND (visit_datetime >= '2020-01-01 00:00:00'::timestamp without time zone) AND (visit_datetime < '2020-10-16 00:00:00'::timestamp without time zone) AND (data_top_id = 603,056,867))
  • Filter: ((ptf_topclinic_id = 603,056,867) AND ((visit_type)::text <> ALL ('{VTY4,VTY6,VTY7,VTY3,VTY8}'::text[])) AND (((visit_status)::text >= 'VST3'::text) OR (((visit_status)::text >= 'VST1'::text) AND ((visit_type)::text = 'VTY9'::text))) AND ((SubPlan 12) = 0) AND (SubPlan 11))
  • Rows Removed by Filter: 9,343
  • Heap Blocks: exact=8,558,418
  • Buffers: shared hit=83,838,875
33. 1,272.854 9,006.140 ↓ 0.0 0 1,034

BitmapAnd (cost=952.96..952.96 rows=1 width=0) (actual time=8.710..8.710 rows=0 loops=1,034)

  • Buffers: shared hit=331,914
34. 2,838.330 2,838.330 ↓ 17.6 22,522 1,034

Bitmap Index Scan on ndx_vst_seedocid (cost=0.00..20.05 rows=1,283 width=0) (actual time=2.745..2.745 rows=22,522 loops=1,034)

  • Index Cond: (see_doctor_id = $6)
  • Buffers: shared hit=125,114
35. 1,297.670 1,297.670 ↑ 1.3 11,115 1,034

Bitmap Index Scan on ndx_vst_clinicid_vstdt (cost=0.00..360.03 rows=14,848 width=0) (actual time=1.255..1.255 rows=11,115 loops=1,034)

  • Index Cond: ((ptf_clinic_id = 603,057,984) AND (visit_datetime >= '2020-01-01 00:00:00'::timestamp without time zone) AND (visit_datetime < '2020-10-16 00:00:00'::timestamp without time zone))
  • Buffers: shared hit=71,346
36. 3,597.286 3,597.286 ↑ 1.0 34,757 1,034

Bitmap Index Scan on ndx_vst_topid (cost=0.00..572.38 rows=35,993 width=0) (actual time=3.479..3.479 rows=34,757 loops=1,034)

  • Index Cond: (data_top_id = 603,056,867)
  • Buffers: shared hit=135,454
37.          

SubPlan (for Bitmap Heap Scan)

38. 0.000 168,405.512 ↑ 1.0 1 8,863,448

Aggregate (cost=12.76..12.77 rows=1 width=8) (actual time=0.019..0.019 rows=1 loops=8,863,448)

  • Buffers: shared hit=72,436,870
39. 168,405.512 168,405.512 ↓ 11.0 11 8,863,448

Index Scan using ndx_vstcharge_vstid on cln_visitcharge vc_2 (cost=0.44..12.75 rows=1 width=0) (actual time=0.004..0.019 rows=11 loops=8,863,448)

  • Index Cond: (cln_visit_id = v_1.cln_visit_id)
  • Filter: ((payment_ind = 'Y'::bpchar) AND (to_char(charged_datetime, 'yyyy-MM-dd'::text) = to_char(v_1.visit_datetime, 'yyyy-MM-dd'::text)))
  • Rows Removed by Filter: 0
  • Buffers: shared hit=72,436,870
40. 367.070 1,954.260 ↓ 0.0 0 325,710

Append (cost=1,005.38..3,537.96 rows=3 width=4) (actual time=0.006..0.006 rows=0 loops=325,710)

  • Buffers: shared hit=2,511,673
41. 976.470 977.130 ↓ 0.0 0 325,710

Index Scan using ndx_vstdiag_vstid on cln_visitdiagnosis vd_1 (cost=1,005.38..1,009.40 rows=1 width=4) (actual time=0.003..0.003 rows=0 loops=325,710)

  • Index Cond: (cln_visit_id = v_1.cln_visit_id)
  • Filter: ((defunct_ind = 'N'::bpchar) AND ((hashed SubPlan 8) OR ((diagnosis_remark)::text ~~ '%不孕%'::text)))
  • Rows Removed by Filter: 1
  • Buffers: shared hit=1,287,417
42.          

SubPlan (for Index Scan)

43. 0.660 0.660 ↑ 1.0 1 1

Index Scan using ndx_clndns_clnid on cln_diagnosis dia_1 (cost=0.43..1,004.95 rows=1 width=8) (actual time=0.607..0.660 rows=1 loops=1)

  • Index Cond: (ptf_topclinic_id = 603,056,867)
  • Filter: ((diagnosis_desc)::text ~~ '%不孕%'::text)
  • Rows Removed by Filter: 3,470
  • Buffers: shared hit=87
44. 305.030 305.030 ↓ 0.0 0 305,030

Index Scan using ndx_vcd_visitid on cln_visitchndisease vcd_1 (cost=347.06..351.09 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=305,030)

  • Index Cond: (cln_visit_id = v_1.cln_visit_id)
  • Filter: ((defunct_ind = 'N'::bpchar) AND ((hashed SubPlan 9) OR ((chndisease_remark)::text ~~ '%不孕%'::text) OR ((chndisease_content)::text ~~ '%不孕%'::text)))
  • Buffers: shared hit=612,128
45.          

SubPlan (for Index Scan)

46. 0.000 0.000 ↓ 0.0 0

Index Scan using ndx_chndiag_top_id on cln_chinesediagnosis cdia_1 (cost=0.42..346.77 rows=1 width=8) (never executed)

  • Index Cond: (ptf_topclinic_id = 603,056,867)
  • Filter: ((chinesediagnosis_desc)::text ~~ '%不孕%'::text)
47. 305.030 305.030 ↓ 0.0 0 305,030

Index Scan using ndx_vcs_visitid on cln_visitchnsyndrome vs_1 (cost=2,173.39..2,177.42 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=305,030)

  • Index Cond: (cln_visit_id = v_1.cln_visit_id)
  • Filter: ((defunct_ind = 'N'::bpchar) AND ((hashed SubPlan 10) OR ((chnsyndrome_remark)::text ~~ '%不孕%'::text) OR ((chnsyndrome_content)::text ~~ '%不孕%'::text)))
  • Buffers: shared hit=612,128
48.          

SubPlan (for Index Scan)

49. 0.000 0.000 ↓ 0.0 0

Index Scan using ndx_cln_chnsymp_topclinic_id on cln_chinesesymptom csym_1 (cost=0.42..2,173.10 rows=1 width=8) (never executed)

  • Index Cond: (ptf_topclinic_id = 603,056,867)
  • Filter: ((chinesesymptom_desc)::text ~~ '%不孕%'::text)
50. 20.680 20.680 ↓ 0.0 0 20,680

Index Scan using ndx_vvd_visitid on cln_videovisitdetails vvd (cost=0.14..4.16 rows=1 width=12) (actual time=0.001..0.001 rows=0 loops=20,680)

  • Index Cond: (v_1.cln_visit_id = cln_visit_id)
  • Buffers: shared hit=20,680
51.          

SubPlan (for Nested Loop Left Join)

52. 0.000 0.000 ↓ 0.0 0

Aggregate (cost=12.55..12.56 rows=1 width=32) (never executed)

53. 0.000 0.000 ↓ 0.0 0

Index Scan using ndx_vstcharge_vstid on cln_visitcharge vc_1 (cost=0.44..12.54 rows=1 width=5) (never executed)

  • Index Cond: (cln_visit_id = v_1.cln_visit_id)
  • Filter: (((charge_status)::text = ANY ('{CST1,CST3}'::text[])) AND ((business_type)::text = 'BTY1'::text) AND (payment_ind = 'Y
54. 51.700 2,865.214 ↓ 482.0 482 1,034

Subquery Scan on *SELECT* 2 (cost=3,192.17..3,192.25 rows=1 width=236) (actual time=0.275..2.771 rows=482 loops=1,034)

  • Buffers: shared hit=189,100
55. 2,371.987 2,813.514 ↓ 482.0 482 1,034

GroupAggregate (cost=3,192.17..3,192.24 rows=1 width=240) (actual time=0.274..2.721 rows=482 loops=1,034)

  • Group Key: v_2.cln_visit_id, (to_char(v_2.visit_datetime, 'yyyy-MM-dd'::text)), (to_char(vc.charged_datetime, 'yyyy-MM-dd'::text)), vvd_1.visit_time
  • Buffers: shared hit=189,100
56.          

Initplan (for GroupAggregate)

57. 0.009 0.009 ↑ 1.0 1 1

Index Scan using ndx_clndoc_userid on cln_doctor c_2 (cost=0.29..4.31 rows=1 width=8) (actual time=0.008..0.009 rows=1 loops=1)

  • Index Cond: (cln_user_id = '6030580170001'::bigint)
  • Filter: (defunct_ind = 'N'::bpchar)
  • Buffers: shared hit=4
58. 173.093 441.518 ↓ 2,632.0 2,632 1,034

Sort (cost=3,187.86..3,187.86 rows=1 width=116) (actual time=0.262..0.427 rows=2,632 loops=1,034)

  • Sort Key: v_2.cln_visit_id, (to_char(v_2.visit_datetime, 'yyyy-MM-dd'::text)), (to_char(vc.charged_datetime, 'yyyy-MM-dd'::text)), vvd_1.visit_time
  • Sort Method: quicksort Memory: 467kB
  • Buffers: shared hit=189,100
59. 3.426 268.425 ↓ 2,632.0 2,632 1

Nested Loop (cost=1,319.89..3,187.85 rows=1 width=116) (actual time=33.039..268.425 rows=2,632 loops=1)

  • Buffers: shared hit=189,100
60. 0.000 250.523 ↓ 1,034.0 1,034 1

Nested Loop Left Join (cost=1,319.45..3,175.08 rows=1 width=25) (actual time=14.489..250.523 rows=1,034 loops=1)

  • Buffers: shared hit=183,222
61. 91.264 249.523 ↓ 1,034.0 1,034 1

Bitmap Heap Scan on cln_visit v_2 (cost=1,319.31..3,170.91 rows=1 width=21) (actual time=14.485..249.523 rows=1,034 loops=1)

  • Recheck Cond: ((see_doctor_id = $13) AND (ptf_clinic_id = 603,057,984) AND (ptf_topclinic_id = 603,056,867))
  • Filter: (((visit_type)::text <> ALL ('{VTY4,VTY6,VTY7,VTY3,VTY8}'::text[])) AND (((visit_status)::text >= 'VST3'::text) OR (((visit_status)::text >= 'VST1'::text) AND ((visit_type)::text = 'VTY9'::text))) AND (SubPlan 17))
  • Rows Removed by Filter: 21,317
  • Heap Blocks: exact=19,297
  • Buffers: shared hit=182,188
62. 1.310 11.322 ↓ 0.0 0 1

BitmapAnd (cost=1,319.31..1,319.31 rows=1 width=0) (actual time=11.322..11.322 rows=0 loops=1)

  • Buffers: shared hit=509
63. 2.661 2.661 ↓ 17.6 22,522 1

Bitmap Index Scan on ndx_vst_seedocid (cost=0.00..20.05 rows=1,283 width=0) (actual time=2.661..2.661 rows=22,522 loops=1)

  • Index Cond: (see_doctor_id = $13)
  • Buffers: shared hit=125
64. 4.015 4.015 ↑ 1.0 34,757 1

Bitmap Index Scan on ndx_vst_clinicid (cost=0.00..534.38 rows=35,993 width=0) (actual time=4.015..4.015 rows=34,757 loops=1)

  • Index Cond: (ptf_clinic_id = 603,057,984)
  • Buffers: shared hit=135
65. 3.336 3.336 ↑ 1.0 34,757 1

Bitmap Index Scan on ndx_vst_topclinicid_vstdt (cost=0.00..764.38 rows=35,993 width=0) (actual time=3.336..3.336 rows=34,757 loops=1)

  • Index Cond: (ptf_topclinic_id = 603,056,867)
  • Buffers: shared hit=249
66.          

SubPlan (for Bitmap Heap Scan)

67. 0.000 146.937 ↓ 0.0 0 20,991

Append (cost=1,005.38..3,537.96 rows=3 width=4) (actual time=0.007..0.007 rows=0 loops=20,991)

  • Buffers: shared hit=162,382
68. 125.319 125.946 ↓ 0.0 0 20,991

Index Scan using ndx_vstdiag_vstid on cln_visitdiagnosis vd_2 (cost=1,005.38..1,009.40 rows=1 width=4) (actual time=0.006..0.006 rows=0 loops=20,991)

  • Index Cond: (cln_visit_id = v_2.cln_visit_id)
  • Filter: ((defunct_ind = 'N'::bpchar) AND ((hashed SubPlan 14) OR ((diagnosis_remark)::text ~~ '%不孕%'::text)))
  • Rows Removed by Filter: 1
  • Buffers: shared hit=82,490
69.          

SubPlan (for Index Scan)

70. 0.627 0.627 ↑ 1.0 1 1

Index Scan using ndx_clndns_clnid on cln_diagnosis dia_2 (cost=0.43..1,004.95 rows=1 width=8) (actual time=0.588..0.627 rows=1 loops=1)

  • Index Cond: (ptf_topclinic_id = 603,056,867)
  • Filter: ((diagnosis_desc)::text ~~ '%不孕%'::text)
  • Rows Removed by Filter: 3,470
  • Buffers: shared hit=87
71. 19.957 19.957 ↓ 0.0 0 19,957

Index Scan using ndx_vcd_visitid on cln_visitchndisease vcd_2 (cost=347.06..351.09 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=19,957)

  • Index Cond: (cln_visit_id = v_2.cln_visit_id)
  • Filter: ((defunct_ind = 'N'::bpchar) AND ((hashed SubPlan 15) OR ((chndisease_remark)::text ~~ '%不孕%'::text) OR ((chndisease_content)::text ~~ '%不孕%'::text)))
  • Buffers: shared hit=39,957
72.          

SubPlan (for Index Scan)

73. 0.000 0.000 ↓ 0.0 0

Index Scan using ndx_chndiag_top_id on cln_chinesediagnosis cdia_2 (cost=0.42..346.77 rows=1 width=8) (never executed)

  • Index Cond: (ptf_topclinic_id = 603,056,867)
  • Filter: ((chinesediagnosis_desc)::text ~~ '%不孕%'::text)
74. 19.957 19.957 ↓ 0.0 0 19,957

Index Scan using ndx_vcs_visitid on cln_visitchnsyndrome vs_2 (cost=2,173.39..2,177.42 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=19,957)

  • Index Cond: (cln_visit_id = v_2.cln_visit_id)
  • Filter: ((defunct_ind = 'N'::bpchar) AND ((hashed SubPlan 16) OR ((chnsyndrome_remark)::text ~~ '%不孕%'::text) OR ((chnsyndrome_content)::text ~~ '%不孕%'::text)))
  • Buffers: shared hit=39,935
75.          

SubPlan (for Index Scan)

76. 0.000 0.000 ↓ 0.0 0

Index Scan using ndx_cln_chnsymp_topclinic_id on cln_chinesesymptom csym_2 (cost=0.42..2,173.10 rows=1 width=8) (never executed)

  • Index Cond: (ptf_topclinic_id = 603,056,867)
  • Filter: ((chinesesymptom_desc)::text ~~ '%不孕%'::text)
77. 1.034 1.034 ↓ 0.0 0 1,034

Index Scan using ndx_vvd_visitid on cln_videovisitdetails vvd_1 (cost=0.14..4.16 rows=1 width=12) (actual time=0.001..0.001 rows=0 loops=1,034)

  • Index Cond: (v_2.cln_visit_id = cln_visit_id)
  • Buffers: shared hit=1,034
78. 14.476 14.476 ↓ 3.0 3 1,034

Index Scan using ndx_vstcharge_vstid on cln_visitcharge vc (cost=0.44..12.75 rows=1 width=51) (actual time=0.012..0.014 rows=3 loops=1,034)

  • Index Cond: (cln_visit_id = v_2.cln_visit_id)
  • Filter: ((charged_datetime >= '2020-01-01 00:00:00'::timestamp without time zone) AND (charged_datetime < '2020-10-16 00:00:00'::timestamp without time zone) AND (payment_ind = 'Y'::bpchar) AND (data_top_id = 603,056,867))
  • Rows Removed by Filter: 3
  • Buffers: shared hit=5,878
Planning time : 9.593 ms
Execution time : 206,794.590 ms