explain.depesz.com

PostgreSQL's explain analyze made readable

Result: JQrk

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

Hash Join (cost=2,981.35..18,606.18 rows=265,331 width=551) (never executed)

2. 0.000 0.000 ↓ 0.0

Merge Join (cost=2,762.55..3,079.02 rows=20,729 width=674) (never executed)

3. 0.000 0.000 ↓ 0.0

Sort (cost=199.18..201.95 rows=1,107 width=50) (never executed)

  • Sort Key: delivery_installation.ordered_offer_id
4. 0.000 0.000 ↓ 0.0

Foreign Scan (cost=100..143.21 rows=1,107 width=50) (never executed)

5. 0.000 0.000 ↓ 0.0

Sort (cost=2,563.36..2,572.73 rows=3,745 width=640) (never executed)

  • Sort Key: offers_customeroffer.uuid
6. 0.000 0.000 ↓ 0.0

Hash Join (cost=2,148.75..2,341.08 rows=3,745 width=640) (never executed)

7. 0.000 0.000 ↓ 0.0

Hash Join (cost=2,002.5..2,061.9 rows=878 width=572) (never executed)

8. 0.000 0.000 ↓ 0.0

Hash Join (cost=1,876.09..1,903.39 rows=455 width=416) (never executed)

9. 0.000 0.000 ↓ 0.0

Hash Join (cost=1,733.2..1,759.28 rows=455 width=384) (never executed)

10. 0.000 0.000 ↓ 0.0

Hash Join (cost=894.29..919.16 rows=455 width=268) (never executed)

11. 0.000 0.000 ↓ 0.0

Foreign Scan (cost=100..123.65 rows=455 width=156) (never executed)

12. 0.000 0.000 ↓ 0.0

Hash (cost=791.79..791.79 rows=200 width=128) (never executed)

13. 0.000 0.000 ↓ 0.0

Subquery Scan on ol (cost=786.29..791.79 rows=200 width=128) (never executed)

14. 0.000 0.000 ↓ 0.0

Aggregate (cost=786.29..789.79 rows=200 width=128) (never executed)

15. 0.000 0.000 ↓ 0.0

Merge Join (cost=523.64..758.13 rows=1,024 width=56) (never executed)

16. 0.000 0.000 ↓ 0.0

Sort (cost=191.92..194.48 rows=1,024 width=56) (never executed)

  • Sort Key: offers_offercomponent.object_id
17. 0.000 0.000 ↓ 0.0

Foreign Scan (cost=100..140.72 rows=1,024 width=56) (never executed)

18. 0.000 0.000 ↓ 0.0

Sort (cost=331.72..338.12 rows=2,560 width=8) (never executed)

  • Sort Key: offergenerator_workingtimetype.id
19. 0.000 0.000 ↓ 0.0

Foreign Scan (cost=100..186.8 rows=2,560 width=8) (never executed)

20. 0.000 0.000 ↓ 0.0

Hash (cost=836.41..836.41 rows=200 width=132) (never executed)

21. 0.000 0.000 ↓ 0.0

Subquery Scan on osl (cost=830.91..836.41 rows=200 width=132) (never executed)

22. 0.000 0.000 ↓ 0.0

Aggregate (cost=830.91..834.41 rows=200 width=132) (never executed)

23. 0.000 0.000 ↓ 0.0

Merge Join (cost=474.79..656.26 rows=11,643 width=52) (never executed)

24. 0.000 0.000 ↓ 0.0

Sort (cost=222.03..225.44 rows=1,365 width=36) (never executed)

  • Sort Key: offers_suboffercomponent.offer_id
25. 0.000 0.000 ↓ 0.0

Foreign Scan (cost=100..150.95 rows=1,365 width=36) (never executed)

26. 0.000 0.000 ↓ 0.0

Sort (cost=252.76..257.03 rows=1,706 width=24) (never executed)

  • Sort Key: offers_customersuboffer.id
27. 0.000 0.000 ↓ 0.0

Foreign Scan (cost=100..161.18 rows=1,706 width=24) (never executed)

28. 0.000 0.000 ↓ 0.0

Hash (cost=140.4..140.4 rows=200 width=48) (never executed)

29. 0.000 0.000 ↓ 0.0

Subquery Scan on oe (cost=107.28..140.4 rows=200 width=48) (never executed)

30. 0.000 0.000 ↓ 0.0

Foreign Scan (cost=107.28..138.4 rows=200 width=48) (never executed)

31. 0.000 0.000 ↓ 0.0

Hash (cost=121.58..121.58 rows=386 width=188) (never executed)

32. 0.000 0.000 ↓ 0.0

Foreign Scan (cost=100..121.58 rows=386 width=188) (never executed)

33. 0.000 0.000 ↓ 0.0

Hash (cost=135.59..135.59 rows=853 width=72) (never executed)

34. 0.000 0.000 ↓ 0.0

Foreign Scan (cost=100..135.59 rows=853 width=72) (never executed)

35. 0.000 0.000 ↓ 0.0

Hash (cost=186.8..186.8 rows=2,560 width=8) (never executed)

36. 0.000 0.000 ↓ 0.0

Foreign Scan (cost=100..186.8 rows=2,560 width=8) (never executed)