explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9sp3

Settings
# exclusive inclusive rows x rows loops node
1. 1.262 2,357.338 ↑ 1.0 100 1

Limit (cost=3,498,840.59..3,498,852.26 rows=100 width=10,589) (actual time=2,339.098..2,357.338 rows=100 loops=1)

  • Buffers: shared hit=10926, temp read=1442 written=7705
2. 0.000 2,356.076 ↑ 847.7 600 1

Gather Merge (cost=3,498,782.25..3,558,124.46 rows=508,612 width=10,589) (actual time=2,334.963..2,356.076 rows=600 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
  • Buffers: shared hit=10926, temp read=1442 written=7705
3. 4,348.923 6,969.708 ↑ 465.8 546 3

Sort (cost=3,497,782.23..3,498,417.99 rows=254,306 width=10,589) (actual time=2,321.198..2,323.236 rows=546 loops=3)

  • Sort Key: name
  • Sort Method: external merge Disk: 17824kB
  • Buffers: shared hit=10926, temp read=1442 written=7705
4. 2,620.785 2,620.785 ↑ 1.3 200,933 3

Parallel Seq Scan on task (cost=0.00..14,622.88 rows=254,306 width=10,589) (actual time=0.025..873.595 rows=200,933 loops=3)

  • Filter: ((name)::text ~~ '%r%'::text)
  • Rows Removed by Filter: 39507
  • Buffers: shared hit=10866
Planning time : 0.318 ms
Execution time : 2,364.274 ms