explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6dCV

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 15,853.961 ↑ 1.0 1 1

Finalize Aggregate (cost=581,908.28..581,908.29 rows=1 width=32) (actual time=15,853.961..15,853.961 rows=1 loops=1)

2. 28.149 15,864.971 ↓ 1.5 3 1

Gather (cost=581,908.06..581,908.27 rows=2 width=32) (actual time=15,843.144..15,864.971 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 72.566 15,836.822 ↑ 1.0 1 3

Partial Aggregate (cost=580,908.06..580,908.07 rows=1 width=32) (actual time=15,836.822..15,836.822 rows=1 loops=3)

4. 15,764.256 15,764.256 ↑ 1.2 305,671 3

Parallel Seq Scan on royalties_transaction (cost=0.00..579,959.72 rows=379,336 width=8) (actual time=3,122.655..15,764.256 rows=305,671 loops=3)

  • Filter: ((customer_id = 3) AND ((transaction_type)::text = 'income'::text))
  • Rows Removed by Filter: 1120513
Planning time : 0.275 ms
Execution time : 15,865.047 ms