explain.depesz.com

PostgreSQL's explain analyze made readable

Result: FXIl

Settings
# exclusive inclusive rows x rows loops node
1. 137.728 710.875 ↑ 1,220.9 36 1

HashAggregate (cost=11,807.81..12,247.33 rows=43,952 width=30) (actual time=710.777..710.875 rows=36 loops=1)

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

Subquery Scan on x2 (cost=8,236.71..10,434.31 rows=109,880 width=22) (actual time=269.194..573.147 rows=110,192 loops=1)

3. 264.641 406.554 ↓ 1.0 110,192 1

HashAggregate (cost=8,236.71..9,335.51 rows=109,880 width=404) (actual time=269.192..406.554 rows=110,192 loops=1)

  • Group Key: bills.id
4. 141.913 141.913 ↓ 1.0 110,192 1

Seq Scan on bills (cost=0.00..7,962.01 rows=109,880 width=60) (actual time=0.011..141.913 rows=110,192 loops=1)

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