explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1oId

Settings
# exclusive inclusive rows x rows loops node
1. 0.021 23,155.042 ↑ 1.0 100 1

Limit (cost=109,959.94..109,971.61 rows=100 width=1,218) (actual time=23,152.780..23,155.042 rows=100 loops=1)

2. 0.000 23,155.021 ↑ 2,684.6 100 1

Gather Merge (cost=109,959.94..141,281.99 rows=268,456 width=1,218) (actual time=23,152.779..23,155.021 rows=100 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 1,590.687 69,354.537 ↑ 2,033.8 66 3

Sort (cost=108,959.92..109,295.49 rows=134,228 width=1,218) (actual time=23,118.161..23,118.179 rows=66 loops=3)

  • Sort Key: author
  • Sort Method: top-N heapsort Memory: 214kB
  • Worker 0: Sort Method: top-N heapsort Memory: 205kB
  • Worker 1: Sort Method: top-N heapsort Memory: 182kB
4. 67,763.850 67,763.850 ↑ 1.3 105,705 3

Parallel Seq Scan on mail_messages (cost=0.00..103,829.82 rows=134,228 width=1,218) (actual time=7.822..22,587.950 rows=105,705 loops=3)

  • Filter: (subject ~~ 'Re:%'::text)
  • Rows Removed by Filter: 13004
Planning time : 0.309 ms