explain.depesz.com

PostgreSQL's explain analyze made readable

Result: TC6l

Settings
# exclusive inclusive rows x rows loops node
1. 21.451 267.154 ↓ 1.1 86,891 1

Gather (cost=1,000.00..62,773.30 rows=79,526 width=4) (actual time=0.298..267.154 rows=86,891 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 20.779 245.703 ↑ 114.4 28,964 3

ProjectSet (cost=0.00..53,820.70 rows=3,313,600 width=4) (actual time=0.026..245.703 rows=28,964 loops=3)

3. 224.924 224.924 ↑ 1.3 25,547 3

Parallel Seq Scan on patient_logs (cost=0.00..37,004.18 rows=33,136 width=25) (actual time=0.023..224.924 rows=25,547 loops=3)

  • Filter: ((change_date > '2018-07-01'::date) AND (change_date < '2018-07-31'::date))
  • Rows Removed by Filter: 601721