explain.depesz.com

PostgreSQL's explain analyze made readable

Result: x3HQ

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.088 ↓ 0.0 0 1

Nested Loop (cost=5.59..6,167.40 rows=1 width=29) (actual time=0.088..0.088 rows=0 loops=1)

2. 0.000 0.087 ↓ 0.0 0 1

Nested Loop (cost=5.02..3,631.48 rows=1 width=29) (actual time=0.087..0.087 rows=0 loops=1)

3. 0.029 0.087 ↓ 0.0 0 1

Hash Join (cost=4.45..3,625.39 rows=1 width=19) (actual time=0.086..0.087 rows=0 loops=1)

  • Hash Cond: (op.operation_details_id = od.operation_details_id)
4. 0.015 0.015 ↑ 138,377.0 1 1

Seq Scan on operation_procedures op (cost=0.00..3,257.69 rows=138,377 width=17) (actual time=0.015..0.015 rows=1 loops=1)

  • Filter: ((oper_priority)::text = 'P'::text)
5. 0.001 0.043 ↓ 0.0 0 1

Hash (cost=4.44..4.44 rows=1 width=6) (actual time=0.042..0.043 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
6. 0.042 0.042 ↓ 0.0 0 1

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

  • Index Cond: ((patient_id)::text = 'A13O20030000030'::text)
7. 0.000 0.000 ↓ 0.0 0

Index Scan using bac_activity_id_index on bill_activity_charge bac (cost=0.57..6.08 rows=1 width=18) (never executed)

  • Index Cond: ((activity_id)::text = (op.prescribed_id)::text)
  • Filter: ((activity_code)::text = 'OPE'::text)
8. 0.000 0.000 ↓ 0.0 0

Index Scan using bill_charge_charge_ref_index on bill_charge bc (cost=0.56..2,535.76 rows=15 width=11) (never executed)

  • Index Cond: ((charge_ref)::text = (bac.charge_id)::text)
  • Filter: (((charge_head)::text = 'SACOPE'::text) AND ((is_secondary_operation_item)::text = 'N'::text))
Planning time : 1.509 ms
Execution time : 0.233 ms