explain.depesz.com

PostgreSQL's explain analyze made readable

Result: WlB

Settings
# exclusive inclusive rows x rows loops node
1. 0.010 0.315 ↓ 3.0 3 1

Nested Loop (cost=1.97..9,669.44 rows=1 width=29) (actual time=0.145..0.315 rows=3 loops=1)

2. 0.013 0.194 ↓ 3.0 3 1

Nested Loop (cost=1.41..26.08 rows=1 width=29) (actual time=0.100..0.194 rows=3 loops=1)

3. 0.009 0.073 ↓ 3.0 3 1

Nested Loop (cost=0.84..16.89 rows=1 width=19) (actual time=0.054..0.073 rows=3 loops=1)

4. 0.037 0.037 ↓ 3.0 3 1

Index Scan using opd_patient_id_idx on operation_details od (cost=0.42..8.44 rows=1 width=6) (actual time=0.034..0.037 rows=3 loops=1)

  • Index Cond: ((patient_id)::text = 'A13O20030000030'::text)
5. 0.027 0.027 ↑ 1.0 1 3

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

  • Index Cond: (operation_details_id = od.operation_details_id)
  • Filter: ((oper_priority)::text = 'P'::text)
  • Rows Removed by Filter: 0
6. 0.108 0.108 ↑ 1.0 1 3

Index Scan using bac_activity_id_index on bill_activity_charge bac (cost=0.57..9.18 rows=1 width=18) (actual time=0.025..0.036 rows=1 loops=3)

  • Index Cond: ((activity_id)::text = (op.prescribed_id)::text)
  • Filter: ((activity_code)::text = 'OPE'::text)
  • Rows Removed by Filter: 5
7. 0.111 0.111 ↑ 13.0 1 3

Index Scan using bill_charge_charge_ref_index on bill_charge bc (cost=0.56..9,643.23 rows=13 width=11) (actual time=0.033..0.037 rows=1 loops=3)

  • Index Cond: ((charge_ref)::text = (bac.charge_id)::text)
  • Filter: (((charge_head)::text = 'SACOPE'::text) AND ((is_secondary_operation_item)::text = 'N'::text))
  • Rows Removed by Filter: 4
Planning time : 1.449 ms
Execution time : 0.510 ms