explain.depesz.com

PostgreSQL's explain analyze made readable

Result: pyG

Settings
# exclusive inclusive rows x rows loops node
1. 210.394 693.507 ↓ 1.0 110,188 1

Unique (cost=17,161.59..24,578.22 rows=109,876 width=321) (actual time=367.687..693.507 rows=110,188 loops=1)

2. 304.012 483.113 ↓ 1.0 110,188 1

Sort (cost=17,161.59..17,436.28 rows=109,876 width=321) (actual time=367.684..483.113 rows=110,188 loops=1)

  • Sort Key: "patientId", "apptId", "insuranceCoverageId", "secondaryInsuranceCoverageId", status, titl, "time", "statusTime", "serviceDate", "serviceTime", "locationId", due, "claimSentTime", "eligibleReferenceId", "paymentScheduledFor", "invoiceSentTime", reasons, "preferredPaymentMethodId", "failedAttempts", "externalId", "payerControlNumber", reviewed, "reviewedBy", "syncFailedReason", "createdAt", id
  • Sort Method: quicksort Memory: 42717kB
3. 179.101 179.101 ↓ 1.0 110,188 1

Seq Scan on bills (cost=0.00..7,961.94 rows=109,876 width=321) (actual time=0.057..179.101 rows=110,188 loops=1)

  • Filter: ("practiceId" = '5bdaef44-8ff0-439f-99d7-3285afcc6911'::uuid)
  • Rows Removed by Filter: 43887
Planning time : 0.227 ms
Execution time : 779.765 ms