explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vmrI

Settings
# exclusive inclusive rows x rows loops node
1. 5.953 15.181 ↓ 6.4 1,872 1

HashAggregate (cost=203.90..206.84 rows=294 width=947) (actual time=13.885..15.181 rows=1,872 loops=1)

  • Group Key: guardianus0_.user_id, company1_.company_id, applicatio2_.company_application_id, metadata3_.company_application_metadata_id, features4_.company_application_feature_id, area6_.area_id, colors7_.company_color_id, guardianus0_.license_begin, guardianus0_.license_end, guardianus0_.agency, guardianus0_.company_id, guardianus0_.company_admin, guardianus0_.created, guardianus0_.device_id, guardianus0_.email, guardianus0_.first_name, guardianus0_.last_login, guardianus0_.last_name, guardianus0_.modified, guardianus0_.password, guardianus0_.system_admin, guardianus0_.trial_accepted, guardianus0_.trial_accepted_date, guardianus0_.username, company1_.license_begin, company1_.license_end, company1_.created, company1_.modified, company1_.name, company1_.notes, company1_.poc_email, company1_.trial, company1_.username, company1_.website_logo, applicatio2_.license_begin, applicatio2_.license_end, applicatio2_.application_id, applicatio2_.company_id, applicatio2_.company_id, applicatio2_.company_application_id, metadata3_.company_application_id, metadata3_.metadata_key, metadata3_.metadata_value, metadata3_.company_application_id, metadata3_.company_application_metadata_id, features4_.license_begin, features4_.license_end, features4_.boundary, features4_.company_application_id, features4_.content, features4_.count, features4_.count_modified, features4_.count_username, features4_.feature_id, features4_."limit", features4_.company_application_id, features4_.company_application_feature_id, area6_.name, area6_.type, areas5_.company_application_feature_id, areas5_.area_id, colors7_.color, colors7_.company_id, colors7_.name, colors7_.company_id, colors7_.company_color_id
2. 1.259 9.228 ↓ 6.4 1,872 1

Hash Right Join (cost=135.63..155.39 rows=294 width=947) (actual time=7.983..9.228 rows=1,872 loops=1)

  • Hash Cond: (colors7_.company_id = company1_.company_id)
3. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on company_color colors7_ (cost=0.00..14.20 rows=420 width=164) (actual time=0.002..0.003 rows=0 loops=1)

4. 1.953 7.966 ↓ 13.4 1,872 1

Hash (cost=133.88..133.88 rows=140 width=751) (actual time=7.966..7.966 rows=1,872 loops=1)

  • Buckets: 2,048 (originally 1024) Batches: 1 (originally 1) Memory Usage: 939kB
5. 2.127 6.013 ↓ 13.4 1,872 1

Nested Loop Left Join (cost=9.51..133.88 rows=140 width=751) (actual time=0.115..6.013 rows=1,872 loops=1)

6. 0.972 2.014 ↓ 13.4 1,872 1

Nested Loop Left Join (cost=9.36..103.50 rows=140 width=723) (actual time=0.114..2.014 rows=1,872 loops=1)

7. 0.084 0.310 ↓ 4.1 122 1

Nested Loop Left Join (cost=9.08..16.33 rows=30 width=715) (actual time=0.106..0.310 rows=122 loops=1)

8. 0.006 0.142 ↓ 4.7 14 1

Nested Loop Left Join (cost=8.80..12.81 rows=3 width=539) (actual time=0.102..0.142 rows=14 loops=1)

9. 0.029 0.071 ↑ 1.0 1 1

Hash Right Join (cost=8.30..10.93 rows=1 width=462) (actual time=0.060..0.071 rows=1 loops=1)

  • Hash Cond: (company1_.company_id = guardianus0_.company_id)
10. 0.017 0.017 ↓ 1.0 46 1

Seq Scan on company company1_ (cost=0.00..2.45 rows=45 width=194) (actual time=0.005..0.017 rows=46 loops=1)

11. 0.009 0.025 ↑ 1.0 1 1

Hash (cost=8.29..8.29 rows=1 width=268) (actual time=0.025..0.025 rows=1 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
12. 0.016 0.016 ↑ 1.0 1 1

Index Scan using email_idx on "user" guardianus0_ (cost=0.27..8.29 rows=1 width=268) (actual time=0.015..0.016 rows=1 loops=1)

  • Index Cond: (lower((email)::text) = 'kenneth.eisner@athenium.com'::text)
13. 0.040 0.065 ↓ 4.7 14 1

Hash Right Join (cost=0.50..1.85 rows=3 width=77) (actual time=0.041..0.065 rows=14 loops=1)

  • Hash Cond: (metadata3_.company_application_id = applicatio2_.company_application_id)
14. 0.009 0.009 ↑ 1.0 25 1

Seq Scan on company_application_metadata metadata3_ (cost=0.00..1.25 rows=25 width=49) (actual time=0.003..0.009 rows=25 loops=1)

15. 0.009 0.016 ↓ 4.3 13 1

Hash (cost=0.46..0.46 rows=3 width=28) (actual time=0.016..0.016 rows=13 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
16. 0.007 0.007 ↓ 4.3 13 1

Index Scan using company_id_application_id_uq on company_application applicatio2_ (cost=0.14..0.46 rows=3 width=28) (actual time=0.003..0.007 rows=13 loops=1)

  • Index Cond: (company1_.company_id = company_id)
17. 0.084 0.084 ↑ 1.2 8 14

Index Scan using company_application_id_feature_id_uq on company_application_feature features4_ (cost=0.28..1.07 rows=10 width=176) (actual time=0.002..0.006 rows=8 loops=14)

  • Index Cond: (applicatio2_.company_application_id = company_application_id)
18. 0.732 0.732 ↑ 6.5 14 122

Index Only Scan using company_feature_id_area_id_uq on company_application_feature_area areas5_ (cost=0.28..2.00 rows=91 width=8) (actual time=0.002..0.006 rows=14 loops=122)

  • Index Cond: (company_application_feature_id = features4_.company_application_feature_id)
  • Heap Fetches: 400
19. 1.872 1.872 ↑ 1.0 1 1,872

Index Scan using area_pk on area area6_ (cost=0.15..0.21 rows=1 width=28) (actual time=0.001..0.001 rows=1 loops=1,872)

  • Index Cond: (areas5_.area_id = area_id)
Planning time : 3.875 ms
Execution time : 15.934 ms