explain.depesz.com

PostgreSQL's explain analyze made readable

Result: edu7

Settings
# exclusive inclusive rows x rows loops node
1. 0.133 28.697 ↑ 1.0 500 1

Limit (cost=6,745.31..6,746.56 rows=500 width=144) (actual time=28.621..28.697 rows=500 loops=1)

2. 13.612 28.564 ↑ 28.9 2,500 1

Sort (cost=6,740.31..6,921.18 rows=72,348 width=144) (actual time=28.392..28.564 rows=2,500 loops=1)

  • Sort Key: role_id, expires_by
  • Sort Method: top-N heapsort Memory: 857kB
3. 14.952 14.952 ↑ 1.0 72,348 1

Seq Scan on role_assignment (cost=0.00..2,295.35 rows=72,348 width=144) (actual time=0.011..14.952 rows=72,348 loops=1)

  • Filter: (organization_id = '05abe52f-b269-4fb7-9c5d-be99058f0bb6'::uuid)
  • Rows Removed by Filter: 1
Planning time : 0.108 ms
Execution time : 28.745 ms