explain.depesz.com

PostgreSQL's explain analyze made readable

Result: kAnD

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 4.915 ↓ 30.7 614 1

Nested Loop Left Join (cost=2.54..71.34 rows=20 width=16) (actual time=0.311..4.915 rows=614 loops=1)

2. 4.518 4.518 ↓ 30.1 602 1

Nested Loop Left Join (cost=2.26..63.05 rows=20 width=24) (actual time=0.278..4.518 rows=602 loops=1)

3. 3.705 3.705 ↓ 30.1 602 1

Nested Loop Left Join (cost=1.98..56.77 rows=20 width=24) (actual time=0.250..3.705 rows=602 loops=1)

4. 2.141 2.141 ↓ 23.5 447 1

Nested Loop Left Join (cost=1.56..46.98 rows=19 width=16) (actual time=0.234..2.141 rows=447 loops=1)

5. 1.011 1.011 ↓ 23.5 447 1

Nested Loop Left Join (cost=1.14..37.89 rows=19 width=16) (actual time=0.164..1.011 rows=447 loops=1)

6. 0.604 0.604 ↓ 23.5 447 1

Nested Loop Left Join (cost=0.99..34.04 rows=19 width=16) (actual time=0.143..0.604 rows=447 loops=1)

7. 0.162 0.162 ↓ 20.0 20 1

Nested Loop Left Join (cost=0.57..8.62 rows=1 width=16) (actual time=0.111..0.162 rows=20 loops=1)

8. 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.062..0.062 rows=1 loops=1)

9. 0.077 0.077 ↓ 20.0 20 1

Index Scan using form_page_fk_idx on form_page (cost=0.29..4.30 rows=1 width=16) (actual time=0.035..0.077 rows=20 loops=1)

10. 0.340 0.340 ↓ 1.0 22 20

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

11. 0.447 0.447 ↓ 0.0 0 447

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

12. 0.894 0.894 ↑ 1.0 1 447

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

13. 1.341 1.341 ↑ 1.0 1 447

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

14. 0.602 0.602 ↓ 0.0 0 602

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

15. 0.000 0.000 ↓ 0.0 0 602

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.000..0.000 rows=0 loops=602)