explain.depesz.com

PostgreSQL's explain analyze made readable

Result: e5Ev

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 56.231 ↓ 0.0 0 1

GroupAggregate (cost=5,039.76..9,499.54 rows=1 width=54) (actual time=56.231..56.231 rows=0 loops=1)

  • Group Key: bcc.claim_id
2. 0.001 56.229 ↓ 0.0 0 1

Nested Loop (cost=5,039.76..9,499.45 rows=1 width=47) (actual time=56.229..56.229 rows=0 loops=1)

3. 0.649 56.228 ↓ 0.0 0 1

Hash Join (cost=5,039.19..9,491.67 rows=1 width=18) (actual time=56.228..56.228 rows=0 loops=1)

  • Hash Cond: ((bac.activity_id)::text = (sd.prescription_id)::text)
4. 0.004 1.479 ↑ 127.0 1 1

Nested Loop (cost=1.69..1,131.98 rows=127 width=22) (actual time=0.841..1.479 rows=1 loops=1)

5. 0.013 1.379 ↑ 147.0 1 1

Nested Loop (cost=1.13..1,034.06 rows=147 width=34) (actual time=0.743..1.379 rows=1 loops=1)

6. 1.228 1.228 ↑ 77.5 2 1

Index Scan using bill_charge_claim_claim_idx on bill_charge_claim bcc (cost=0.56..320.28 rows=155 width=24) (actual time=0.667..1.228 rows=2 loops=1)

  • Index Cond: ((claim_id)::text = 'C1320000062779'::text)
7. 0.138 0.138 ↓ 0.0 0 2

Index Scan using bill_charge_pkey on bill_charge bc (cost=0.56..4.61 rows=1 width=10) (actual time=0.069..0.069 rows=0 loops=2)

  • Index Cond: ((charge_id)::text = (bcc.charge_id)::text)
  • Filter: (status <> 'X'::bpchar)
  • Rows Removed by Filter: 0
8. 0.096 0.096 ↑ 1.0 1 1

Index Scan using bac_charge_id_index on bill_activity_charge bac (cost=0.56..0.64 rows=1 width=18) (actual time=0.095..0.096 rows=1 loops=1)

  • Index Cond: ((charge_id)::text = (bc.charge_id)::text)
9. 30.794 54.100 ↑ 1.0 69,307 1

Hash (cost=2,770.56..2,770.56 rows=69,752 width=8) (actual time=54.100..54.100 rows=69,307 loops=1)

  • Buckets: 131072 Batches: 1 Memory Usage: 3732kB
10. 23.306 23.306 ↑ 1.0 69,307 1

Seq Scan on service_documents sd (cost=0.00..2,770.56 rows=69,752 width=8) (actual time=0.008..23.306 rows=69,307 loops=1)

11. 0.000 0.000 ↓ 0.0 0

Index Scan using patient_documents_docid_pkey on patient_documents pd (cost=0.56..4.17 rows=1 width=37) (never executed)

  • Index Cond: (doc_id = sd.doc_id)
  • Filter: ((doc_format)::text = 'DOC_FILEUPLOAD'::text)