explain.depesz.com

PostgreSQL's explain analyze made readable

Result: WJvD

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

Sort (cost=18,535.04..18,809.73 rows=109,876 width=321) (actual time=2,195.710..2,341.803 rows=110,188 loops=1)

  • Sort Key: "serviceDate", id
  • Sort Method: quicksort Memory: 42717kB
2. 345.113 515.715 ↓ 1.0 110,188 1

HashAggregate (cost=8,236.63..9,335.39 rows=109,876 width=321) (actual time=343.326..515.715 rows=110,188 loops=1)

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

Seq Scan on bills (cost=0.00..7,961.94 rows=109,876 width=321) (actual time=0.021..170.602 rows=110,188 loops=1)

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