explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Do3e

Settings
# exclusive inclusive rows x rows loops node
1. 286.295 2,150.319 ↓ 1.0 110,188 1

Unique (cost=17,161.49..24,578.05 rows=109,875 width=321) (actual time=1,727.250..2,150.319 rows=110,188 loops=1)

2. 1,628.236 1,864.024 ↓ 1.0 110,188 1

Sort (cost=17,161.49..17,436.17 rows=109,875 width=321) (actual time=1,727.247..1,864.024 rows=110,188 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. 235.788 235.788 ↓ 1.0 110,188 1

Seq Scan on bills (cost=0.00..7,961.93 rows=109,875 width=321) (actual time=0.034..235.788 rows=110,188 loops=1)

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