explain.depesz.com

PostgreSQL's explain analyze made readable

Result: pdLg

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.620 ↑ 1.0 100 1

Limit (cost=1,000.00..1,768.01 rows=100 width=300) (actual time=0.504..0.620 rows=100 loops=1)

2. 14.539 14.691 ↑ 11,151.3 100 1

Gather (cost=1,000.00..8,565,335.60 rows=1,115,129 width=300) (actual time=0.502..14.691 rows=100 loops=1)

  • Workers Planned: 9
  • Workers Launched: 9
3. 0.152 0.152 ↑ 11,263.9 11 10 / 10

Parallel Seq Scan on lhg_markets_202006 (cost=0.00..8,452,822.70 rows=123,903 width=300) (actual time=0.151..0.152 rows=11 loops=10)

  • Filter: ((startdatetime >= '2020-06-21 22:00:00'::timestamp without time zone) AND (startdatetime <= '2020-06-21 23:59:59'::timestamp without time zone))