explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4IviZ

Settings
# exclusive inclusive rows x rows loops node
1. 144.531 1,018.295 ↑ 1,220.9 36 1

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

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

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

3. 203.301 680.485 ↓ 1.0 110,192 1

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

4. 322.064 477.184 ↓ 1.0 110,192 1

Sort (cost=17,162.03..17,436.73 rows=109,880 width=321) (actual time=357.193..477.184 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. 155.120 155.120 ↓ 1.0 110,192 1

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

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