explain.depesz.com

PostgreSQL's explain analyze made readable

Result: HvG6

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 0.644 ↓ 2.7 8 1

Limit (cost=10.71..10.72 rows=3 width=567) (actual time=0.638..0.644 rows=8 loops=1)

2. 0.040 0.642 ↓ 2.7 8 1

Sort (cost=10.71..10.72 rows=3 width=567) (actual time=0.637..0.642 rows=8 loops=1)

  • Sort Key: t0_.name
  • Sort Method: quicksort Memory: 27kB
3. 0.007 0.602 ↓ 2.7 8 1

Nested Loop Left Join (cost=1.75..10.69 rows=3 width=567) (actual time=0.519..0.602 rows=8 loops=1)

4. 0.021 0.046 ↑ 1.0 3 1

Hash Join (cost=1.07..2.22 rows=3 width=8) (actual time=0.038..0.046 rows=3 loops=1)

  • Hash Cond: (t8_.id = t9_.user_id)
5. 0.014 0.014 ↑ 1.0 9 1

Seq Scan on tbl_users t8_ (cost=0.00..1.09 rows=9 width=8) (actual time=0.011..0.014 rows=9 loops=1)

6. 0.004 0.011 ↑ 1.0 3 1

Hash (cost=1.03..1.03 rows=3 width=16) (actual time=0.011..0.011 rows=3 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
7. 0.007 0.007 ↑ 1.0 3 1

Seq Scan on tbl_organization_responsibles t9_ (cost=0.00..1.03 rows=3 width=16) (actual time=0.005..0.007 rows=3 loops=1)

8. 0.007 0.549 ↓ 3.0 3 3

Nested Loop (cost=0.69..2.81 rows=1 width=567) (actual time=0.170..0.183 rows=3 loops=3)

9. 0.006 0.510 ↓ 3.0 3 3

Nested Loop (cost=0.55..2.45 rows=1 width=575) (actual time=0.161..0.170 rows=3 loops=3)

10. 0.010 0.489 ↓ 2.0 2 3

Nested Loop Left Join (cost=0.42..2.18 rows=1 width=567) (actual time=0.157..0.163 rows=2 loops=3)

11. 0.009 0.399 ↓ 2.0 2 3

Nested Loop Left Join (cost=0.28..1.89 rows=1 width=567) (actual time=0.131..0.133 rows=2 loops=3)

12. 0.015 0.015 ↑ 1.0 1 3

Index Scan using idx_16680_primary on tbl_organizations t0_ (cost=0.14..1.62 rows=1 width=567) (actual time=0.005..0.005 rows=1 loops=3)

  • Index Cond: (id = t9_.organization_id)
13. 0.375 0.375 ↓ 2.0 2 3

Index Only Scan using organization_country_unique_idx on tbl_organization_countries t3_ (cost=0.14..0.26 rows=1 width=16) (actual time=0.124..0.125 rows=2 loops=3)

  • Index Cond: (organization_id = t0_.id)
  • Heap Fetches: 8
14. 0.080 0.080 ↑ 2.0 1 5

Index Only Scan using organization_sector_unique_idx on tbl_organization_sectors t5_ (cost=0.14..0.28 rows=2 width=8) (actual time=0.015..0.016 rows=1 loops=5)

  • Index Cond: (organization_id = t0_.id)
  • Heap Fetches: 5
15. 0.015 0.015 ↓ 2.0 2 5

Index Scan using idx_16705_organization_id on tbl_organization_types t7_ (cost=0.14..0.25 rows=1 width=16) (actual time=0.002..0.003 rows=2 loops=5)

  • Index Cond: (organization_id = t0_.id)
16. 0.032 0.032 ↑ 1.0 1 8

Index Only Scan using idx_16528_primary on tbl_dictionary_organization_type t6_ (cost=0.13..0.36 rows=1 width=8) (actual time=0.004..0.004 rows=1 loops=8)

  • Index Cond: (id = t7_.organization_type_id)
  • Heap Fetches: 8
Planning time : 2.478 ms
Execution time : 0.857 ms