explain.depesz.com

PostgreSQL's explain analyze made readable

Result: tH4l

Settings

Optimization(s) for this plan:

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

GroupAggregate (cost=56,137,089.12..56,195,794.65 rows=281,547 width=132) (actual rows= loops=)

  • Group Key: r.request_id, r.owner_pacs_id, r.owner_server_id, r.owner_app_id, r.scoped_seq_num, r.request_timestamp_as_epoch, r.target, r.type, r.requester_app_id, r.requester_
2. 0.000 0.000 ↓ 0.0

Sort (cost=56,137,089.12..56,140,721.28 rows=1,452,862 width=132) (actual rows= loops=)

  • Sort Key: r.request_id, r.owner_pacs_id, r.owner_server_id, r.owner_app_id, r.scoped_seq_num, r.request_timestamp_as_epoch, r.target, r.type, r.requester_app_id, r.reque
3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.82..55,891,550.81 rows=1,452,862 width=132) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Index Scan using requests_target_full_idx on requests r (cost=0.70..1,128,525.77 rows=281,547 width=112) (actual rows= loops=)

  • Index Cond: ((target)::text = ANY ('{2.25.70979651869268635392983113873997187447,2.25.202973438196673271781698759096192781730,2.25.24521812611206352719504898
  • Filter: (((status)::text = 'PENDING'::text) OR ((status)::text <> 'PENDING'::text))
5. 0.000 0.000 ↓ 0.0

Append (cost=0.12..191.26 rows=325 width=28) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Index Scan using request_attrs_request_id_idx on request_attrs a (cost=0.12..0.14 rows=1 width=44) (actual rows= loops=)

  • Index Cond: (request_id = r.request_id)
7. 0.000 0.000 ↓ 0.0

Index Scan using request_attrs_pk on request_attrs_partition_221562697 a_1 (cost=0.58..15.78 rows=171 width=28) (actual rows= loops=)

  • Index Cond: (request_id = r.request_id)
8. 0.000 0.000 ↓ 0.0

Index Scan using request_attrs_partition_current_request_id_idx on request_attrs_partition_226912529 a_2 (cost=0.44..8.34 rows=7 width=28) (actual rows= loops=)

  • Index Cond: (request_id = r.request_id)
9. 0.000 0.000 ↓ 0.0

Index Scan using request_attrs_partition_current_request_id_idx1 on request_attrs_partition_232613849 a_3 (cost=0.44..8.34 rows=7 width=28) (actual rows= loops=)

  • Index Cond: (request_id = r.request_id)
10. 0.000 0.000 ↓ 0.0

Index Scan using request_attrs_partition_current_request_id_idx2 on request_attrs_partition_238458194 a_4 (cost=0.44..8.34 rows=7 width=28) (actual rows= loops=)

  • Index Cond: (request_id = r.request_id)
11. 0.000 0.000 ↓ 0.0

Index Scan using request_attrs_partition_current_request_id_idx3 on request_attrs_partition_244124150 a_5 (cost=0.44..8.34 rows=7 width=29) (actual rows= loops=)

  • Index Cond: (request_id = r.request_id)
12. 0.000 0.000 ↓ 0.0

Index Scan using request_attrs_partition_current_request_id_idx4 on request_attrs_partition_249551379 a_6 (cost=0.44..8.34 rows=7 width=29) (actual rows= loops=)

  • Index Cond: (request_id = r.request_id)
13. 0.000 0.000 ↓ 0.0

Index Scan using request_attrs_partition_current_request_id_idx5 on request_attrs_partition_254853149 a_7 (cost=0.44..8.36 rows=8 width=28) (actual rows= loops=)

  • Index Cond: (request_id = r.request_id)
14. 0.000 0.000 ↓ 0.0

Index Scan using request_attrs_partition_current_request_id_idx6 on request_attrs_partition_260281345 a_8 (cost=0.44..8.34 rows=7 width=29) (actual rows= loops=)

  • Index Cond: (request_id = r.request_id)
15. 0.000 0.000 ↓ 0.0

Index Scan using request_attrs_partition_current_request_id_idx7 on request_attrs_partition_265641364 a_9 (cost=0.44..8.34 rows=7 width=29) (actual rows= loops=)

  • Index Cond: (request_id = r.request_id)
16. 0.000 0.000 ↓ 0.0

Index Scan using request_attrs_partition_current_request_id_idx8 on request_attrs_partition_270861535 a_10 (cost=0.44..8.34 rows=7 width=29) (actual rows= loops=)

  • Index Cond: (request_id = r.request_id)
17. 0.000 0.000 ↓ 0.0

Index Scan using request_attrs_partition_current_request_id_idx9 on request_attrs_partition_276335522 a_11 (cost=0.44..8.34 rows=7 width=29) (actual rows= loops=)

  • Index Cond: (request_id = r.request_id)
18. 0.000 0.000 ↓ 0.0

Index Scan using request_attrs_partition_current_request_id_idx10 on request_attrs_partition_281464835 a_12 (cost=0.44..8.36 rows=8 width=29) (actual rows= loops=)

  • Index Cond: (request_id = r.request_id)
19. 0.000 0.000 ↓ 0.0

Index Scan using request_attrs_partition_current_request_id_idx11 on request_attrs_partition_286926621 a_13 (cost=0.44..8.36 rows=8 width=29) (actual rows= loops=)

  • Index Cond: (request_id = r.request_id)
20. 0.000 0.000 ↓ 0.0

Index Scan using request_attrs_partition_current_request_id_idx12 on request_attrs_partition_292448696 a_14 (cost=0.44..8.36 rows=8 width=29) (actual rows= loops=)

  • Index Cond: (request_id = r.request_id)
21. 0.000 0.000 ↓ 0.0

Index Scan using request_attrs_partition_current_request_id_idx13 on request_attrs_partition_297922775 a_15 (cost=0.44..8.34 rows=7 width=29) (actual rows= loops=)

  • Index Cond: (request_id = r.request_id)
22. 0.000 0.000 ↓ 0.0

Index Scan using request_attrs_partition_current_request_id_idx14 on request_attrs_partition_303578283 a_16 (cost=0.44..8.36 rows=8 width=29) (actual rows= loops=)

  • Index Cond: (request_id = r.request_id)
23. 0.000 0.000 ↓ 0.0

Index Scan using request_attrs_partition_current_request_id_idx15 on request_attrs_partition_309209601 a_17 (cost=0.44..8.34 rows=7 width=29) (actual rows= loops=)

  • Index Cond: (request_id = r.request_id)
24. 0.000 0.000 ↓ 0.0

Index Scan using request_attrs_partition_current_request_id_idx16 on request_attrs_partition_314634834 a_18 (cost=0.44..8.34 rows=7 width=29) (actual rows= loops=)

  • Index Cond: (request_id = r.request_id)
25. 0.000 0.000 ↓ 0.0

Index Scan using request_attrs_partition_current_request_id_idx17 on request_attrs_partition_320280087 a_19 (cost=0.44..8.36 rows=8 width=29) (actual rows= loops=)

  • Index Cond: (request_id = r.request_id)
26. 0.000 0.000 ↓ 0.0

Index Scan using request_attrs_partition_current_request_id_idx18 on request_attrs_partition_326017480 a_20 (cost=0.44..8.34 rows=7 width=29) (actual rows= loops=)

  • Index Cond: (request_id = r.request_id)
27. 0.000 0.000 ↓ 0.0

Index Scan using request_attrs_partition_current_request_id_idx19 on request_attrs_partition_331666157 a_21 (cost=0.44..8.35 rows=7 width=29) (actual rows= loops=)

  • Index Cond: (request_id = r.request_id)
28. 0.000 0.000 ↓ 0.0

Index Scan using request_attrs_partition_current_request_id_idx20 on request_attrs_partition_current a_22 (cost=0.43..8.38 rows=7 width=29) (actual rows= loops=)

  • Index Cond: (request_id = r.request_id)