explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Crry

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=6,976.78..13,751.27 rows=69,657 width=307) (actual rows= loops=)

  • Hash Cond: (rsc.kit_usage_config_id = kuc.kit_usage_config_id)
2. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=6,957.02..13,164.30 rows=69,657 width=275) (actual rows= loops=)

  • Hash Cond: (rsc.device_role_id = dr.device_role_id)
3. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=6,955.96..12,205.45 rows=69,657 width=243) (actual rows= loops=)

  • Hash Cond: (rsc.kit_usage_id = ku.kit_usage_id)
4. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=6,954.80..11,413.36 rows=69,657 width=211) (actual rows= loops=)

  • Hash Cond: (rsc.kit_container_type_id = kct.kit_container_type_id)
5. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=6,953.73..10,486.23 rows=69,657 width=179) (actual rows= loops=)

  • Hash Cond: (rsc.kit_type_id = kt.kit_type_id)
6. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=6,952.66..9,582.48 rows=69,657 width=147) (actual rows= loops=)

  • Hash Cond: (rsc.kit_id = vk.kit_id)
7. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=6,925.14..8,653.34 rows=69,657 width=115) (actual rows= loops=)

  • Hash Cond: ((cse.collection_set_id = cs.collection_set_id) AND (cse.employee_id = rsc.employee_id))
8. 0.000 0.000 ↓ 0.0

Seq Scan on collection_set_employee cse (cost=0.00..153.76 rows=8,376 width=10) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Hash (cost=4,655.29..4,655.29 rows=69,657 width=117) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Hash Join (cost=1,616.50..4,655.29 rows=69,657 width=117) (actual rows= loops=)

  • Hash Cond: (rsc.report_set_id = rs.report_set_id)
11. 0.000 0.000 ↓ 0.0

Seq Scan on report_set_collector rsc (cost=0.00..1,558.57 rows=69,657 width=57) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

Hash (cost=1,277.33..1,277.33 rows=27,134 width=64) (actual rows= loops=)

13. 0.000 0.000 ↓ 0.0

Hash Join (cost=250.31..1,277.33 rows=27,134 width=64) (actual rows= loops=)

  • Hash Cond: (rs.collection_set_id = cs.collection_set_id)
14. 0.000 0.000 ↓ 0.0

Seq Scan on report_set rs (cost=0.00..484.34 rows=27,134 width=15) (actual rows= loops=)

15. 0.000 0.000 ↓ 0.0

Hash (cost=167.36..167.36 rows=6,636 width=49) (actual rows= loops=)

16. 0.000 0.000 ↓ 0.0

Seq Scan on collection_set cs (cost=0.00..167.36 rows=6,636 width=49) (actual rows= loops=)

17. 0.000 0.000 ↓ 0.0

Hash (cost=20.01..20.01 rows=601 width=36) (actual rows= loops=)

18. 0.000 0.000 ↓ 0.0

Seq Scan on kit vk (cost=0.00..20.01 rows=601 width=36) (actual rows= loops=)

19. 0.000 0.000 ↓ 0.0

Hash (cost=1.03..1.03 rows=3 width=36) (actual rows= loops=)

20. 0.000 0.000 ↓ 0.0

Seq Scan on kit_type kt (cost=0.00..1.03 rows=3 width=36) (actual rows= loops=)

21. 0.000 0.000 ↓ 0.0

Hash (cost=1.03..1.03 rows=3 width=36) (actual rows= loops=)

22. 0.000 0.000 ↓ 0.0

Seq Scan on kit_container_type kct (cost=0.00..1.03 rows=3 width=36) (actual rows= loops=)

23. 0.000 0.000 ↓ 0.0

Hash (cost=1.07..1.07 rows=7 width=36) (actual rows= loops=)

24. 0.000 0.000 ↓ 0.0

Seq Scan on kit_usage ku (cost=0.00..1.07 rows=7 width=36) (actual rows= loops=)

25. 0.000 0.000 ↓ 0.0

Hash (cost=1.03..1.03 rows=3 width=36) (actual rows= loops=)

26. 0.000 0.000 ↓ 0.0

Seq Scan on device_role dr (cost=0.00..1.03 rows=3 width=36) (actual rows= loops=)

27. 0.000 0.000 ↓ 0.0

Hash (cost=18.78..18.78 rows=78 width=36) (actual rows= loops=)

28. 0.000 0.000 ↓ 0.0

Seq Scan on kit_usage_config kuc (cost=0.00..18.78 rows=78 width=36) (actual rows= loops=)