explain.depesz.com

PostgreSQL's explain analyze made readable

Result: n5LM

Settings
# exclusive inclusive rows x rows loops node
1. 0.007 0.156 ↑ 1.0 23 1

Limit (cost=34.01..34.07 rows=23 width=570) (actual time=0.147..0.156 rows=23 loops=1)

2. 0.045 0.149 ↑ 1.0 23 1

Sort (cost=34.01..34.07 rows=23 width=570) (actual time=0.146..0.149 rows=23 loops=1)

  • Sort Key: t0_.name DESC
  • Sort Method: quicksort Memory: 43kB
3. 0.025 0.104 ↑ 1.0 23 1

Nested Loop (cost=0.28..33.49 rows=23 width=570) (actual time=0.021..0.104 rows=23 loops=1)

4. 0.010 0.010 ↑ 1.0 23 1

Seq Scan on tbl_organization_responsibles t9_ (cost=0.00..1.23 rows=23 width=8) (actual time=0.008..0.010 rows=23 loops=1)

5. 0.069 0.069 ↑ 1.0 1 23

Index Scan using idx_16680_primary on tbl_organizations t0_ (cost=0.28..1.39 rows=1 width=570) (actual time=0.002..0.003 rows=1 loops=23)

  • Index Cond: (id = t9_.organization_id)
Planning time : 0.210 ms
Execution time : 0.212 ms