explain.depesz.com

PostgreSQL's explain analyze made readable

Result: oJDn

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 5,816.305 ↑ 21,199.2 10 1

Gather Merge (cost=42,831.02..67,565.14 rows=211,992 width=55) (actual time=5,805.080..5,816.305 rows=10 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 557.151 17,281.536 ↑ 555.0 191 3

Sort (cost=41,830.99..42,095.98 rows=105,996 width=55) (actual time=5,758.067..5,760.512 rows=191 loops=3)

  • Sort Key: vdnumber, province
  • Sort Method: quicksort Memory: 2027kB
  • Worker 0: Sort Method: quicksort Memory: 2058kB
  • Worker 1: Sort Method: quicksort Memory: 2015kB
3. 16,724.385 16,724.385 ↑ 9.0 11,726 3

Partial HashAggregate (cost=31,923.73..32,983.69 rows=105,996 width=55) (actual time=5,420.498..5,574.795 rows=11,726 loops=3)