explain.depesz.com

PostgreSQL's explain analyze made readable

Result: GVVv : count with nothing filtered

Settings
# exclusive inclusive rows x rows loops node
1. 1,997.861 5,496.413 ↑ 1.0 1 1

Aggregate (cost=10,707,103.500..10,707,104.000 rows=1 width=0) (actual time=5,496.413..5,496.413 rows=1 loops=1)

2. 3,498.552 3,498.552 ↓ 1.0 10,375,581 1

Seq Scan on echo (cost=0.000..5,544,439.000 rows=10,325,329 width=0) (actual time=0.004..3,498.552 rows=10,375,581 loops=1)

  • Filter: (yankee five NULL)
  • Rows Removed by Filter: 2170