explain.depesz.com

PostgreSQL's explain analyze made readable

Result: QgFQ

Settings
# exclusive inclusive rows x rows loops node
1. 138.172 990.672 ↑ 1,220.9 36 1

HashAggregate (cost=27,050.43..27,489.95 rows=43,952 width=30) (actual time=990.569..990.672 rows=36 loops=1)

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

Subquery Scan on x2 (cost=17,161.59..25,676.98 rows=109,876 width=22) (actual time=358.356..852.500 rows=110,192 loops=1)

3. 194.167 667.762 ↓ 1.0 110,192 1

Unique (cost=17,161.59..24,578.22 rows=109,876 width=321) (actual time=358.352..667.762 rows=110,192 loops=1)

4. 304.435 473.595 ↓ 1.0 110,192 1

Sort (cost=17,161.59..17,436.28 rows=109,876 width=321) (actual time=358.347..473.595 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: 42716kB
5. 169.160 169.160 ↓ 1.0 110,192 1

Seq Scan on bills (cost=0.00..7,961.94 rows=109,876 width=321) (actual time=0.022..169.160 rows=110,192 loops=1)

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