explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2sqX

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 70,456.093 ↑ 1.0 1 1

Finalize Aggregate (cost=5,861,663.15..5,861,663.16 rows=1 width=8) (actual time=70,456.092..70,456.093 rows=1 loops=1)

2. 0.331 70,456.182 ↑ 2.0 1 1

Gather (cost=5,861,662.94..5,861,663.15 rows=2 width=8) (actual time=70,456.083..70,456.182 rows=1 loops=1)

  • Workers Planned: 2
  • Workers Launched: 0
3. 0.006 70,455.851 ↑ 1.0 1 1

Partial Aggregate (cost=5,860,662.94..5,860,662.95 rows=1 width=8) (actual time=70,455.850..70,455.851 rows=1 loops=1)

4. 70,455.845 70,455.845 ↓ 0.0 0 1

Parallel Seq Scan on dmoz_queries_catid_order (cost=0.00..5,860,630.83 rows=12,842 width=4) (actual time=70,455.844..70,455.845 rows=0 loops=1)

  • Filter: (catid = 5,854,883)
  • Rows Removed by Filter: 444,195,461
Planning time : 0.116 ms
Execution time : 70,456.908 ms