explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xtVV

Settings
# exclusive inclusive rows x rows loops node
1. 71,724.211 2,970,863.995 ↓ 0.0 0 1

Insert on wkdlv_testt (cost=152,813.60..15,012,246.06 rows=31,198,136 width=1,080) (actual time=2,970,863.995..2,970,863.995 rows=0 loops=1)

  • Buffers: shared hit=131,467,040 read=3,365,615 dirtied=532,206 written=1,427,372
  • I/O Timings: read=1,191,991.161 write=179,795.864
2. 92,377.753 2,899,139.784 ↑ 1.0 31,191,937 1

Merge Join (cost=152,813.60..15,012,246.06 rows=31,198,136 width=1,080) (actual time=0.215..2,899,139.784 rows=31,191,937 loops=1)

  • Merge Cond: (w0.iid = n1.irecipientid)
  • Buffers: shared hit=99,136,110 read=2,833,408 written=1,271,912
  • I/O Timings: read=1,191,983.141 write=164,035.639
3. 1,007,475.938 1,007,475.938 ↑ 1.0 31,191,937 1

Index Scan using wkdlv_test_iid_idx on wkdlv_test w0 (cost=0.56..2,984,094.60 rows=31,198,136 width=35) (actual time=0.052..1,007,475.938 rows=31,191,937 loops=1)

  • Buffers: shared hit=504,736 read=2,467,533 written=700,585
  • I/O Timings: read=902,662.049 write=70,025.474
4. 1,799,286.093 1,799,286.093 ↑ 1.4 115,378,606 1

Index Scan using nmsrecipient_id on nmsrecipient n1 (cost=0.57..14,938,848.88 rows=158,842,848 width=32) (actual time=0.008..1,799,286.093 rows=115,378,606 loops=1)

  • Buffers: shared hit=98,631,374 read=365,875 written=571,327
  • I/O Timings: read=289,321.092 write=94,010.164
Planning time : 18.063 ms
Execution time : 2,970,864.209 ms