explain.depesz.com

PostgreSQL's explain analyze made readable

Result: YPo

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 11.964 ↓ 0.0 0 1

Unique (cost=6,199.50..6,199.51 rows=1 width=72) (actual time=11.963..11.964 rows=0 loops=1)

2. 0.031 11.963 ↓ 0.0 0 1

Sort (cost=6,199.50..6,199.50 rows=1 width=72) (actual time=11.962..11.963 rows=0 loops=1)

  • Sort Key: ap.company_name, apl.id
  • Sort Method: quicksort Memory: 25kB
3. 0.003 11.932 ↓ 0.0 0 1

WindowAgg (cost=6,199.46..6,199.49 rows=1 width=72) (actual time=11.932..11.932 rows=0 loops=1)

4. 0.005 11.929 ↓ 0.0 0 1

Sort (cost=6,199.46..6,199.47 rows=1 width=50) (actual time=11.929..11.929 rows=0 loops=1)

  • Sort Key: apl.ap_payee_id
  • Sort Method: quicksort Memory: 25kB
5. 0.000 11.924 ↓ 0.0 0 1

Nested Loop (cost=1,061.50..6,199.45 rows=1 width=50) (actual time=11.924..11.924 rows=0 loops=1)

6. 11.847 13.722 ↓ 0.0 0 1

Gather (cost=1,060.22..6,169.66 rows=1 width=50) (actual time=11.923..13.722 rows=0 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
7. 0.001 1.875 ↓ 0.0 0 2

Nested Loop (cost=60.22..5,169.56 rows=1 width=50) (actual time=1.875..1.875 rows=0 loops=2)

  • Join Filter: (ap.id = apl.ap_payee_id)
8. 0.001 1.874 ↓ 0.0 0 2

Nested Loop Semi Join (cost=59.80..5,158.37 rows=6 width=32) (actual time=1.874..1.874 rows=0 loops=2)

9. 0.000 1.873 ↓ 0.0 0 2

Parallel Bitmap Heap Scan on ap_payees ap (cost=59.37..3,445.64 rows=1,518 width=28) (actual time=1.873..1.873 rows=0 loops=2)

  • Recheck Cond: (cid = 13531)
  • Filter: ((company_name IS NOT NULL) AND (ap_payee_status_type_id = 1) AND (ap_payee_type_id = ANY ('{1,2,3,7}'::integer[])))
10. 3.550 3.550 ↓ 0.0 0 1

Bitmap Index Scan on pk_ap_payees (cost=0.00..58.73 rows=2,974 width=0) (actual time=3.550..3.550 rows=0 loops=1)

  • Index Cond: (cid = 13531)
11. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_ap_headers_ap_payee_id_remote_primary_key on ap_headers ah (cost=0.43..91.86 rows=131 width=8) (never executed)

  • Index Cond: ((cid = 13531) AND (ap_payee_id = ap.id))
  • Filter: ((deleted_on IS NULL) AND (ap_header_type_id = 5))
12. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_ap_payee_locations_cid_ap_payee_id on ap_payee_locations apl (cost=0.42..1.85 rows=1 width=30) (never executed)

  • Index Cond: ((cid = 13531) AND (ap_payee_id = ah.ap_payee_id))
  • Filter: ((deleted_on IS NULL) AND (disabled_on IS NULL))
13. 0.000 0.000 ↓ 0.0 0

Group (cost=1.28..29.77 rows=1 width=4) (never executed)

  • Group Key: appg.ap_payee_id
14. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.28..29.77 rows=1 width=4) (never executed)

15. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.99..25.08 rows=1 width=16) (never executed)

16. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.71..16.76 rows=1 width=20) (never executed)

17. 0.000 0.000 ↓ 0.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.42..8.44 rows=1 width=12) (never executed)

  • Index Cond: ((cid = 13531) AND (ap_payee_id = apl.ap_payee_id) AND (ap_payee_location_id = apl.id))
  • Heap Fetches: 0
18. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_property_groups_id on property_groups pg (cost=0.29..8.30 rows=1 width=8) (never executed)

  • Index Cond: (id = 100013531)
  • Filter: ((deleted_on IS NULL) AND (cid = 13531))
19. 0.000 0.000 ↓ 0.0 0

Index Only Scan using idx_property_group_associations_master on property_group_associations pga_2 (cost=0.29..8.31 rows=1 width=12) (never executed)

  • Index Cond: ((cid = 13531) AND (property_group_id = appg.property_group_id))
  • Heap Fetches: 0
20. 0.000 0.000 ↓ 0.0 0

Index Only Scan using idx_property_group_associations_master on property_group_associations pga (cost=0.29..4.68 rows=1 width=12) (never executed)

  • Index Cond: ((cid = 13531) AND (property_group_id = 100013531) AND (property_id = pga_2.property_id))
  • Heap Fetches: 0
Planning time : 233.247 ms