explain.depesz.com

PostgreSQL's explain analyze made readable

Result: LWcD

Settings
# exclusive inclusive rows x rows loops node
1. 0.089 3.195 ↑ 1.0 500 1

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

2. 2.053 3.106 ↑ 1.1 500 1

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

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

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

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

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

5. 0.335 0.600 ↑ 1.0 683 1

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

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

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

Planning time : 0.280 ms
Execution time : 3.411 ms