explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jZQc

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 0.225 ↑ 1.0 1 1

Nested Loop (cost=1.84..495.80 rows=1 width=29) (actual time=0.158..0.225 rows=1 loops=1)

2. 0.001 0.097 ↑ 1.0 1 1

Nested Loop (cost=1.27..13.35 rows=1 width=33) (actual time=0.095..0.097 rows=1 loops=1)

3. 0.006 0.068 ↑ 1.0 1 1

Nested Loop (cost=0.84..8.89 rows=1 width=35) (actual time=0.066..0.068 rows=1 loops=1)

4. 0.029 0.029 ↑ 1.0 1 1

Index Scan using opd_patient_id_idx on operation_details od (cost=0.42..4.44 rows=1 width=22) (actual time=0.029..0.029 rows=1 loops=1)

  • Index Cond: ((patient_id)::text = 'A13I16000000033'::text)
5. 0.033 0.033 ↑ 1.0 1 1

Index Scan using idx_operation_procedures_operation_details_id on operation_procedures op (cost=0.42..4.44 rows=1 width=17) (actual time=0.033..0.033 rows=1 loops=1)

  • Index Cond: (operation_details_id = od.operation_details_id)
  • Filter: ((oper_priority)::text = 'P'::text)
6. 0.028 0.028 ↑ 1.0 1 1

Index Scan using bill_visit_id_idx on bill b (cost=0.43..4.45 rows=1 width=29) (actual time=0.027..0.028 rows=1 loops=1)

  • Index Cond: ((visit_id)::text = 'A13I16000000033'::text)
7. 0.125 0.125 ↑ 1.0 1 1

Index Scan using bill_charge_bill_no_index on bill_charge bc (cost=0.56..482.44 rows=1 width=24) (actual time=0.062..0.125 rows=1 loops=1)

  • Index Cond: ((bill_no)::text = (b.bill_no)::text)
  • Filter: (((charge_head)::text = 'SACOPE'::text) AND ((charge_group)::text = 'OPE'::text) AND ((is_secondary_operation_item)::text = 'N'::text))
  • Rows Removed by Filter: 36
Planning time : 2.057 ms
Execution time : 0.304 ms