explain.depesz.com

PostgreSQL's explain analyze made readable

Result: IauU

Settings
# exclusive inclusive rows x rows loops node
1. 258.321 1,876.600 ↓ 1.0 110,186 1

Unique (cost=17,161.16..24,577.52 rows=109,872 width=321) (actual time=1,488.440..1,876.600 rows=110,186 loops=1)

2. 1,341.642 1,618.279 ↓ 1.0 110,186 1

Sort (cost=17,161.16..17,435.84 rows=109,872 width=321) (actual time=1,488.430..1,618.279 rows=110,186 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: 42717kB
3. 276.637 276.637 ↓ 1.0 110,186 1

Seq Scan on bills (cost=0.00..7,961.88 rows=109,872 width=321) (actual time=0.025..276.637 rows=110,186 loops=1)

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