explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vfPt

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 0.751 ↑ 1.0 1 1

ON (T27.Fld17745RRef = CASE WHEN T1._Q_000_F_005 = TRUE AND ((COALESCE(T12.Fld20067RRef,T17.Fld20067RRef)) IS NULL) THEN T1._Q_000_F_008RRef ELSE COALESCE(T12.Fld20067RRef,T17.Fld20067RRef) END)",planSQLText="Nested Loop Left Join (cost=630.59..1,108.39 rows=1 width=69) (actual time=0.614..0.751 rows=1 loops=1)

  • Output: t1._q_000_f_000rref, t1._q_000_f_001rref, t1._q_000_f_003rref, t1._q_000_f_004rref, t1._q_000_f_005
  • Join Filter: (t31._fld17745rref = CASE WHEN (t1._q_000_f_005 AND (COALESCE(t16._fld20067rref, t21._fld20067rref) IS NULL)) THEN t1._q_000_f_008rref ELSE COALESCE(t16._fld20067rref, t21._fld20067rref) END)
  • Buffers: shared hit=102, local hit=8
2. 0.001 0.613 ↑ 1.0 1 1

Nested Loop Left Join (cost=624.88..1,098.60 rows=1 width=126) (actual time=0.524..0.613 rows=1 loops=1)

  • Output: t1._q_000_f_000rref, t1._q_000_f_001rref, t1._q_000_f_003rref, t1._q_000_f_004rref, t1._q_000_f_005, t1._q_000_f_008rref, t16._fld20067rref, t21._fld20067rref
  • Buffers: shared hit=98, local hit=7
3. 0.002 0.540 ↑ 1.0 1 1

Nested Loop Left Join (cost=469.57..792.63 rows=1 width=126) (actual time=0.452..0.540 rows=1 loops=1)

  • Output: t1._q_000_f_000rref, t1._q_000_f_001rref, t1._q_000_f_003rref, t1._q_000_f_004rref, t1._q_000_f_005, t1._q_000_f_008rref, t16._fld20067rref, t21._fld20067rref
  • Buffers: shared hit=78, local hit=6
4. 0.001 0.373 ↑ 1.0 1 1

Nested Loop Left Join (cost=316.12..629.55 rows=1 width=126) (actual time=0.322..0.373 rows=1 loops=1)

  • Output: t1._q_000_f_000rref, t1._q_000_f_001rref, t1._q_000_f_003rref, t1._q_000_f_004rref, t1._q_000_f_005, t1._q_000_f_008rref, t16._fld20067rref, t21._fld20067rref
  • Buffers: shared hit=47, local hit=5
5. 0.001 0.304 ↑ 1.0 1 1

Nested Loop Left Join (cost=161.07..323.82 rows=1 width=106) (actual time=0.253..0.304 rows=1 loops=1)

  • Output: t1._q_000_f_000rref, t1._q_000_f_001rref, t1._q_000_f_003rref, t1._q_000_f_004rref, t1._q_000_f_005, t1._q_000_f_008rref, t16._fld20067rref
  • Buffers: shared hit=27, local hit=4
6. 0.004 0.201 ↑ 1.0 1 1

Nested Loop Left Join (cost=5.76..17.85 rows=1 width=86) (actual time=0.151..0.201 rows=1 loops=1)

  • Output: t1._q_000_f_000rref, t1._q_000_f_001rref, t1._q_000_f_003rref, t1._q_000_f_004rref, t1._q_000_f_005, t1._q_000_f_008rref
  • Join Filter: (t1._q_000_f_008rref = t26._fld17745rref)
  • Buffers: shared hit=7, local hit=3
7. 0.007 0.007 ↑ 1.0 1 1

Index Scan using tmpind_0 on pg_temp_4.tt1 t1 (cost=0.05..8.06 rows=1 width=86) (actual time=0.006..0.007 rows=1 loops=1)

  • Output: t1._q_000_f_000rref, t1._q_000_f_001rref, t1._q_000_f_002rref, t1._q_000_f_003rref, t1._q_000_f_004rref, t1._q_000_f_005, t1._q_000_f_006rref, t1._q_000_f_007, t1._q_000_f_008rref
  • Buffers: local hit=2
8. 0.058 0.190 ↑ 2.0 1 1

Hash Join (cost=5.71..9.76 rows=2 width=20) (actual time=0.141..0.190 rows=1 loops=1)

  • Output: t26._fld17745rref
  • Inner Unique: true
  • Hash Cond: ((t26._fld17745rref = t24._fld17745rref) AND (t26._period = (max(t24._period))))
  • Buffers: shared hit=7, local hit=1
9. 0.043 0.043 ↑ 1.0 169 1

Seq Scan on public._inforg17744 t26 (cost=0.00..3.69 rows=169 width=28) (actual time=0.025..0.043 rows=169 loops=1)

  • Output: t26._period, t26._fld17745rref, t26._fld17746, t26._fld17747
  • Buffers: shared hit=2
10. 0.002 0.089 ↑ 4.0 1 1

Hash (cost=5.66..5.66 rows=4 width=28) (actual time=0.089..0.089 rows=1 loops=1)

  • Output: t24._fld17745rref, (max(t24._period))
  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=2, local hit=1
11. 0.008 0.087 ↑ 4.0 1 1

HashAggregate (cost=5.58..5.62 rows=4 width=28) (actual time=0.087..0.087 rows=1 loops=1)

  • Output: t24._fld17745rref, max(t24._period)
  • Group Key: t24._fld17745rref
  • Buffers: shared hit=2, local hit=1
12. 0.035 0.079 ↑ 42.0 1 1

Hash Semi Join (cost=1.02..5.50 rows=42 width=28) (actual time=0.025..0.079 rows=1 loops=1)

  • Output: t24._fld17745rref, t24._period
  • Hash Cond: (t24._fld17745rref = t25._q_000_f_008rref)
  • Buffers: shared hit=2, local hit=1
13. 0.036 0.036 ↑ 1.0 169 1

Seq Scan on public._inforg17744 t24 (cost=0.00..3.86 rows=169 width=28) (actual time=0.008..0.036 rows=169 loops=1)

  • Output: t24._period, t24._fld17745rref, t24._fld17746, t24._fld17747
  • Filter: (t24._period <= '2019-11-25 20:20:20'::timestamp without time zone)
  • Buffers: shared hit=2
14. 0.004 0.008 ↑ 1.0 1 1

Hash (cost=1.01..1.01 rows=1 width=17) (actual time=0.007..0.008 rows=1 loops=1)

  • Output: t25._q_000_f_008rref
  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: local hit=1
15. 0.004 0.004 ↑ 1.0 1 1

Seq Scan on pg_temp_4.tt1 t25 (cost=0.00..1.01 rows=1 width=17) (actual time=0.003..0.004 rows=1 loops=1)

  • Output: t25._q_000_f_008rref
  • Buffers: local hit=1
16. 0.015 0.102 ↑ 1.0 1 1

Hash Join (cost=155.31..305.96 rows=1 width=80) (actual time=0.101..0.102 rows=1 loops=1)

  • Output: t16._fld20064rref, t16._fld20065rref, t16._fld20066rref, t16._fld20067rref
  • Inner Unique: true
  • Hash Cond: ((t16._fld20064rref = t14._fld20064rref) AND (t16._fld20065rref = t14._fld20065rref) AND (t16._fld20066rref = t14._fld20066rref) AND (t16._period = (max(t14._period))))
  • Buffers: shared hit=20, local hit=1
17. 0.029 0.029 ↑ 7.0 6 1

Index Scan using _inforg20063_bydims_rrrt on public._inforg20063 t16 (cost=0.22..150.69 rows=42 width=88) (actual time=0.025..0.029 rows=6 loops=1)

  • Output: t16._period, t16._recordertref, t16._recorderrref, t16._lineno, t16._active, t16._fld20064rref, t16._fld20065rref, t16._fld20066rref, t16._fld20067rref, t16._fld20068, t16._fld20069rref, t16._fld20070, t16._fld20071rref
  • Index Cond: ((t1._q_000_f_004rref = t16._fld20064rref) AND (t1._q_000_f_000rref = t16._fld20065rref) AND (t1._q_000_f_001rref = t16._fld20066rref))
  • Buffers: shared hit=10
18. 0.002 0.058 ↑ 42.0 1 1

Hash (cost=154.50..154.50 rows=42 width=68) (actual time=0.058..0.058 rows=1 loops=1)

  • Output: t14._fld20064rref, t14._fld20065rref, t14._fld20066rref, (max(t14._period))
  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=10, local hit=1
19. 0.005 0.056 ↑ 42.0 1 1

GroupAggregate (cost=153.45..154.08 rows=42 width=68) (actual time=0.056..0.056 rows=1 loops=1)

  • Output: t14._fld20064rref, t14._fld20065rref, t14._fld20066rref, max(t14._period)
  • Group Key: t14._fld20065rref, t14._fld20064rref, t14._fld20066rref
  • Buffers: shared hit=10, local hit=1
20. 0.014 0.051 ↑ 7.0 6 1

Sort (cost=153.45..153.49 rows=42 width=68) (actual time=0.051..0.051 rows=6 loops=1)

  • Output: t14._fld20064rref, t14._fld20065rref, t14._fld20066rref, t14._period
  • Sort Key: t14._fld20065rref, t14._fld20064rref, t14._fld20066rref
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=10, local hit=1
21. 0.003 0.037 ↑ 7.0 6 1

Nested Loop (cost=1.24..152.18 rows=42 width=68) (actual time=0.027..0.037 rows=6 loops=1)

  • Output: t14._fld20064rref, t14._fld20065rref, t14._fld20066rref, t14._period
  • Buffers: shared hit=10, local hit=1
22. 0.001 0.014 ↑ 1.0 1 1

Unique (cost=1.01..1.02 rows=1 width=51) (actual time=0.013..0.014 rows=1 loops=1)

  • Output: t15._q_000_f_004rref, t15._q_000_f_000rref, t15._q_000_f_001rref
  • Buffers: local hit=1
23. 0.009 0.013 ↑ 1.0 1 1

Sort (cost=1.01..1.02 rows=1 width=51) (actual time=0.012..0.013 rows=1 loops=1)

  • Output: t15._q_000_f_004rref, t15._q_000_f_000rref, t15._q_000_f_001rref
  • Sort Key: t15._q_000_f_004rref, t15._q_000_f_000rref, t15._q_000_f_001rref
  • Sort Method: quicksort Memory: 25kB
  • Buffers: local hit=1
24. 0.004 0.004 ↑ 1.0 1 1

Seq Scan on pg_temp_4.tt1 t15 (cost=0.00..1.01 rows=1 width=51) (actual time=0.003..0.004 rows=1 loops=1)

  • Output: t15._q_000_f_004rref, t15._q_000_f_000rref, t15._q_000_f_001rref
  • Buffers: local hit=1
25. 0.020 0.020 ↑ 7.0 6 1

Index Scan using _inforg20063_bydims_rrrt on public._inforg20063 t14 (cost=0.22..150.74 rows=42 width=68) (actual time=0.011..0.020 rows=6 loops=1)

  • Output: t14._period, t14._recordertref, t14._recorderrref, t14._lineno, t14._active, t14._fld20064rref, t14._fld20065rref, t14._fld20066rref, t14._fld20067rref, t14._fld20068, t14._fld20069rref, t14._fld20070, t14._fld20071rref
  • Index Cond: ((t14._fld20064rref = t15._q_000_f_004rref) AND (t14._fld20065rref = t15._q_000_f_000rref) AND (t14._fld20066rref = t15._q_000_f_001rref) AND (t14._period <= '2019-11-25 20:20:20'::timestamp without time zone))
  • Filter: t14._active
  • Buffers: shared hit=10
26. 0.012 0.068 ↑ 1.0 1 1

Hash Join (cost=155.05..305.72 rows=1 width=60) (actual time=0.067..0.068 rows=1 loops=1)

  • Output: t21._fld20064rref, t21._fld20065rref, t21._fld20067rref
  • Hash Cond: ((t21._fld20064rref = t19._fld20064rref) AND (t21._fld20065rref = t19._fld20065rref) AND (t21._period = (max(t19._period))))
  • Buffers: shared hit=20, local hit=1
27. 0.013 0.013 ↑ 7.0 6 1

Index Scan using _inforg20063_bydims_rrrt on public._inforg20063 t21 (cost=0.22..150.69 rows=42 width=88) (actual time=0.009..0.013 rows=6 loops=1)

  • Output: t21._period, t21._recordertref, t21._recorderrref, t21._lineno, t21._active, t21._fld20064rref, t21._fld20065rref, t21._fld20066rref, t21._fld20067rref, t21._fld20068, t21._fld20069rref, t21._fld20070, t21._fld20071rref
  • Index Cond: ((t1._q_000_f_004rref = t21._fld20064rref) AND (t1._q_000_f_000rref = t21._fld20065rref) AND (t21._fld20066rref = '\\x00000000000000000000000000000000'::bytea))
  • Buffers: shared hit=10
28. 0.002 0.043 ↑ 42.0 1 1

Hash (cost=154.28..154.28 rows=42 width=68) (actual time=0.043..0.043 rows=1 loops=1)

  • Output: t19._fld20064rref, t19._fld20065rref, t19._fld20066rref, (max(t19._period))
  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=10, local hit=1
29. 0.003 0.041 ↑ 42.0 1 1

GroupAggregate (cost=153.23..153.86 rows=42 width=68) (actual time=0.041..0.041 rows=1 loops=1)

  • Output: t19._fld20064rref, t19._fld20065rref, t19._fld20066rref, max(t19._period)
  • Group Key: t19._fld20065rref, t19._fld20064rref, t19._fld20066rref
  • Buffers: shared hit=10, local hit=1
30. 0.009 0.038 ↑ 7.0 6 1

Sort (cost=153.23..153.27 rows=42 width=68) (actual time=0.037..0.038 rows=6 loops=1)

  • Output: t19._fld20064rref, t19._fld20065rref, t19._fld20066rref, t19._period
  • Sort Key: t19._fld20065rref, t19._fld20064rref
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=10, local hit=1
31. 0.004 0.029 ↑ 7.0 6 1

Nested Loop (cost=1.24..152.17 rows=42 width=68) (actual time=0.022..0.029 rows=6 loops=1)

  • Output: t19._fld20064rref, t19._fld20065rref, t19._fld20066rref, t19._period
  • Buffers: shared hit=10, local hit=1
32. 0.000 0.010 ↑ 1.0 1 1

Unique (cost=1.01..1.02 rows=1 width=34) (actual time=0.010..0.010 rows=1 loops=1)

  • Output: t20._q_000_f_004rref, t20._q_000_f_000rref
  • Buffers: local hit=1
33. 0.006 0.010 ↑ 1.0 1 1

Sort (cost=1.01..1.02 rows=1 width=34) (actual time=0.009..0.010 rows=1 loops=1)

  • Output: t20._q_000_f_004rref, t20._q_000_f_000rref
  • Sort Key: t20._q_000_f_004rref, t20._q_000_f_000rref
  • Sort Method: quicksort Memory: 25kB
  • Buffers: local hit=1
34. 0.004 0.004 ↑ 1.0 1 1

Seq Scan on pg_temp_4.tt1 t20 (cost=0.00..1.01 rows=1 width=34) (actual time=0.003..0.004 rows=1 loops=1)

  • Output: t20._q_000_f_004rref, t20._q_000_f_000rref
  • Buffers: local hit=1
35. 0.015 0.015 ↑ 7.0 6 1

Index Scan using _inforg20063_bydims_rrrt on public._inforg20063 t19 (cost=0.22..150.74 rows=42 width=68) (actual time=0.011..0.015 rows=6 loops=1)

  • Output: t19._period, t19._recordertref, t19._recorderrref, t19._lineno, t19._active, t19._fld20064rref, t19._fld20065rref, t19._fld20066rref, t19._fld20067rref, t19._fld20068, t19._fld20069rref, t19._fld20070, t19._fld20071rref
  • Index Cond: ((t19._fld20064rref = t20._q_000_f_004rref) AND (t19._fld20065rref = t20._q_000_f_000rref) AND (t19._fld20066rref = '\\x00000000000000000000000000000000'::bytea) AND (t19._period <= '2019-11-25 20:20:20'::timestamp without time zone))
  • Filter: t19._active
  • Buffers: shared hit=10
36. 0.023 0.165 ↑ 1.0 1 1

Nested Loop (cost=153.45..163.07 rows=1 width=20) (actual time=0.129..0.165 rows=1 loops=1)

  • Output: t11._fld20065rref
  • Join Filter: ((t11._fld20064rref = t9._fld20064rref) AND (t11._fld20065rref = t9._fld20065rref) AND (t11._period = (max(t9._period))))
  • Rows Removed by Join Filter: 16
  • Buffers: shared hit=31, local hit=1
37. 0.057 0.057 ↓ 17.0 17 1

Index Only Scan using _inforg20063_bydims20073_rtrr on public._inforg20063 t11 (cost=0.22..8.24 rows=1 width=68) (actual time=0.030..0.057 rows=17 loops=1)

  • Output: t11._fld20065rref, t11._period, t11._fld20064rref, t11._fld20066rref
  • Index Cond: ((t11._fld20065rref = t1._q_000_f_000rref) AND (t11._fld20065rref = t1._q_000_f_000rref) AND (t11._fld20066rref = '\\x00000000000000000000000000000000'::bytea))
  • Heap Fetches: 17
  • Buffers: shared hit=21
38. 0.034 0.085 ↑ 42.0 1 17

GroupAggregate (cost=153.23..153.86 rows=42 width=68) (actual time=0.005..0.005 rows=1 loops=17)

  • Output: t9._fld20064rref, t9._fld20065rref, t9._fld20066rref, max(t9._period)
  • Group Key: t9._fld20065rref, t9._fld20064rref, t9._fld20066rref
  • Buffers: shared hit=10, local hit=1
39. 0.022 0.051 ↑ 7.0 6 17

Sort (cost=153.23..153.27 rows=42 width=68) (actual time=0.002..0.003 rows=6 loops=17)

  • Output: t9._fld20064rref, t9._fld20065rref, t9._fld20066rref, t9._period
  • Sort Key: t9._fld20065rref, t9._fld20064rref
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=10, local hit=1
40. 0.003 0.029 ↑ 7.0 6 1

Nested Loop (cost=1.24..152.17 rows=42 width=68) (actual time=0.022..0.029 rows=6 loops=1)

  • Output: t9._fld20064rref, t9._fld20065rref, t9._fld20066rref, t9._period
  • Buffers: shared hit=10, local hit=1
41. 0.001 0.010 ↑ 1.0 1 1

Unique (cost=1.01..1.02 rows=1 width=34) (actual time=0.009..0.010 rows=1 loops=1)

  • Output: t10._q_000_f_003rref, t10._q_000_f_000rref
  • Buffers: local hit=1
42. 0.006 0.009 ↑ 1.0 1 1

Sort (cost=1.01..1.02 rows=1 width=34) (actual time=0.009..0.009 rows=1 loops=1)

  • Output: t10._q_000_f_003rref, t10._q_000_f_000rref
  • Sort Key: t10._q_000_f_003rref, t10._q_000_f_000rref
  • Sort Method: quicksort Memory: 25kB
  • Buffers: local hit=1
43. 0.003 0.003 ↑ 1.0 1 1

Seq Scan on pg_temp_4.tt1 t10 (cost=0.00..1.01 rows=1 width=34) (actual time=0.003..0.003 rows=1 loops=1)

  • Output: t10._q_000_f_003rref, t10._q_000_f_000rref
  • Buffers: local hit=1
44. 0.016 0.016 ↑ 7.0 6 1

Index Scan using _inforg20063_bydims_rrrt on public._inforg20063 t9 (cost=0.22..150.74 rows=42 width=68) (actual time=0.011..0.016 rows=6 loops=1)

  • Output: t9._period, t9._recordertref, t9._recorderrref, t9._lineno, t9._active, t9._fld20064rref, t9._fld20065rref, t9._fld20066rref, t9._fld20067rref, t9._fld20068, t9._fld20069rref, t9._fld20070, t9._fld20071rref
  • Index Cond: ((t9._fld20064rref = t10._q_000_f_003rref) AND (t9._fld20065rref = t10._q_000_f_000rref) AND (t9._fld20066rref = '\\x00000000000000000000000000000000'::bytea) AND (t9._period <= '2019-11-25 20:20:20'::timestamp without time zone))
  • Filter: t9._active
  • Buffers: shared hit=10
45. 0.013 0.072 ↑ 1.0 1 1

Hash Join (cost=155.31..305.96 rows=1 width=60) (actual time=0.071..0.072 rows=1 loops=1)

  • Output: t6._fld20064rref, t6._fld20065rref, t6._fld20066rref
  • Inner Unique: true
  • Hash Cond: ((t6._fld20064rref = t4._fld20064rref) AND (t6._fld20065rref = t4._fld20065rref) AND (t6._fld20066rref = t4._fld20066rref) AND (t6._period = (max(t4._period))))
  • Buffers: shared hit=20, local hit=1
46. 0.015 0.015 ↑ 7.0 6 1

Index Only Scan using _inforg20063_bydims_rrrt on public._inforg20063 t6 (cost=0.22..150.69 rows=42 width=68) (actual time=0.011..0.015 rows=6 loops=1)

  • Output: t6._fld20064rref, t6._fld20065rref, t6._fld20066rref, t6._period
  • Index Cond: ((t6._fld20064rref = t1._q_000_f_003rref) AND (t6._fld20065rref = t1._q_000_f_000rref) AND (t6._fld20066rref = t1._q_000_f_001rref))
  • Heap Fetches: 6
  • Buffers: shared hit=10
47. 0.002 0.044 ↑ 42.0 1 1

Hash (cost=154.50..154.50 rows=42 width=68) (actual time=0.044..0.044 rows=1 loops=1)

  • Output: t4._fld20064rref, t4._fld20065rref, t4._fld20066rref, (max(t4._period))
  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=10, local hit=1
48. 0.003 0.042 ↑ 42.0 1 1

GroupAggregate (cost=153.45..154.08 rows=42 width=68) (actual time=0.042..0.042 rows=1 loops=1)

  • Output: t4._fld20064rref, t4._fld20065rref, t4._fld20066rref, max(t4._period)
  • Group Key: t4._fld20065rref, t4._fld20064rref, t4._fld20066rref
  • Buffers: shared hit=10, local hit=1
49. 0.010 0.039 ↑ 7.0 6 1

Sort (cost=153.45..153.49 rows=42 width=68) (actual time=0.038..0.039 rows=6 loops=1)

  • Output: t4._fld20064rref, t4._fld20065rref, t4._fld20066rref, t4._period
  • Sort Key: t4._fld20065rref, t4._fld20064rref, t4._fld20066rref
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=10, local hit=1
50. 0.004 0.029 ↑ 7.0 6 1

Nested Loop (cost=1.24..152.18 rows=42 width=68) (actual time=0.022..0.029 rows=6 loops=1)

  • Output: t4._fld20064rref, t4._fld20065rref, t4._fld20066rref, t4._period
  • Buffers: shared hit=10, local hit=1
51. 0.000 0.010 ↑ 1.0 1 1

Unique (cost=1.01..1.02 rows=1 width=51) (actual time=0.010..0.010 rows=1 loops=1)

  • Output: t5._q_000_f_003rref, t5._q_000_f_000rref, t5._q_000_f_001rref
  • Buffers: local hit=1
52. 0.007 0.010 ↑ 1.0 1 1

Sort (cost=1.01..1.02 rows=1 width=51) (actual time=0.010..0.010 rows=1 loops=1)

  • Output: t5._q_000_f_003rref, t5._q_000_f_000rref, t5._q_000_f_001rref
  • Sort Key: t5._q_000_f_003rref, t5._q_000_f_000rref, t5._q_000_f_001rref
  • Sort Method: quicksort Memory: 25kB
  • Buffers: local hit=1
53. 0.003 0.003 ↑ 1.0 1 1

Seq Scan on pg_temp_4.tt1 t5 (cost=0.00..1.01 rows=1 width=51) (actual time=0.003..0.003 rows=1 loops=1)

  • Output: t5._q_000_f_003rref, t5._q_000_f_000rref, t5._q_000_f_001rref
  • Buffers: local hit=1
54. 0.015 0.015 ↑ 7.0 6 1

Index Scan using _inforg20063_bydims_rrrt on public._inforg20063 t4 (cost=0.22..150.74 rows=42 width=68) (actual time=0.011..0.015 rows=6 loops=1)

  • Output: t4._period, t4._recordertref, t4._recorderrref, t4._lineno, t4._active, t4._fld20064rref, t4._fld20065rref, t4._fld20066rref, t4._fld20067rref, t4._fld20068, t4._fld20069rref, t4._fld20070, t4._fld20071rref
  • Index Cond: ((t4._fld20064rref = t5._q_000_f_003rref) AND (t4._fld20065rref = t5._q_000_f_000rref) AND (t4._fld20066rref = t5._q_000_f_001rref) AND (t4._period <= '2019-11-25 20:20:20'::timestamp without time zone))
  • Filter: t4._active
  • Buffers: shared hit=10
55. 0.040 0.136 ↑ 2.0 1 1

Hash Join (cost=5.71..9.76 rows=2 width=20) (actual time=0.089..0.136 rows=1 loops=1)

  • Output: t31._fld17745rref
  • Inner Unique: true
  • Hash Cond: ((t31._fld17745rref = t29._fld17745rref) AND (t31._period = (max(t29._period))))
  • Buffers: shared hit=4, local hit=1
56. 0.023 0.023 ↑ 1.0 169 1

Seq Scan on public._inforg17744 t31 (cost=0.00..3.69 rows=169 width=28) (actual time=0.006..0.023 rows=169 loops=1)

  • Output: t31._period, t31._fld17745rref, t31._fld17746, t31._fld17747
  • Buffers: shared hit=2
57. 0.001 0.073 ↑ 4.0 1 1

Hash (cost=5.66..5.66 rows=4 width=28) (actual time=0.073..0.073 rows=1 loops=1)

  • Output: t29._fld17745rref, (max(t29._period))
  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=2, local hit=1
58. 0.002 0.072 ↑ 4.0 1 1

HashAggregate (cost=5.58..5.62 rows=4 width=28) (actual time=0.072..0.072 rows=1 loops=1)

  • Output: t29._fld17745rref, max(t29._period)
  • Group Key: t29._fld17745rref
  • Buffers: shared hit=2, local hit=1
59. 0.034 0.070 ↑ 42.0 1 1

Hash Semi Join (cost=1.02..5.50 rows=42 width=28) (actual time=0.018..0.070 rows=1 loops=1)

  • Output: t29._fld17745rref, t29._period
  • Hash Cond: (t29._fld17745rref = t30._q_000_f_008rref)
  • Buffers: shared hit=2, local hit=1
60. 0.032 0.032 ↑ 1.0 169 1

Seq Scan on public._inforg17744 t29 (cost=0.00..3.86 rows=169 width=28) (actual time=0.006..0.032 rows=169 loops=1)

  • Output: t29._period, t29._fld17745rref, t29._fld17746, t29._fld17747
  • Filter: (t29._period <= '2019-11-25 20:20:20'::timestamp without time zone)
  • Buffers: shared hit=2
61. 0.001 0.004 ↑ 1.0 1 1

Hash (cost=1.01..1.01 rows=1 width=17) (actual time=0.004..0.004 rows=1 loops=1)

  • Output: t30._q_000_f_008rref
  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: local hit=1
62. 0.003 0.003 ↑ 1.0 1 1

Seq Scan on pg_temp_4.tt1 t30 (cost=0.00..1.01 rows=1 width=17) (actual time=0.003..0.003 rows=1 loops=1)

  • Output: t30._q_000_f_008rref
  • Buffers: local hit=1
Planning time : 173.009 ms
Execution time : 1.125 ms