explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 16E : Optimization for: plan #N5Oa

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.019 0.578 ↓ 1.2 49 1

Hash Join (cost=32.33..36.15 rows=41 width=1,099) (actual time=0.527..0.578 rows=49 loops=1)

  • Hash Cond: (dam.datasource_guid = pdm.datasource_guid)
2. 0.016 0.465 ↓ 1.3 48 1

Hash Join (cost=29.35..32.60 rows=38 width=351) (actual time=0.426..0.465 rows=48 loops=1)

  • Hash Cond: (dam.application_instance_id = pa.id)
3. 0.020 0.415 ↓ 1.3 48 1

Hash Left Join (cost=26.86..29.64 rows=38 width=327) (actual time=0.383..0.415 rows=48 loops=1)

  • Hash Cond: ((ds.created_by)::text = ((pr.identity2)::character varying)::text)
4. 0.021 0.224 ↓ 1.3 48 1

Hash Join (cost=16.63..18.79 rows=38 width=309) (actual time=0.202..0.224 rows=48 loops=1)

  • Hash Cond: (ds.erp_type_id = ise.id)
5. 0.020 0.160 ↓ 1.3 48 1

Hash Join (cost=15.58..17.44 rows=38 width=91) (actual time=0.147..0.160 rows=48 loops=1)

  • Hash Cond: (dam.datasource_guid = ds.guid)
6. 0.013 0.013 ↓ 1.3 48 1

Seq Scan on platformservice_datasource_applicationinstance_mapping dam (cost=0.00..1.38 rows=38 width=20) (actual time=0.010..0.013 rows=48 loops=1)

7. 0.012 0.127 ↓ 1.0 27 1

Hash (cost=15.26..15.26 rows=26 width=71) (actual time=0.127..0.127 rows=27 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 12kB
8. 0.115 0.115 ↓ 1.0 27 1

Seq Scan on platformservice_datasources ds (cost=0.00..15.26 rows=26 width=71) (actual time=0.011..0.115 rows=27 loops=1)

9. 0.007 0.043 ↑ 1.0 2 1

Hash (cost=1.02..1.02 rows=2 width=222) (actual time=0.043..0.043 rows=2 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
10. 0.036 0.036 ↑ 1.0 2 1

Seq Scan on infrastructure_supported_erptypes ise (cost=0.00..1.02 rows=2 width=222) (actual time=0.036..0.036 rows=2 loops=1)

11. 0.065 0.171 ↑ 1.0 188 1

Hash (cost=7.88..7.88 rows=188 width=34) (actual time=0.171..0.171 rows=188 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 21kB
12. 0.106 0.106 ↑ 1.0 188 1

Seq Scan on platformservice_profiles pr (cost=0.00..7.88 rows=188 width=34) (actual time=0.069..0.106 rows=188 loops=1)

13. 0.009 0.034 ↑ 1.0 22 1

Hash (cost=2.22..2.22 rows=22 width=32) (actual time=0.034..0.034 rows=22 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
14. 0.025 0.025 ↑ 1.0 22 1

Seq Scan on platformservice_applications pa (cost=0.00..2.22 rows=22 width=32) (actual time=0.008..0.025 rows=22 loops=1)

15. 0.006 0.094 ↑ 1.0 28 1

Hash (cost=2.62..2.62 rows=28 width=766) (actual time=0.094..0.094 rows=28 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
16. 0.013 0.088 ↑ 1.0 28 1

Hash Join (cost=1.07..2.62 rows=28 width=766) (actual time=0.082..0.088 rows=28 loops=1)

  • Hash Cond: (pdm.pm_guid = ip.guid)
17. 0.051 0.051 ↑ 1.0 28 1

Seq Scan on platformservice_datasource_processmodule_mapping pdm (cost=0.00..1.28 rows=28 width=32) (actual time=0.049..0.051 rows=28 loops=1)

18. 0.010 0.024 ↑ 1.0 3 1

Hash (cost=1.03..1.03 rows=3 width=750) (actual time=0.024..0.024 rows=3 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
19. 0.014 0.014 ↑ 1.0 3 1

Seq Scan on infrastructure_processmodules ip (cost=0.00..1.03 rows=3 width=750) (actual time=0.014..0.014 rows=3 loops=1)

Planning time : 8.792 ms