explain.depesz.com

PostgreSQL's explain analyze made readable

Result: SkRM

Settings
# exclusive inclusive rows x rows loops node
1. 1,276.616 1,801.238 ↓ 1.0 110,188 1

Sort (cost=18,534.92..18,809.61 rows=109,875 width=321) (actual time=1,669.772..1,801.238 rows=110,188 loops=1)

  • Sort Key: "serviceDate", id
  • Sort Method: quicksort Memory: 42,717kB
2. 337.364 524.622 ↓ 1.0 110,188 1

HashAggregate (cost=8,236.61..9,335.36 rows=109,875 width=321) (actual time=359.266..524.622 rows=110,188 loops=1)

  • Group Key: id
3. 187.258 187.258 ↓ 1.0 110,188 1

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

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