explain.depesz.com

PostgreSQL's explain analyze made readable

Result: RD7T

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

Unique (cost=681.93..682.20 rows=4 width=320) (actual time=0.079..0.080 rows=0 loops=1)

2. 0.062 0.078 ↓ 0.0 0 1

Sort (cost=681.93..681.94 rows=4 width=320) (actual time=0.078..0.078 rows=0 loops=1)

  • Sort Key: bills."serviceDate", bills.id, bills."patientId", bills."apptId", bills."insuranceCoverageId", bills."secondaryInsuranceCoverageId", bills.status, bills.titl, bills."time", bills."statusTime", bills."serviceTime", bills."locationId", bills.due, bills."claimSentTime", bills."eligibleReferenceId", bills."paymentScheduledFor", bills."invoiceSentTime", bills.reasons, bills."preferredPaymentMethodId", bills."failedAttempts", bills."externalId", bills."payerControlNumber", bills.reviewed, bills."reviewedBy", bills."syncFailedReason", bills."createdAt
  • Sort Method: quicksort Memory: 25kB
3. 0.003 0.016 ↓ 0.0 0 1

Nested Loop (cost=0.84..681.89 rows=4 width=320) (actual time=0.015..0.016 rows=0 loops=1)

4. 0.013 0.013 ↓ 0.0 0 1

Index Scan using "apptSpecialtyIdx" on appts (cost=0.42..51.69 rows=76 width=16) (actual time=0.013..0.013 rows=0 loops=1)

  • Index Cond: ("specialtyId" = 'af4efea1-4c00-41db-b8cb-65f6a288e831'::uuid)
5. 0.000 0.000 ↓ 0.0 0

Index Scan using "billToApptFkIdx" on bills (cost=0.42..8.28 rows=1 width=320) (never executed)

  • Index Cond: ("apptId" = appts.id)
  • Filter: ("practiceId" = '5bdaef44-8ff0-439f-99d7-3285afcc6911'::uuid)
Planning time : 1.955 ms
Execution time : 0.190 ms