explain.depesz.com

PostgreSQL's explain analyze made readable

Result: is77

Settings
# exclusive inclusive rows x rows loops node
1. 0.009 289.820 ↓ 1.7 93 1

Limit (cost=119,031.32..119,039.18 rows=54 width=84) (actual time=289.712..289.820 rows=93 loops=1)

2. 0.000 289.811 ↓ 1.7 93 1

Finalize GroupAggregate (cost=119,031.32..119,038.64 rows=54 width=84) (actual time=289.710..289.811 rows=93 loops=1)

  • Group Key: b.marketareaid, a."interval
3. 16.839 301.667 ↓ 2.1 93 1

Gather Merge (cost=119,031.32..119,037.06 rows=44 width=108) (actual time=289.690..301.667 rows=93 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
4. 0.033 284.828 ↓ 1.4 31 3 / 3

Partial GroupAggregate (cost=118,031.30..118,031.96 rows=22 width=108) (actual time=284.804..284.828 rows=31 loops=3)

  • Group Key: b.marketareaid, a."interval
5. 0.143 284.795 ↓ 1.4 31 3 / 3

Sort (cost=118,031.30..118,031.35 rows=22 width=56) (actual time=284.793..284.795 rows=31 loops=3)

  • Sort Key: a."interval
  • Sort Method: quicksort Memory: 25kB
  • Worker 0: Sort Method: quicksort Memory: 25kB
  • Worker 1: Sort Method: quicksort Memory: 38kB
6. 0.158 284.652 ↓ 1.4 31 3 / 3

Nested Loop (cost=9.06..118,030.81 rows=22 width=56) (actual time=216.085..284.652 rows=31 loops=3)

7. 284.124 284.124 ↑ 1.0 12 3 / 3

Parallel Seq Scan on businessmarketareaids b (cost=0.00..114,430.08 rows=12 width=50) (actual time=29.027..284.124 rows=12 loops=3)

  • Filter: (((markettype)::text = 'projectionCell'::text) AND ((marketareaid)::text = 'projectionCell^0.0.0.0.4.2'::text))
  • Rows Removed by Filter: 1,904,973
8. 0.099 0.370 ↑ 27.0 3 37 / 3

Bitmap Heap Scan on businessorderaggs a (cost=9.06..299.25 rows=81 width=57) (actual time=0.028..0.030 rows=3 loops=37)

  • Recheck Cond: ((id)::text = (b.id)::text)
9. 0.271 0.271 ↑ 27.0 3 37 / 3

Bitmap Index Scan on businessorderaggs_pkey (cost=0.00..9.04 rows=81 width=0) (actual time=0.022..0.022 rows=3 loops=37)

  • Index Cond: ((id)::text = (b.id)::text)
Planning time : 0.471 ms