.Q.pn
In partitioned DBs, returns a dictionary of cached partition counts – conformant to .Q.pt, each
conformant to .Q.pv – as populated by .Q.cn.
Cleared by .Q.view.
.Q.pv!flip .Q.pn can be used to create a crosstab of table-to-partition-counts once .Q.pn
is fully populated.
q)n:100
q)t:([]time:.z.T+til n;sym:n?`2;num:n)
q).Q.dpft[`:.;;`sym;`t]each 2010.01.01+til 5
`t`t`t`t`t
q)\l .
q).Q.pn
t|
q).Q.cn t
100 100 100 100 100
q).Q.pn
t| 100 100 100 100 100
q).Q.pv!flip .Q.pn
| t
----------| ---
2010.01.01| 100
2010.01.02| 100
2010.01.03| 100
2010.01.04| 100
2010.01.05| 100
q).Q.view 2#date
q).Q.pn
t|
q).Q.cn t
100 100
q).Q.pn
t| 100 100
q).Q.pv!flip .Q.pn
| t
----------| ---
2010.01.01| 100
2010.01.02| 100