explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vp3H

Settings
# exclusive inclusive rows x rows loops node
1. 0.007 365.177 ↑ 1.0 100 1

Limit (cost=250,547.98..250,548.23 rows=100 width=4) (actual time=363.131..365.177 rows=100 loops=1)

  • Output: t.id
  • Buffers: shared hit=7,097 read=227,314
2. 0.190 365.170 ↑ 2.0 100 1

Sort (cost=250,547.98..250,548.48 rows=200 width=4) (actual time=363.130..365.170 rows=100 loops=1)

  • Output: t.id
  • Sort Key: t.id
  • Sort Method: top-N heapsort Memory: 32kB
  • Buffers: shared hit=7,097 read=227,314
3. 0.072 364.980 ↓ 5.0 1,000 1

Subquery Scan on t (cost=0.00..250,540.34 rows=200 width=4) (actual time=362.784..364.980 rows=1,000 loops=1)

  • Output: t.id
  • Buffers: shared hit=7,097 read=227,314
4. 0.242 364.908 ↓ 5.0 1,000 1

HashSetOp Except (cost=0.00..250,538.34 rows=200 width=8) (actual time=362.782..364.908 rows=1,000 loops=1)

  • Output: "*SELECT* 1".id, (0)
  • Buffers: shared hit=7,097 read=227,314
5. 0.051 364.666 ↑ 1.0 1,000 1

Append (cost=0.00..250,535.81 rows=1,009 width=8) (actual time=0.068..364.666 rows=1,000 loops=1)

  • Buffers: shared hit=7,097 read=227,314
6. 0.099 0.204 ↑ 1.0 1,000 1

Subquery Scan on *SELECT* 1 (cost=0.00..20.00 rows=1,000 width=8) (actual time=0.067..0.204 rows=1,000 loops=1)

  • Output: "*SELECT* 1".id, 0
7. 0.105 0.105 ↑ 1.0 1,000 1

Function Scan on pg_catalog.generate_series s (cost=0.00..10.00 rows=1,000 width=4) (actual time=0.066..0.105 rows=1,000 loops=1)

  • Output: s.id
  • Function Call: generate_series(8900000, 8900999)
8. 0.002 364.411 ↓ 0.0 0 1

Subquery Scan on *SELECT* 2 (cost=1,000.00..250,510.77 rows=9 width=8) (actual time=362.377..364.411 rows=0 loops=1)

  • Output: "*SELECT* 2".aktions_key, 1
  • Buffers: shared hit=7,097 read=227,314
9. 4.289 364.409 ↓ 0.0 0 1

Gather (cost=1,000.00..250,510.68 rows=9 width=4) (actual time=362.377..364.409 rows=0 loops=1)

  • Output: ((regel.aktions_key)::integer)
  • Workers Planned: 2
  • Workers Launched: 2
  • Buffers: shared hit=7,097 read=227,314
10. 360.120 360.120 ↓ 0.0 0 3 / 3

Parallel Seq Scan on public.regel (cost=0.00..249,509.78 rows=4 width=4) (actual time=360.120..360.120 rows=0 loops=3)

  • Output: (regel.aktions_key)::integer
  • Filter: (((regel.aktions_key)::text ~~ '8900___'::text) AND ((regel.aktions_key)::text ~ '^[0-9]$'::text))
  • Rows Removed by Filter: 805,706
  • Buffers: shared hit=7,097 read=227,314
  • Worker 0: actual time=359.207..359.208 rows=0 loops=1
  • Buffers: shared hit=2,190 read=78,318
  • Worker 1: actual time=359.208..359.209 rows=0 loops=1
  • Buffers: shared hit=2,164 read=75,201
Planning time : 0.390 ms
Execution time : 365.227 ms