explain.depesz.com

PostgreSQL's explain analyze made readable

Result: cwDn

Settings
# exclusive inclusive rows x rows loops node
1. 69.333 371.181 ↓ 1.5 34,523 1

Unique (cost=8,129.65..9,726.16 rows=23,652 width=320) (actual time=266.102..371.181 rows=34,523 loops=1)

2. 251.481 301.848 ↓ 1.5 34,523 1

Sort (cost=8,129.65..8,188.78 rows=23,652 width=320) (actual time=266.100..301.848 rows=34,523 loops=1)

  • Sort Key: "serviceDate", id, "patientId", "apptId", "insuranceCoverageId", "secondaryInsuranceCoverageId", status, titl, "time", "statusTime", "serviceTime", "locationId", due, "claimSentTime", "eligibleReferenceId", "paymentScheduledFor", "invoiceSentTime", reasons, "preferredPaymentMethodId", "failedAttempts", "externalId", "payerControlNumber", reviewed, "reviewedBy", "syncFailedReason", "createdAt
  • Sort Method: quicksort Memory: 11304kB
3. 46.053 50.367 ↓ 1.5 34,523 1

Bitmap Heap Scan on bills (cost=563.72..6,411.37 rows=23,652 width=320) (actual time=4.871..50.367 rows=34,523 loops=1)

  • Recheck Cond: ("practiceId" = '5bdaef44-8ff0-439f-99d7-3285afcc6911'::uuid)
  • Heap Blocks: exact=2829
4. 4.314 4.314 ↓ 1.5 34,525 1

Bitmap Index Scan on "bills_practiceId_idx" (cost=0.00..557.81 rows=23,652 width=0) (actual time=4.313..4.314 rows=34,525 loops=1)

  • Index Cond: ("practiceId" = '5bdaef44-8ff0-439f-99d7-3285afcc6911'::uuid)
Planning time : 0.199 ms
Execution time : 398.949 ms