explain.depesz.com

PostgreSQL's explain analyze made readable

Result: WSl7

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 668.013 ↑ 1.0 1 1

Finalize Aggregate (cost=155,874.64..155,874.65 rows=1 width=8) (actual time=668.013..668.013 rows=1 loops=1)

2. 56.314 686.213 ↓ 1.3 4 1

Gather (cost=155,874.32..155,874.63 rows=3 width=8) (actual time=667.997..686.213 rows=4 loops=1)

  • Workers Planned: 3
  • Workers Launched: 3
3. 13.735 629.899 ↑ 1.0 1 4

Partial Aggregate (cost=154,874.32..154,874.33 rows=1 width=8) (actual time=629.898..629.899 rows=1 loops=4)

4. 173.881 616.164 ↑ 1.3 174,988 4

Hash Join (cost=135,835.00..154,309.81 rows=225,806 width=0) (actual time=411.363..616.164 rows=174,988 loops=4)

  • Hash Cond: (rtb_dsp_log.ssp_log_id = rtb_ssp_log.id)
5. 32.232 32.232 ↑ 1.3 175,000 4

Parallel Seq Scan on rtb_dsp_log (cost=0.00..12,258.06 rows=225,806 width=16) (actual time=0.029..32.232 rows=175,000 loops=4)

6. 149.136 410.051 ↑ 1.0 700,000 4

Hash (cost=123,667.00..123,667.00 rows=700,000 width=16) (actual time=410.051..410.051 rows=700,000 loops=4)

  • Buckets: 131072 Batches: 8 Memory Usage: 5123kB
7. 260.915 260.915 ↑ 1.0 700,000 4

Seq Scan on rtb_ssp_log (cost=0.00..123,667.00 rows=700,000 width=16) (actual time=0.035..260.915 rows=700,000 loops=4)