explain.depesz.com

PostgreSQL's explain analyze made readable

Result: uZo4

Settings
# exclusive inclusive rows x rows loops node
1. 70,901.070 73,760.365 ↓ 0.0 0 1

Update on cards (cost=66,530.74..136,748.28 rows=1,094,611 width=159) (actual time=73,760.365..73,760.365 rows=0 loops=1)

2. 1,908.794 2,859.295 ↑ 1.0 1,094,611 1

Hash Join (cost=66,530.74..136,748.28 rows=1,094,611 width=159) (actual time=740.271..2,859.295 rows=1,094,611 loops=1)

  • Hash Cond: (tc.id = cards.id)
3. 210.448 210.448 ↑ 1.0 1,094,611 1

Seq Scan on tmp_nik_id tc (cost=0.00..16,862.11 rows=1,094,611 width=17) (actual time=0.043..210.448 rows=1,094,611 loops=1)

4. 411.415 740.053 ↑ 1.0 1,058,433 1

Hash (cost=30,560.33..30,560.33 rows=1,058,433 width=146) (actual time=740.053..740.053 rows=1,058,433 loops=1)

  • Buckets: 32,768 Batches: 64 Memory Usage: 2,354kB
5. 328.638 328.638 ↑ 1.0 1,058,433 1

Seq Scan on cards (cost=0.00..30,560.33 rows=1,058,433 width=146) (actual time=0.027..328.638 rows=1,058,433 loops=1)