explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dLri

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 45,641.602 ↓ 11.0 11 1

Limit (cost=78,942.91..78,942.92 rows=1 width=1,660) (actual time=45,641.591..45,641.602 rows=11 loops=1)

2. 119.520 45,641.598 ↓ 11.0 11 1

Sort (cost=78,942.91..78,942.92 rows=1 width=1,660) (actual time=45,641.589..45,641.598 rows=11 loops=1)

  • Sort Key: selectprod0_.changestamp DESC NULLS LAST, selectprod0_.id
  • Sort Method: top-N heapsort Memory: 31kB
3. 63.302 45,522.078 ↓ 32,297.0 32,297 1

Nested Loop Left Join (cost=6.02..78,942.90 rows=1 width=1,660) (actual time=4.102..45,522.078 rows=32,297 loops=1)

4. 12,808.713 45,426.479 ↓ 32,297.0 32,297 1

Nested Loop Left Join (cost=5.73..78,941.52 rows=1 width=1,661) (actual time=4.082..45,426.479 rows=32,297 loops=1)

  • Join Filter: (point6_.id = pointkladr7_.owner_id)
  • Rows Removed by Join Filter: 57940818
5. 12,853.914 26,352.148 ↓ 32,297.0 32,297 1

Nested Loop Left Join (cost=5.73..78,837.13 rows=1 width=1,548) (actual time=2.183..26,352.148 rows=32,297 loops=1)

  • Join Filter: (selectprod0_4_.point_id = point6_.id)
  • Rows Removed by Join Filter: 57843927
6. 60.150 6,554.379 ↓ 32,297.0 32,297 1

Nested Loop Left Join (cost=5.73..78,710.81 rows=1 width=1,502) (actual time=1.076..6,554.379 rows=32,297 loops=1)

7. 40.317 6,235.853 ↓ 32,297.0 32,297 1

Nested Loop Left Join (cost=5.44..78,708.32 rows=1 width=1,451) (actual time=1.075..6,235.853 rows=32,297 loops=1)

8. 64.942 5,904.863 ↓ 32,297.0 32,297 1

Nested Loop Left Join (cost=5.15..78,706.94 rows=1 width=1,451) (actual time=1.068..5,904.863 rows=32,297 loops=1)

9. 70.009 5,581.545 ↓ 32,297.0 32,297 1

Nested Loop Left Join (cost=4.72..78,704.30 rows=1 width=310) (actual time=1.066..5,581.545 rows=32,297 loops=1)

10. 337.386 5,285.457 ↓ 32,297.0 32,297 1

Nested Loop Left Join (cost=4.15..78,702.26 rows=1 width=309) (actual time=1.057..5,285.457 rows=32,297 loops=1)

  • Join Filter: (company2_.partner_id = partner3_.id)
  • Rows Removed by Join Filter: 678237
11. 447.826 4,818.883 ↓ 32,297.0 32,297 1

Nested Loop Left Join (cost=4.15..78,700.76 rows=1 width=237) (actual time=1.037..4,818.883 rows=32,297 loops=1)

  • Join Filter: (selectprod0_4_.company_id = company2_.id)
  • Rows Removed by Join Filter: 1227286
12. 506.898 4,080.384 ↓ 32,297.0 32,297 1

Nested Loop Left Join (cost=4.15..78,694.88 rows=1 width=192) (actual time=0.962..4,080.384 rows=32,297 loops=1)

  • Join Filter: (bankinfo1_.id = bankinfo1_1_.owner_id)
  • Rows Removed by Join Filter: 2020714
13. 43.768 3,282.813 ↓ 32,297.0 32,297 1

Nested Loop Left Join (cost=4.15..78,691.47 rows=1 width=174) (actual time=0.910..3,282.813 rows=32,297 loops=1)

14. 53.387 3,109.857 ↓ 32,297.0 32,297 1

Nested Loop (cost=3.58..78,689.42 rows=1 width=173) (actual time=0.893..3,109.857 rows=32,297 loops=1)

  • Join Filter: (selectprod0_.id = selectprod0_9_.owner_id)
15. 89.566 2,765.797 ↓ 32,297.0 32,297 1

Nested Loop (cost=3.15..78,687.88 rows=1 width=209) (actual time=0.768..2,765.797 rows=32,297 loops=1)

  • Join Filter: (selectprod0_.id = selectprod0_5_.owner_id)
16. 90.814 2,191.776 ↓ 32,297.0 32,297 1

Nested Loop (cost=2.72..78,685.22 rows=1 width=185) (actual time=0.704..2,191.776 rows=32,297 loops=1)

  • Join Filter: (selectprod0_.id = selectprod0_1_.owner_id)
17. 69.898 1,713.398 ↓ 32,297.0 32,297 1

Nested Loop (cost=2.29..78,682.57 rows=1 width=105) (actual time=0.634..1,713.398 rows=32,297 loops=1)

  • Join Filter: (selectprod0_.id = selectprod0_4_.owner_id)
18. 46.241 1,320.530 ↓ 6,459.4 32,297 1

Nested Loop (cost=1.86..78,669.40 rows=5 width=45) (actual time=0.561..1,320.530 rows=32,297 loops=1)

  • Join Filter: (selectprod0_.id = selectprod0_2_.owner_id)
19. 71.097 1,015.913 ↓ 922.8 32,297 1

Nested Loop (cost=1.43..78,614.35 rows=35 width=39) (actual time=0.440..1,015.913 rows=32,297 loops=1)

  • Join Filter: (selectprod0_.id = selectprod0_6_.owner_id)
20. 68.910 718.737 ↓ 41.2 32,297 1

Nested Loop (cost=1.00..77,405.46 rows=783 width=33) (actual time=0.332..718.737 rows=32,297 loops=1)

21. 359.154 359.154 ↓ 1.8 32,297 1

Index Scan using test_idx_ups_doc__module__type__createstamp on ups_doc selectprod0_ (cost=0.57..33,805.49 rows=17,836 width=27) (actual time=0.204..359.154 rows=32,297 loops=1)

  • Index Cond: (((doc_module)::text = 'mc'::text) AND ((doc_type)::text = 'select_product'::text) AND (createstamp >= '2019-11-30 00:00:00'::timestamp without time zone) AND (createstamp <= '2019-12-03 23:59:59'::timestamp without time zone))
  • Filter: (((doc_status)::text <> 'delete'::text) AND (isarchive = '0'::numeric) AND (istemplate = '0'::numeric))
22. 290.673 290.673 ↑ 1.0 1 32,297

Index Only Scan using pk_mc_doc_cl_ownership on mc_doc_cl_ownership selectprod0_3_ (cost=0.43..2.43 rows=1 width=6) (actual time=0.009..0.009 rows=1 loops=32,297)

  • Index Cond: (owner_id = selectprod0_.id)
  • Heap Fetches: 21144
23. 226.079 226.079 ↑ 1.0 1 32,297

Index Only Scan using pk_mc_doc_employment on mc_doc_employment selectprod0_6_ (cost=0.43..1.53 rows=1 width=6) (actual time=0.007..0.007 rows=1 loops=32,297)

  • Index Cond: (owner_id = selectprod0_3_.owner_id)
  • Heap Fetches: 20757
24. 258.376 258.376 ↑ 1.0 1 32,297

Index Only Scan using pk_mc_dic on mc_dic selectprod0_2_ (cost=0.43..1.56 rows=1 width=6) (actual time=0.007..0.008 rows=1 loops=32,297)

  • Index Cond: (owner_id = selectprod0_6_.owner_id)
  • Heap Fetches: 22789
25. 322.970 322.970 ↑ 1.0 1 32,297

Index Scan using pk_mc_doc_product on mc_doc_product selectprod0_4_ (cost=0.43..2.62 rows=1 width=60) (actual time=0.009..0.010 rows=1 loops=32,297)

  • Index Cond: (owner_id = selectprod0_2_.owner_id)
26. 387.564 387.564 ↑ 1.0 1 32,297

Index Scan using pk_mc_usr_fl_client on mc_usr_fl_client selectprod0_1_ (cost=0.43..2.64 rows=1 width=80) (actual time=0.011..0.012 rows=1 loops=32,297)

  • Index Cond: (owner_id = selectprod0_2_.owner_id)
27. 484.455 484.455 ↑ 1.0 1 32,297

Index Scan using pk_mc_doc_product_prm on mc_doc_product_prm selectprod0_5_ (cost=0.43..2.65 rows=1 width=24) (actual time=0.014..0.015 rows=1 loops=32,297)

  • Index Cond: (owner_id = selectprod0_2_.owner_id)
28. 290.673 290.673 ↑ 1.0 1 32,297

Index Only Scan using pk_mc_usr_fl_find on mc_usr_fl_find selectprod0_9_ (cost=0.43..1.53 rows=1 width=6) (actual time=0.008..0.009 rows=1 loops=32,297)

  • Index Cond: (owner_id = selectprod0_2_.owner_id)
  • Heap Fetches: 21163
29. 129.188 129.188 ↓ 0.0 0 32,297

Index Only Scan using pk_ups_doc on ups_doc bankinfo1_ (cost=0.57..2.03 rows=1 width=7) (actual time=0.004..0.004 rows=0 loops=32,297)

  • Index Cond: (id = selectprod0_5_.integration_id)
  • Heap Fetches: 7771
30. 290.673 290.673 ↑ 1.0 63 32,297

Seq Scan on ups_doc_title bankinfo1_1_ (cost=0.00..2.63 rows=63 width=31) (actual time=0.003..0.009 rows=63 loops=32,297)

31. 290.673 290.673 ↑ 1.0 39 32,297

Seq Scan on mc_customer company2_ (cost=0.00..5.39 rows=39 width=51) (actual time=0.002..0.009 rows=39 loops=32,297)

32. 129.188 129.188 ↑ 1.0 22 32,297

Seq Scan on mc_partner_info partner3_ (cost=0.00..1.22 rows=22 width=79) (actual time=0.002..0.004 rows=22 loops=32,297)

33. 226.079 226.079 ↓ 0.0 0 32,297

Index Only Scan using pk_ups_doc on ups_doc offer4_ (cost=0.57..2.03 rows=1 width=7) (actual time=0.007..0.007 rows=0 loops=32,297)

  • Index Cond: (id = selectprod0_5_.offer_id)
  • Heap Fetches: 9022
34. 258.376 258.376 ↓ 0.0 0 32,297

Index Scan using pk_mc_doc_offer on mc_doc_offer offer4_1_ (cost=0.43..2.63 rows=1 width=1,154) (actual time=0.008..0.008 rows=0 loops=32,297)

  • Index Cond: (offer4_.id = owner_id)
35. 290.673 290.673 ↑ 1.0 1 32,297

Index Only Scan using pk_mc_usr_user on mc_usr_user operatorpr5_ (cost=0.29..1.37 rows=1 width=6) (actual time=0.008..0.009 rows=1 loops=32,297)

  • Index Cond: (id = selectprod0_4_.client_id)
  • Heap Fetches: 17235
36. 258.376 258.376 ↑ 1.0 1 32,297

Index Scan using pk_ups_doc_subject on ups_doc_subject operatorpr5_2_ (cost=0.29..2.48 rows=1 width=57) (actual time=0.008..0.008 rows=1 loops=32,297)

  • Index Cond: (operatorpr5_.id = owner_id)
37. 6,943.855 6,943.855 ↑ 1.0 1,792 32,297

Seq Scan on mc_point point6_ (cost=0.00..103.92 rows=1,792 width=52) (actual time=0.004..0.215 rows=1,792 loops=32,297)

38. 6,265.618 6,265.618 ↑ 1.0 1,795 32,297

Seq Scan on kladr_addr pointkladr7_ (cost=0.00..81.95 rows=1,795 width=119) (actual time=0.003..0.194 rows=1,795 loops=32,297)

39. 32.297 32.297 ↓ 0.0 0 32,297

Index Only Scan using pk_mc_usr_user on mc_usr_user operatorpr8_ (cost=0.29..1.37 rows=1 width=6) (actual time=0.001..0.001 rows=0 loops=32,297)

  • Index Cond: (id = selectprod0_4_.processed_by_operator_id)
  • Heap Fetches: 273
Planning time : 52.131 ms
Execution time : 45,642.716 ms