#	exclusive	inclusive	rows x	rows	loops	node
1.	112.582	112.582	↑ 2.9	13,829	1	→ Seq Scan on "Positions" (cost=0.00..23,867.52 rows=39,834 width=112) (actual time=75.707..112.582 rows=13,829 loops=1) Filter: ((t >= '2019-04-01 22:00:00'::timestamp without time zone) AND (t <= '2019-04-02 22:00:00'::timestamp without time zone) AND ("spaceId" = 'ef7179e7-7a64-4540-901d-4379e64d9698'::uuid)) Rows Removed by Filter: 602750 Buffers: shared hit=13077

Planning time	:	0.099 ms

"Seq Scan on "Positions"  (cost=0.00..23867.52 rows=39834 width=112) (actual time=75.707..112.582 rows=13829 loops=1)"
"  Filter: ((t >= '2019-04-01 22:00:00'::timestamp without time zone) AND (t <= '2019-04-02 22:00:00'::timestamp without time zone) AND ("spaceId" = 'ef7179e7-7a64-4540-901d-4379e64d9698'::uuid))"
"  Rows Removed by Filter: 602750"
"  Buffers: shared hit=13077"
"Planning time: 0.099 ms"
"Execution time: 113.444 ms"

Per node type stats

node type	count	sum of times	% of query
Seq Scan	1	112.582 ms	100.0 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
"Positions"	1	112.582 ms	100.0 %
Seq Scan	1	112.582 ms	100.0 %

explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2oI7

Color mode:

Visible columns:

Per node type stats

Per table stats