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

02:59.310000-351999,DBPOSTGRS,7,process=rphost,p:processName=eurasia_e,OSThread=11354,t:clientID=1547,t:applicationName=1CV8,t:computerName=PCA82,t:connectID=284,SessionID=9,Usr=Майский Евгений,DBMS=DBPOSTGRS,DataBase='localhost port=5433\eurasia_e',Trans=0,dbpid=11165,Sql="SELECTT1._Q_000_F_000RRef,T1._Q_000_F_001RRef,T1._Q_000_F_003RRef,T1._Q_000_F_004RRef,T1._Q_000_F_005FROM pg_temp.tt1 T1LEFT OUTER JOIN (SELECTT6._Fld20065RRef AS Fld20065RRef,T6._Fld20066RRef AS Fld20066RRef,T6._Fld20064RRef AS Fld20064RRefFROM (SELECTT4._Fld20064RRef AS Fld20064RRef,T4._Fld20065RRef AS Fld20065RRef,T4._Fld20066RRef AS Fld20066RRef,MAX(T4._Period) AS MAXPERIOD_FROM _InfoRg20063 T4WHERE T4._Period <= '2019-11-25 20:20:20'::timestamp AND T4._Active = TRUE AND ((T4._Fld20064RRef, T4._Fld20065RRef, T4._Fld20066RRef) IN(SELECTT5._Q_000_F_003RRef AS Q_001_F_000RRef,T5._Q_000_F_000RRef AS Q_001_F_001RRef,T5._Q_000_F_001RRef AS Q_001_F_002RRefFROM pg_temp.tt1 T5))GROUP BY T4._Fld20064RRef,T4._Fld20065RRef,T4._Fld20066RRef) T3INNER JOIN _InfoRg20063 T6ON T3.Fld20064RRef = T6._Fld20064RRef AND T3.Fld20065RRef = T6._Fld20065RRef AND T3.Fld20066RRef = T6._Fld20066RRef AND T3.MAXPERIOD_ = T6._Period) T2ON (T1._Q_000_F_000RRef = T2.Fld20065RRef) AND (T1._Q_000_F_001RRef = T2.Fld20066RRef) AND (T1._Q_000_F_003RRef = T2.Fld20064RRef)LEFT OUTER JOIN (SELECTT11._Fld20065RRef AS Fld20065RRef,T11._Fld20066RRef AS Fld20066RRefFROM (SELECTT9._Fld20064RRef AS Fld20064RRef,T9._Fld20065RRef AS Fld20065RRef,T9._Fld20066RRef AS Fld20066RRef,MAX(T9._Period) AS MAXPERIOD_FROM _InfoRg20063 T9WHERE T9._Period <= '2019-11-25 20:20:20'::timestamp AND T9._Active = TRUE AND ((T9._Fld20064RRef, T9._Fld20065RRef) IN(SELECTT10._Q_000_F_003RRef AS Q_001_F_000RRef,T10._Q_000_F_000RRef AS Q_001_F_001RRefFROM pg_temp.tt1 T10) AND (T9._Fld20066RRef = '\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000'::bytea))GROUP BY T9._Fld20064RRef,T9._Fld20065RRef,T9._Fld20066RRef) T8INNER JOIN _InfoRg20063 T11ON T8.Fld20064RRef = T11._Fld20064RRef AND T8.Fld20065RRef = T11._Fld20065RRef AND T8.Fld20066RRef = T11._Fld20066RRef AND T8.MAXPERIOD_ = T11._Period) T7ON (T1._Q_000_F_000RRef = T7.Fld20065RRef) AND (T7.Fld20066RRef = '\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000'::bytea) AND (T1._Q_000_F_000RRef = T7.Fld20065RRef)LEFT OUTER JOIN (SELECTT16._Fld20065RRef AS Fld20065RRef,T16._Fld20066RRef AS Fld20066RRef,T16._Fld20064RRef AS Fld20064RRef,T16._Fld20067RRef AS Fld20067RRefFROM (SELECTT14._Fld20064RRef AS Fld20064RRef,T14._Fld20065RRef AS Fld20065RRef,T14._Fld20066RRef AS Fld20066RRef,MAX(T14._Period) AS MAXPERIOD_FROM _InfoRg20063 T14WHERE T14._Period <= '2019-11-25 20:20:20'::timestamp AND T14._Active = TRUE AND ((T14._Fld20064RRef, T14._Fld20065RRef, T14._Fld20066RRef) IN(SELECTT15._Q_000_F_004RRef AS Q_001_F_000RRef,T15._Q_000_F_000RRef AS Q_001_F_001RRef,T15._Q_000_F_001RRef AS Q_001_F_002RRefFROM pg_temp.tt1 T15))GROUP BY T14._Fld20064RRef,T14._Fld20065RRef,T14._Fld20066RRef) T13INNER JOIN _InfoRg20063 T16ON T13.Fld20064RRef = T16._Fld20064RRef AND T13.Fld20065RRef = T16._Fld20065RRef AND T13.Fld20066RRef = T16._Fld20066RRef AND T13.MAXPERIOD_ = T16._Period) T12ON (T1._Q_000_F_000RRef = T12.Fld20065RRef) AND (T1._Q_000_F_001RRef = T12.Fld20066RRef) AND (T1._Q_000_F_004RRef = T12.Fld20064RRef)LEFT OUTER JOIN (SELECTT21._Fld20065RRef AS Fld20065RRef,T21._Fld20066RRef AS Fld20066RRef,T21._Fld20064RRef AS Fld20064RRef,T21._Fld20067RRef AS Fld20067RRefFROM (SELECTT19._Fld20064RRef AS Fld20064RRef,T19._Fld20065RRef AS Fld20065RRef,T19._Fld20066RRef AS Fld20066RRef,MAX(T19._Period) AS MAXPERIOD_FROM _InfoRg20063 T19WHERE T19._Period <= '2019-11-25 20:20:20'::timestamp AND T19._Active = TRUE AND ((T19._Fld20064RRef, T19._Fld20065RRef) IN(SELECTT20._Q_000_F_004RRef AS Q_001_F_000RRef,T20._Q_000_F_000RRef AS Q_001_F_001RRefFROM pg_temp.tt1 T20) AND (T19._Fld20066RRef = '\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000'::bytea))GROUP BY T19._Fld20064RRef,T19._Fld20065RRef,T19._Fld20066RRef) T18INNER JOIN _InfoRg20063 T21ON T18.Fld20064RRef = T21._Fld20064RRef AND T18.Fld20065RRef = T21._Fld20065RRef AND T18.Fld20066RRef = T21._Fld20066RRef AND T18.MAXPERIOD_ = T21._Period) T17ON (T1._Q_000_F_000RRef = T17.Fld20065RRef) AND (T17.Fld20066RRef = '\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000'::bytea) AND (T1._Q_000_F_004RRef = T17.Fld20064RRef)LEFT OUTER JOIN (SELECTT26._Fld17745RRef AS Fld17745RRefFROM (SELECTT24._Fld17745RRef AS Fld17745RRef,MAX(T24._Period) AS MAXPERIOD_FROM _InfoRg17744 T24WHERE T24._Period <= '2019-11-25 20:20:20'::timestamp AND (T24._Fld17745RRef IN(SELECTT25._Q_000_F_008RRef AS Q_001_F_000RRefFROM pg_temp.tt1 T25))GROUP BY T24._Fld17745RRef) T23INNER JOIN _InfoRg17744 T26ON T23.Fld17745RRef = T26._Fld17745RRef AND T23.MAXPERIOD_ = T26._Period) T22ON (T1._Q_000_F_008RRef = T22.Fld17745RRef)LEFT OUTER JOIN (SELECTT31._Fld17745RRef AS Fld17745RRefFROM (SELECTT29._Fld17745RRef AS Fld17745RRef,MAX(T29._Period) AS MAXPERIOD_FROM _InfoRg17744 T29WHERE T29._Period <= '2019-11-25 20:20:20'::timestamp AND (T29._Fld17745RRef IN(SELECTT30._Q_000_F_008RRef AS Q_001_F_000RRefFROM pg_temp.tt1 T30))GROUP BY T29._Fld17745RRef) T28INNER JOIN _InfoRg17744 T31ON T28.Fld17745RRef = T31._Fld17745RRef AND T28.MAXPERIOD_ = T31._Period) T27ON (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: 1,024 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: 1,024 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: 1,024 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: 1,024 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: 1,024 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: 1,024 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: 1,024 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