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)

  • Group Key: import_zensus.quelle
  • Buffers: shared hit=525 read=274,298, temp read=102,392 written=115,176
2. 1,207.433 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)

  • Workers Planned: 12
  • Workers Launched: 11
  • Buffers: shared hit=8,964 read=3,241,412, temp read=1,350,301 written=1,351,404
3. 0.044 146,705.705 ↑ 6.0 1 12 / 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=8,964 read=3,241,412, temp read=1,350,301 written=1,351,404
4. 354.273 146,705.661 ↑ 6.0 1 12 / 12

HashAggregate (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)

  • Group Key: import_zensus.quelle
  • Buffers: shared hit=8,865 read=3,241,412, temp read=1,350,301 written=1,351,404
5. 10,974.462 146,351.388 ↑ 6.5 2,714,942 12 / 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=8,865 read=3,241,412, temp read=1,350,301 written=1,351,404
6. 134,137.018 134,137.018 ↑ 1.0 17,591,836 12 / 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=3,457 read=3,039,308
7. 591.333 1,239.908 ↑ 1.0 2,714,942 12 / 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=5,408 read=202,104, temp written=143,364
8. 648.575 648.575 ↑ 1.0 2,714,942 12 / 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=5,408 read=202,104
Planning time : 0.348 ms
Execution time : 147,914.59 ms