explain.depesz.com

PostgreSQL's explain analyze made readable

Result: KdFe

Settings
# exclusive inclusive rows x rows loops node
1. 0.110 347,625.770 ↓ 1.7 87 1

Nested Loop Left Join (cost=47,894.37..78,916.85 rows=52 width=733) (actual time=347,590.973..347,625.770 rows=87 loops=1)

2.          

Initplan (for Nested Loop Left Join)

3. 0.009 0.009 ↑ 1.0 1 1

Index Scan using good_pkey on good __t34 (cost=0.42..2.66 rows=1 width=32) (actual time=0.008..0.009 rows=1 loops=1)

  • Index Cond: (id = '7fbd6891-ff72-11e7-6b01-4b1d0018d1d2'::uuid)
  • Filter: (account_id = '7ba9c902-ff62-11e7-7a69-971100005844'::uuid)
4. 0.061 347,625.477 ↓ 1.7 87 1

Hash Left Join (cost=47,891.43..78,894.94 rows=52 width=322) (actual time=347,590.948..347,625.477 rows=87 loops=1)

  • Hash Cond: (__t0.id = __t4.good_id)
  • Join Filter: ((__t0.dtype)::text = 'Kit'::text)
5. 0.057 91.950 ↓ 1.7 87 1

Hash Left Join (cost=34,163.96..65,166.68 rows=52 width=295) (actual time=57.462..91.950 rows=87 loops=1)

  • Hash Cond: (__t2.id = __t3.id)
  • Join Filter: ((__t0.dtype)::text = 'Good'::text)
6. 0.115 71.287 ↓ 1.7 87 1

Hash Left Join (cost=15,723.90..46,725.84 rows=52 width=263) (actual time=36.838..71.287 rows=87 loops=1)

  • Hash Cond: (__t2.id = __t6.id)
7. 0.089 61.178 ↓ 1.7 87 1

Hash Left Join (cost=8,120.67..39,121.95 rows=52 width=231) (actual time=26.763..61.178 rows=87 loops=1)

  • Hash Cond: (__t2.id = __t5.id)
8. 0.000 38.973 ↓ 1.7 87 1

Nested Loop (cost=136.61..31,137.24 rows=52 width=199) (actual time=4.608..38.973 rows=87 loops=1)

9. 5.995 6.998 ↑ 1.1 10,725 1

Bitmap Heap Scan on feature __t2 (cost=136.19..10,428.61 rows=11,266 width=63) (actual time=1.404..6.998 rows=10,725 loops=1)

  • Recheck Cond: (account_id = '7ba9c902-ff62-11e7-7a69-971100005844'::uuid)
  • Filter: (NOT archived)
  • Heap Blocks: exact=2703
10. 1.003 1.003 ↑ 1.1 10,725 1

Bitmap Index Scan on i__feature__account_id (cost=0.00..133.37 rows=11,273 width=0) (actual time=1.003..1.003 rows=10,725 loops=1)

  • Index Cond: (account_id = '7ba9c902-ff62-11e7-7a69-971100005844'::uuid)
11. 32.175 32.175 ↓ 0.0 0 10,725

Index Scan using good_pkey on good __t0 (cost=0.42..1.84 rows=1 width=152) (actual time=0.003..0.003 rows=0 loops=10,725)

  • Index Cond: (id = __t2.parent_id)
  • Filter: ((NOT archived) AND ((dtype)::text = ANY ('{Good,Kit}'::text[])) AND (((path)::text || (id)::text) ~~ $0))
  • Rows Removed by Filter: 1
12. 0.164 22.116 ↓ 9.3 353 1

Hash (cost=7,983.58..7,983.58 rows=38 width=48) (actual time=22.116..22.116 rows=353 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 44kB
13. 0.056 21.952 ↓ 9.3 353 1

Subquery Scan on __t5 (cost=7,980.92..7,983.58 rows=38 width=48) (actual time=20.643..21.952 rows=353 loops=1)

14. 0.927 21.896 ↓ 9.3 353 1

GroupAggregate (cost=7,980.92..7,983.20 rows=38 width=48) (actual time=20.642..21.896 rows=353 loops=1)

  • Group Key: __t23.id
15. 0.314 20.969 ↓ 9.3 353 1

GroupAggregate (cost=7,980.92..7,982.15 rows=38 width=64) (actual time=20.617..20.969 rows=353 loops=1)

  • Group Key: __t23.id, (CASE WHEN (((__t25.path)::text || (__t25.id)::text) ~~ '/7bc6d4c8-ff62-11e7-6b01-4b1d0015f3db%'::text) THEN '7bc6d4c8-ff62-11e7-6b01-4b1d0015f3db'::uuid ELSE NULL::uuid END)
16. 0.215 20.655 ↓ 9.3 353 1

Sort (cost=7,980.92..7,981.01 rows=38 width=35) (actual time=20.590..20.655 rows=353 loops=1)

  • Sort Key: __t23.id, (CASE WHEN (((__t25.path)::text || (__t25.id)::text) ~~ '/7bc6d4c8-ff62-11e7-6b01-4b1d0015f3db%'::text) THEN '7bc6d4c8-ff62-11e7-6b01-4b1d0015f3db'::uuid ELSE NULL::uuid END)
  • Sort Method: quicksort Memory: 52kB
17. 0.239 20.440 ↓ 9.3 353 1

Nested Loop (cost=1,659.16..7,979.92 rows=38 width=35) (actual time=14.221..20.440 rows=353 loops=1)

18. 0.274 18.397 ↓ 11.6 451 1

Nested Loop (cost=1,658.73..7,959.59 rows=39 width=53) (actual time=14.201..18.397 rows=451 loops=1)

19. 0.358 16.770 ↓ 11.6 451 1

Nested Loop (cost=1,658.31..7,940.75 rows=39 width=37) (actual time=14.189..16.770 rows=451 loops=1)

20. 0.146 15.059 ↓ 11.6 451 1

Hash Join (cost=1,657.88..7,862.88 rows=39 width=37) (actual time=14.173..15.059 rows=451 loops=1)

  • Hash Cond: (__t24.store_id = __t25.id)
21. 0.817 3.018 ↑ 17.2 451 1

Bitmap Heap Scan on reserve __t24 (cost=845.43..6,952.64 rows=7,745 width=35) (actual time=2.268..3.018 rows=451 loops=1)

  • Recheck Cond: ((account_id = '7ba9c902-ff62-11e7-7a69-971100005844'::uuid) AND (momentto > '2020-02-06 13:43:00'::timestamp without time zone))
  • Filter: (isvalid AND (momentfrom <= '2020-02-06 13:43:00'::timestamp without time zone) AND (reservetype = 1))
  • Rows Removed by Filter: 182
  • Heap Blocks: exact=448
22. 2.201 2.201 ↑ 13.2 633 1

Bitmap Index Scan on i__reserve_momentto (cost=0.00..843.49 rows=8,345 width=0) (actual time=2.201..2.201 rows=633 loops=1)

  • Index Cond: ((account_id = '7ba9c902-ff62-11e7-7a69-971100005844'::uuid) AND (momentto > '2020-02-06 13:43:00'::timestamp without time zone))
23. 0.022 11.895 ↑ 86.0 1 1

Hash (cost=811.38..811.38 rows=86 width=18) (actual time=11.895..11.895 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
24. 11.873 11.873 ↑ 86.0 1 1

Seq Scan on place __t25 (cost=0.00..811.38 rows=86 width=18) (actual time=1.366..11.873 rows=1 loops=1)

  • Filter: (((path)::text || (id)::text) ~~ '/7bc6d4c8-ff62-11e7-6b01-4b1d0015f3db%'::text)
  • Rows Removed by Filter: 17118
25. 1.353 1.353 ↑ 1.0 1 451

Index Scan using consignment_pkey on consignment __t26 (cost=0.42..2.00 rows=1 width=32) (actual time=0.003..0.003 rows=1 loops=451)

  • Index Cond: (id = __t24.consignment_id)
26. 1.353 1.353 ↑ 1.0 1 451

Index Scan using pk__feature on feature __t23 (cost=0.42..0.48 rows=1 width=32) (actual time=0.003..0.003 rows=1 loops=451)

  • Index Cond: (id = __t26.feature_id)
27. 1.804 1.804 ↑ 1.0 1 451

Index Scan using good_pkey on good __t27 (cost=0.42..0.51 rows=1 width=16) (actual time=0.004..0.004 rows=1 loops=451)

  • Index Cond: (id = __t23.parent_id)
  • Filter: (NOT archived)
  • Rows Removed by Filter: 0
28. 0.037 9.994 ↓ 29.0 87 1

Hash (cost=7,603.20..7,603.20 rows=3 width=48) (actual time=9.994..9.994 rows=87 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 17kB
29. 0.016 9.957 ↓ 29.0 87 1

Subquery Scan on __t6 (cost=7,602.99..7,603.20 rows=3 width=48) (actual time=9.559..9.957 rows=87 loops=1)

30. 0.322 9.941 ↓ 29.0 87 1

GroupAggregate (cost=7,602.99..7,603.17 rows=3 width=48) (actual time=9.557..9.941 rows=87 loops=1)

  • Group Key: __t29.id
31. 0.115 9.619 ↓ 29.0 87 1

GroupAggregate (cost=7,602.99..7,603.08 rows=3 width=64) (actual time=9.524..9.619 rows=87 loops=1)

  • Group Key: __t29.id, (CASE WHEN (((__t31.path)::text || (__t31.id)::text) ~~ '/7bc6d4c8-ff62-11e7-6b01-4b1d0015f3db%'::text) THEN '7bc6d4c8-ff62-11e7-6b01-4b1d0015f3db'::uuid ELSE NULL::uuid END)
32. 0.128 9.504 ↓ 29.0 87 1

Sort (cost=7,602.99..7,602.99 rows=3 width=35) (actual time=9.495..9.504 rows=87 loops=1)

  • Sort Key: __t29.id, (CASE WHEN (((__t31.path)::text || (__t31.id)::text) ~~ '/7bc6d4c8-ff62-11e7-6b01-4b1d0015f3db%'::text) THEN '7bc6d4c8-ff62-11e7-6b01-4b1d0015f3db'::uuid ELSE NULL::uuid END)
  • Sort Method: quicksort Memory: 31kB
33. 0.134 9.376 ↓ 29.0 87 1

Nested Loop (cost=845.20..7,602.96 rows=3 width=35) (actual time=6.843..9.376 rows=87 loops=1)

34. 0.091 8.787 ↓ 30.3 91 1

Nested Loop (cost=844.77..7,601.40 rows=3 width=53) (actual time=6.821..8.787 rows=91 loops=1)

35. 0.029 8.332 ↓ 30.3 91 1

Nested Loop (cost=844.35..7,599.95 rows=3 width=37) (actual time=6.808..8.332 rows=91 loops=1)

36. 0.064 7.848 ↓ 30.3 91 1

Nested Loop (cost=843.92..7,592.26 rows=3 width=37) (actual time=6.790..7.848 rows=91 loops=1)

37. 0.822 7.511 ↑ 6.2 91 1

Bitmap Heap Scan on reserve __t30 (cost=843.63..6,950.85 rows=566 width=35) (actual time=6.763..7.511 rows=91 loops=1)

  • Recheck Cond: ((account_id = '7ba9c902-ff62-11e7-7a69-971100005844'::uuid) AND (momentto > '2020-02-06 13:43:00'::timestamp without time zone))
  • Filter: (isvalid AND (momentfrom <= '2020-02-06 13:43:00'::timestamp without time zone) AND (reservetype = 0))
  • Rows Removed by Filter: 542
  • Heap Blocks: exact=448
38. 6.689 6.689 ↑ 13.2 633 1

Bitmap Index Scan on i__reserve_momentto (cost=0.00..843.49 rows=8,345 width=0) (actual time=6.689..6.689 rows=633 loops=1)

  • Index Cond: ((account_id = '7ba9c902-ff62-11e7-7a69-971100005844'::uuid) AND (momentto > '2020-02-06 13:43:00'::timestamp without time zone))
39. 0.273 0.273 ↑ 1.0 1 91

Index Scan using place_pkey on place __t31 (cost=0.29..1.13 rows=1 width=18) (actual time=0.003..0.003 rows=1 loops=91)

  • Index Cond: (id = __t30.store_id)
  • Filter: (((path)::text || (id)::text) ~~ '/7bc6d4c8-ff62-11e7-6b01-4b1d0015f3db%'::text)
40. 0.455 0.455 ↑ 1.0 1 91

Index Scan using consignment_pkey on consignment __t32 (cost=0.42..2.56 rows=1 width=32) (actual time=0.005..0.005 rows=1 loops=91)

  • Index Cond: (id = __t30.consignment_id)
41. 0.364 0.364 ↑ 1.0 1 91

Index Scan using pk__feature on feature __t29 (cost=0.42..0.48 rows=1 width=32) (actual time=0.004..0.004 rows=1 loops=91)

  • Index Cond: (id = __t32.feature_id)
42. 0.455 0.455 ↑ 1.0 1 91

Index Scan using good_pkey on good __t33 (cost=0.42..0.51 rows=1 width=16) (actual time=0.005..0.005 rows=1 loops=91)

  • Index Cond: (id = __t29.parent_id)
  • Filter: (NOT archived)
  • Rows Removed by Filter: 0
43. 0.103 20.606 ↓ 6.1 503 1

Hash (cost=18,439.03..18,439.03 rows=82 width=48) (actual time=20.606..20.606 rows=503 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 60kB
44. 0.052 20.503 ↓ 6.1 503 1

Subquery Scan on __t3 (cost=18,433.29..18,439.03 rows=82 width=48) (actual time=19.176..20.503 rows=503 loops=1)

45. 0.985 20.451 ↓ 6.1 503 1

GroupAggregate (cost=18,433.29..18,438.21 rows=82 width=48) (actual time=19.175..20.451 rows=503 loops=1)

  • Group Key: __t8.id
46. 0.299 19.466 ↓ 6.1 503 1

GroupAggregate (cost=18,433.29..18,435.95 rows=82 width=64) (actual time=19.151..19.466 rows=503 loops=1)

  • Group Key: __t8.id, (CASE WHEN (((__t10.path)::text || (__t10.id)::text) ~~ '/7bc6d4c8-ff62-11e7-6b01-4b1d0015f3db%'::text) THEN '7bc6d4c8-ff62-11e7-6b01-4b1d0015f3db'::uuid ELSE NULL::uuid END)
47. 0.198 19.167 ↓ 6.1 503 1

Sort (cost=18,433.29..18,433.49 rows=82 width=37) (actual time=19.137..19.167 rows=503 loops=1)

  • Sort Key: __t8.id, (CASE WHEN (((__t10.path)::text || (__t10.id)::text) ~~ '/7bc6d4c8-ff62-11e7-6b01-4b1d0015f3db%'::text) THEN '7bc6d4c8-ff62-11e7-6b01-4b1d0015f3db'::uuid ELSE NULL::uuid END)
  • Sort Method: quicksort Memory: 64kB
48. 0.496 18.969 ↓ 6.1 503 1

Nested Loop (cost=814.28..18,430.68 rows=82 width=37) (actual time=9.564..18.969 rows=503 loops=1)

49. 0.047 16.946 ↓ 6.0 509 1

Nested Loop (cost=813.86..18,386.38 rows=85 width=55) (actual time=9.550..16.946 rows=509 loops=1)

50. 0.177 15.372 ↓ 6.0 509 1

Nested Loop (cost=813.43..18,345.31 rows=85 width=39) (actual time=9.539..15.372 rows=509 loops=1)

51. 0.164 13.668 ↓ 6.0 509 1

Hash Join (cost=813.01..18,209.76 rows=85 width=39) (actual time=9.513..13.668 rows=509 loops=1)

  • Hash Cond: (__t9.store_id = __t10.id)
52. 4.048 4.048 ↑ 33.3 509 1

Index Scan using i__cost_momentto on cost __t9 (cost=0.55..17,183.38 rows=16,945 width=37) (actual time=0.037..4.048 rows=509 loops=1)

  • Index Cond: ((account_id = '7ba9c902-ff62-11e7-7a69-971100005844'::uuid) AND (momentto > '2020-02-06 13:43:00'::timestamp without time zone))
  • Filter: ((initialcost_id IS NULL) AND (motion_id IS NOT NULL) AND isvalid AND (momentfrom <= '2020-02-06 13:43:00'::timestamp without time zone) AND (stock <> '0'::numeric))
  • Rows Removed by Filter: 438
53. 0.006 9.456 ↑ 86.0 1 1

Hash (cost=811.38..811.38 rows=86 width=18) (actual time=9.456..9.456 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
54. 9.450 9.450 ↑ 86.0 1 1

Seq Scan on place __t10 (cost=0.00..811.38 rows=86 width=18) (actual time=1.302..9.450 rows=1 loops=1)

  • Filter: (((path)::text || (id)::text) ~~ '/7bc6d4c8-ff62-11e7-6b01-4b1d0015f3db%'::text)
  • Rows Removed by Filter: 17118
55. 1.527 1.527 ↑ 1.0 1 509

Index Scan using consignment_pkey on consignment __t11 (cost=0.42..1.59 rows=1 width=32) (actual time=0.003..0.003 rows=1 loops=509)

  • Index Cond: (id = __t9.consignment_id)
56. 1.527 1.527 ↑ 1.0 1 509

Index Scan using pk__feature on feature __t8 (cost=0.42..0.48 rows=1 width=32) (actual time=0.003..0.003 rows=1 loops=509)

  • Index Cond: (id = __t11.feature_id)
57. 1.527 1.527 ↑ 1.0 1 509

Index Scan using good_pkey on good __t12 (cost=0.42..0.51 rows=1 width=16) (actual time=0.003..0.003 rows=1 loops=509)

  • Index Cond: (id = __t8.parent_id)
  • Filter: (NOT archived)
  • Rows Removed by Filter: 0
58. 1.770 347,533.466 ↓ 1,364.6 9,552 1

Hash (cost=13,727.39..13,727.39 rows=7 width=48) (actual time=347,533.466..347,533.466 rows=9,552 loops=1)

  • Buckets: 16384 (originally 1024) Batches: 1 (originally 1) Memory Usage: 1102kB
59. 1.001 347,531.696 ↓ 1,364.6 9,552 1

Subquery Scan on __t4 (cost=13,726.92..13,727.39 rows=7 width=48) (actual time=347,486.785..347,531.696 rows=9,552 loops=1)

60. 19.680 347,530.695 ↓ 1,364.6 9,552 1

GroupAggregate (cost=13,726.92..13,727.32 rows=7 width=48) (actual time=347,486.784..347,530.695 rows=9,552 loops=1)

  • Group Key: __t14.kit_id
61. 21.587 347,511.015 ↓ 1,364.6 9,552 1

GroupAggregate (cost=13,726.92..13,727.13 rows=7 width=64) (actual time=347,486.763..347,511.015 rows=9,552 loops=1)

  • Group Key: __t14.kit_id, __t14.root_store_id
62. 24.615 347,489.428 ↓ 7,959.0 55,713 1

Sort (cost=13,726.92..13,726.93 rows=7 width=69) (actual time=347,486.752..347,489.428 rows=55,713 loops=1)

  • Sort Key: __t14.kit_id, __t14.root_store_id
  • Sort Method: quicksort Memory: 5889kB
63. 5.324 347,464.813 ↓ 7,959.0 55,713 1

Subquery Scan on __t14 (cost=13,726.42..13,726.82 rows=7 width=69) (actual time=347,386.493..347,464.813 rows=55,713 loops=1)

64. 67.384 347,459.489 ↓ 7,959.0 55,713 1

GroupAggregate (cost=13,726.42..13,726.75 rows=7 width=85) (actual time=347,386.492..347,459.489 rows=55,713 loops=1)

  • Group Key: __t15.id, (CASE WHEN (((__t19.path)::text || (__t19.id)::text) ~~ '/7bc6d4c8-ff62-11e7-6b01-4b1d0015f3db%'::text) THEN '7bc6d4c8-ff62-11e7-6b01-4b1d0015f3db'::uuid ELSE NULL::uuid END)
65. 123.245 347,392.105 ↓ 7,959.0 55,713 1

Sort (cost=13,726.42..13,726.43 rows=7 width=64) (actual time=347,386.478..347,392.105 rows=55,713 loops=1)

  • Sort Key: __t15.id, (CASE WHEN (((__t19.path)::text || (__t19.id)::text) ~~ '/7bc6d4c8-ff62-11e7-6b01-4b1d0015f3db%'::text) THEN '7bc6d4c8-ff62-11e7-6b01-4b1d0015f3db'::uuid ELSE NULL::uuid END)
  • Sort Method: quicksort Memory: 9371kB
66. 205.642 347,268.860 ↓ 7,959.0 55,713 1

Nested Loop Left Join (cost=10,645.88..13,726.32 rows=7 width=64) (actual time=21.455..347,268.860 rows=55,713 loops=1)

  • Join Filter: (__t19.id = __t18.store_id)
67. 123.430 277,867.672 ↓ 7,959.0 55,713 1

Nested Loop Left Join (cost=10,645.46..13,715.91 rows=7 width=95) (actual time=21.415..277,867.672 rows=55,713 loops=1)

  • Join Filter: (__t19.id = __t17.store_id)
68. 103.712 203,033.109 ↓ 7,959.0 55,713 1

Nested Loop Left Join (cost=10,645.03..13,705.57 rows=7 width=92) (actual time=20.309..203,033.109 rows=55,713 loops=1)

  • Join Filter: (__t19.id = __t16.store_id)
69. 24.986 635.494 ↓ 7,959.0 55,713 1

Nested Loop (cost=10,644.61..13,691.12 rows=7 width=87) (actual time=17.972..635.494 rows=55,713 loops=1)

70. 0.016 0.016 ↑ 1.0 1 1

Index Scan using i__place__account_id on place __t19 (cost=0.29..2.52 rows=1 width=18) (actual time=0.015..0.016 rows=1 loops=1)

  • Index Cond: (account_id = '7ba9c902-ff62-11e7-7a69-971100005844'::uuid)
  • Filter: (((path)::text || (id)::text) ~~ '/7bc6d4c8-ff62-11e7-6b01-4b1d0015f3db%'::text)
71. 114.101 610.492 ↓ 7,959.0 55,713 1

Nested Loop (cost=10,644.32..13,688.54 rows=7 width=69) (actual time=17.954..610.492 rows=55,713 loops=1)

72. 97.014 161.567 ↓ 92.7 55,804 1

Hash Join (cost=10,643.89..12,586.81 rows=602 width=85) (actual time=17.929..161.567 rows=55,804 loops=1)

  • Hash Cond: (__t15.element_id = __t20.feature_id)
73. 46.691 46.691 ↓ 1.0 55,804 1

Seq Scan on kitelement __t15 (cost=0.00..1,727.84 rows=55,750 width=69) (actual time=0.010..46.691 rows=55,804 loops=1)

  • Filter: (account_id = '7ba9c902-ff62-11e7-7a69-971100005844'::uuid)
  • Rows Removed by Filter: 2263
74. 4.858 17.862 ↑ 1.1 10,725 1

Hash (cost=10,502.89..10,502.89 rows=11,280 width=64) (actual time=17.862..17.862 rows=10,725 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 1134kB
75. 12.218 13.004 ↑ 1.1 10,725 1

Bitmap Heap Scan on consignment __t20 (cost=136.25..10,502.89 rows=11,280 width=64) (actual time=1.131..13.004 rows=10,725 loops=1)

  • Recheck Cond: (account_id = '7ba9c902-ff62-11e7-7a69-971100005844'::uuid)
  • Filter: isdefault
  • Heap Blocks: exact=3045
76. 0.786 0.786 ↑ 1.1 10,725 1

Bitmap Index Scan on i__consignment__account_id (cost=0.00..133.43 rows=11,280 width=0) (actual time=0.786..0.786 rows=10,725 loops=1)

  • Index Cond: (account_id = '7ba9c902-ff62-11e7-7a69-971100005844'::uuid)
77. 334.824 334.824 ↑ 1.0 1 55,804

Index Scan using good_pkey on good __t21 (cost=0.42..1.83 rows=1 width=32) (actual time=0.006..0.006 rows=1 loops=55,804)

  • Index Cond: (id = __t20.good_id)
  • Filter: (((dtype)::text <> 'Service'::text) AND (account_id = '7ba9c902-ff62-11e7-7a69-971100005844'::uuid))
  • Rows Removed by Filter: 0
78. 202,293.903 202,293.903 ↑ 1.0 1 55,713

Index Scan using cost_cons_moment on cost __t16 (cost=0.43..2.05 rows=1 width=53) (actual time=3.625..3.631 rows=1 loops=55,713)

  • Index Cond: ((__t20.account_id = account_id) AND (account_id = '7ba9c902-ff62-11e7-7a69-971100005844'::uuid) AND (__t20.id = consignment_id))
  • Filter: ((initialcost_id IS NULL) AND (motion_id IS NOT NULL) AND isvalid AND (momentfrom <= '2020-02-06 13:43:00'::timestamp without time zone) AND (momentto > '2020-02-06 13:43:00'::timestamp without time zone))
  • Rows Removed by Filter: 4487
79. 74,711.133 74,711.133 ↑ 1.0 1 55,713

Index Scan using reserve_isvalid_cons_moment on reserve __t17 (cost=0.42..1.46 rows=1 width=51) (actual time=1.338..1.341 rows=1 loops=55,713)

  • Index Cond: ((account_id = __t20.account_id) AND (account_id = '7ba9c902-ff62-11e7-7a69-971100005844'::uuid) AND (isvalid = true) AND (__t20.id = consignment_id))
  • Filter: ((motion_id IS NOT NULL) AND isvalid AND (momentfrom <= '2020-02-06 13:43:00'::timestamp without time zone) AND (momentto > '2020-02-06 13:43:00'::timestamp without time zone) AND (reservetype = 1))
  • Rows Removed by Filter: 1876
80. 69,195.546 69,195.546 ↑ 1.0 1 55,713

Index Scan using reserve_isvalid_cons_moment on reserve __t18 (cost=0.42..1.46 rows=1 width=51) (actual time=0.397..1.242 rows=1 loops=55,713)

  • Index Cond: ((account_id = __t20.account_id) AND (account_id = '7ba9c902-ff62-11e7-7a69-971100005844'::uuid) AND (isvalid = true) AND (__t20.id = consignment_id))
  • Filter: ((motion_id IS NOT NULL) AND isvalid AND (momentfrom <= '2020-02-06 13:43:00'::timestamp without time zone) AND (momentto > '2020-02-06 13:43:00'::timestamp without time zone) AND (reservetype = 0))
  • Rows Removed by Filter: 1876
81. 0.174 0.174 ↑ 1.0 1 87

Index Scan using uom_pkey on uom __t1 (cost=0.28..0.32 rows=1 width=38) (actual time=0.002..0.002 rows=1 loops=87)

  • Index Cond: (id = __t0.uom_id)
  • Filter: ((account_id = '7ba9c902-ff62-11e7-7a69-971100005844'::uuid) OR (account_id IS NULL))
Planning time : 16.484 ms
Execution time : 347,627.023 ms