explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1Cb : no index - parallel seq scan

Settings
# exclusive inclusive rows x rows loops node
1. 10.997 21,938.874 ↑ 2.3 30,119 1

Finalize GroupAggregate (cost=1,167,582.60..1,178,101.06 rows=70,120 width=28) (actual time=21,902.382..21,938.874 rows=30,119 loops=1)

  • Group Key: person_id
  • Buffers: shared hit=29516 read=210604
2. 0.000 21,927.877 ↑ 1.9 39,643 1

Gather Merge (cost=1,167,582.60..1,177,017.82 rows=76,408 width=24) (actual time=21,902.376..21,927.877 rows=39,643 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
  • Buffers: shared hit=145184 read=1037100
3. 19.040 109,050.480 ↑ 2.4 7,929 5

Partial GroupAggregate (cost=1,166,582.55..1,166,916.83 rows=19,102 width=24) (actual time=21,804.555..21,810.096 rows=7,929 loops=5)

  • Group Key: person_id
  • Buffers: shared hit=145184 read=1037100
4. 69.520 109,031.440 ↑ 1.3 15,232 5

Sort (cost=1,166,582.55..1,166,630.30 rows=19,102 width=24) (actual time=21,804.549..21,806.288 rows=15,232 loops=5)

  • Sort Key: person_id
  • Sort Method: quicksort Memory: 1595kB
  • Buffers: shared hit=145184 read=1037100
5. 108,961.920 108,961.920 ↑ 1.3 15,232 5

Parallel Seq Scan on max_test_2018_3 o (cost=0.00..1,165,224.26 rows=19,102 width=24) (actual time=33.464..21,792.384 rows=15,232 loops=5)

  • Filter: ((location_path)::text ~~ '/tax-calculator%'::text)
  • Rows Removed by Filter: 3545552
  • Buffers: shared hit=144972 read=1037100
Planning time : 1.507 ms
Execution time : 21,940.921 ms