explain.depesz.com

PostgreSQL's explain analyze made readable

Result: CRBp : iotiming test-max2 - no index

Settings
# exclusive inclusive rows x rows loops node
1. 10.879 9,174.477 ↓ 150.6 30,119 1

Finalize GroupAggregate (cost=1,167,831.33..1,168,101.53 rows=200 width=28) (actual time=9,138.311..9,174.477 rows=30,119 loops=1)

  • Group Key: person_id
  • Buffers: shared read=220499
  • I/O Timings: read=106.393
2. 108.032 9,163.598 ↓ 49.7 39,740 1

Gather Merge (cost=1,167,831.33..1,168,095.53 rows=800 width=24) (actual time=9,138.307..9,163.598 rows=39,740 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
  • Buffers: shared hit=212 read=1109587
  • I/O Timings: read=106.393
3. 3.973 9,055.566 ↓ 39.7 7,948 5 / 5

Partial GroupAggregate (cost=1,166,831.27..1,167,000.18 rows=200 width=24) (actual time=9,049.874..9,055.566 rows=7,948 loops=5)

  • Group Key: person_id
  • Buffers: shared hit=212 read=1109587
  • I/O Timings: read=106.393
4. 16.713 9,051.593 ↑ 1.5 15,232 5 / 5

Sort (cost=1,166,831.27..1,166,886.91 rows=22,255 width=24) (actual time=9,049.869..9,051.593 rows=15,232 loops=5)

  • Sort Key: person_id
  • Sort Method: quicksort Memory: 1572kB
  • Buffers: shared hit=212 read=1109587
  • I/O Timings: read=106.393
5. 9,034.880 9,034.880 ↑ 1.5 15,232 5 / 5

Parallel Seq Scan on max_test2_2018_3 o (cost=0.00..1,165,224.26 rows=22,255 width=24) (actual time=13.793..9,034.880 rows=15,232 loops=5)

  • Filter: ((location_path)::text ~~ '/tax-calculator%'::text)
  • Rows Removed by Filter: 3545552
  • Buffers: shared read=1109587
  • I/O Timings: read=106.393
Planning time : 0.151 ms
Execution time : 9,176.754 ms