explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4jTp

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.310 ↓ 4.0 8 1

Limit (cost=11.30..11.31 rows=2 width=567) (actual time=0.308..0.310 rows=8 loops=1)

2. 0.020 0.309 ↓ 4.0 8 1

Sort (cost=11.30..11.31 rows=2 width=567) (actual time=0.307..0.309 rows=8 loops=1)

  • Sort Key: t0_.name
  • Sort Method: quicksort Memory: 27kB
3. 0.010 0.289 ↓ 4.0 8 1

Hash Join (cost=9.33..11.29 rows=2 width=567) (actual time=0.234..0.289 rows=8 loops=1)

  • Hash Cond: (t0_.id = t9_.organization_id)
4. 0.031 0.248 ↓ 2.4 41 1

Hash Join (cost=7.07..8.95 rows=17 width=575) (actual time=0.198..0.248 rows=41 loops=1)

  • Hash Cond: (t7_.organization_type_id = t6_.id)
5. 0.037 0.208 ↓ 2.4 41 1

Hash Right Join (cost=5.95..7.61 rows=17 width=583) (actual time=0.177..0.208 rows=41 loops=1)

  • Hash Cond: (t5_.organization_id = t0_.id)
6. 0.013 0.013 ↑ 1.0 35 1

Seq Scan on tbl_organization_sectors t5_ (cost=0.00..1.35 rows=35 width=8) (actual time=0.006..0.013 rows=35 loops=1)

7. 0.024 0.158 ↓ 1.2 20 1

Hash (cost=5.75..5.75 rows=16 width=583) (actual time=0.157..0.158 rows=20 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 17kB
8. 0.036 0.134 ↓ 1.2 20 1

Hash Right Join (cost=4.22..5.75 rows=16 width=583) (actual time=0.110..0.134 rows=20 loops=1)

  • Hash Cond: (t3_.organization_id = t0_.id)
9. 0.008 0.008 ↑ 1.0 29 1

Seq Scan on tbl_organization_countries t3_ (cost=0.00..1.29 rows=29 width=16) (actual time=0.006..0.008 rows=29 loops=1)

10. 0.025 0.090 ↑ 1.0 16 1

Hash (cost=4.02..4.02 rows=16 width=583) (actual time=0.090..0.090 rows=16 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 16kB
11. 0.027 0.065 ↑ 1.0 16 1

Hash Join (cost=1.36..4.02 rows=16 width=583) (actual time=0.039..0.065 rows=16 loops=1)

  • Hash Cond: (t0_.id = t7_.organization_id)
12. 0.022 0.022 ↑ 1.0 33 1

Seq Scan on tbl_organizations t0_ (cost=0.00..2.33 rows=33 width=567) (actual time=0.006..0.022 rows=33 loops=1)

13. 0.006 0.016 ↑ 1.0 16 1

Hash (cost=1.16..1.16 rows=16 width=16) (actual time=0.016..0.016 rows=16 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
14. 0.010 0.010 ↑ 1.0 16 1

Seq Scan on tbl_organization_types t7_ (cost=0.00..1.16 rows=16 width=16) (actual time=0.005..0.010 rows=16 loops=1)

15. 0.005 0.009 ↑ 1.0 5 1

Hash (cost=1.05..1.05 rows=5 width=8) (actual time=0.009..0.009 rows=5 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
16. 0.004 0.004 ↑ 1.0 5 1

Seq Scan on tbl_dictionary_organization_type t6_ (cost=0.00..1.05 rows=5 width=8) (actual time=0.004..0.004 rows=5 loops=1)

17. 0.002 0.031 ↑ 1.0 3 1

Hash (cost=2.22..2.22 rows=3 width=8) (actual time=0.031..0.031 rows=3 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
18. 0.006 0.029 ↑ 1.0 3 1

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

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

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

20. 0.003 0.007 ↑ 1.0 3 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
21. 0.004 0.004 ↑ 1.0 3 1

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

Planning time : 2.051 ms
Execution time : 0.540 ms