explain.depesz.com

PostgreSQL's explain analyze made readable

Result: IHlD

Settings
# exclusive inclusive rows x rows loops node
1. 7.429 16,403.639 ↑ 11.6 12 1

Gather (cost=1,000.00..964,279.65 rows=139 width=8) (actual time=2,739.964..16,403.639 rows=12 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 16,396.210 16,396.210 ↑ 14.5 4 3

Parallel Seq Scan on recommended (cost=0.00..963,265.75 rows=58 width=8) (actual time=11,842.345..16,396.210 rows=4 loops=3)

  • Filter: (home_id = 873292)
  • Rows Removed by Filter: 33331741
Planning time : 0.052 ms
Execution time : 16,403.664 ms