explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jpN

Settings
# exclusive inclusive rows x rows loops node
1. 0.008 78.411 ↑ 1.0 1 1

Nested Loop (cost=5.45..4,111.98 rows=1 width=29) (actual time=13.523..78.411 rows=1 loops=1)

2. 0.004 69.503 ↑ 1.0 1 1

Nested Loop (cost=4.88..3,629.53 rows=1 width=33) (actual time=6.493..69.503 rows=1 loops=1)

3. 12.386 68.645 ↑ 1.0 1 1

Hash Join (cost=4.45..3,625.07 rows=1 width=35) (actual time=5.637..68.645 rows=1 loops=1)

  • Hash Cond: (op.operation_details_id = od.operation_details_id)
4. 54.380 54.380 ↓ 1.0 138,414 1

Seq Scan on operation_procedures op (cost=0.00..3,257.66 rows=138,266 width=17) (actual time=0.589..54.380 rows=138,414 loops=1)

  • Filter: ((oper_priority)::text = 'P'::text)
  • Rows Removed by Filter: 18599
5. 0.006 1.879 ↑ 1.0 1 1

Hash (cost=4.44..4.44 rows=1 width=22) (actual time=1.879..1.879 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
6. 1.873 1.873 ↑ 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=1.872..1.873 rows=1 loops=1)

  • Index Cond: ((patient_id)::text = 'A13I16000000033'::text)
7. 0.854 0.854 ↑ 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.853..0.854 rows=1 loops=1)

  • Index Cond: ((visit_id)::text = 'A13I16000000033'::text)
8. 8.900 8.900 ↑ 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=7.024..8.900 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 : 13.939 ms
Execution time : 78.519 ms