explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wyGg

Settings
# exclusive inclusive rows x rows loops node
1. 0.126 16,930.420 ↑ 6.5 30 1

Nested Loop Left Join (cost=114,685.73..703,284.97 rows=194 width=91) (actual time=8,584.388..16,930.420 rows=30 loops=1)

2. 1,318.019 16,924.594 ↓ 1.5 30 1

Hash Join (cost=114,683.35..703,126.67 rows=20 width=91) (actual time=8,584.070..16,924.594 rows=30 loops=1)

  • Hash Cond: (v.id = fdc_request_pts.pasport_id)
3. 2,730.164 15,606.479 ↑ 19.8 2,265,734 1

Hash Left Join (cost=114,674.89..585,286.91 rows=44,888,026 width=91) (actual time=3,389.946..15,606.479 rows=2,265,734 loops=1)

  • Hash Cond: (c.id = t.status_id)
4. 2,865.143 12,875.017 ↑ 9.9 2,265,734 1

Hash Left Join (cost=114,670.84..513,882.84 rows=22,444,013 width=74) (actual time=3,388.638..12,875.017 rows=2,265,734 loops=1)

  • Hash Cond: (v.status_id = c.id)
5. 4,461.477 10,009.757 ↑ 1.0 2,265,734 1

Hash Join (cost=114,547.07..255,312.86 rows=2,267,072 width=74) (actual time=3,388.499..10,009.757 rows=2,265,734 loops=1)

  • Hash Cond: (v.root_id = r.id)
6. 2,160.669 2,160.669 ↑ 1.0 2,265,734 1

Seq Scan on fdc_pts_ver v (cost=0.00..73,532.72 rows=2,267,072 width=58) (actual time=0.031..2,160.669 rows=2,265,734 loops=1)

7. 1,701.605 3,387.611 ↑ 1.0 2,141,814 1

Hash (cost=75,149.14..75,149.14 rows=2,145,914 width=24) (actual time=3,387.610..3,387.611 rows=2,141,814 loops=1)

  • Buckets: 524,288 Batches: 8 Memory Usage: 14,551kB
8. 1,686.006 1,686.006 ↑ 1.0 2,141,814 1

Seq Scan on fdc_pts_root r (cost=0.00..75,149.14 rows=2,145,914 width=24) (actual time=0.016..1,686.006 rows=2,141,814 loops=1)

9. 0.011 0.117 ↑ 9.9 10 1

Hash (cost=122.54..122.54 rows=99 width=8) (actual time=0.117..0.117 rows=10 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
10. 0.027 0.106 ↑ 9.9 10 1

Nested Loop Left Join (cost=1.82..122.54 rows=99 width=8) (actual time=0.054..0.106 rows=10 loops=1)

11. 0.039 0.039 ↑ 1.0 10 1

Seq Scan on fdc_status_pts c (cost=0.00..1.10 rows=10 width=16) (actual time=0.033..0.039 rows=10 loops=1)

12. 0.010 0.040 ↓ 0.0 0 10

Nested Loop Left Join (cost=1.82..12.04 rows=10 width=8) (actual time=0.004..0.004 rows=0 loops=10)

13. 0.020 0.030 ↓ 0.0 0 10

Nested Loop Left Join (cost=0.42..6.96 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=10)

14. 0.010 0.010 ↓ 0.0 0 10

Index Scan using fdc_user_pk on fdc_user usr (cost=0.27..6.29 rows=1 width=16) (actual time=0.001..0.001 rows=0 loops=10)

  • Index Cond: (c.user_add = id)
15. 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 = usr.person_root_id)
  • Filter: ((statement_timestamp() >= date_from) AND (statement_timestamp() <= date_to))
16. 0.000 0.000 ↓ 0.0 0

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

17. 0.000 0.000 ↓ 0.0 0

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

18. 0.000 0.000 ↓ 0.0 0

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

19. 0.000 0.000 ↓ 0.0 0

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

20. 0.000 0.000 ↓ 0.0 0

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

21. 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)
22. 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
23. 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)
24. 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)
25. 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))
26. 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=8) (never executed)

  • Index Cond: (person_root_id = leg_ver.person_root_id)
  • Filter: ((statement_timestamp() >= date_from) AND (statement_timestamp() <= date_to))
27. 0.014 1.298 ↑ 2.0 10 1

Hash (cost=3.80..3.80 rows=20 width=33) (actual time=1.298..1.298 rows=10 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
28. 1.284 1.284 ↑ 2.0 10 1

Seq Scan on fdc_status_pts_translation t (cost=0.00..3.80 rows=20 width=33) (actual time=0.312..1.284 rows=10 loops=1)

  • Filter: (language_id = lang.get_current_lang_id())
  • Rows Removed by Filter: 50
29. 0.035 0.096 ↓ 30.0 30 1

Hash (cost=8.45..8.45 rows=1 width=8) (actual time=0.096..0.096 rows=30 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 10kB
30. 0.061 0.061 ↓ 30.0 30 1

Index Only Scan using fdc_request_pts_req_i on fdc_request_pts (cost=0.43..8.45 rows=1 width=8) (actual time=0.026..0.061 rows=30 loops=1)

  • Index Cond: (request_id = 16,404,697)
  • Heap Fetches: 30
31. 0.146 5.700 ↑ 10.0 1 30

Nested Loop Left Join (cost=2.38..7.82 rows=10 width=16) (actual time=0.173..0.190 rows=1 loops=30)

32. 2.028 2.670 ↑ 1.0 1 30

Nested Loop Left Join (cost=0.56..1.14 rows=1 width=24) (actual time=0.087..0.089 rows=1 loops=30)

33. 0.390 0.390 ↑ 1.0 1 30

Index Scan using fdc_ts_trademark_pk on fdc_ts_trademark c_1 (cost=0.28..0.29 rows=1 width=16) (actual time=0.012..0.013 rows=1 loops=30)

  • Index Cond: (v.ts_trademark_id = id)
34. 0.252 0.252 ↑ 1.0 1 28

Index Scan using fdc_ts_trademark_translation_vl_i on fdc_ts_trademark_translation t_1 (cost=0.29..0.84 rows=1 width=16) (actual time=0.009..0.009 rows=1 loops=28)

  • Index Cond: ((c_1.id = trademark_id) AND (language_id = lang.get_current_lang_id()))
35. 0.140 2.884 ↑ 10.0 1 28

Nested Loop Left Join (cost=1.82..6.58 rows=10 width=8) (actual time=0.088..0.103 rows=1 loops=28)

36. 0.224 0.784 ↑ 1.0 1 28

Nested Loop Left Join (cost=0.42..1.50 rows=1 width=16) (actual time=0.024..0.028 rows=1 loops=28)

37. 0.168 0.168 ↑ 1.0 1 28

Index Scan using fdc_user_pk on fdc_user usr_1 (cost=0.27..0.83 rows=1 width=16) (actual time=0.006..0.006 rows=1 loops=28)

  • Index Cond: (c_1.user_add = id)
38. 0.392 0.392 ↑ 1.0 1 28

Index Scan using fdc_person_root_date_uk on fdc_person per_2 (cost=0.14..0.66 rows=1 width=16) (actual time=0.014..0.014 rows=1 loops=28)

  • Index Cond: (person_root_id = usr_1.person_root_id)
  • Filter: ((statement_timestamp() >= date_from) AND (statement_timestamp() <= date_to))
39. 0.112 1.960 ↑ 65.0 1 28

Nested Loop Left Join (cost=1.40..4.43 rows=65 width=8) (actual time=0.061..0.070 rows=1 loops=28)

40. 0.140 1.316 ↑ 8.0 1 28

Nested Loop Left Join (cost=1.26..2.43 rows=8 width=16) (actual time=0.040..0.047 rows=1 loops=28)

41. 0.112 0.896 ↑ 1.0 1 28

Nested Loop Left Join (cost=1.11..2.18 rows=1 width=24) (actual time=0.028..0.032 rows=1 loops=28)

42. 0.140 0.672 ↑ 1.0 1 28

Nested Loop Left Join (cost=0.83..1.56 rows=1 width=24) (actual time=0.021..0.024 rows=1 loops=28)

43. 0.140 0.476 ↑ 1.0 1 28

Nested Loop (cost=0.55..0.93 rows=1 width=24) (actual time=0.015..0.017 rows=1 loops=28)

44. 0.196 0.196 ↑ 1.0 1 28

Index Scan using fdc_official_person_pk on fdc_official_person ofp_1 (cost=0.27..0.31 rows=1 width=24) (actual time=0.006..0.007 rows=1 loops=28)

  • Index Cond: (id = per_2.id)
45. 0.140 0.140 ↑ 1.0 1 28

Index Only Scan using fdc_person_pk on fdc_person per_3 (cost=0.28..0.62 rows=1 width=8) (actual time=0.005..0.005 rows=1 loops=28)

  • Index Cond: (id = ofp_1.id)
  • Heap Fetches: 28
46. 0.056 0.056 ↑ 1.0 1 28

Index Scan using fdc_person_pk on fdc_person ind_ver_1 (cost=0.28..0.62 rows=1 width=16) (actual time=0.002..0.002 rows=1 loops=28)

  • Index Cond: (id = ofp_1.individual_id)
47. 0.112 0.112 ↑ 1.0 1 28

Index Scan using fdc_person_pk on fdc_person leg_ver_1 (cost=0.28..0.62 rows=1 width=16) (actual time=0.004..0.004 rows=1 loops=28)

  • Index Cond: (id = ofp_1.legal_person_id)
48. 0.280 0.280 ↑ 1.0 1 28

Index Scan using fdc_person_root_date_uk on fdc_person ind_per_1 (cost=0.14..0.24 rows=1 width=16) (actual time=0.009..0.010 rows=1 loops=28)

  • Index Cond: (person_root_id = ind_ver_1.person_root_id)
  • Filter: ((statement_timestamp() >= date_from) AND (statement_timestamp() <= date_to))
49. 0.532 0.532 ↑ 1.0 1 28

Index Scan using fdc_person_root_date_uk on fdc_person leg_per_1 (cost=0.14..0.24 rows=1 width=8) (actual time=0.018..0.019 rows=1 loops=28)

  • Index Cond: (person_root_id = leg_ver_1.person_root_id)
  • Filter: ((statement_timestamp() >= date_from) AND (statement_timestamp() <= date_to))
  • Rows Removed by Filter: 13
Planning time : 13.029 ms
Execution time : 16,930.880 ms