explain.depesz.com

PostgreSQL's explain analyze made readable

Result: J1zE

Settings
# exclusive inclusive rows x rows loops node
1. 0.012 39.948 ↑ 1.0 1 1

Nested Loop (cost=5.59..6,009.57 rows=1 width=29) (actual time=6.000..39.948 rows=1 loops=1)

2. 0.015 38.854 ↑ 1.0 1 1

Nested Loop (cost=5.02..3,288.34 rows=1 width=29) (actual time=4.911..38.854 rows=1 loops=1)

3. 19.869 33.615 ↑ 1.0 1 1

Hash Join (cost=4.45..3,281.75 rows=1 width=19) (actual time=2.131..33.615 rows=1 loops=1)

  • Hash Cond: (op.operation_details_id = od.operation_details_id)
4. 13.688 13.688 ↑ 1.0 157,013 1

Seq Scan on operation_procedures op (cost=0.00..2,865.13 rows=157,013 width=17) (actual time=0.017..13.688 rows=157,013 loops=1)

5. 0.015 0.058 ↑ 1.0 1 1

Hash (cost=4.44..4.44 rows=1 width=6) (actual time=0.058..0.058 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
6. 0.043 0.043 ↑ 1.0 1 1

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

  • Index Cond: ((patient_id)::text = 'A13I16000000033'::text)
7. 5.224 5.224 ↑ 1.0 1 1

Index Scan using bac_activity_id_index on bill_activity_charge bac (cost=0.57..6.58 rows=1 width=18) (actual time=2.768..5.224 rows=1 loops=1)

  • Index Cond: ((activity_id)::text = (op.prescribed_id)::text)
  • Filter: ((activity_code)::text = 'OPE'::text)
  • Rows Removed by Filter: 6
8. 1.082 1.082 ↑ 33.0 1 1

Index Scan using bill_charge_charge_ref_index on bill_charge bc (cost=0.56..2,720.90 rows=33 width=11) (actual time=1.078..1.082 rows=1 loops=1)

  • Index Cond: ((charge_ref)::text = (bac.charge_id)::text)
  • Filter: ((charge_head)::text = 'SACOPE'::text)
  • Rows Removed by Filter: 1
Planning time : 3.341 ms
Execution time : 40.091 ms