explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ablZ

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

Unique (cost=23,702.78..23,710.46 rows=1,024 width=72) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Sort (cost=23,702.78..23,705.34 rows=1,024 width=72) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

WindowAgg (cost=23,631.10..23,651.58 rows=1,024 width=72) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Sort (cost=23,631.10..23,633.66 rows=1,024 width=58) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Nested Loop Semi Join (cost=5,279.54..23,579.90 rows=1,024 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=66) (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

Hash Join (cost=10.44..20.11 rows=93 width=8) (actual rows= loops=)

13. 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=)

14. 0.000 0.000 ↓ 0.0

Hash (cost=9.13..9.13 rows=82 width=20) (actual rows= loops=)

15. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.84..9.13 rows=82 width=20) (actual rows= loops=)

16. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.56..8.64 rows=1 width=24) (actual rows= loops=)

17. 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=)

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..0.34 rows=1 width=16) (actual rows= loops=)

19. 0.000 0.000 ↓ 0.0

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