explain.depesz.com

PostgreSQL's explain analyze made readable

Result: u5jn

Settings
# exclusive inclusive rows x rows loops node
1. 69.003 37,016.813 ↑ 4,598.4 18 1

Gather (cost=1,022.38..1,312,527.85 rows=82,771 width=40) (actual time=14,718.683..37,016.813 rows=18 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 16,810.453 36,947.810 ↑ 5,748.0 6 3 / 3

Hash Join (cost=22.38..1,303,250.75 rows=34,488 width=40) (actual time=22,075.713..36,947.810 rows=6 loops=3)

  • Hash Cond: ((res.numtube)::text = (tttttttttttttttt.numtube)::text)
3. 20,137.200 20,137.200 ↑ 1.2 8,197,118 3 / 3

Parallel Seq Scan on resjour_tout res (cost=0.00..572,762.08 rows=10,246,108 width=43) (actual time=0.351..20,137.200 rows=8,197,118 loops=3)

4. 0.022 0.157 ↑ 275.0 2 3 / 3

Hash (cost=15.50..15.50 rows=550 width=118) (actual time=0.155..0.157 rows=2 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
5. 0.135 0.135 ↑ 275.0 2 3 / 3

Seq Scan on tttttttttttttttt (cost=0.00..15.50 rows=550 width=118) (actual time=0.129..0.135 rows=2 loops=3)