explain.depesz.com

PostgreSQL's explain analyze made readable

Result: amhj

Settings
# exclusive inclusive rows x rows loops node
1. 0.005 926.049 ↑ 1.0 1 1

Limit (cost=341,405.91..341,405.92 rows=1 width=8) (actual time=926.046..926.049 rows=1 loops=1)

2.          

Initplan (for Limit)

3. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=8) (never executed)

4. 0.008 926.044 ↑ 1.0 1 1

Aggregate (cost=341,405.90..341,405.91 rows=1 width=8) (actual time=926.043..926.044 rows=1 loops=1)

5. 0.002 926.036 ↓ 0.0 0 1

Nested Loop (cost=710.55..341,405.90 rows=1 width=8) (actual time=926.036..926.036 rows=0 loops=1)

  • Join Filter: (request.org_add = org_list.id)
6. 0.001 926.034 ↓ 0.0 0 1

Nested Loop Left Join (cost=710.55..341,275.52 rows=1 width=24) (actual time=926.034..926.034 rows=0 loops=1)

7. 0.002 926.033 ↓ 0.0 0 1

Nested Loop Semi Join (cost=708.58..341,266.88 rows=1 width=32) (actual time=926.032..926.033 rows=0 loops=1)

8. 0.041 926.031 ↓ 0.0 0 1

Nested Loop (cost=683.09..341,190.67 rows=1 width=40) (actual time=926.030..926.031 rows=0 loops=1)

  • Join Filter: (request.org_add = lp_p.id)
  • Rows Removed by Join Filter: 20
9. 0.750 0.750 ↑ 1.0 20 1

Index Scan using fdc_person_pk on fdc_person lp_p (cost=0.28..116.34 rows=20 width=8) (actual time=0.045..0.750 rows=20 loops=1)

  • Filter: (person_root_id = 15,126)
  • Rows Removed by Filter: 2,705
10. 0.035 925.240 ↑ 107.0 1 20

Materialize (cost=682.81..341,042.50 rows=107 width=32) (actual time=3.292..46.262 rows=1 loops=20)

11. 0.461 925.205 ↑ 107.0 1 1

Hash Join (cost=682.81..341,041.96 rows=107 width=32) (actual time=65.823..925.205 rows=1 loops=1)

  • Hash Cond: (rsh.request_id = request.id)
12. 0.960 919.559 ↑ 2,791.6 444 1

Nested Loop (cost=3.34..335,713.38 rows=1,239,479 width=8) (actual time=1.565..919.559 rows=444 loops=1)

13. 0.362 0.362 ↑ 1.0 1 1

Seq Scan on fdc_request_status c_1 (cost=0.00..3.89 rows=1 width=8) (actual time=0.168..0.362 rows=1 loops=1)

  • Filter: (id = request.c_request_status_new_id())
  • Rows Removed by Filter: 10
14. 0.912 918.237 ↑ 2,791.6 444 1

Hash Left Join (cost=3.34..323,314.70 rows=1,239,479 width=16) (actual time=1.187..918.237 rows=444 loops=1)

  • Hash Cond: (rsh.reason_id = c_2.id)
15. 917.114 917.114 ↑ 2,791.6 444 1

Index Scan using fdc_request_status_history_stat_i on fdc_request_status_history rsh (cost=0.68..318,663.99 rows=1,239,479 width=24) (actual time=0.958..917.114 rows=444 loops=1)

  • Index Cond: (status_id = request.c_request_status_new_id())
  • Filter: ((statement_timestamp() >= date_from) AND (statement_timestamp() <= date_to))
  • Rows Removed by Filter: 2,533,425
16. 0.042 0.211 ↓ 1.1 25 1

Hash (cost=2.37..2.37 rows=23 width=8) (actual time=0.210..0.211 rows=25 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
17. 0.091 0.169 ↓ 1.1 25 1

Hash Join (cost=1.07..2.37 rows=23 width=8) (actual time=0.064..0.169 rows=25 loops=1)

  • Hash Cond: (c_2.object_type_id = c_3.id)
18. 0.050 0.050 ↓ 1.1 25 1

Seq Scan on fdc_change_status_reason c_2 (cost=0.00..1.23 rows=23 width=16) (actual time=0.019..0.050 rows=25 loops=1)

19. 0.010 0.028 ↑ 1.0 3 1

Hash (cost=1.03..1.03 rows=3 width=8) (actual time=0.028..0.028 rows=3 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
20. 0.018 0.018 ↑ 1.0 3 1

Seq Scan on fdc_object_type c_3 (cost=0.00..1.03 rows=3 width=8) (actual time=0.012..0.018 rows=3 loops=1)

21. 1.010 5.185 ↓ 3.8 788 1

Hash (cost=676.84..676.84 rows=210 width=32) (actual time=5.184..5.185 rows=788 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 55kB
22. 1.882 4.175 ↓ 3.8 788 1

Nested Loop (cost=1.07..676.84 rows=210 width=32) (actual time=0.474..4.175 rows=788 loops=1)

23. 0.243 0.243 ↑ 1.0 1 1

Index Scan using fdc_request_type_pk on fdc_request_type c (cost=0.39..8.41 rows=1 width=12) (actual time=0.240..0.243 rows=1 loops=1)

  • Index Cond: (id = nsi.c_request_type_000_id())
24. 2.050 2.050 ↓ 3.8 788 1

Index Scan using fdc_request_rtype_i on fdc_request request (cost=0.68..666.33 rows=210 width=40) (actual time=0.020..2.050 rows=788 loops=1)

  • Index Cond: (request_type_id = nsi.c_request_type_000_id())
25. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=25.50..76.19 rows=4 width=8) (never executed)

  • Hash Cond: (gra.group_id = grm.group_id)
26. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=8.77..56.15 rows=262 width=16) (never executed)

27. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=8.49..32.64 rows=6 width=24) (never executed)

28. 0.000 0.000 ↓ 0.0 0

Index Only Scan using fdc_request_type_pk on fdc_request_type c_4 (cost=0.39..8.41 rows=1 width=8) (never executed)

  • Index Cond: (id = nsi.c_request_type_000_id())
  • Heap Fetches: 0
29. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=8.09..24.17 rows=6 width=24) (never executed)

  • Hash Cond: (c_5.id = rta.authority_id)
30. 0.000 0.000 ↓ 0.0 0

Seq Scan on fdc_authority c_5 (cost=0.00..14.20 rows=711 width=16) (never executed)

  • Filter: (NOT is_archived)
31. 0.000 0.000 ↓ 0.0 0

Hash (cost=8.02..8.02 rows=6 width=16) (never executed)

32. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on fdc_request_type_authority rta (cost=4.44..8.02 rows=6 width=16) (never executed)

  • Recheck Cond: (request_type_id = nsi.c_request_type_000_id())
33. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on fdc_request_authority_uk (cost=0.00..4.44 rows=6 width=0) (never executed)

  • Index Cond: (request_type_id = nsi.c_request_type_000_id())
34. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_group_authority_a_i on fdc_group_authority gra (cost=0.29..3.41 rows=51 width=16) (never executed)

  • Index Cond: (authority_id = c_5.id)
35. 0.000 0.000 ↓ 0.0 0

Hash (cost=16.62..16.62 rows=8 width=8) (never executed)

36. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_group_member_u_i on fdc_group_member grm (cost=0.28..16.62 rows=8 width=8) (never executed)

  • Index Cond: (user_id = $0)
37. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=1.96..8.54 rows=10 width=8) (never executed)

38. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=0.56..3.45 rows=1 width=16) (never executed)

39. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=0.42..2.78 rows=1 width=16) (never executed)

40. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_user_pk on fdc_user u (cost=0.27..2.42 rows=1 width=32) (never executed)

  • Index Cond: (id = request.user_add)
41. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_user_password_user_date_uk on fdc_user_password up (cost=0.14..0.35 rows=1 width=8) (never executed)

  • Index Cond: (user_id = u.id)
  • Filter: ((statement_timestamp() >= date_from) AND (statement_timestamp() <= date_to))
42. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_person_root_date_uk on fdc_person per (cost=0.14..0.66 rows=1 width=16) (never executed)

  • Index Cond: (person_root_id = u.person_root_id)
  • Filter: ((statement_timestamp() >= date_from) AND (statement_timestamp() <= date_to))
43. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=1.40..4.44 rows=65 width=8) (never executed)

44. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=1.26..2.43 rows=8 width=16) (never executed)

45. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=1.11..2.18 rows=1 width=24) (never executed)

46. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=0.83..1.56 rows=1 width=24) (never executed)

47. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.55..0.93 rows=1 width=24) (never executed)

48. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_official_person_pk on fdc_official_person ofp (cost=0.27..0.31 rows=1 width=24) (never executed)

  • Index Cond: (id = per.id)
49. 0.000 0.000 ↓ 0.0 0

Index Only Scan using fdc_person_pk on fdc_person per_1 (cost=0.28..0.62 rows=1 width=8) (never executed)

  • Index Cond: (id = ofp.id)
  • Heap Fetches: 0
50. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_person_pk on fdc_person ind_ver (cost=0.28..0.62 rows=1 width=16) (never executed)

  • Index Cond: (id = ofp.individual_id)
51. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_person_pk on fdc_person leg_ver (cost=0.28..0.62 rows=1 width=16) (never executed)

  • Index Cond: (id = ofp.legal_person_id)
52. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_person_root_date_uk on fdc_person ind_per (cost=0.14..0.24 rows=1 width=16) (never executed)

  • Index Cond: (person_root_id = ind_ver.person_root_id)
  • Filter: ((statement_timestamp() >= date_from) AND (statement_timestamp() <= date_to))
53. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_person_root_date_uk on fdc_person leg_per (cost=0.14..0.24 rows=1 width=16) (never executed)

  • Index Cond: (person_root_id = leg_ver.person_root_id)
  • Filter: ((statement_timestamp() >= date_from) AND (statement_timestamp() <= date_to))
54. 0.000 0.000 ↓ 0.0 0

Seq Scan on fdc_legal_person org_list (cost=0.00..106.28 rows=1,928 width=8) (never executed)

Planning time : 19.235 ms
Execution time : 926.470 ms