explain.depesz.com

PostgreSQL's explain analyze made readable

Result: d8l4

Settings
# exclusive inclusive rows x rows loops node
1. 0.076 257,584.013 ↑ 1.1 18 1

Finalize GroupAggregate (cost=21,981,638.01..21,981,638.49 rows=19 width=10) (actual time=257,583.902..257,584.013 rows=18 loops=1)

  • Group Key: video_standard
2. 0.177 257,583.937 ↓ 1.4 53 1

Sort (cost=21,981,638.01..21,981,638.11 rows=38 width=10) (actual time=257,583.892..257,583.937 rows=53 loops=1)

  • Sort Key: video_standard
  • Sort Method: quicksort Memory: 27kB
3. 4.499 257,583.760 ↓ 1.4 53 1

Gather (cost=21,981,633.03..21,981,637.02 rows=38 width=10) (actual time=257,583.625..257,583.760 rows=53 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
4. 26,149.026 257,579.261 ↑ 1.1 18 3 / 3

Partial HashAggregate (cost=21,980,633.03..21,980,633.22 rows=19 width=10) (actual time=257,579.242..257,579.261 rows=18 loops=3)

  • Group Key: video_standard
5. 231,430.235 231,430.235 ↑ 1.2 22,419,263 3 / 3

Parallel Seq Scan on pond_item_common (cost=0.00..21,840,914.45 rows=27,943,715 width=2) (actual time=0.195..231,430.235 rows=22,419,263 loops=3)

  • Filter: ((version_bits <> 0) AND (status = 30))
  • Rows Removed by Filter: 11,723,668
Planning time : 2.549 ms
Execution time : 258,325.920 ms