explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qMsD

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Finalize Aggregate (cost=598,975.39..598,975.40 rows=1 width=8) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Gather (cost=598,975.18..598,975.39 rows=2 width=8) (actual rows= loops=)

  • Workers Planned: 2
3. 0.000 0.000 ↓ 0.0

Partial Aggregate (cost=597,975.18..597,975.19 rows=1 width=8) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on id_tag (cost=0.00..596,639.61 rows=534,228 width=0) (actual rows= loops=)

  • Filter: ((tag)::text = 'php'::text)