explain.depesz.com

PostgreSQL's explain analyze made readable

Result: x0b

Settings
# exclusive inclusive rows x rows loops node
1. 140.243 1,009.740 ↑ 1,220.9 36 1

HashAggregate (cost=27,051.23..27,490.75 rows=43,952 width=30) (actual time=1,009.617..1,009.740 rows=36 loops=1)

  • Group Key: x2.x3, (x2.x4 IS NOT NULL), x2.x5, (x2.x6 IS NOT NULL)
2. 188.676 869.497 ↓ 1.0 110,192 1

Subquery Scan on x2 (cost=17,162.03..25,677.73 rows=109,880 width=22) (actual time=365.726..869.497 rows=110,192 loops=1)

3. 198.895 680.821 ↓ 1.0 110,192 1

Unique (cost=17,162.03..24,578.93 rows=109,880 width=321) (actual time=365.723..680.821 rows=110,192 loops=1)

4. 306.934 481.926 ↓ 1.0 110,192 1

Sort (cost=17,162.03..17,436.73 rows=109,880 width=321) (actual time=365.720..481.926 rows=110,192 loops=1)

  • Sort Key: bills."patientId", bills."apptId", bills."insuranceCoverageId", bills."secondaryInsuranceCoverageId", bills.status, bills.titl, bills."time", bills."statusTime", bills."serviceDate", 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", bills.id
  • Sort Method: quicksort Memory: 42715kB
5. 174.992 174.992 ↓ 1.0 110,192 1

Seq Scan on bills (cost=0.00..7,962.01 rows=109,880 width=321) (actual time=0.033..174.992 rows=110,192 loops=1)

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