explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Q54s

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

Unique (cost=52,283.36..52,295.57 rows=1,629 width=72) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Sort (cost=52,283.36..52,287.43 rows=1,629 width=72) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

WindowAgg (cost=52,163.87..52,196.45 rows=1,629 width=72) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Sort (cost=52,163.87..52,167.94 rows=1,629 width=58) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Nested Loop (cost=5,287.51..52,076.97 rows=1,629 width=58) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Hash Join (cost=5,269.10..5,923.32 rows=1,629 width=58) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Seq Scan on ap_payee_locations apl (cost=0.00..575.27 rows=16,712 width=38) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Hash (cost=5,249.39..5,249.39 rows=1,577 width=32) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Nested Loop Semi Join (cost=0.42..5,249.39 rows=1,577 width=32) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Seq Scan on ap_payees ap (cost=0.00..833.68 rows=8,322 width=28) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Index Scan using idx_ap_headers_ap_payee_id on ap_headers ah (cost=0.42..10.28 rows=112 width=8) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

Group (cost=18.41..28.31 rows=1 width=4) (actual rows= loops=)

13. 0.000 0.000 ↓ 0.0

Hash Join (cost=18.41..28.08 rows=93 width=4) (actual rows= loops=)

14. 0.000 0.000 ↓ 0.0

Index Only Scan using idx_property_group_associations_master on property_group_associations pga (cost=0.28..8.28 rows=200 width=12) (actual rows= loops=)

15. 0.000 0.000 ↓ 0.0

Hash (cost=17.11..17.11 rows=82 width=16) (actual rows= loops=)

16. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.84..17.11 rows=82 width=16) (actual rows= loops=)

17. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.56..12.62 rows=1 width=20) (actual rows= loops=)

18. 0.000 0.000 ↓ 0.0

Index Only Scan using uk_ap_payee_property_groups_cid_ap_payee_id_ap_payee_location_i on ap_payee_property_groups appg (cost=0.29..4.31 rows=1 width=12) (actual rows= loops=)

19. 0.000 0.000 ↓ 0.0

Index Scan using idx_property_groups_id on property_groups pg (cost=0.28..8.29 rows=1 width=8) (actual rows= loops=)

20. 0.000 0.000 ↓ 0.0

Index Only Scan using idx_property_group_associations_master on property_group_associations pga_2 (cost=0.28..4.42 rows=7 width=12) (actual rows= loops=)