explain.depesz.com

PostgreSQL's explain analyze made readable

Result: BK1Z

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 16.367 ↑ 1.0 1 1

Aggregate (cost=597.08..597.09 rows=1 width=8) (actual time=16.367..16.367 rows=1 loops=1)

2. 16.260 16.260 ↓ 38.4 767 1

Nested Loop Left Join (cost=81.03..597.03 rows=20 width=8) (actual time=5.445..16.260 rows=767 loops=1)

3. 15.425 15.425 ↓ 38.4 767 1

Hash Left Join (cost=80.76..590.93 rows=20 width=24) (actual time=5.439..15.425 rows=767 loops=1)

4. 13.895 13.895 ↓ 38.4 767 1

Nested Loop Left Join (cost=3.79..513.80 rows=20 width=24) (actual time=4.208..13.895 rows=767 loops=1)

5. 12.551 12.551 ↓ 31.0 620 1

Nested Loop Left Join (cost=3.38..502.92 rows=20 width=40) (actual time=4.170..12.551 rows=620 loops=1)

6. 11.816 11.816 ↓ 30.4 608 1

Nested Loop Left Join (cost=3.10..494.67 rows=20 width=32) (actual time=4.137..11.816 rows=608 loops=1)

7. 10.707 10.707 ↓ 30.4 608 1

Nested Loop Left Join (cost=2.82..486.17 rows=20 width=32) (actual time=4.104..10.707 rows=608 loops=1)

8. 10.172 10.172 ↓ 30.1 603 1

Nested Loop Left Join (cost=2.67..480.96 rows=20 width=40) (actual time=4.086..10.172 rows=603 loops=1)

9. 7.872 7.872 ↓ 30.1 603 1

Nested Loop Left Join (cost=2.25..471.58 rows=20 width=32) (actual time=4.052..7.872 rows=603 loops=1)

10. 6.216 6.216 ↓ 23.6 448 1

Nested Loop Left Join (cost=1.83..461.79 rows=19 width=32) (actual time=4.017..6.216 rows=448 loops=1)

11. 4.901 4.901 ↓ 23.6 448 1

Nested Loop Left Join (cost=1.41..452.71 rows=19 width=24) (actual time=3.935..4.901 rows=448 loops=1)

12. 4.438 4.438 ↓ 23.6 448 1

Nested Loop Left Join (cost=1.27..448.86 rows=19 width=24) (actual time=3.902..4.438 rows=448 loops=1)

13. 3.957 3.957 ↓ 20.0 20 1

Nested Loop Left Join (cost=0.85..447.13 rows=1 width=24) (actual time=3.870..3.957 rows=20 loops=1)

14. 3.907 3.907 ↓ 20.0 20 1

Nested Loop Left Join (cost=0.57..446.82 rows=1 width=24) (actual time=3.858..3.907 rows=20 loops=1)

15. 3.829 3.829 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.29..446.47 rows=1 width=16) (actual time=3.827..3.829 rows=1 loops=1)

16. 3.758 3.758 ↑ 1.0 1 1

Seq Scan on reports (cost=0.00..442.16 rows=1 width=16) (actual time=3.757..3.758 rows=1 loops=1)

17. 0.062 0.062 ↑ 1.0 1 1

Index Only Scan using forms_pk on forms (cost=0.29..4.30 rows=1 width=8) (actual time=0.061..0.062 rows=1 loops=1)

18. 0.069 0.069 ↓ 20.0 20 1

Index Scan using form_page_fk_idx on form_page (cost=0.29..0.34 rows=1 width=16) (actual time=0.027..0.069 rows=20 loops=1)

19. 0.040 0.040 ↓ 0.0 0 20

Index Only Scan using form_payment_fk_idx on form_payment (cost=0.28..0.30 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=20)

20. 0.400 0.400 ↓ 1.0 22 20

Index Scan using form_element_fk1_idx on form_element (cost=0.42..1.52 rows=21 width=16) (actual time=0.008..0.020 rows=22 loops=20)

21. 0.448 0.448 ↓ 0.0 0 448

Index Only Scan using subform_element_fk_idx on subform_element (cost=0.15..0.18 rows=2 width=8) (actual time=0.001..0.001 rows=0 loops=448)

22. 0.896 0.896 ↑ 1.0 1 448

Index Only Scan using form_field_pk on form_field (cost=0.42..0.47 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=448)

23. 1.344 1.344 ↑ 1.0 1 448

Index Scan using form_component_fk1_idx on form_component (cost=0.42..0.51 rows=1 width=16) (actual time=0.003..0.003 rows=1 loops=448)

24. 1.809 1.809 ↓ 2.0 2 603

Index Scan using report_component_fk2_idx on report_component (cost=0.42..0.46 rows=1 width=24) (actual time=0.002..0.003 rows=2 loops=603)

25. 0.603 0.603 ↓ 0.0 0 603

Index Only Scan using report_component_subform_fk1_idx on report_component_subform (cost=0.15..0.22 rows=4 width=8) (actual time=0.001..0.001 rows=0 loops=603)

26. 0.608 0.608 ↑ 1.0 1 608

Index Only Scan using forms_info_fk_idx on forms_info (cost=0.29..0.42 rows=1 width=8) (actual time=0.001..0.001 rows=1 loops=608)

27. 0.608 0.608 ↓ 0.0 0 608

Index Scan using form_select_option_group_fk1_idx on form_select_option_group (cost=0.28..0.36 rows=5 width=16) (actual time=0.001..0.001 rows=0 loops=608)

28. 1.240 1.240 ↑ 4.0 1 620

Index Scan using form_picklist_value_fk3_idx on form_picklist_value (cost=0.41..0.49 rows=4 width=24) (actual time=0.001..0.002 rows=1 loops=620)

29. 1.186 1.186 ↓ 1.0 2,596 1

Hash (cost=44.76..44.76 rows=2,576 width=16) (actual time=1.186..1.186 rows=2,596 loops=1)

30. 0.539 0.539 ↓ 1.0 2,596 1

Seq Scan on report_to_criteria_operator (cost=0.00..44.76 rows=2,576 width=16) (actual time=0.007..0.539 rows=2,596 loops=1)

31. 0.767 0.767 ↓ 0.0 0 767

Index Scan using report_base_criteria_fk1_idx on report_base_criteria (cost=0.28..0.29 rows=1 width=16) (actual time=0.001..0.001 rows=0 loops=767)