explain.depesz.com

PostgreSQL's explain analyze made readable

Result: UObt

Settings
# exclusive inclusive rows x rows loops node
1. 95.432 3,653.188 ↓ 0.0 0 1

Insert on tmp_src_data (cost=196,830.84..204,835.13 rows=35,670 width=24) (actual time=3,653.188..3,653.188 rows=0 loops=1)

2. 101.743 3,557.756 ↓ 2.5 90,044 1

Merge Join (cost=196,830.84..204,835.13 rows=35,670 width=24) (actual time=3,463.213..3,557.756 rows=90,044 loops=1)

  • Merge Cond: ((vdc.type_id = tk.type_id) AND (vdc.nr = tk.nr))
3. 1,341.371 3,449.772 ↑ 2.7 360,172 1

Sort (cost=196,730.21..199,190.23 rows=984,008 width=32) (actual time=3,274.877..3,449.772 rows=360,172 loops=1)

  • Sort Key: vdc.type_id, vdc.nr
  • Sort Method: external merge Disk: 41752kB
4. 1,036.942 2,108.401 ↑ 1.1 928,467 1

Hash Join (cost=46,326.29..75,236.02 rows=984,008 width=32) (actual time=1,084.205..2,108.401 rows=928,467 loops=1)

  • Hash Cond: (l.device_id = vdc.device_id)
5. 1.098 1.098 ↑ 1.1 3,110 1

Seq Scan on tmp_device_list l (cost=0.00..49.70 rows=3,570 width=4) (actual time=0.193..1.098 rows=3,110 loops=1)

6. 603.322 1,070.361 ↑ 1.0 1,163,034 1

Hash (cost=23,254.13..23,254.13 rows=1,193,213 width=32) (actual time=1,070.361..1,070.361 rows=1,163,034 loops=1)

  • Buckets: 65536 Batches: 32 Memory Usage: 2858kB
7. 467.039 467.039 ↑ 1.0 1,163,034 1

Seq Scan on device_data_cache_1 vdc (cost=0.00..23,254.13 rows=1,193,213 width=32) (actual time=0.162..467.039 rows=1,163,034 loops=1)

8. 6.129 6.241 ↑ 1,450.0 1 1

Sort (cost=100.64..104.26 rows=1,450 width=8) (actual time=0.147..6.241 rows=1 loops=1)

  • Sort Key: tk.type_id, tk.nr
  • Sort Method: quicksort Memory: 25kB
9. 0.112 0.112 ↑ 1,450.0 1 1

Seq Scan on tmp_task_row tk (cost=0.00..24.50 rows=1,450 width=8) (actual time=0.111..0.112 rows=1 loops=1)

Planning time : 1.335 ms
Execution time : 3,670.617 ms