Re: dsa_allocate could not find 4 free pages

> On Dec 5, 2017, at 11:25 AM, Thomas Munro <thomas(dot)munro(at)enterprisedb(dot)com> wrote:
>
> On Wed, Dec 6, 2017 at 6:17 AM, Mark Dilger <hornschnorter(at)gmail(dot)com> wrote:
>> I'm not asking for help configuring my system. If this is a run of the mill out of memory
>> type error, I'll deal with it myself. But if this indicates a bug, I'll be happy to try to distill
>> what I'm doing to a test case that I can share. (I've only hit this once, and have little
>> idea whether it would be reproducible.) The gist of the query was an array_agg over
>> the results of a parallel query over a partitioned table, executed from within a plpgsql
>> function, like:
>>
>> SELECT ARRAY_AGG((a, latest, timelogged, b, cnt)::custom_composite_type) AS trans FROM
>> (SELECT a, b, timelogged, MAX(timelogged) OVER (PARTITION BY a) AS latest, SUM(cnt) AS cnt FROM
>> (SELECT a, b, timelogged, COUNT(*) AS cnt
>> FROM mytable
>> WHERE a= ANY('{65537,65538,65539,65540,65541,65542,65543,65544}'::OID[])
>> AND timelogged >= '2017-12-04 16:12:50-08'::TIMESTAMP
>> AND timelogged < '2017-12-04 17:12:50-08'::TIMESTAMP
>> GROUP BY a, b, timelogged
>> ) AS ss
>> GROUP BY a, b, timelogged
>> ) AS s
>
> Hi Mark,
>
> Does the plan have multiple Gather nodes with Parallel Bitmap Heap Scan?

This was encountered and logged by a java client. The only data I got was:

org.postgresql.util.PSQLException: ERROR: dsa_allocate could not find 4 free pages
Where: parallel worker

I know what the query was, because it is the only query this client issues, but there is
no record of what the plan might have been. The java client runs queries spanning a long
time period followed by multiple queries spanning short time periods. The sql query is
the same in both cases; only the bind parameters for the time frame differ. The short time
period queries do not generate parallel plans (in my experience), but the long time period
ones do, with plans that look something like this:

Aggregate (cost=31552146.47..31552146.48 rows=1 width=32)
-> WindowAgg (cost=14319575.96..31538146.47 rows=800000 width=43)
-> GroupAggregate (cost=14319575.96..31526146.47 rows=800000 width=39)
Group Key: acct_r.mta, acct_r.dtype, (moment(acct_r.timelogged))
-> Finalize GroupAggregate (cost=14319575.96..31356146.47 rows=8000000 width=15)
Group Key: acct_r.mta, acct_r.dtype, (moment(acct_r.timelogged))
-> Gather Merge (cost=14319575.96..30056146.47 rows=120000000 width=15)
Workers Planned: 15
-> Partial GroupAggregate (cost=14318575.64..14755146.15 rows=8000000 width=15)
Group Key: acct_r.mta, acct_r.dtype, (moment(acct_r.timelogged))
-> Sort (cost=14318575.64..14385889.74 rows=26925641 width=7)
Sort Key: acct_r.mta, acct_r.dtype, (moment(acct_r.timelogged))
-> Result (cost=0.00..10627491.52 rows=26925641 width=7)
-> Append (cost=0.00..10290921.01 rows=26925641 width=7)
-> Parallel Seq Scan on acct_r (cost=0.00..784882.50 rows=1805625 width=7)
Filter: (mta = ANY ('{65537,65538,65539,65540,65541,65542,65543,65544}'::smallid[]))
-> Parallel Seq Scan on acct_d (cost=0.00..542032.80 rows=1757640 width=7)
Filter: (mta = ANY ('{65537,65538,65539,65540,65541,65542,65543,65544}'::smallid[]))
-> Parallel Seq Scan on acct_b (cost=0.00..111584.91 rows=206096 width=7)
Filter: (mta = ANY ('{65537,65538,65539,65540,65541,65542,65543,65544}'::smallid[]))
-> Parallel Seq Scan on acct_x (cost=0.00..20661.29 rows=48165 width=7)
Filter: (mta = ANY ('{65537,65538,65539,65540,65541,65542,65543,65544}'::smallid[]))
-> Parallel Seq Scan on acct_r acct_r_1 (cost=0.00..795917.43 rows=1831322 width=7)
Filter: (mta = ANY ('{65537,65538,65539,65540,65541,65542,65543,65544}'::smallid[]))
-> Parallel Seq Scan on acct_d acct_d_1 (cost=0.00..549630.82 rows=1782141 width=7)
Filter: (mta = ANY ('{65537,65538,65539,65540,65541,65542,65543,65544}'::smallid[]))
-> Parallel Seq Scan on acct_b acct_b_1 (cost=0.00..113211.40 rows=208970 width=7)
Filter: (mta = ANY ('{65537,65538,65539,65540,65541,65542,65543,65544}'::smallid[]))
-> Parallel Seq Scan on acct_x acct_x_1 (cost=0.00..20667.64 rows=46732 width=7)
Filter: (mta = ANY ('{65537,65538,65539,65540,65541,65542,65543,65544}'::smallid[]))
-> Parallel Seq Scan on acct_r acct_r_2 (cost=0.00..790341.78 rows=1818139 width=7)
Filter: (mta = ANY ('{65537,65538,65539,65540,65541,65542,65543,65544}'::smallid[]))
-> Parallel Seq Scan on acct_d acct_d_2 (cost=0.00..545702.84 rows=1769442 width=7)
Filter: (mta = ANY ('{65537,65538,65539,65540,65541,65542,65543,65544}'::smallid[]))
-> Parallel Seq Scan on acct_b acct_b_2 (cost=0.00..112481.26 rows=207663 width=7)
Filter: (mta = ANY ('{65537,65538,65539,65540,65541,65542,65543,65544}'::smallid[]))
-> Parallel Seq Scan on acct_x acct_x_2 (cost=0.00..20834.24 rows=48462 width=7)
Filter: (mta = ANY ('{65537,65538,65539,65540,65541,65542,65543,65544}'::smallid[]))
-> Parallel Seq Scan on acct_r acct_r_3 (cost=0.00..791592.41 rows=1822370 width=7)
Filter: (mta = ANY ('{65537,65538,65539,65540,65541,65542,65543,65544}'::smallid[]))
-> Parallel Seq Scan on acct_d acct_d_3 (cost=0.00..546542.70 rows=1773285 width=7)
Filter: (mta = ANY ('{65537,65538,65539,65540,65541,65542,65543,65544}'::smallid[]))
-> Parallel Seq Scan on acct_b acct_b_3 (cost=0.00..112643.48 rows=208174 width=7)
Filter: (mta = ANY ('{65537,65538,65539,65540,65541,65542,65543,65544}'::smallid[]))
-> Parallel Seq Scan on acct_x acct_x_3 (cost=0.00..20488.79 rows=46540 width=7)
Filter: (mta = ANY ('{65537,65538,65539,65540,65541,65542,65543,65544}'::smallid[]))
-> Parallel Seq Scan on acct_r acct_r_4 (cost=0.00..790958.39 rows=1820569 width=7)
Filter: (mta = ANY ('{65537,65538,65539,65540,65541,65542,65543,65544}'::smallid[]))
-> Parallel Seq Scan on acct_d acct_d_4 (cost=0.00..546166.22 rows=1772061 width=7)
Filter: (mta = ANY ('{65537,65538,65539,65540,65541,65542,65543,65544}'::smallid[]))
-> Parallel Seq Scan on acct_b acct_b_4 (cost=0.00..112614.67 rows=207933 width=7)
Filter: (mta = ANY ('{65537,65538,65539,65540,65541,65542,65543,65544}'::smallid[]))
-> Parallel Seq Scan on acct_x acct_x_4 (cost=0.00..20505.07 rows=46503 width=7)
Filter: (mta = ANY ('{65537,65538,65539,65540,65541,65542,65543,65544}'::smallid[]))
-> Parallel Seq Scan on acct_r acct_r_5 (cost=0.00..796322.24 rows=1832912 width=7)
Filter: (mta = ANY ('{65537,65538,65539,65540,65541,65542,65543,65544}'::smallid[]))
-> Parallel Seq Scan on acct_d acct_d_5 (cost=0.00..549874.51 rows=1784126 width=7)
Filter: (mta = ANY ('{65537,65538,65539,65540,65541,65542,65543,65544}'::smallid[]))
-> Parallel Seq Scan on acct_b acct_b_5 (cost=0.00..113290.21 rows=209260 width=7)
Filter: (mta = ANY ('{65537,65538,65539,65540,65541,65542,65543,65544}'::smallid[]))
-> Parallel Seq Scan on acct_x acct_x_5 (cost=0.00..20703.26 rows=47013 width=7)
Filter: (mta = ANY ('{65537,65538,65539,65540,65541,65542,65543,65544}'::smallid[]))
-> Parallel Seq Scan on acct_r acct_r_6 (cost=0.00..785534.98 rows=1807499 width=7)
Filter: (mta = ANY ('{65537,65538,65539,65540,65541,65542,65543,65544}'::smallid[]))
-> Parallel Seq Scan on acct_d acct_d_6 (cost=0.00..542409.68 rows=1759134 width=7)
Filter: (mta = ANY ('{65537,65538,65539,65540,65541,65542,65543,65544}'::smallid[]))
-> Parallel Seq Scan on acct_b acct_b_6 (cost=0.00..111713.68 rows=206334 width=7)
Filter: (mta = ANY ('{65537,65538,65539,65540,65541,65542,65543,65544}'::smallid[]))
-> Parallel Seq Scan on acct_x acct_x_6 (cost=0.00..20667.40 rows=48120 width=7)
Filter: (mta = ANY ('{65537,65538,65539,65540,65541,65542,65543,65544}'::smallid[]))
-> Parallel Seq Scan on acct_r acct_r_7 (cost=0.00..11.29 rows=5 width=7)
Filter: (mta = ANY ('{65537,65538,65539,65540,65541,65542,65543,65544}'::smallid[]))
-> Parallel Seq Scan on acct_d acct_d_7 (cost=0.00..782.52 rows=2576 width=7)
Filter: (mta = ANY ('{65537,65538,65539,65540,65541,65542,65543,65544}'::smallid[]))
-> Parallel Seq Scan on acct_b acct_b_7 (cost=0.00..130.95 rows=698 width=7)
Filter: (mta = ANY ('{65537,65538,65539,65540,65541,65542,65543,65544}'::smallid[]))
-> Parallel Seq Scan on acct_x acct_x_7 (cost=0.00..19.65 rows=132 width=7)
Filter: (mta = ANY ('{65537,65538,65539,65540,65541,65542,65543,65544}'::smallid[]))
(78 rows)

The short time period ones tend to look like this:

Aggregate (cost=9499062.32..9499062.33 rows=1 width=32)
-> WindowAgg (cost=9487746.22..9497897.43 rows=66565 width=43)
-> GroupAggregate (cost=9487746.22..9496898.95 rows=66565 width=39)
Group Key: acct_r.mta, acct_r.dtype, (moment(acct_r.timelogged))
-> Sort (cost=9487746.22..9489410.35 rows=665654 width=15)
Sort Key: acct_r.mta, acct_r.dtype, (moment(acct_r.timelogged))
-> HashAggregate (cost=9408385.57..9416706.25 rows=665654 width=15)
Group Key: acct_r.mta, acct_r.dtype, moment(acct_r.timelogged)
-> Result (cost=12668.25..9341820.14 rows=6656543 width=7)
-> Append (cost=12668.25..9258613.35 rows=6656543 width=7)
-> Bitmap Heap Scan on acct_r (cost=12668.25..739601.94 rows=525895 width=7)
Recheck Cond: (moment(timelogged) >= '2017-12-05 11:20:00-08'::secondstamp)
Filter: (mta = ANY ('{65537,65538,65539,65540,65541,65542,65543,65544}'::smallid[]))
-> Bitmap Index Scan on acct_r_mta_moment (cost=0.00..12536.77 rows=525895 width=0)
Index Cond: (moment(timelogged) >= '2017-12-05 11:20:00-08'::secondstamp)
-> Bitmap Heap Scan on acct_d (cost=12119.70..546172.53 rows=498469 width=7)
Recheck Cond: (moment(timelogged) >= '2017-12-05 11:20:00-08'::secondstamp)
Filter: (mta = ANY ('{65537,65538,65539,65540,65541,65542,65543,65544}'::smallid[]))
-> Bitmap Index Scan on acct_d_mta_moment (cost=0.00..11995.08 rows=498469 width=0)
Index Cond: (moment(timelogged) >= '2017-12-05 11:20:00-08'::secondstamp)
-> Index Scan using acct_b_mta_moment on acct_b (cost=0.43..63926.98 rows=36865 width=7)
Index Cond: (moment(timelogged) >= '2017-12-05 11:20:00-08'::secondstamp)
Filter: (mta = ANY ('{65537,65538,65539,65540,65541,65542,65543,65544}'::smallid[]))
-> Index Scan using acct_x_mta_moment on acct_x (cost=0.42..16974.14 rows=9732 width=7)
Index Cond: (moment(timelogged) >= '2017-12-05 11:20:00-08'::secondstamp)
Filter: (mta = ANY ('{65537,65538,65539,65540,65541,65542,65543,65544}'::smallid[]))
-> Bitmap Heap Scan on acct_r acct_r_1 (cost=13188.15..756606.11 rows=548076 width=7)
Recheck Cond: (moment(timelogged) >= '2017-12-05 11:20:00-08'::secondstamp)
Filter: (mta = ANY ('{65537,65538,65539,65540,65541,65542,65543,65544}'::smallid[]))
-> Bitmap Index Scan on acct_r_mta_moment (cost=0.00..13051.13 rows=548076 width=0)
Index Cond: (moment(timelogged) >= '2017-12-05 11:20:00-08'::secondstamp)
-> Bitmap Heap Scan on acct_d acct_d_1 (cost=9583.46..521988.16 rows=394697 width=7)
Recheck Cond: (moment(timelogged) >= '2017-12-05 11:20:00-08'::secondstamp)
Filter: (mta = ANY ('{65537,65538,65539,65540,65541,65542,65543,65544}'::smallid[]))
-> Bitmap Index Scan on acct_d_mta_moment (cost=0.00..9484.79 rows=394697 width=0)
Index Cond: (moment(timelogged) >= '2017-12-05 11:20:00-08'::secondstamp)
-> Index Scan using acct_b_mta_moment on acct_b acct_b_1 (cost=0.43..63528.17 rows=36631 width=7)
Index Cond: (moment(timelogged) >= '2017-12-05 11:20:00-08'::secondstamp)
Filter: (mta = ANY ('{65537,65538,65539,65540,65541,65542,65543,65544}'::smallid[]))
-> Index Scan using acct_x_mta_moment on acct_x acct_x_1 (cost=0.42..12437.69 rows=7174 width=7)
Index Cond: (moment(timelogged) >= '2017-12-05 11:20:00-08'::secondstamp)
Filter: (mta = ANY ('{65537,65538,65539,65540,65541,65542,65543,65544}'::smallid[]))
-> Index Scan using acct_r_mta_moment on acct_r acct_r_2 (cost=0.56..577183.17 rows=335206 width=7)
Index Cond: (moment(timelogged) >= '2017-12-05 11:20:00-08'::secondstamp)
Filter: (mta = ANY ('{65537,65538,65539,65540,65541,65542,65543,65544}'::smallid[]))
-> Bitmap Heap Scan on acct_d acct_d_2 (cost=9955.04..524788.79 rows=409610 width=7)
Recheck Cond: (moment(timelogged) >= '2017-12-05 11:20:00-08'::secondstamp)
Filter: (mta = ANY ('{65537,65538,65539,65540,65541,65542,65543,65544}'::smallid[]))
-> Bitmap Index Scan on acct_d_mta_moment (cost=0.00..9852.64 rows=409610 width=0)
Index Cond: (moment(timelogged) >= '2017-12-05 11:20:00-08'::secondstamp)
-> Index Scan using acct_b_mta_moment on acct_b acct_b_2 (cost=0.43..91630.01 rows=52910 width=7)
Index Cond: (moment(timelogged) >= '2017-12-05 11:20:00-08'::secondstamp)
Filter: (mta = ANY ('{65537,65538,65539,65540,65541,65542,65543,65544}'::smallid[]))
-> Bitmap Heap Scan on acct_x acct_x_2 (cost=271.31..17389.00 rows=10179 width=7)
Recheck Cond: (moment(timelogged) >= '2017-12-05 11:20:00-08'::secondstamp)
Filter: (mta = ANY ('{65537,65538,65539,65540,65541,65542,65543,65544}'::smallid[]))
-> Bitmap Index Scan on acct_x_mta_moment (cost=0.00..268.76 rows=10179 width=0)
Index Cond: (moment(timelogged) >= '2017-12-05 11:20:00-08'::secondstamp)
-> Bitmap Heap Scan on acct_r acct_r_3 (cost=9617.11..669375.23 rows=399555 width=7)
Recheck Cond: (moment(timelogged) >= '2017-12-05 11:20:00-08'::secondstamp)
Filter: (mta = ANY ('{65537,65538,65539,65540,65541,65542,65543,65544}'::smallid[]))
-> Bitmap Index Scan on acct_r_mta_moment (cost=0.00..9517.23 rows=399555 width=0)
Index Cond: (moment(timelogged) >= '2017-12-05 11:20:00-08'::secondstamp)
-> Bitmap Heap Scan on acct_d acct_d_3 (cost=7954.15..489086.26 rows=327431 width=7)
Recheck Cond: (moment(timelogged) >= '2017-12-05 11:20:00-08'::secondstamp)
Filter: (mta = ANY ('{65537,65538,65539,65540,65541,65542,65543,65544}'::smallid[]))
-> Bitmap Index Scan on acct_d_mta_moment (cost=0.00..7872.30 rows=327431 width=0)
Index Cond: (moment(timelogged) >= '2017-12-05 11:20:00-08'::secondstamp)
-> Index Scan using acct_b_mta_moment on acct_b acct_b_3 (cost=0.43..57803.57 rows=33318 width=7)
Index Cond: (moment(timelogged) >= '2017-12-05 11:20:00-08'::secondstamp)
Filter: (mta = ANY ('{65537,65538,65539,65540,65541,65542,65543,65544}'::smallid[]))
-> Bitmap Heap Scan on acct_x acct_x_3 (cost=266.63..17170.64 rows=10091 width=7)
Recheck Cond: (moment(timelogged) >= '2017-12-05 11:20:00-08'::secondstamp)
Filter: (mta = ANY ('{65537,65538,65539,65540,65541,65542,65543,65544}'::smallid[]))
-> Bitmap Index Scan on acct_x_mta_moment (cost=0.00..264.11 rows=10091 width=0)
Index Cond: (moment(timelogged) >= '2017-12-05 11:20:00-08'::secondstamp)
-> Bitmap Heap Scan on acct_r acct_r_4 (cost=14364.05..772579.42 rows=596579 width=7)
Recheck Cond: (moment(timelogged) >= '2017-12-05 11:20:00-08'::secondstamp)
Filter: (mta = ANY ('{65537,65538,65539,65540,65541,65542,65543,65544}'::smallid[]))
-> Bitmap Index Scan on acct_r_mta_moment (cost=0.00..14214.90 rows=596579 width=0)
Index Cond: (moment(timelogged) >= '2017-12-05 11:20:00-08'::secondstamp)
-> Bitmap Heap Scan on acct_d acct_d_4 (cost=8948.13..508920.98 rows=368460 width=7)
Recheck Cond: (moment(timelogged) >= '2017-12-05 11:20:00-08'::secondstamp)
Filter: (mta = ANY ('{65537,65538,65539,65540,65541,65542,65543,65544}'::smallid[]))
-> Bitmap Index Scan on acct_d_mta_moment (cost=0.00..8856.01 rows=368460 width=0)
Index Cond: (moment(timelogged) >= '2017-12-05 11:20:00-08'::secondstamp)
-> Index Scan using acct_b_mta_moment on acct_b acct_b_4 (cost=0.43..66568.72 rows=38394 width=7)
Index Cond: (moment(timelogged) >= '2017-12-05 11:20:00-08'::secondstamp)
Filter: (mta = ANY ('{65537,65538,65539,65540,65541,65542,65543,65544}'::smallid[]))
-> Index Scan using acct_x_mta_moment on acct_x acct_x_4 (cost=0.42..16054.04 rows=9268 width=7)
Index Cond: (moment(timelogged) >= '2017-12-05 11:20:00-08'::secondstamp)
Filter: (mta = ANY ('{65537,65538,65539,65540,65541,65542,65543,65544}'::smallid[]))
-> Bitmap Heap Scan on acct_r acct_r_5 (cost=12191.39..737360.94 rows=506687 width=7)
Recheck Cond: (moment(timelogged) >= '2017-12-05 11:20:00-08'::secondstamp)
Filter: (mta = ANY ('{65537,65538,65539,65540,65541,65542,65543,65544}'::smallid[]))
-> Bitmap Index Scan on acct_r_mta_moment (cost=0.00..12064.72 rows=506687 width=0)
Index Cond: (moment(timelogged) >= '2017-12-05 11:20:00-08'::secondstamp)
-> Bitmap Heap Scan on acct_d acct_d_5 (cost=10295.39..532639.53 rows=424107 width=7)
Recheck Cond: (moment(timelogged) >= '2017-12-05 11:20:00-08'::secondstamp)
Filter: (mta = ANY ('{65537,65538,65539,65540,65541,65542,65543,65544}'::smallid[]))
-> Bitmap Index Scan on acct_d_mta_moment (cost=0.00..10189.36 rows=424107 width=0)
Index Cond: (moment(timelogged) >= '2017-12-05 11:20:00-08'::secondstamp)
-> Index Scan using acct_b_mta_moment on acct_b acct_b_5 (cost=0.43..71723.09 rows=41379 width=7)
Index Cond: (moment(timelogged) >= '2017-12-05 11:20:00-08'::secondstamp)
Filter: (mta = ANY ('{65537,65538,65539,65540,65541,65542,65543,65544}'::smallid[]))
-> Bitmap Heap Scan on acct_x acct_x_5 (cost=277.93..17587.45 rows=10517 width=7)
Recheck Cond: (moment(timelogged) >= '2017-12-05 11:20:00-08'::secondstamp)
Filter: (mta = ANY ('{65537,65538,65539,65540,65541,65542,65543,65544}'::smallid[]))
-> Bitmap Index Scan on acct_x_mta_moment (cost=0.00..275.30 rows=10517 width=0)
Index Cond: (moment(timelogged) >= '2017-12-05 11:20:00-08'::secondstamp)
-> Bitmap Heap Scan on acct_r acct_r_6 (cost=14015.51..763250.58 rows=581541 width=7)
Recheck Cond: (moment(timelogged) >= '2017-12-05 11:20:00-08'::secondstamp)
Filter: (mta = ANY ('{65537,65538,65539,65540,65541,65542,65543,65544}'::smallid[]))
-> Bitmap Index Scan on acct_r_mta_moment (cost=0.00..13870.12 rows=581541 width=0)
Index Cond: (moment(timelogged) >= '2017-12-05 11:20:00-08'::secondstamp)
-> Bitmap Heap Scan on acct_d acct_d_6 (cost=9523.94..515952.84 rows=391661 width=7)
Recheck Cond: (moment(timelogged) >= '2017-12-05 11:20:00-08'::secondstamp)
Filter: (mta = ANY ('{65537,65538,65539,65540,65541,65542,65543,65544}'::smallid[]))
-> Bitmap Index Scan on acct_d_mta_moment (cost=0.00..9426.02 rows=391661 width=0)
Index Cond: (moment(timelogged) >= '2017-12-05 11:20:00-08'::secondstamp)
-> Index Scan using acct_b_mta_moment on acct_b acct_b_6 (cost=0.43..75659.10 rows=43660 width=7)
Index Cond: (moment(timelogged) >= '2017-12-05 11:20:00-08'::secondstamp)
Filter: (mta = ANY ('{65537,65538,65539,65540,65541,65542,65543,65544}'::smallid[]))
-> Index Scan using acct_x_mta_moment on acct_x acct_x_6 (cost=0.42..14623.44 rows=8445 width=7)
Index Cond: (moment(timelogged) >= '2017-12-05 11:20:00-08'::secondstamp)
Filter: (mta = ANY ('{65537,65538,65539,65540,65541,65542,65543,65544}'::smallid[]))
-> Seq Scan on acct_r acct_r_7 (cost=0.00..12.75 rows=3 width=7)
Filter: ((moment(timelogged) >= '2017-12-05 11:20:00-08'::secondstamp) AND (mta = ANY ('{65537,65538,65539,65540,65541,65542,65543,65544}'::smallid[])))
-> Index Scan using acct_d_mta_moment on acct_d acct_d_7 (cost=0.29..6.06 rows=1 width=7)
Index Cond: (moment(timelogged) >= '2017-12-05 11:20:00-08'::secondstamp)
Filter: (mta = ANY ('{65537,65538,65539,65540,65541,65542,65543,65544}'::smallid[]))
-> Index Scan using acct_b_mta_moment on acct_b acct_b_7 (cost=0.28..6.06 rows=1 width=7)
Index Cond: (moment(timelogged) >= '2017-12-05 11:20:00-08'::secondstamp)
Filter: (mta = ANY ('{65537,65538,65539,65540,65541,65542,65543,65544}'::smallid[]))
-> Index Scan using acct_x_mta_moment on acct_x acct_x_7 (cost=0.14..5.95 rows=1 width=7)
Index Cond: (moment(timelogged) >= '2017-12-05 11:20:00-08'::secondstamp)
Filter: (mta = ANY ('{65537,65538,65539,65540,65541,65542,65543,65544}'::smallid[]))
(137 rows)