explain.depesz.com

PostgreSQL's explain analyze made readable

Result: urUG

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 146,813.461 ↑ 6.0 1 1

Group (cost=3,851,170.42..3,851,179.68 rows=6 width=9) (actual time=146,813.456..146,813.461 rows=1 loops=1)

  • Buffers: shared hit=525 read=274298, temp read=102392 written=115176
2. 0.000 147,913.138 ↑ 6.0 12 1

Gather Merge (cost=3,851,170.42..3,851,179.5 rows=72 width=9) (actual time=146,813.453..147,913.138 rows=12 loops=1)

  • Buffers: shared hit=8964 read=3241412, temp read=1350301 written=1351404
3. 0.528 1,760,468.460 ↑ 6.0 1 12

Sort (cost=3,850,170.18..3,850,170.19 rows=6 width=9) (actual time=146,705.705..146,705.705 rows=1 loops=12)

  • Sort Key: import_zensus.quelle
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=8964 read=3241412, temp read=1350301 written=1351404
4. 4,251.276 1,760,467.932 ↑ 6.0 1 12

Aggregate (cost=3,850,170.04..3,850,170.1 rows=6 width=9) (actual time=146,705.661..146,705.661 rows=1 loops=12)

  • Buffers: shared hit=8865 read=3241412, temp read=1350301 written=1351404
5. 131,693.544 1,756,216.656 ↑ 6.5 2,714,942 12

Hash Join (cost=284,506.19..3,806,155.69 rows=17,605,741 width=9) (actual time=139,972.435..146,351.388 rows=2,714,942 loops=12)

  • Buffers: shared hit=8865 read=3241412, temp read=1350301 written=1351404
6. 1,609,644.216 1,609,644.216 ↑ 1.0 17,591,836 12

Seq Scan on import_zensus import_zensus (cost=0..3,218,822.41 rows=17,605,741 width=26) (actual time=1.961..134,137.018 rows=17,591,836 loops=12)

  • Buffers: shared hit=3457 read=3039308
7. 7,095.996 14,878.896 ↑ 1.0 2,714,942 12

Hash (cost=234,661.42..234,661.42 rows=2,714,942 width=17) (actual time=1,239.907..1,239.908 rows=2,714,942 loops=12)

  • Buffers: shared hit=5408 read=202104, temp written=143364
8. 7,782.900 7,782.900 ↑ 1.0 2,714,942 12

Seq Scan on import_zensus_helper import_zensus_helper (cost=0..234,661.42 rows=2,714,942 width=17) (actual time=0.026..648.575 rows=2,714,942 loops=12)

  • Buffers: shared hit=5408 read=202104
Planning time : 0.348 ms
Execution time : 147,914.59 ms