explain.depesz.com

PostgreSQL's explain analyze made readable

Result: QRj6

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 8.257 ↓ 1.9 37 1

Nested Loop Left Join (cost=2.54..71.35 rows=20 width=8) (actual time=7.209..8.257 rows=37 loops=1)

2. 8.208 8.208 ↓ 1.9 37 1

Nested Loop Left Join (cost=2.26..63.06 rows=20 width=16) (actual time=7.202..8.208 rows=37 loops=1)

3. 8.081 8.081 ↓ 1.9 37 1

Nested Loop Left Join (cost=1.98..56.78 rows=20 width=16) (actual time=7.179..8.081 rows=37 loops=1)

4. 7.697 7.697 ↓ 1.8 34 1

Nested Loop Left Join (cost=1.56..46.98 rows=19 width=16) (actual time=7.165..7.697 rows=34 loops=1)

5. 7.296 7.296 ↓ 1.8 34 1

Nested Loop Left Join (cost=1.14..37.90 rows=19 width=16) (actual time=7.070..7.296 rows=34 loops=1)

6. 7.231 7.231 ↓ 1.8 34 1

Nested Loop Left Join (cost=0.99..34.05 rows=19 width=16) (actual time=7.063..7.231 rows=34 loops=1)

7. 7.028 7.028 ↓ 3.0 3 1

Nested Loop Left Join (cost=0.57..8.62 rows=1 width=16) (actual time=7.024..7.028 rows=3 loops=1)

8. 6.938 6.938 ↑ 1.0 1 1

Index Only Scan using forms_pk on forms (cost=0.29..4.31 rows=1 width=8) (actual time=6.937..6.938 rows=1 loops=1)

9. 0.064 0.064 ↓ 3.0 3 1

Index Scan using form_page_fk_idx on form_page (cost=0.29..4.30 rows=1 width=16) (actual time=0.061..0.064 rows=3 loops=1)

10. 0.189 0.189 ↑ 1.9 11 3

Index Scan using form_element_fk1_idx on form_element (cost=0.42..25.22 rows=21 width=16) (actual time=0.020..0.063 rows=11 loops=3)

11. 0.034 0.034 ↓ 0.0 0 34

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=34)

12. 0.374 0.374 ↑ 1.0 1 34

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

13. 0.374 0.374 ↑ 1.0 1 34

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

14. 0.111 0.111 ↓ 0.0 0 37

Index Only Scan using form_select_fk_idx on form_select (cost=0.29..0.30 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=37)

15. 0.037 0.037 ↓ 0.0 0 37

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