explain.depesz.com

PostgreSQL's explain analyze made readable

Result: weXC

Settings
# exclusive inclusive rows x rows loops node
1. 0.079 3.427 ↑ 1.0 500 1

Limit (cost=99.39..100.64 rows=500 width=570) (actual time=3.172..3.427 rows=500 loops=1)

2. 1.726 3.348 ↑ 1.1 500 1

Sort (cost=99.39..100.73 rows=536 width=570) (actual time=3.172..3.348 rows=500 loops=1)

  • Sort Key: t0_.name DESC
  • Sort Method: quicksort Memory: 456kB
3. 0.478 1.622 ↑ 1.0 536 1

Hash Join (cost=59.37..75.10 rows=536 width=570) (actual time=1.096..1.622 rows=536 loops=1)

  • Hash Cond: (t7_.organization_id = t0_.id)
4. 0.093 0.093 ↑ 1.0 536 1

Seq Scan on tbl_organization_types t7_ (cost=0.00..8.36 rows=536 width=8) (actual time=0.008..0.093 rows=536 loops=1)

5. 0.639 1.051 ↑ 1.0 683 1

Hash (cost=50.83..50.83 rows=683 width=570) (actual time=1.051..1.051 rows=683 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 339kB
6. 0.412 0.412 ↑ 1.0 683 1

Seq Scan on tbl_organizations t0_ (cost=0.00..50.83 rows=683 width=570) (actual time=0.007..0.412 rows=683 loops=1)

Planning time : 0.425 ms
Execution time : 3.578 ms